Re: [monit] Problem with Mysql

[Chuck Young]

William Lebel wrote:
> Hi all!
>
> I got a problem. All my monit work but only mysql dont work and i don't 
> know why. I got this error: connection failed to localhost:3306 [MYSQL 
> via TCP]
> Here my mysql config part:

As important is /etc/my.cnf, or whatever the config file is for your mysql 
setup.

You may be listening, not on localhost (127.0.0.1), but on your outside IP.  Or, you might have mysql 
doing all it's connections via sockets, with no networking.

`man netstat` for help on figuring out what processes are listening and where.

cy

> # MySQL
> check process mysql with pidfile /var/run/mysqld/mysqld.pid
> group database
> start program = "/etc/init.d/mysql start"
> stop program = "/etc/init.d/mysql stop"
> if failed port 3306 protocol mysql then unmonitor
> if 5 restarts within 5 cycles then timeout
<snip>