* Re: [PATCH] mysql: upgraded to mariadb 10.1.14
[not found] <5756BF71.5060704@ipfire.org>
@ 2016-06-07 12:35 ` Michael Tremer
2016-06-07 15:00 ` ummeegge
0 siblings, 1 reply; 4+ messages in thread
From: Michael Tremer @ 2016-06-07 12:35 UTC (permalink / raw)
To: development
[-- Attachment #1: Type: text/plain, Size: 5952 bytes --]
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(a)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(a)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
> > >
>
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 819 bytes --]
^ permalink raw reply [flat|nested] 4+ messages in thread* Re: [PATCH] mysql: upgraded to mariadb 10.1.14
2016-06-07 12:35 ` [PATCH] mysql: upgraded to mariadb 10.1.14 Michael Tremer
@ 2016-06-07 15:00 ` ummeegge
0 siblings, 0 replies; 4+ messages in thread
From: ummeegge @ 2016-06-07 15:00 UTC (permalink / raw)
To: development
[-- Attachment #1: Type: text/plain, Size: 5996 bytes --]
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(a)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(a)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(a)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
>>>>
>>
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 842 bytes --]
^ permalink raw reply [flat|nested] 4+ messages in thread
* [PATCH] mysql: upgraded to mariadb 10.1.14
@ 2016-06-06 11:34 Daniel Weismüller
2016-06-06 11:40 ` Daniel Weismüller
0 siblings, 1 reply; 4+ messages in thread
From: Daniel Weismüller @ 2016-06-06 11:34 UTC (permalink / raw)
To: development
[-- Attachment #1: Type: text/plain, Size: 2208 bytes --]
Signed-off-by: Daniel Weismüller <daniel.weismueller(a)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
--
2.4.4
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: [PATCH] mysql: upgraded to mariadb 10.1.14
2016-06-06 11:34 Daniel Weismüller
@ 2016-06-06 11:40 ` Daniel Weismüller
0 siblings, 0 replies; 4+ messages in thread
From: Daniel Weismüller @ 2016-06-06 11:40 UTC (permalink / raw)
To: development
[-- Attachment #1: Type: text/plain, Size: 2627 bytes --]
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(a)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
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2016-06-07 15:00 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
[not found] <5756BF71.5060704@ipfire.org>
2016-06-07 12:35 ` [PATCH] mysql: upgraded to mariadb 10.1.14 Michael Tremer
2016-06-07 15:00 ` ummeegge
2016-06-06 11:34 Daniel Weismüller
2016-06-06 11:40 ` Daniel Weismüller
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox