I got the same problem on the weekend... I hope they fix It soon.
On Wed, May 13, 2009 at 12:18 PM, David C. Rankin, J.D.,P.E.
Listmates,
Somewhat critical, but update of mysql to mysql-5.1.34-29.1 through buildservice breaks the mysql install by putting the mysql.sock and mysqld.pid in /var/run/mysql instead of /var/lib/mysql as normal. This of course prevents access to your existing databases on openSuSE 10.3. The init script in /usr/sbin/rcmysql is mucked up as well as /etc/my.cnf. In /usr/sbin/rcmysql the variables setting the socket and pid dir are:
# The following section has been taken from # the original MySQL init script # Note: If you want to change these variables, you'll make your life easier # if you do so in /etc/my.cnf, which is preserved during upgrades basedir=/usr datadir=/var/lib/mysql mysql_daemon_user=mysql mysql_daemon_group=mysql pid_file=/var/run/mysql/mysqld.pid socket=/var/run/mysql/mysql.sock print_defaults=/usr/bin/my_print_defaults upgrade_log=/var/log/mysql_upgrade.log
That's NUTS! Since when does openSuSE use /var/run for mysql??
The init script for mysql-5.0.67-22.1 on 10.3 correctly provides:
# The following section has been taken from # the original MySQL init script # Note: If you want to change these variables, you'll make your life easier # if you do so in /etc/my.cnf, which is preserved during upgrades basedir=/usr datadir=/var/lib/mysql mysql_daemon_user=mysql mysql_daemon_group=mysql pid_file=/var/lib/mysql/mysqld.pid socket=/var/lib/mysql/mysql.sock print_defaults=/usr/bin/my_print_defaults
If you are bitten my by this bug, just make the needed changes to /etc/my.cnf and /usr/sbin/rcmysql and restart the server.
-- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-- [ ]'s Aledr - Alexandre "OpenSource Solutions for SmallBusiness Problems" -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org