From mboxrd@z Thu Jan 1 00:00:00 1970 From: ummeegge To: development@lists.ipfire.org Subject: Re: [PATCH] mysql: upgraded to mariadb 10.1.14 Date: Tue, 07 Jun 2016 17:00:58 +0200 Message-ID: <4CEC2D2C-721B-47B0-8F63-ED66A6D41566@ipfire.org> In-Reply-To: <1465302929.24121.110.camel@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6582006322918551791==" List-Id: --===============6582006322918551791== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi all, no Daniel i used it in the old fashion way. Will check the next installation = by the described procedure. Have seen you opened up a topic in the forum, wil= l post you there my results. Thank you both. Greetings, Erik Am 07.06.2016 um 14:35 schrieb Michael Tremer : > On Tue, 2016-06-07 at 14:34 +0200, Daniel Weism=C3=BCller wrote: >> Hi Erik >>=20 >> Did you installed it like this? >> "name=3Dmysql ./update.sh" >=20 > NAME=3Dmysql ./update.sh >=20 >>=20 >> Or how? >>=20 >> - Daniel >>=20 >>=20 >>=20 >>=20 >> Am 07.06.2016 um 12:24 schrieb ummeegge: >>> 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: >>>=20 >>> 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. >>>=20 >>>=20 >>> but i could start MariaDB with an /etc/init.d/mysql start. Currently not >>> sure where this problem comes from. >>>=20 >>> 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: >>>=20 >>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >>> password: YES) >>>=20 >>> i needed to make a fast work around: >>>=20 >>> /etc/init.d/mysql stop >>> mysqld_safe --skip-grant-tables --skip-networking & >>>=20 >>> 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: >>>=20 >>> mysql -u root >>> use mysql; >>> update user set password=3DPASSWORD("mysqlfire") where User=3D'root'; >>> flush privileges; >>> exit >>>=20 >>> may this could help someone else, or you have some other hints for upgrad= ing >>> the old to the new one ?! >>>=20 >>> Have added new databases, tables and templates which seems to work smooth= ly. >>> I try currently to use the new MariaDB for pmacct --> http://forum.ipfire= .or >>> g/viewtopic.php?f=3D50&t=3D14849#p90102 will see how it works... >>>=20 >>> Greetings, >>>=20 >>> Erik >>>=20 >>>=20 >>>=20 >>> Am 06.06.2016 um 13:40 schrieb Daniel Weism=C3=BCller >> org>: >>>=20 >>>> As promised :-) >>>>=20 >>>> For all who want to test it I've uploaded the package to my people folde= r. >>>>=20 >>>> http://people.ipfire.org/~dweismueller/mysql-10.1.14-5.ipfire >>>>=20 >>>> Am 06.06.2016 um 13:34 schrieb Daniel Weism=C3=BCller: >>>>> Signed-off-by: Daniel Weism=C3=BCller >>>>> --- >>>>> config/mysql/my.cnf | 6 +++--- >>>>> lfs/mysql | 8 ++++---- >>>>> src/initscripts/init.d/mysql | 2 +- >>>>> 3 files changed, 8 insertions(+), 8 deletions(-) >>>>>=20 >>>>> 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 =3D mysqlfire >>>>> port =3D 3306 >>>>> -socket =3D /var/run/mysql/mysql.sock >>>>> +socket =3D /var/run/mysql/mysqld.sock >>>>> [mysqld] >>>>> port =3D 3306 >>>>> -socket =3D /var/run/mysql/mysql.sock >>>>> +socket =3D /var/run/mysql/mysqld.sock >>>>> datadir =3D /srv/mysql >>>>> bind-address=3D127.0.0.1 >>>>> @@ -14,7 +14,7 @@ user=3Dmysql >>>>> [mysqld_safe] >>>>> log-error=3D/var/log/mysqld.log >>>>> -#pid-file=3D/var/run/mysqld/mysqld.pid >>>>> +pid-file=3D/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 =3D 10.1.12 >>>>> +VER =3D 10.1.14 >>>>> THISAPP =3D mariadb-$(VER) >>>>> DL_FILE =3D $(THISAPP).tar.gz >>>>> @@ -32,7 +32,7 @@ DL_FROM =3D $(URL_IPFIRE) >>>>> DIR_APP =3D $(DIR_SRC)/$(THISAPP) >>>>> TARGET =3D $(DIR_INFO)/$(THISAPP) >>>>> PROG =3D mysql >>>>> -PAK_VER =3D 4 >>>>> +PAK_VER =3D 5 >>>>> CFLAGS +=3D -fno-strict-aliasing -fno-delete-null-pointer-checks >>>>> @@ -44,7 +44,7 @@ objects =3D $(DL_FILE) >>>>> $(DL_FILE) =3D $(DL_FROM)/$(DL_FILE) >>>>> -$(DL_FILE)_MD5 =3D a2c0809f27ec112139c2c50f03569b2b >>>>> +$(DL_FILE)_MD5 =3D 294925531e0fd2f0461e3894496a5adc >>>>> install : $(TARGET) >>>>> @@ -100,7 +100,7 @@ $(TARGET) : $(patsubst %,$(DIR_DL)/%,$(objects)) >>>>> -DMYSQL_UNIX_ADDR=3D"/var/run/mysql/mysql.sock" \ >>>>> -DMYSQL_DATADIR=3D"/srv/mysql" \ >>>>> -DTMPDIR=3D"/var/tmp" \ >>>>> - -DPID_FILE_DIR=3D"/var/run/mysql" >>>>> + -DPID_FILE_DIR=3D"/var/run/mysql" \ >>>>> -DENABLED_LOCAL_INFILE=3DON \ >>>>> -DWITH_EMBEDDED_SERVER=3DOFF \ >>>>> -DWITH_SSL=3Dsystem \ >>>>> 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=3D/var/run/mysql/mysql.pid >>>>> +PIDFILE=3D/var/run/mysql/mysqld.pid >>>>> KILLDELAY=3D20 >>>>> case "$1" in >>>>=20 >>=20 --===============6582006322918551791== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KQ29tbWVudDogR1BHVG9vbHMgLSBodHRwczov L2dwZ3Rvb2xzLm9yZwoKaVFJY0JBRUJDZ0FHQlFKWFZ1RzBBQW9KRUlQaWh4WDVKOGpuU2djUUFK RzU0WEVSQzRZTzU2MmcxSm5jcWlZMwpnckhpeHR6ZjhQYThMU3JPaEUrUGF5elc3YnZzOS9ldVd0 NThKWmQ5dDRaZmhQeGRmUnhxWjZGaTZrYTdidUpFCkwwaTNGOHpVeDBSQVJKV2xXZ1lsVmNRamZ0 b2N1ODJQODNmcHg1QmsvR0I5SWRHMWJLVjNqcmg2Vzc0R0w5VUwKZ0NiZzZUWkw3b1hlcllJajJz dXN0STBrR0RZT2xyY3lDN0dtVlRuQ1VYc0FMNDRNQ3l0SWpITW02VnJ0MWhCVwo1c2s2Tjhhei9s Vzc5MDMzMndTcGg1TXFVV0N0MHdONDY2c2Vwa2VmM1NtWWIrTHVpQ0UxV0s2NWtTSTUya1piCjJ4 U2RzbkxRY3NaenJWRGUra0kwTWxibUFaVmRoQWJRS2hiTjRYdXQ1aDkxUTBBMnFtSFVXdkp3NkZn OGhYSmIKZ3JDdWYrSmpXWTNpVXNoS1M1SjlXQTBLckIwR0IremQ1VDJ6MTUwYmFTMVp6a0locXNN dlhEU2JMQjFjNzRXeAppOXUyQi9uc1krZEhUcGhncFUwRERvamFaclRnSTNaK25HaEkvNlU2ZGd4 WHZZcjVCY3EyQU0wak90d1FOWmNvCmF5VjBqdC9EQUdxQVZlWEVGSlkzWDY5aE0yWXhaeTRCUzN0 bi9HNmFBcDVNd05wTlBkV2pab2pZc0w5a0hrTFMKbG5ZNmhmRUp2bEJxNVQvK3VlYzhHQ2dFb3Bp V3N2N0pqcFJPaGlxRG9xMkU1RlpWWTBqWTVxdy85WlNLUWxJNgpaMVNKeHZyV0h4VUtRVnhISzJn N1ZqZVdHQklHVDMra1JERksvY0dGbHJ4a3A1eHFTZjdmclBSTnd6ZG1qYldKCnBoTWlRbDg1UzBl Rks5dEVlRkVSCj1YS016Ci0tLS0tRU5EIFBHUCBTSUdOQVRVUkUtLS0tLQo= --===============6582006322918551791==--