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