Bugzilla Bug 158769

mysql seems not to start with baselayout-1.13.0-alpha10-r2

* Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (1)                                                       
                                         [ !! ]
 * ERROR:  mysql failed to start

although ps shows that it's running (is it meant to be running twice?)

 8667 ?        Ssl    0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf
--basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock
 8673 ?        Ssl    0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf
--basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock

I have the same problem on my machine.

The error is in the mysql init script, on line 275.
Basically, if you use pid-file as an option in mysqld_thing then it causes
mysql to create a blank pidfile, hence the error.

I've tested with ssh_thing =1 and =0 and it seems to create the pidfile in the
right place quite happily without it.

(In reply to comment #2)
> The error is in the mysql init script, on line 275.
> Basically, if you use pid-file as an option in mysqld_thing then it causes
> mysql to create a blank pidfile, hence the error.
> 
> I've tested with ssh_thing =1 and =0 and it seems to create the pidfile in the
> right place quite happily without it.
> 

Confirmed, commenting out this line fixes the error for me. pidfile is created
correctly without it.

commented out line 275 as Suggested by Roy, in cvs now.