Re: Monit MySQL and ssh on AWS

[Martin Pala]

Hi,

do you use some SSL port test with other services? There was bug in monit which 
was fixed in 5.2: when some port was checked with SSL enabled, the close was 
done twice - normally the second close returned error but if by accident some 
other connection was established and the same filedescriptor assigned to it, 
then it may cause sporadic false-positive error.

Monit upgrade will solve the problem (monit 5.2.5 is recommended).

Regards,
Martin


On May 23, 2011, at 11:43 AM, Stanislav Pogrebnyak wrote:

> Hi!
> 
> I'm using monit 5.0.3 on Ubuntu 10.04 LTS on aws EC2 extra large
> memory instance, for monitoring everal services, besides them are sshd
> and mysql.
> 
> Here are my configs for those:
> 
> 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 host 127.0.0.1 port *port*protocol mysql then alert
>   #f 5 restarts within 5 cycles then timeout
> 
> check process sshd with pidfile /var/run/sshd.pid
> start program "/etc/init.d/ssh start"
> stop program "/etc/init.d/ssh stop"
> if failed port *port* protocol ssh then restarts
> if 5 restarts within 5 cycles then timeout
> 
> those *port*s are approriated ports of the services TCP/IP protocols
> 
> Any way the issue is that some times once a day or some times a few
> times a day monit reports me an tcp checks errors, With munin netstats
> i c that for a some reasons conncetions was reseted. First i was
> thinking about huge load to services, changed ports and configured
> some firewals and started to monitoring ports usage, but it seems not
> the case, since nothing changed. Next i thought that its hardware
> problems, but as u can see checks are over localhost, those should go
> ok.
> 
> In general errors messages looks like:
> 
> Connection failed Service mysql
> 
>       Date:        Mon, 23 May 2011 09:04:43 +0000
>       Action:      alert
>       Host:        *host*
>       Description: failed protocol test [MYSQL] at INET[127.0.0.1:3306] via 
> TCP
> 
> Your faithful employee,
> monit
> 
> And in 2 mins (next checks i suppose):
> 
> Connection succeeded Service mysql
> 
>       Date:        Mon, 23 May 2011 09:06:51 +0000
>       Action:      alert
>       Host:        *host*
>       Description: connection succeeded to INET[127.0.0.1:3306] via TCP
> 
> Your faithful employee,
> monit
> 
> 
> Does any one got those errors as well? Its quite annoying since i'm
> using monit for monitoring other services on other instances as well
> and it works perfect.
> 
> Thnx.
> 
> wbr, Stanislav O. Pogrebnyak
> ------------------------------------------
> ICQ: 242-267-649
> Skype: stanislav.o.pogrebnyak
> cell-phone: +380663966659
> 
> --
> To unsubscribe:
> https://lists.nongnu.org/mailman/listinfo/monit-general