Re: bonsai.php.net down, no one cares?

On 2001-05-07 17:28:16, "Andrei Zmievski" <andrei@ispi.net> wrote: > The MySQL server on the machine died. I've restarted it and it's now > rebuilding the entire check-in history to make sure it's complete. I know this isn't entirely relevant to PHP, but I thought it might help... I've found an interesting "feature" of mySQL and the "standard" cron jobs found in most Linux distros. If you are using a unix socket to connect to mySQL, that socket usually lives in /tmp. Most distros periodically purge old files from /tmp, and since the mysql.sock is not owned by root, it gets deleted and that causes mayhem when trying to connect to mysql. I've encountered (and been seriously bitten by) this problem on Cobalt/RedHat, RedHat and SuSE distros. The solution is simply to prevent that socket from being deleted either by changing ownership or tuning the overnight cron job. --Wez.