Page 2 of 3
Re: DB LB ERROR OF MSSQL monitoring
Posted: Mon Apr 25, 2016 1:52 am
by gselvakumar
Hi,
Please help with error given below
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WSRCPdfsFOE010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUSvCPLdLdfd010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUdgfdsgX00.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WdsgfsdddE01.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: <class 'pymssql.InterfaceError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.
Re: DB LB ERROR OF MSSQL monitoring
Posted: Mon Apr 25, 2016 10:15 am
by rkennedy
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WSRCPdfsFOE010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused
From the Nagios machine, what is the full output of
nmap WSRCPdfsFOE010.fossil.com?
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUSvCPLdLdfd010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
Looks like you have the wrong credentials.
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUdgfdsgX00.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused
From the Nagios machine, what is the full output of
nmap WUdgfdsgX00.fossil.com?
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WdsgfsdddE01.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: <class 'pymssql.InterfaceError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.
Can you show us the corresponding log from your SQL server?
Re: DB LB ERROR OF MSSQL monitoring
Posted: Wed Jun 15, 2016 6:06 am
by gselvakumar
Hi Team,
There are few MSSQL servers which has only windows authentication only (No SQL authentication).Even DB team is using Windows authentication on these servers. So for monitoring for those servers we have created user id having windows authentication to connect to the SQL server,but when we are trying we are getting error.Is that anything we are missing?
Can anyone pls help us regarding this.
Please find below the command and the error for server
Code: Select all
/usr/local/nagios/libexec/check_mssql_database.py -H xxxxxxx -U 'xxxxxx' -P 'xxxxxxx' -T 'master' -I xxxxxxx --time2connect --warning 1 --critical 5
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
Thanks
Gomathyshankar Selvakumar
Re: DB LB ERROR OF MSSQL monitoring
Posted: Wed Jun 15, 2016 7:34 am
by gselvakumar
Hi,
Regarding the previous post pls let can we monitor MSSQL servers using windows authentication using MSSQL Database, MSSQL Query and MSSQL server plugin.
If not let is there any other plugin that we can use
Thanks,
Gomathyshankar Selvakumar
Re: DB LB ERROR OF MSSQL monitoring
Posted: Wed Jun 15, 2016 10:00 am
by rkennedy
rkennedy wrote:
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WSRCPdfsFOE010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused
From the Nagios machine, what is the full output of
nmap WSRCPdfsFOE010.fossil.com?
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUSvCPLdLdfd010.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: SQL Server message 18456, severity 14, state 1, line 1:
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
Looks like you have the wrong credentials.
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WUdgfdsgX00.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused
From the Nagios machine, what is the full output of
nmap WUdgfdsgX00.fossil.com?
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H WdsgfsdddE01.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: <class 'pymssql.InterfaceError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.
Can you show us the corresponding log from your SQL server?
Can you please address these questions I asked previously? It should work fine with windows authentication, perhaps you're missing the computer or domain account name. The error is indicating the credentials are wrong.
Code: Select all
Login failed for user 'nagios'.
DB-Lib error message 18456, severity 14:
Re: DB LB ERROR OF MSSQL monitoring
Posted: Thu Jun 16, 2016 11:31 pm
by gselvakumar
Hi,
We are monitoring MSSQL servers. Few MSSQL servers are windows authenticated only there is no SQL authenication on those servers.For that we are created AD user iD:Domain\xxxxxxx for those servers .But we are getting error as mentioned below.
Code: Select all
COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H xxxxxxxxx -U 'Domain\xxxxxxx' -P 'xxxxxxx' -T 'master' -I BKUPEXEC --time2connect --warning 1 --critical 5
OUTPUT: DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
Is this any access issue bcoz when we checked with DB they said " they have created the Id that you asked and you have all access to login to the server".But when we tried taking RDP we unable to do we are getting "connection denied to the user"
Anything we are missing.
Can any one pls help us with this.
Re: DB LB ERROR OF MSSQL monitoring
Posted: Thu Jun 16, 2016 11:32 pm
by gselvakumar
The nmap output:
Code: Select all
[root@lussvpnagiosxi00 ~]# nmap xxxxxxxxxxx
Starting Nmap 6.47 ( http://nmap.org ) at 2016-06-16 23:27 CDT
Nmap scan report for xxxxxxxx (xxxxxxxxxx)
Host is up (0.13s latency).
Not shown: 981 closed ports
PORT STATE SERVICE
80/tcp open http
135/tcp open msrpc
139/tcp open netbios-ssn
443/tcp open https
445/tcp open microsoft-ds
515/tcp open printer
1311/tcp open rxmon
3527/tcp open beserver-msg-q
5633/tcp open beorl
5666/tcp open nrpe
6101/tcp open backupexec
6106/tcp open isdninfo
8000/tcp open http-alt
8002/tcp open teradataordbms
8081/tcp open blackice-icecap
10000/tcp open snet-sensor-mgmt
49152/tcp open unknown
49153/tcp open unknown
49154/tcp open unknown
Nmap done: 1 IP address (1 host up) scanned in 9.65 seconds
Re: DB LB ERROR OF MSSQL monitoring
Posted: Fri Jun 17, 2016 12:06 am
by gselvakumar
https://github.com/pymssql/pymssql/blob ... cs/faq.rst
Code: Select all
[root@lussvpnagiosxi00 ~]# tsql -H xxxxxxx -p 1433 -U domain/xxxxxx -P Welcome123 -D tempdb
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Default database being set to tempdb
Error 20009 (severity 9):
Unable to connect: Adaptive Server is unavailable or does not exist
OS error 111, "Connection refused"
There was a problem connecting to the server
Re: DB LB ERROR OF MSSQL monitoring
Posted: Fri Jun 17, 2016 11:31 am
by tgriep
Try using a forward slash in the username like the example below.
If that doesn't work, you will have to create an SQL local account on the MSSQL server.
Re: DB LB ERROR OF MSSQL monitoring
Posted: Mon Jun 20, 2016 6:24 am
by gselvakumar
Hi,
I tried forward slash but it is not working.
These servers are not having SQL authentication.They are having windows authentication only ,even Database team are windows authentication for these servers.