Monitoring MySQL Server

[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.

[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.

[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!

[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?

[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

[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.

[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!

[slansing]

Excellent, glad to hear you're up and running! Locking as resolved.