[opensuse] mysqld won't run
Following a new installation of openSUSE 12.2, I'm trying to get a LAMP server running, and I've hit a problem with the mysql server. I restored the contents of /var/lib/mysql from a backup. When I use YaST
System Services (Runlevel) to start the mysql server, it returns 1 (unspecified error).
The contents of /var/log/mysql/mysqld.log are: ----- 121108 09:51:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) 121108 9:51:30 [ERROR] Aborting 121108 9:51:30 [Note] /usr/sbin/mysqld: Shutdown complete 121108 09:51:30 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended ----- /var/lib/mysql contains a number of files named mysql-bin.0000nn and a file named mysql-bin.index So, I can't understand why it won't run :( Thanks, Bob -- Bob Williams System: Linux 3.4.11-2.16-desktop Distro: openSUSE 12.2 (x86_64) with KDE Development Platform: 4.9.2 "release 511" Uptime: 06:00am up 6 days 13:31, 4 users, load average: 0.21, 0.28, 0.27 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Bob Williams wrote:
Following a new installation of openSUSE 12.2, I'm trying to get a LAMP server running, and I've hit a problem with the mysql server.
I restored the contents of /var/lib/mysql from a backup. When I use YaST
System Services (Runlevel) to start the mysql server, it returns 1 (unspecified error).
The contents of /var/log/mysql/mysqld.log are:
----- 121108 09:51:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) 121108 9:51:30 [ERROR] Aborting
121108 9:51:30 [Note] /usr/sbin/mysqld: Shutdown complete
121108 09:51:30 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended -----
/var/lib/mysql contains a number of files named mysql-bin.0000nn and a file named mysql-bin.index
So, I can't understand why it won't run :(
Permission problems perhaps? -- Per Jessen, Zürich (7.4°C) http://www.dns24.ch/ - free DNS hosting, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/11/12 10:43, Per Jessen wrote:
Bob Williams wrote:
Following a new installation of openSUSE 12.2, I'm trying to get a LAMP server running, and I've hit a problem with the mysql server.
I restored the contents of /var/lib/mysql from a backup. When I use YaST
System Services (Runlevel) to start the mysql server, it returns 1 (unspecified error).
The contents of /var/log/mysql/mysqld.log are:
----- 121108 09:51:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) 121108 9:51:30 [ERROR] Aborting
121108 9:51:30 [Note] /usr/sbin/mysqld: Shutdown complete
121108 09:51:30 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended -----
/var/lib/mysql contains a number of files named mysql-bin.0000nn and a file named mysql-bin.index
So, I can't understand why it won't run :(
Permission problems perhaps?
/var/lib/mysql is owned by root:root Bob -- Bob Williams System: Linux 3.4.11-2.16-desktop Distro: openSUSE 12.2 (x86_64) with KDE Development Platform: 4.9.2 "release 511" Uptime: 06:00am up 6 days 13:31, 4 users, load average: 0.21, 0.28, 0.27 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Bob Williams wrote:
So, I can't understand why it won't run :( Permission problems perhaps?
/var/lib/mysql is owned by root:root
Right, but what about the permissions? Also, what created the backup (i.e. OS and mysql version?) and does the mysql manual say that you can directly use such a copy with a newer version if that is applicable? Or does it say to take a dump with the old version and restore from the dump? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/11/12 11:27, Dave Howorth wrote:
Bob Williams wrote:
So, I can't understand why it won't run :( Permission problems perhaps?
/var/lib/mysql is owned by root:root
Right, but what about the permissions?
Oh yes! All the mysql-bin files in /var/lib/mysql are rw-rw----
Also, what created the backup (i.e. OS and mysql version?) and does the mysql manual say that you can directly use such a copy with a newer version if that is applicable? Or does it say to take a dump with the old version and restore from the dump?
The backup was done outside mysql, by rsnapshot (uses rsync and cp). But the problem here is starting (or not) mysqld. Surely the databases come next. Maybe in future I should locate my databases in /home, and I won't get this problem. Bob -- Bob Williams System: Linux 3.4.11-2.16-desktop Distro: openSUSE 12.2 (x86_64) with KDE Development Platform: 4.9.2 "release 511" Uptime: 06:00am up 6 days 13:31, 4 users, load average: 0.21, 0.28, 0.27 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 2012-11-08 12:04, Bob Williams wrote:
/var/lib/mysql is owned by root:root
Should be mysql:mysql. I had a similar problem. - -- Cheers / Saludos, Carlos E. R. (from 11.4 x86_64 "Celadon" (Minas Tirith)) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://www.enigmail.net/ iF4EAREIAAYFAlCbl5oACgkQja8UbcUWM1yCAAD/WNNfY7GmQNcVTURfTfz+Ak/w mpay9SnekpAPUi67hQIBAI2R9PJY/iVUewYhy8hwjdPHM5QRAmnt/9O8DmIiqAtb =hIKx -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 2012-11-08 12:29, Carlos E. R. wrote:
On 2012-11-08 12:04, Bob Williams wrote:
/var/lib/mysql is owned by root:root
Should be mysql:mysql. I had a similar problem.
And all the files inside, I forget. - -- Cheers / Saludos, Carlos E. R. (from 11.4 x86_64 "Celadon" (Minas Tirith)) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://www.enigmail.net/ iF4EAREIAAYFAlCbmAkACgkQja8UbcUWM1zAXwEAmxyYQgpwMytPFYzJGZ7D5nBL HUu5I37gv4+HrFfpIrEA/1x4mPxQimPCBUvcFA/FNgv9/0wSwaPaMHfknUDlw0g7 =WtvP -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/11/12 11:29, Carlos E. R. wrote:
On 2012-11-08 12:04, Bob Williams wrote:
/var/lib/mysql is owned by root:root
Should be mysql:mysql. I had a similar problem.
Is the right answer! Many thanks, Carlos. Bob -- Bob Williams System: Linux 3.4.11-2.16-desktop Distro: openSUSE 12.2 (x86_64) with KDE Development Platform: 4.9.2 "release 511" Uptime: 06:00am up 6 days 13:31, 4 users, load average: 0.21, 0.28, 0.27 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 11/08/2012 12:43 PM, Bob Williams wrote:
On 08/11/12 11:29, Carlos E. R. wrote:
On 2012-11-08 12:04, Bob Williams wrote:
/var/lib/mysql is owned by root:root
Should be mysql:mysql. I had a similar problem.
Is the right answer! Many thanks, Carlos.
Yep, unfortunately, the "not found" message was irritating: 121108 09:51:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) Error code 13 is: $ python -c "import os; print os.strerror(13)" Permission denied Have a nice day, Berny -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 11/08/2012 02:22 PM, Dave Howorth wrote:
Or just
$ perror 13 Error code 13: Permission denied
Interesting: $ cnf perror The program 'perror' can be found in following packages: * mariadb-tools [ path: /usr/bin/perror, repository: zypp (repo-oss) ] * mysql-cluster-tools [ path: /usr/bin/perror, repository: zypp (repo-oss) ] * mysql-community-server-tools [ path: /usr/bin/perror, repository: zypp (repo-oss) ] * mariadb-tools [ path: /usr/bin/perror, repository: zypp (repo-update) ] * mysql-cluster-tools [ path: /usr/bin/perror, repository: zypp (repo-update) ] * mysql-community-server-tools [ path: /usr/bin/perror, repository: zypp (repo-update) ] Have a nice day, Berny -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/11/12 12:29, Bernhard Voelker wrote:
On 11/08/2012 12:43 PM, Bob Williams wrote:
On 08/11/12 11:29, Carlos E. R. wrote:
On 2012-11-08 12:04, Bob Williams wrote:
/var/lib/mysql is owned by root:root
Should be mysql:mysql. I had a similar problem.
Is the right answer! Many thanks, Carlos.
Yep, unfortunately, the "not found" message was irritating:
121108 09:51:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13)
Error code 13 is:
$ python -c "import os; print os.strerror(13)" Permission denied
Have a nice day, Berny
Good tip. Many thanks -- Bob Williams System: Linux 3.4.11-2.16-desktop Distro: openSUSE 12.2 (x86_64) with KDE Development Platform: 4.9.2 "release 511" Uptime: 06:00am up 6 days 13:31, 4 users, load average: 0.21, 0.28, 0.27 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On Thursday 08 November 2012, Bob Williams wrote:
Following a new installation of openSUSE 12.2, I'm trying to get a LAMP server running, and I've hit a problem with the mysql server.
I restored the contents of /var/lib/mysql from a backup. When I use YaST
Have you also tried to use /etc/my.cnf from the same backup? cu, Rudi -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/11/12 10:47, Ruediger Meier wrote:
On Thursday 08 November 2012, Bob Williams wrote:
Following a new installation of openSUSE 12.2, I'm trying to get a LAMP server running, and I've hit a problem with the mysql server.
I restored the contents of /var/lib/mysql from a backup. When I use YaST
Have you also tried to use /etc/my.cnf from the same backup?
cu, Rudi
The current copy of /etc/my.cnf is identical to the backup copy. Bob -- Bob Williams System: Linux 3.4.11-2.16-desktop Distro: openSUSE 12.2 (x86_64) with KDE Development Platform: 4.9.2 "release 511" Uptime: 06:00am up 6 days 13:31, 4 users, load average: 0.21, 0.28, 0.27 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (6)
-
Bernhard Voelker -
Bob Williams -
Carlos E. R. -
Dave Howorth -
Per Jessen -
Ruediger Meier