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
