search

lausser / check_mssql_health

Wenn du dich für Plugins (oder OMD oder allgemein Monitoring) interessierst oder von deiner Installation erzählen willst...die Tradition der deutschsprachigen Monitoring-Workshops wird wiederbelebt: https://discord.gg/jDfPZ63FcJ A plugin, which checks various parameters of Microsoft SQL database servers.
http://labs.consol.de/nagios/check_mssql_health
GNU General Public License v2.0
38 stars 27 forks source link

No connect to MSSQL Server 2022 #51

Open winter1967 opened 1 year ago

winter1967 commented 1 year ago

Hello,

we want to use check_mssql_health for a mssql 2022 Server.

At first we try with our installed freetds 1.1.1 with mssql_health 2.7.2,

We got this message: CRITICAL - DBI connect(';host=Host.domain.de;port=50100;encryptPassword=1','username',...) failed: OpenClient messag ORIGIN = (0) SEVERITY = (78) NUMBER = (44) Server , database Message String: Server name not found in configuration files. OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34) Server , database Message String: Adaptive Server connection failed at /usr/lib64/nagios/plugins_contrib/check_mssql_health line 6601. Okay, with freetds 1.1.1 we're not able to connect against the server to, so we updated to freetds 1.3.17 with openssl 1.1.1o and we get the last mssql_health_check (2.7.4) Now wie could connect with freetds, but the mssql_health_check still throws an error. After some tests, we find out, that the newest DBD-Sybase is not able to do the connection, and, in my opinion so the check_mssql_check, who use the DBD-Sybase can't connect.. is it right?

Here a test with dbd-sybase: DBI connect(';host=Servername;port=50100','user',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (44) Server , database Message String: Server name not found in configuration files. OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (49) Server , database Message String: Unexpected EOF from the server OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34) Server , database Message String: Adaptive Server connection failed OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34) Server , database Message String: Adaptive Server connection failed at ./sqltest.pl line 9. The same error.. How to connect to the mssql server 2022 with check_mssql_health?

lgmu commented 6 months ago

Hi, we are successfully monitoring SQL Server 2022:

./check_mssql_health --server '' --port 1433 --username '' --password '' --timeout 60 --commit --mode connection-time OK - 0.03 seconds to connect as

We are using v2.7.4 and freetds v1.3.16 Make sure that the user is correctly created on the database and has the correct permissions, otherwise the error will be misleading but it's actually a login problem.