search

lausser / check_nwc_health

nwc = network component. This plugin checks lots of aspects of routers, switches, wlan controllers, firewalls,.....
http://labs.consol.de/nagios/check_nwc_health
GNU General Public License v2.0
146 stars 88 forks source link

Message String: Adaptive Server connection failed #313

Closed proebstle closed 1 year ago

proebstle commented 1 year ago

Hi,

running on Debian GNU/Linux 10 (buster) since last update apt-get update and upgrade the follow error on "old" SQL Servers. New SQL Servers without problems....

/omd/sites/xxx/lib/monitoring-plugins/check_mssql_health --offlineok --notemp --multiline --server 'KK-SQL-02' --username 'sa' --password xxx --mode cpu-busy

CRITICAL - DBI connect(';server=KK-SQL-02;encryptPassword=1','sa',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34) Server KK-SQL-02, database Message String: Adaptive Server connection failed OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34) Server KK-SQL-02, database Message String: Adaptive Server connection failed at /omd/sites/xxx/lib/monitoring-plugins/check_mssql_health line 6718.

Any idea?

lausser commented 1 year ago

I have no idea. Maybe the old servers do not use encrypted communication and the pre-upgrade-freetds libraries ignored the encryptPassword=1 but now enforce encryption?

proebstle commented 1 year ago

After new update issue solved...

The following packages will be upgraded: libapache2-mod-php7.3 php7.3 php7.3-cgi php7.3-cli php7.3-common php7.3-gd php7.3-json php7.3-mbstring php7.3-opcache php7.3-readline php7.3-sqlite3 php7.3-xml 12 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.

lausser commented 1 year ago

What??!?! Updated PHP-packages solved a MS SQL issue with a Perl plugin? Strange, but i wish every issue could be solved so easily. :-)