Nagios Support Forum

Hello,

We are getting the error again on all servers. We did not do any changes from our end, not sure exactly why this issue happened.
We checked the port 1433, its now open on all servers. We also checked using admin credentials that has all right on server and DB. Could you please help us to resolve it on priority.

Is there any possibility that odbc driver is having some issue?
What is FreeTDS here?

I am attaching system profile here for your reference.

[root@HO1-NAGIOSXI ~]# /usr/local/nagios/libexec/check_mssql_server.php -H ho1-dcapp.chalhoub.org --checktype 'database' -U 'nagios' -P 'Nagi0s123' --instancename 'HO1-DCAPP' --perftype default -I 'HO1-DCAPP' -p 1433 --mode time2connect --warning 30 --critical 60
ERROR: [run_check] CRITICAL: Could not connect to odbc:Driver=FreeTDS;Server=ho1-dcapp.chalhoub.org\HO1-DCAPP as nagios (Exception: SQLSTATE[08S01] SQLDriverConnect: 20009 [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist)
CRITICAL: Could not connect to odbc:Driver=FreeTDS;Server=ho1-dcapp.chalhoub.org\HO1-DCAPP as nagios (Exception: SQLSTATE[08S01] SQLDriverConnect: 20009 [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist).
[root@HO1-NAGIOSXI ~]#

Hello,

Just to add an update here.
We have added extra RAM and CPU to our Nagios XI server just to avoid any congestion because of space.

RAM -> 32 GB
CPU -> 16 cores

[root@HO1-NAGIOSXI ~]# free -g
total used free shared buff/cache available
Mem: 31 2 23 0 5 27
Swap: 9 0 9
[root@HO1-NAGIOSXI ~]#

We also increased “max_connections” value and restarted mysqld service.

[root@HO1-NAGIOSXI ~]# mysql -uroot -pnagiosxi -e "show variables like 'max_connections';"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 1000 |
+-----------------+-------+
[root@HO1-NAGIOSXI ~]#
[root@HO1-NAGIOSXI ~]#
[root@HO1-NAGIOSXI ~]#
[root@HO1-NAGIOSXI ~]# mysql -uroot -pnagiosxi -e "show global status like 'Max_used_connections';"
mysql: [Warning] Using a password on the command line interface can be insecure.
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 51 |
+----------------------+-------+
[root@HO1-NAGIOSXI ~]#


After that we tested the MSSQL service command and it is still giving same error.

[root@HO1-NAGIOSXI ~]# /usr/local/nagios/libexec/check_mssql_server.php -H ho1-dcapp.chalhoub.org --checktype 'database' -U 'nagios' -P 'Nagi0s123' --instancename 'HO1-DCAPP' --perftype default -I 'HO1-DCAPP' -p 1433 --mode time2connect --warning 30 --critical 60
ERROR: [run_check] CRITICAL: Could not connect to odbc:Driver=FreeTDS;Server=ho1-dcapp.chalhoub.org\HO1-DCAPP as nagios (Exception: SQLSTATE[08S01] SQLDriverConnect: 20009 [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist)
CRITICAL: Could not connect to odbc:Driver=FreeTDS;Server=ho1-dcapp.chalhoub.org\HO1-DCAPP as nagios (Exception: SQLSTATE[08S01] SQLDriverConnect: 20009 [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist).
[root@HO1-NAGIOSXI ~]#


Could you please take a remote session and look into the issue on priority?

I have updated your other ticket requesting you schedule a remote session for the VSCA issue, we'll take a look at this one as well during that remote session.

Hello,

Can we get an early slot for the same. I checked your booking slot, the latest one available is for Friday. We are sitting in IST zone.
Could you please help us on it?

I apologize but what I have listed on the calendar is what I have available, I'm pretty booked up because we're busy. We only have technicians in the CST timezone, you can see our hours here:

https://www.nagios.com/contact/

Hello Sean,

As we worked on MSSQL services issue in remote session, I added the host details in /etc/freetds.conf file. We tested all hosts from backend and all of them are working fine. Below are few examples:

[root@vmaz-nagiosxi ~]# /usr/local/nagios/libexec/check_mssql_server.php -H BGDC-BAAN1.chalhoub.org --checktype 'database' -U 'nagios' -P 'Nagi0s123' --instancename 'BGDC-BAAN1' --perftype default -p 1433 --mode time2connect --warning 1 --critical 5
OK: Time to connect was 0.391788s|time=0.391788s;1;5;;
[root@vmaz-nagiosxi ~]#

[root@vmaz-nagiosxi ~]# /usr/local/nagios/libexec/check_mssql_server.php -H KSA-JED-TAS.realksa.org --checktype 'database' -U 'nagios' -P 'Nagi0s123' --instancename 'KSA-JED-TAS' --perftype default -p 1433 --mode time2connect --warning 1 --critical 5
OK: Time to connect was 0.404508s|time=0.404508s;1;5;;


[root@vmaz-nagiosxi ~]# /usr/local/nagios/libexec/check_mssql_server.php -H LLC-BAAN1.chalhoub.org --checktype 'database' -U 'nagios' -P 'Nagi0s123' --instancename 'LLC-BAAN1' --perftype default -p 1433 --mode time2connect --warning 1 --critical 5
WARNING: Time to connect was 1.719148s|time=1.719148s;1;5;;

In Nagios XI console, they are still in Critical state giving the same error as it was earlier.
As per your suggestion, I also checked the same in Nagios Core to undertsand if it is actually reflection there as our nagios XI is slow.
In nagios core as well, I can see them in critical state. I am really not sure why it is behaving so wiered.


We want to see them GREEN in Nagios XI. Its been more than 24 hours now, we made the changes and it is still in critical state. Could you please look into it on priority.

Thanks again for your support!!

Please PM me a fresh copy of your profile, schedule another remote session as well in the event the profile doesn't give me the answers.