Problems with check_mysql

[nathanplatt]

Okay i've made progress, now i'm getting from the cpanel server;

Code: Select all

cpanel - MYSQL Load
	
	CRITICAL 	07-26-2018 22:14:49 	2d 12h 17m 7s 	3/3 	Access denied for user 'nagios'@'cpc82787-midd19-2-0-cust603.11-1.cable.virginm.net' (using password: NO) 

cpanel nameserver MYSQL Load
	
	CRITICAL 	07-26-2018 22:10:45 	2d 12h 22m 41s 	3/3 	(Service check timed out after 60.02 seconds) 

Ideas?

[scottwilkerson]

looks like you didn't add the user/password to the command.

What is the command you ran?

In our example earlier we showed

Code: Select all

/usr/local/nagios/libexec/check_mysql -H x.x.x.x -u <username> -p <password> -d <dbname>

[nathanplatt]

We're making progress now i'm just getting a few different errors;

Code: Select all

Host '82.16.34.92' is not allowed to connect to this MariaDB server 
Can't connect to MySQL server on '31.22.2.87' (111) 
Can't connect to MySQL server on '31.22.2.86' (113)
Access denied for user 'nagios'@'cpc82787-midd19-2-0-cust603.11-1.cable.virginm.net' (using password: NO) 

The Access denied is the cpanel server

[nathanplatt]

looks like you didn't add the user/password to the command.

What is the command you ran?

In our example earlier we showed

Code: Select all

/usr/local/nagios/libexec/check_mysql -H x.x.x.x -u <username> -p <password> -d <dbname>

I just want to check if mysql is running rather than a particular database

[scottwilkerson]

With this plugin you would still need to enter a username that has permissions to access a database from your host, even if it is to just check it is running.

[nathanplatt]

Can i pass the variables in the ARG section from the gui something like -u, -p?

[scottwilkerson]

Can i pass the variables in the ARG section from the gui something like -u, -p?

Yes, but you should make it work form the command line first to make sure everything is working, then you can proceed to setup the command with passing args in on your service config