How to install plugins

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: How to install plugins

Post by slansing »

Can you log into mysql and run a "Show processlist" query to the Mysql Server?
alexmati
Posts: 10
Joined: Thu May 16, 2013 1:19 am

Re: How to install plugins

Post by alexmati »

processlist.jpg
Guys

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

Thank you
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: How to install plugins

Post by slansing »

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"
Locked