Hi Daniel, have installed MariaDB and wanted to give you a fast feedback. Since i had the old MySQL installed but only stopped and not uninstalled before installation i faced two problems after installation. The first one was while installation process where i got the following output:
Restoring Backup... ...Finished. /opt/pakfire/lib/functions.sh: line 93: /etc/init.d/: Is a directory MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL server is still not running. Waiting 5 seconds. MySQL still noch running... Exiting.
but i could start MariaDB with an /etc/init.d/mysql start. Currently not sure where this problem comes from.
The second one was, i tried to entered into MariaDB over the root user but no password delivers the same than the old password which was 'mysqlfire', the output was:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
i needed to make a fast work around:
/etc/init.d/mysql stop mysqld_safe --skip-grant-tables --skip-networking &
than it was possible to entered into via a second console into MariaDB without password and i could set in that way also the new/(old) one:
mysql -u root use mysql; update user set password=PASSWORD("mysqlfire") where User='root'; flush privileges; exit
may this could help someone else, or you have some other hints for upgrading the old to the new one ?!
Have added new databases, tables and templates which seems to work smoothly. I try currently to use the new MariaDB for pmacct --> http://forum.ipfire.org/viewtopic.php?f=50&t=14849#p90102 will see how it works...
Greetings,
Erik
Am 06.06.2016 um 13:40 schrieb Daniel Weismüller daniel.weismueller@ipfire.org:
As promised :-)
For all who want to test it I've uploaded the package to my people folder.
http://people.ipfire.org/~dweismueller/mysql-10.1.14-5.ipfire
Am 06.06.2016 um 13:34 schrieb Daniel Weismüller:
Signed-off-by: Daniel Weismüller daniel.weismueller@ipfire.org
config/mysql/my.cnf | 6 +++--- lfs/mysql | 8 ++++---- src/initscripts/init.d/mysql | 2 +- 3 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/config/mysql/my.cnf b/config/mysql/my.cnf index 29a568a..f301bcf 100644 --- a/config/mysql/my.cnf +++ b/config/mysql/my.cnf @@ -1,11 +1,11 @@ [client] password = mysqlfire port = 3306 -socket = /var/run/mysql/mysql.sock +socket = /var/run/mysql/mysqld.sock [mysqld] port = 3306 -socket = /var/run/mysql/mysql.sock +socket = /var/run/mysql/mysqld.sock datadir = /srv/mysql bind-address=127.0.0.1 @@ -14,7 +14,7 @@ user=mysql [mysqld_safe] log-error=/var/log/mysqld.log -#pid-file=/var/run/mysqld/mysqld.pid +pid-file=/var/run/mysql/mysqld.pid [mysql] no-auto-rehash diff --git a/lfs/mysql b/lfs/mysql index 2253928..f254e35 100644 --- a/lfs/mysql +++ b/lfs/mysql @@ -24,7 +24,7 @@ include Config -VER = 10.1.12 +VER = 10.1.14 THISAPP = mariadb-$(VER) DL_FILE = $(THISAPP).tar.gz @@ -32,7 +32,7 @@ DL_FROM = $(URL_IPFIRE) DIR_APP = $(DIR_SRC)/$(THISAPP) TARGET = $(DIR_INFO)/$(THISAPP) PROG = mysql -PAK_VER = 4 +PAK_VER = 5 CFLAGS += -fno-strict-aliasing -fno-delete-null-pointer-checks @@ -44,7 +44,7 @@ objects = $(DL_FILE) $(DL_FILE) = $(DL_FROM)/$(DL_FILE) -$(DL_FILE)_MD5 = a2c0809f27ec112139c2c50f03569b2b +$(DL_FILE)_MD5 = 294925531e0fd2f0461e3894496a5adc install : $(TARGET) @@ -100,7 +100,7 @@ $(TARGET) : $(patsubst %,$(DIR_DL)/%,$(objects)) -DMYSQL_UNIX_ADDR="/var/run/mysql/mysql.sock" \ -DMYSQL_DATADIR="/srv/mysql" \ -DTMPDIR="/var/tmp" \
-DPID_FILE_DIR="/var/run/mysql"
-DPID_FILE_DIR="/var/run/mysql" \diff --git a/src/initscripts/init.d/mysql b/src/initscripts/init.d/mysql index 2c8cfbc..a798793 100644 --- a/src/initscripts/init.d/mysql +++ b/src/initscripts/init.d/mysql @@ -10,7 +10,7 @@ . /etc/sysconfig/rc . $rc_functions -PIDFILE=/var/run/mysql/mysql.pid +PIDFILE=/var/run/mysql/mysqld.pid KILLDELAY=20 case "$1" in