Mailinglist Archive: opensuse (1461 mails)

< Previous Next >
Re: [opensuse] Build Service Update to mysql-5.1.34-29.1 on 10.3 has wrong socket and PID location
  • From: aledr <matrixworkstation@xxxxxxxxx>
  • Date: Wed, 13 May 2009 12:22:15 -0300
  • Message-id: <73e156130905130822s3df91d3weaeb1be704b2fd0f@xxxxxxxxxxxxxx>
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.
<drankinatty@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx


--
[ ]'s
Aledr - Alexandre
"OpenSource Solutions for SmallBusiness Problems"
--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx

< Previous Next >