mssql wizard

[italken]

Greetings,

I have downloaded the Centos vmware file and am up in running. Having difficulty with the mssql wizard. I have followed the Prereqs and installed freetds and pymssql. The check_mssql_server.py command returns succesfully.

However, when running the configuration wizard it fails. The wizard runs but all alerts fail. Is there an document to setup mssql wizards?

[abrist]

The wizard can be tricky. Can you show us the command from the cli and the command, with args, from XI?

[italken]

From the prereq wizard doc, i issued check_mssql_server.py -U user -P password -I mssqlserver. reply is
OK: Time to connecet was 0.062 .

Command from gui is running one of the three 'wizards' for mssql. http://ipaddress_of server/nagiosxi/config/ I then ran the configure monitor, then ran mssql ( tried all three)

[abrist]

I would like to see what the check mssql service looks like in the CCM, specifically, the check command and the arguments.

[italken]

In CCM, I dug around and found the following. username and password has been replaced. Hope this is what you were looking for.

define service {
host_name 10.1.1.111
service_description MSSQL Buffer Hit Ratio
use xiwizard_mssqlserver_service
check_command check_xi_mssql_server!-U 'XXXXX' -P 'XXXXXX' -I 'MSSQLSERVER' -p 1433 --bufferhitratio --warning 90: --critical 95:
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
first_notification_delay 0
notification_period xi_timeperiod_24x7
notification_options n
notifications_enabled 0
_xiwizard mssqlserver
register 1
}

[abrist]

What exact errors are you receiving for the check?

[italken]

under views, services, status is critical and status information is null

[abrist]

Try the following from the cli:

Code: Select all

cd /usr/local/nagios/libexec
check_mssql_server.py -U 'XXXXX' -P 'XXXXXX' -I 'MSSQLSERVER' -p 1433 --bufferhitratio --warning 90: --critical 95:
check_mssql_server.py -U 'XXXXX' -P 'XXXXXX' -I 'mssqlserver' --bufferhitratio --warning 90: --critical 95:

[italken]

Please see my third posting. This test has already been run from the command line and responds in 0.046xxxx seconds. The command you offered appears to be missing the -H for hostname.

The command I ran, from the Nagios server is ./check_mssql_server.py -H 10.1.1.111 -U username -P my_password -I mssqlserver the reply is
OK: Time to connect was 0.0467209815979s ...

[abrist]

Remove the port declaration from the argument string. You are checking an instance, not the DB server.

Code: Select all

check_mssql_server.py -H XXXXX -U 'XXXXX' -P 'XXXXXX' -I 'mssqlserver' --bufferhitratio --warning 90: --critical 95: