Nagios Support Forum

Posted: **Fri Jun 07, 2013 9:37 am**

Can you log into mysql and run a "Show processlist" query to the Mysql Server?

Posted: **Fri Jun 07, 2013 10:16 am**

Guys

If you know a simpler to configure mysql and sql plugin, please let me know.

Thank you

Posted: **Fri Jun 07, 2013 10:39 am**

Have you not defined a connection string for the check? If you do not have Mysql on your local server, that would be the correct output as it cannot find it. This is the easiest way to do this, you have to define the IP of a server you are trying to connect to.. to connect to it. The usage for that plugin is as follows:

Code: Select all

 [-H hostname] [-P port] [-u username] [-p password]
 [-q] [-s seconds] [-w limits] [-c limits]

So.. following that, as we have outlined in documentation you must either change your directory to the one this plugin resides in, or provide the full directory path, in either case run the following:

Code: Select all

/path/to/your/nagiosplugins/checkMySQLProcesslist -H "ip of your mysql server.." -P "port you have configured for external connections to the databases" -u "username" -p "password"

Nagios Support Forum

How to install plugins

Re: How to install plugins

Re: How to install plugins

Re: How to install plugins