Page 1 of 1

SQL SERVER + NAGIOS

Posted: Tue Jan 23, 2018 10:48 am
by davidgr27
Hi,
I'm trying to monitoring database for SQL SERVER 2016 with a plugin (check_mssql_database.py) but I can't to do it.
command: ./check_mssql_database.py -H 192.198.XX.XX -U 'sa' -P 'XXXXX' -T 'master' --datasize'

This command show me an error:
<type 'exceptions.UnicodeDecodeError'>
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.


Could you help me?

Thank you very much

Re: SQL SERVER + NAGIOS

Posted: Tue Jan 23, 2018 2:13 pm
by mcapra
A couple things:
  • Does your sa password contain special characters? If so, please review this documentation: https://support.nagios.com/kb/article.php?id=580
  • What charset is your SQL Server instance's master database configured to use? UTF-8? CP1252? Something else?
  • Which version of check_mssql_database.py are you using? The script should have a version number near the top.

Re: SQL SERVER + NAGIOS

Posted: Tue Jan 23, 2018 5:08 pm
by dwhitfield
Thanks @mcapra!

OP, please let us know the info requested.