Re: Cannot open connection via TCP.

[Martin Pala]

You can monitor remote mysql service provided it listens on TCP port. If the remote host doesn't accept TCP connections then you (logically) cannot test it via TCP - you can for example install monit on this remote host and test it locally too.

The SSL has nothing to do with it.

On Jun 6, 2013, at 12:18 PM, Aswin Roy <address@hidden> wrote:

I am able to monitor MySQL on localhost (my computer) with this code:

 check process mysql with pidfile /var/run/mysqld/mysqld.pid

   group database

   start program = "/etc/init.d/mysql restart"

   stop program = "/etc/init.d/mysql stop"

   if failed host 127.0.0.1 port 3306 then restart

   if 5 restarts within 5 cycles then timeout

 So, should I be testing the remote host system in which I am trying to monitor MySQL on? 

Also, I installed monit using apt-get command and hence I did not install ssl. Does it have anything to do with it? 

Thanks. 

On Thu, Jun 6, 2013 at 1:39 PM, Martin Pala <address@hidden> wrote:

Maybe your mysql server is set to not accept TCP connections on the given address. You can use netstat/lsof to check whether mysql listens for connections and try to connect to the mysql server port for example using telnet to see, whether the connection can be established.

Regards,
Martin

On Jun 6, 2013, at 8:54 AM, AswinRoy <address@hidden> wrote:

> Hello,
>
> I am using monit to monitor MySQL on another system in my same network. The
> ICMP echo request is established. But, monitoring ports ( MySQL ) doesn't
> work. Error shown is cannot open connection to INET ( ip address) via TCP
> when i checked the events through M/Monit. The code I use in monitrc file is
> :
>
>   check host remotehost with address xxx.xxx.x.xxx
>   if failed icmp type echo count 3 with timeout 3 seconds then alert
>   if failed port 3306 protocol mysql with timeout 15 seconds then alert
>
> Should there be any change in the code? Or is it something regarding the
> port? I tried disabling ipv6 firewall using:
> sudo ufw disable
>
> Regards.
>
>
>
>
>
> --
> View this message in context: http://nongnu.13855.n7.nabble.com/Cannot-open-connection-via-TCP-tp168954.html
> Sent from the monit-general mailing list archive at Nabble.com.
>
> --
> To unsubscribe:
> https://lists.nongnu.org/mailman/listinfo/monit-general


--
To unsubscribe:
https://lists.nongnu.org/mailman/listinfo/monit-general

--

Aswin Jose Roy

Computer Science and Engineering (2010-2014)

Govt. Model Engineering College

Cochin-21

+91 9746237979

address@hidden

--
To unsubscribe:
https://lists.nongnu.org/mailman/listinfo/monit-general