SQL SERVER + NAGIOS

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
davidgr27
Posts: 4
Joined: Thu Dec 29, 2016 9:28 am

SQL SERVER + NAGIOS

Post 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
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: SQL SERVER + NAGIOS

Post 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.
Former Nagios employee
https://www.mcapra.com/
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: SQL SERVER + NAGIOS

Post by dwhitfield »

Thanks @mcapra!

OP, please let us know the info requested.
Locked