The 127.0.0.1 is loopback (local-only network) => you cannot access it from other network hosts.
You have two options if you want to test it: 1.) reconfigure MySQL to listen on any network interface 2.) or install monit on that machine and test it via 127.0.0.1 But first - i think you should read some linux administration and network basics, as it's dangerous to try monitoring something when you don't understand how it works. On Jun 6, 2013, at 12:50 PM, Aswin Roy <[email protected]> wrote: > Doesn't the netstat test result show that the remote host accepts TCP > connection? Any other method to check this? > > > On Thu, Jun 6, 2013 at 4:15 PM, Aswin Roy <[email protected]> wrote: > When I tested for connections using Netstat, this was the result: > > tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN > > Still, the same result is shown. What can I do? > > > On Thu, Jun 6, 2013 at 4:00 PM, Martin Pala <[email protected]> wrote: > 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 > > > > -- > Aswin Jose Roy > Computer Science and Engineering (2010-2014) > Govt. Model Engineering College > Cochin-21 > +91 9746237979 > [email protected] > > > > -- > 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
