Page 1 of 2
mssql wizard
Posted: Tue Jul 30, 2013 1:31 pm
by 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?
Re: mssql wizard
Posted: Tue Jul 30, 2013 2:54 pm
by abrist
The wizard can be tricky. Can you show us the command from the cli and the command, with args, from XI?
Re: mssql wizard
Posted: Tue Jul 30, 2013 3:03 pm
by 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)
Re: mssql wizard
Posted: Tue Jul 30, 2013 4:06 pm
by abrist
I would like to see what the check mssql service looks like in the CCM, specifically, the check command and the arguments.
Re: mssql wizard
Posted: Wed Jul 31, 2013 8:25 am
by 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
}
Re: mssql wizard
Posted: Wed Jul 31, 2013 11:00 am
by abrist
What exact errors are you receiving for the check?
Re: mssql wizard
Posted: Wed Jul 31, 2013 11:25 am
by italken
under views, services, status is critical and status information is null
Re: mssql wizard
Posted: Wed Jul 31, 2013 12:52 pm
by 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:
Re: mssql wizard
Posted: Wed Jul 31, 2013 1:33 pm
by 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 ...
Re: mssql wizard
Posted: Wed Jul 31, 2013 4:28 pm
by 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: