Page 2 of 5
Re: MS SQL
Posted: Tue May 22, 2012 4:27 pm
by lmiltchev
I don't think you can use a windows authentication - see the documentation:
Code: Select all
Required Options:
-H HOSTNAME, --hostname=HOSTNAME
Specify MSSQL Server Address
-U USER, --user=USER
Specify MSSQL User Name
-P PASSWORD, --password=PASSWORD
Specify MSSQL Password
-T TABLE, --table=TABLE
Specify MSSQL Table
Re: MS SQL
Posted: Tue May 22, 2012 4:30 pm
by scottwilkerson
I believe lmiltchev is correct, this will only work with SQL server credentials, not Windows domain credentials, even if the Windows Domain user has access to the MSSQL Server
Re: MS SQL
Posted: Wed May 23, 2012 9:28 am
by nscott
Yes, those two are absolutely correct. Also, I was mistaken with my previous post, I had misread yours and thought you wanted something that you did not. Please be sure make sure you have the latest MSSQL wizard, I just uploaded the latest version to our assets site, so be sure to use that one.
Posted: Tue May 29, 2012 5:36 pm
by ecarrasq
I got the MS SQL Admin to create me a local account, as you specified, and I downloaded the latest MS SQL Database Wizard. Once I try these out, I'll let you know how it worked.
Thank you for all you do,
Eddie
Re: MS SQL
Posted: Wed May 30, 2012 9:06 am
by scottwilkerson
Thanks for the update.
Re: MS SQL
Posted: Tue Jun 19, 2012 7:21 pm
by ecarrasq
I obtained local read only access to the database, I installed the new "MSSQL Server/Database/Query" wizards, ran them, but I get:
(Service Check Timed Out)
Please help.
Thanks,
Eddie
Re: MS SQL
Posted: Wed Jun 20, 2012 9:39 am
by scottwilkerson
Can you temporarily disable iptables on the nagioxi server and then force one of the checks to see if that makes a difference
Then force the check on one of these services to see if it can connect
restore iptables
Re: MS SQL
Posted: Wed Jun 20, 2012 5:22 pm
by ecarrasq
I "service iptables stop" and tried it again, but no luck.
Re: MS SQL
Posted: Thu Jun 21, 2012 9:45 am
by scottwilkerson
Can you send your current command for one of the checks.. (removing any sensitive data)
Re: MS SQL
Posted: Thu Jun 21, 2012 12:24 pm
by ecarrasq
Here is the full configuration file generated by NagiosXi MSSQL Database Wizard.
###############################################################################
#
# Service configuration file
#
# Created by: Nagios QL Version 3.0.3
# Date: 2012-06-21 10:17:56
# Version: Nagios 3.x config file
#
# --- DO NOT EDIT THIS FILE BY HAND ---
# Nagios QL will overwite all manual settings during the next update
#
###############################################################################
define service {
host_name <MSSQL>
service_description MSSQL Active Transactions
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --activetrans --warning 10 --critical 20
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Connection Time
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --time2connect --warning 1 --critical 5
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Log Cache Hit Rate
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logcachehit --warning 0:95 --critical 0:97
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Log File Usage
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logfileusage --warning 0:80 --critical 0:90
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Log Flush Wait Time
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logwait --warning 100 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Log Growths
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --loggrowths --warning 20 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Log Shrinks
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logshrinks --warning 20 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Log Truncations
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logtruncs --warning 100 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
define service {
host_name <MSSQL>
service_description MSSQL Transactions / Sec
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --transpsec --warning 10 --critical 20
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}
###############################################################################
#
# Service configuration file
#
# END OF FILE
#
###############################################################################