Re: Mysql kill fails

[Michael Dykman]

On Wed, 2005-02-16 at 06:35, Gerd Pleyer wrote:
> Hi there!
> 
> I use MySQL 4.1.9 on Mac OS X Server 10.3.8
> 
> I use the mysql.server script (in support-files) to shutdown my MySQL Server at
> system shutdown.
> But the command kill `cat data/my.server.de.pid` fails, so the DB is still running
> and tables stay open at system shutdown.
> 
> With mysqladmin -uroot -p shutdown command the MySQL I can shutdown.
> 
> Perhaps somebody of you has an idea what the reason could be
> 
> Thanks in advantage
> 
I would first check which which user owns the file data/my.server.de.pid
and incidentally, check it's contents to make sure it actually does
contain the pid of active process.  The effective user at the time the
command "kill `cat data/my.server.de.pid`" is called needs to have
permission to read the file in order to fetch the pid and it needs to
have sufficient permissions to kill the process.  Typically, the
'mysql.server' script is run as root.

-- 
 - michael dykman
 - michael@stripped