Re: install mysql check in monit

[Olivier Kaloudoff]

maybe try to see if mysql is really listening to *:3306,
by launching lsof -i | grep -i mysql

sometimes mysql is configured with skip-networking in my.cnf
by security reson, default in Debian for example, so that he
don't listen to remote hosts by default, but only to localhost
connections via a unix domain docket.

Hope this helps !



Olivier Kaloudoff
Saint Raphael
06 20 65 71 33
---

On Wed, 14 Feb 2007, Maravelias Marios - Tophost Internal wrote:

> Hello, I have monit running for check and monitoring http.
> It works fine.
> To day I tried to install monitor for mysql database too.
> I added these lines at /etc/monitrc file:
>
> check process mysqld with pidfile /var/run/mysqld/mysqld.pid
>       group mysql
>       start "/etc/init.d/mysqld start"
>       stop  "/etc/init.d/mysqld stop"
>       if failed port 3306 then restart
>       if 5 restarts within 5 cycles then timeout
>
> in the web interface I see this:
>
>
>     *Process*
>
>
>
>     *Status*
>
>
>
>     *Uptime*
>
>
>
>     *CPU*
>
>
>
>     *Memory*
>
> mysqld <http://grserver.gr:2828/mysqld> 	Connection failed 	37m 
> 3.4% 5.8% [122288 kB]
>
> Why do I get connection failed? how do I fix that?
>
> Thank you.