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. wrote:

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

* David C. Rankin, J.D.,P.E. [05-13-09 11:18]:

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

Thanks. You have gone the distance, or almost. You have made a bug-report with the solution, yes? -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org