PDA

View Full Version : wrong service not running mail


bolero
24th July 2008, 20:23
At the moment I have deployed three VMs with ISPConfig. All three have suddenly started to send an alert

Warning: service mysqld not running

Started at 10:30 today and still going on. Every 30 mins. I see that checkservices.php runs every 30 mins, so I assume it's coming from it.
However:

ps ax|grep my
24133 pts/0 S+ 0:00 grep my
31589 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
31649 ? Sl 0:06 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock


What's wrong here?

till
25th July 2008, 10:24
Please post the output of:

netstat -tap | grep mysql

bolero
25th July 2008, 12:12
Ah, thanks. That explains it, you are looking for the network socket. I set mysql to unix socket as I don't see any use for an open network socket on most setups. I have now disabled that cron job. The service check in the web interface seems to use a different method.