Page 1 of 1
Monitoring MySQL Server
Posted: Fri Feb 01, 2013 5:00 am
by David.adder
Hi,
I'm trying to monitor a MySQL Server using the Monitoring Wizard, and I'm getting this error:
Captura.JPG
I just fill the necessary fields:
Address: Public IP of the Server
Port: 3306 (I ran a Telnet to this port and it is already accesible)
Username: the correct one
Password: the correct one
How can I check this issue?
Thanks in advance.
Re: Monitoring MySQL Server
Posted: Fri Feb 01, 2013 10:13 am
by slansing
Does the plugin have execution permissions? This needs to be made sure of on both the local system and remote system "If the plugin is being called remotely." This is typically what an out of bounds error means. Whist timeout errors are more related to connectivity.
Re: Monitoring MySQL Server
Posted: Mon Feb 04, 2013 5:58 am
by David.adder
Hi slansing,
How can I check the execution permissions in the plugin? I just used the Monitoring Wizard for MSSQL Server. Please, let me know how can I check this.
Thank you!
Re: Monitoring MySQL Server
Posted: Mon Feb 04, 2013 10:45 am
by slansing
The plugin being used by this monitoring wizard is located in /usr/local/nagios/libexec.
Lets just make sure that it is executable first:
Code: Select all
chmod +x /usr/local/nagios/libexec/check_mssql_server.py
If you run the following with the -h flag as shown below you can create a single one time test check to verify that you can in fact connect to the server in question:
Code: Select all
/usr/local/nagios/libexec/check_mssql_server.py -h
You will need the following at minimum:
Code: Select all
check_mssql_server.py -H hostname -U user -P password -T table --mode
What version of Nagios XI are you running, apologies if this was asked before in the bandwidth thread. Did you have to install the wizard by hand?
Re: Monitoring MySQL Server
Posted: Mon Feb 04, 2013 11:36 am
by David.adder
This is a default Wizard from NagiosXI, I did not installed this manually. Actually, the problem is with the services, I see the host UP but just get the error from services that I tried to monitor.
/usr/local/nagios/libexec/check_mssql_server.py -H 'ip' -U 'user' -P 'password'
CRITICAL:Unable to access SQL Server.
If I try using the port I get this:
/usr/local/nagios/libexec/check_mssql_server.py -H 'ip' -U 'user' -P 'password' -p 'port'
Violación de segmento (`core' generado) (it is spanish)
The Nagios Version is 2012R1.4
Re: Monitoring MySQL Server
Posted: Mon Feb 04, 2013 12:35 pm
by lmiltchev
Are you trying to monitor MySQL or MSSQL? Port: 3306 is a standard MySQL port, not MSSQL one, but you are running the "check_mssql_server.py". I believe you ran a wrong wizard.
Re: Monitoring MySQL Server
Posted: Tue Feb 05, 2013 4:49 am
by David.adder
Hi!
Sorry so much, It was absolutely my fault...
Now I tried with the correct Monitoring Wizard, MySQL Server and everything is OK.
Thank you for your help!
Re: Monitoring MySQL Server
Posted: Tue Feb 05, 2013 10:29 am
by slansing
Excellent, glad to hear you're up and running! Locking as resolved.