From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Tremer To: development@lists.ipfire.org Subject: Re: [PATCH] mysql: upgraded to mariadb 10.1.14 Date: Tue, 07 Jun 2016 13:35:29 +0100 Message-ID: <1465302929.24121.110.camel@ipfire.org> In-Reply-To: <5756BF71.5060704@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6156617753176454425==" List-Id: --===============6156617753176454425== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable 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" NAME=3Dmysql ./update.sh >=20 > Or how? >=20 > - Daniel > =C2=A0 >=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.=C2=A0 > > 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)=C2=A0one: > >=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=C2=A0templates=C2=A0which seems to w= ork smoothly. > > I try currently to use the new MariaDB for pmacct -->=C2=A0http://forum.i= pfire.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 fold= er. > > >=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 > > > > --- > > > > =C2=A0config/mysql/my.cnf =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0| 6 +++--- > > > > =C2=A0lfs/mysql =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0| 8 ++++---- > > > > =C2=A0src/initscripts/init.d/mysql | 2 +- > > > > =C2=A03 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 @@ > > > > =C2=A0[client] > > > > =C2=A0password =3D mysqlfire > > > > =C2=A0port =3D 3306 > > > > -socket =3D /var/run/mysql/mysql.sock > > > > +socket =3D /var/run/mysql/mysqld.sock > > > > =C2=A0=C2=A0=C2=A0[mysqld] > > > > =C2=A0port =3D 3306 > > > > -socket =3D /var/run/mysql/mysql.sock > > > > +socket =3D /var/run/mysql/mysqld.sock > > > > =C2=A0datadir =3D /srv/mysql > > > > =C2=A0bind-address=3D127.0.0.1 > > > > =C2=A0@@ -14,7 +14,7 @@ user=3Dmysql > > > > =C2=A0=C2=A0=C2=A0[mysqld_safe] > > > > =C2=A0log-error=3D/var/log/mysqld.log > > > > -#pid-file=3D/var/run/mysqld/mysqld.pid > > > > +pid-file=3D/var/run/mysql/mysqld.pid > > > > =C2=A0=C2=A0=C2=A0[mysql] > > > > =C2=A0no-auto-rehash > > > > diff --git a/lfs/mysql b/lfs/mysql > > > > index 2253928..f254e35 100644 > > > > --- a/lfs/mysql > > > > +++ b/lfs/mysql > > > > @@ -24,7 +24,7 @@ > > > > =C2=A0=C2=A0=C2=A0include Config > > > > =C2=A0-VER =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=3D 10.1.12 > > > > +VER =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=3D 10.1.14 > > > > =C2=A0=C2=A0=C2=A0THISAPP =C2=A0=C2=A0=C2=A0=3D mariadb-$(VER) > > > > =C2=A0DL_FILE =C2=A0=C2=A0=C2=A0=3D $(THISAPP).tar.gz > > > > @@ -32,7 +32,7 @@ DL_FROM =C2=A0=C2=A0=C2=A0=3D $(URL_IPFIRE) > > > > =C2=A0DIR_APP =C2=A0=C2=A0=C2=A0=3D $(DIR_SRC)/$(THISAPP) > > > > =C2=A0TARGET =C2=A0=C2=A0=C2=A0=C2=A0=3D $(DIR_INFO)/$(THISAPP) > > > > =C2=A0PROG =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=3D mysql > > > > -PAK_VER =C2=A0=C2=A0=C2=A0=3D 4 > > > > +PAK_VER =C2=A0=C2=A0=C2=A0=3D 5 > > > > =C2=A0=C2=A0=C2=A0CFLAGS =C2=A0=C2=A0=C2=A0+=3D -fno-strict-aliasing = -fno-delete-null-pointer-checks > > > > =C2=A0@@ -44,7 +44,7 @@ objects =3D $(DL_FILE) > > > > =C2=A0=C2=A0=C2=A0$(DL_FILE) =3D $(DL_FROM)/$(DL_FILE) > > > > =C2=A0-$(DL_FILE)_MD5 =3D a2c0809f27ec112139c2c50f03569b2b > > > > +$(DL_FILE)_MD5 =3D 294925531e0fd2f0461e3894496a5adc > > > > =C2=A0=C2=A0=C2=A0install : $(TARGET) > > > > =C2=A0@@ -100,7 +100,7 @@ $(TARGET) : $(patsubst %,$(DIR_DL)/%,$(obje= cts)) > > > > =C2=A0 -DMYSQL_UNIX_ADDR=3D"/var/run/mysql/mysql.sock" \ > > > > =C2=A0 -DMYSQL_DATADIR=3D"/srv/mysql" \ > > > > =C2=A0 -DTMPDIR=3D"/var/tmp" \ > > > > - -DPID_FILE_DIR=3D"/var/run/mysql" > > > > + -DPID_FILE_DIR=3D"/var/run/mysql" \ > > > > =C2=A0 -DENABLED_LOCAL_INFILE=3DON \ > > > > =C2=A0 -DWITH_EMBEDDED_SERVER=3DOFF \ > > > > =C2=A0 -DWITH_SSL=3Dsystem \ > > > > diff --git a/src/initscripts/init.d/mysql b/src/initscripts/init.d/my= sql > > > > index 2c8cfbc..a798793 100644 > > > > --- a/src/initscripts/init.d/mysql > > > > +++ b/src/initscripts/init.d/mysql > > > > @@ -10,7 +10,7 @@ > > > > =C2=A0. /etc/sysconfig/rc > > > > =C2=A0. $rc_functions > > > > =C2=A0-PIDFILE=3D/var/run/mysql/mysql.pid > > > > +PIDFILE=3D/var/run/mysql/mysqld.pid > > > > =C2=A0KILLDELAY=3D20 > > > > =C2=A0=C2=A0=C2=A0case "$1" in > > > =C2=A0 > =C2=A0 --===============6156617753176454425== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjIKCmlRSWNCQUFC Q2dBR0JRSlhWcitSQUFvSkVJQjU4UDl2a0FrSERmMFAvUjRFenhHWUtDLytYbStWYlgyKzdmeGkK SFh2TmFFK1pGdTVoRW56dXdjU1M1S0RSNXZMZUsvVXVhYlgwQmtmTDR6SlFiL2JpOHg4M2pjZHFq QXNFZTVtTApvSlhDekVMdjBRcHFPR1h0ZGNqVUMvK1hLMnU4aGRhTWo2QTRaeWZock91bjRpTVZW SXg3MGxyd01XbWlSMDA1CnVTYmpmcDhsSmptQnlyRHd1WUJxbVhRTHFLTjM0RW95Wlh2cTJFSEY4 UFpuRFV0MWRtZWhjZi92bTJqS2NlOUIKam5GQWJqbEpCbnBvMEsxVldUdFQxdk9RNFZqZmVBUnpH RVprQnBQMEpSQ1V1TUVBTkdhcmo3WWJHQWRzQy9WcgpQMzZsVHBzSFJhQk9PNXJNMnpUYThPZ1B3 akdpMHNlZDZJZDVsSGU5K25PcHp0cXN2Wm92Mmdoa3B1cFMvUGJOCnNwbURrS0NnbGFYVWYrUDlF V2lZY0w1bjc5ZFhXK2NqSnFWRUNBaHhHUmc3SEcxYkYzWDQvVmRKWmdQcHV4dm0KOFd1SVJmY0lT SVhBUEpET3pZYlBzNHBQRTBVSFp4L1FobmFBa2Fhd1NBQmowSlVEQkxXb0VjdFhIQldZU0RwSwpl Ris0TjArVEc4RXp0dU54WmZBbWc0ZG5oZWNtaThFZFovNGMzOWNSMno4RnZwMWhHOHdQamtLaDBl RDZ3Y0hyCmFlVnVteTZNZXpPRU1udGwyelh3cS9JcDhNV2Z3WE9LOGxLOGVZT3VMLysrcDBHMTgx dFpGZDJwcUNiVWNmSksKK2U0NzZTL2VUdTFqUSt3VzZWRXZXK2plZUNjTHErVTkrYTh1T3V6MTFy V3ppWHNkODZNSnM5MzBraEJQVFh3cwpoQ3RnaDRlY3pLdU1CWkk1dHFLQQo9dk5sYwotLS0tLUVO RCBQR1AgU0lHTkFUVVJFLS0tLS0K --===============6156617753176454425==--