mysql: upgraded to mariadb 10.1.14
Message ID | 1465212846-20667-1-git-send-email-daniel.weismueller@ipfire.org |
---|---|
State | Dropped |
Headers |
Return-Path: <development-bounces@lists.ipfire.org> Received: from mail01.ipfire.org (hedwig.ipfire.org [172.28.1.200]) by web02.ipfire.org (Postfix) with ESMTP id 60C2061550 for <patchwork@ipfire.org>; Mon, 6 Jun 2016 13:34:20 +0200 (CEST) Received: from mail01.ipfire.org (localhost [IPv6:::1]) by mail01.ipfire.org (Postfix) with ESMTP id BDAE116C9; Mon, 6 Jun 2016 13:34:19 +0200 (CEST) Received: from ipfire2-build.localdomain (dslb-178-006-246-117.178.006.pools.vodafone-ip.de [178.6.246.117]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail01.ipfire.org (Postfix) with ESMTPSA id E104316C9 for <development@lists.ipfire.org>; Mon, 6 Jun 2016 13:34:17 +0200 (CEST) Received: from root (uid 0) (envelope-from root@ipfire2-build.localdomain) id 14198c by ipfire2-build.localdomain (DragonFly Mail Agent v0.10); Mon, 06 Jun 2016 13:34:16 +0200 From: =?UTF-8?q?Daniel=20Weism=C3=BCller?= <daniel.weismueller@ipfire.org> To: development@lists.ipfire.org Subject: [PATCH] mysql: upgraded to mariadb 10.1.14 Date: Mon, 6 Jun 2016 13:34:06 +0200 Message-Id: <1465212846-20667-1-git-send-email-daniel.weismueller@ipfire.org> X-Mailer: git-send-email 2.4.4 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: development@lists.ipfire.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: IPFire development talk <development.lists.ipfire.org> List-Unsubscribe: <http://lists.ipfire.org/mailman/options/development>, <mailto:development-request@lists.ipfire.org?subject=unsubscribe> List-Archive: <http://lists.ipfire.org/pipermail/development/> List-Post: <mailto:development@lists.ipfire.org> List-Help: <mailto:development-request@lists.ipfire.org?subject=help> List-Subscribe: <http://lists.ipfire.org/mailman/listinfo/development>, <mailto:development-request@lists.ipfire.org?subject=subscribe> Errors-To: development-bounces@lists.ipfire.org Sender: "Development" <development-bounces@lists.ipfire.org> |
Message
Daniel Weismueller
June 6, 2016, 9:34 p.m. UTC
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(-)
Comments
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" \ > -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
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" \ >> -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 >
Hi Erik Did you installed it like this? "name=mysql ./update.sh" Or how? - Daniel 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: > > 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 <mailto: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 >> <http://people.ipfire.org/%7Edweismueller/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" \ >>> -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 >> >
On Tue, 2016-06-07 at 14:34 +0200, Daniel Weismüller wrote: > Hi Erik > > Did you installed it like this? > "name=mysql ./update.sh" NAME=mysql ./update.sh > > Or how? > > - Daniel > > > > > 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: > > > > 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.or > > g/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" \ > > > > -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 > > > >
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, will post you there my results. Thank you both. Greetings, Erik Am 07.06.2016 um 14:35 schrieb Michael Tremer <michael.tremer@ipfire.org>: > On Tue, 2016-06-07 at 14:34 +0200, Daniel Weismüller wrote: >> Hi Erik >> >> Did you installed it like this? >> "name=mysql ./update.sh" > > NAME=mysql ./update.sh > >> >> Or how? >> >> - Daniel >> >> >> >> >> 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: >>> >>> 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.or >>> g/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" \ >>>>> -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 >>>> >>