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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 > [email protected] > -- > To unsubscribe: > https://lists.nongnu.org/mailman/listinfo/monit-general
-- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general
