Re: install mysql check in monit

[Maravelias Marios - Tophost Internal]

Hi Olivier,

here is the result,
root /# lsof -i | grep -i mysql
mysqld 5036 mysql 3u IPv4 17747424 TCP *:mysql (LISTEN)

I run the monit in the same server where the mysql server is..

also check this:
root /# netstat -an | grep :3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

Im sure mysql listens to 3306, this is not the problem..it must been 
something else :(


O/H 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.
>
>
> --
> To unsubscribe:
> http://lists.nongnu.org/mailman/listinfo/monit-general