Search found 9 matches

by italken
Mon Aug 12, 2013 9:57 am
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

Can you direct me to where to change the configuration? From views, service, I selected configure and received the following This service appears to make use of an advanced configuration. Use the Nagios Core Config Manager to modify the settings for this service. Does the mssql wizard work? Do I nee...
by italken
Thu Aug 01, 2013 12:07 pm
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

Please advise how to correct the error I am having.

To summarize,
I have installed Nagios using your virtual image.
Windows and unix monitoring works well.
From a command line, I can run the check_mssql_server command and it responds quickly.
The wizard fails.

Please advise.
by italken
Thu Aug 01, 2013 8:23 am
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

under views, service, service detail ( for the failing alert). I then selected reconfigure. In this box the command being issued is check_xi_mssql_server!-U 'username' -P 'xxxxxx' -I 'MSSQLSERVER' -p 1433 --bufferhitratio --warning 90: --critical 95: I then went to /usr/local/nagios/libexec and coul...
by italken
Thu Aug 01, 2013 8:01 am
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

returns with OK: Buffer Cache Hit Ratio is 99.9038923594%|buffer_cache_hit_ratio=99.9038923594%;90:;95;;;;
by italken
Wed Jul 31, 2013 1:33 pm
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

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 mss...
by italken
Wed Jul 31, 2013 11:25 am
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

under views, services, status is critical and status information is null
by italken
Wed Jul 31, 2013 8:25 am
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

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' ...
by italken
Tue Jul 30, 2013 3:03 pm
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

Re: mssql wizard

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 ( tr...
by italken
Tue Jul 30, 2013 1:31 pm
Forum: Nagios XI
Topic: mssql wizard
Replies: 16
Views: 3511

mssql wizard

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