[PATCH] mysql: upgraded to mariadb 10.1.14

ummeegge ummeegge at ipfire.org
Tue Jun 7 12:24:56 CEST 2016


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 at 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 at 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" \
>>  		-DENABLED_LOCAL_INFILE=ON \
>>  		-DWITH_EMBEDDED_SERVER=OFF \
>>  		-DWITH_SSL=system \
>> 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
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ipfire.org/pipermail/development/attachments/20160607/a1176685/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 842 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.ipfire.org/pipermail/development/attachments/20160607/a1176685/attachment.sig>


More information about the Development mailing list