Wndows SNMP wizard does not create Wnd Service service check

[corkyman]

I upgraded the Windows SNMP wizard and ran it to create several Windows services service checks. The wizard ran fine and applied the config but no service checks are created. This problem is consistent in my dev environment. In my prod environment I did not upgrade the wizard and results are inconsistent -- it might create the service check that is seen in core but not XI (I submitted a different incident) or it can create the service check fine or it might fail to create it.

[rkennedy]

Can you please PM over a profile for us to review? (Admin -> System Profile -> Download Profile)

With this it should be a bit more clear as to what's going on. Also, please run the following commands and post the full output -

Code: Select all

grep "date.timezone" /etc/php.ini
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
date
mysql -unagiosxi -pn@gweb -e "SELECT NOW();"

In the past, I've seen the timestamps not lining up lead to a similar problem.

[corkyman]

The info is here and profile is attached.

[c601018@vhlgnngxi071 ~]$ grep "date.timezone" /etc/php.ini
; http://www.php.net/manual/en/datetime.c ... e.timezone
date.timezone = UTC
[c601018@vhlgnngxi071 ~]$ ls -l /etc/localtime
lrwxrwxrwx 1 root root 23 Jan 4 19:45 /etc/localtime -> /usr/share/zoneinfo/UTC
[c601018@vhlgnngxi071 ~]$ php -r 'echo date("D M j G:i:s T Y")."\n";'
Thu Jan 26 12:38:00 UTC 2017
[c601018@vhlgnngxi071 ~]$ date
Thu Jan 26 12:38:06 UTC 2017
[c601018@vhlgnngxi071 ~]$ mysql -unagiosxi -pn@gweb -e "SELECT NOW();"
+---------------------+
| NOW() |
+---------------------+
| 2017-01-26 12:38:19 |
+---------------------+
[c601018@vhlgnngxi071 ~]$

[lmiltchev]

I haven't been able to recreate the issue you are describing.

What is the version of the "Windows SNMP" wizard that you are currently using? Have you checked the mysqld.log on the remote server for errors/crashed tables?

[corkyman]

I am using the latest version:

Windows SNMP
Monitor a Microsoft® Windows workstation or server using SNMP.
Version: 1.4.9

I have asked my DBA for the log.

[rkennedy]

Can you post /var/log/mysqld.log or /var/log/mariadb.log (path may vary) for us to review? You may have crashed tables occurring.

Also, are there any special characters in your password or service names? If you're able to show us a screenshot of what you're attempting to use we can try to re-create this further in house.

[corkyman]

I see errors in the log. These errors in mysqld.log have today's time stamp:

2017-01-30T13:32:58.547847Z 6036876 [Note] Aborted connection 6036876 to db: 'nagios' user: 'ndoutils' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T13:32:58.547981Z 6036875 [Note] Aborted connection 6036875 to db: 'nagiosxi' user: 'nagiosxi' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T13:32:58.549218Z 6036877 [Note] Aborted connection 6036877 to db: 'nagiosql' user: 'nagiosql' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T14:29:27.485516Z 5783805 [Note] Aborted connection 5783805 to db: 'nagios' user: 'ndoutils' host: '10.5.197.38' (Got an error reading communication packets)
2017-01-30T15:53:24.319782Z 6031989 [Note] Aborted connection 6031989 to db: 'nagios' user: 'ndoutils' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T15:53:24.319911Z 6031990 [Note] Aborted connection 6031990 to db: 'nagiosql' user: 'nagiosql' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T15:53:24.319994Z 6031988 [Note] Aborted connection 6031988 to db: 'nagiosxi' user: 'nagiosxi' host: '10.5.197.39' (Got timeout reading communication packets)

10.5.197.38 is my primary Nagios XI server
10.5.197.39 is my backup Nagios XI server

There is a character '@' in the password.

I'll attach the screen shots shortly.

[corkyman]

Screen shots attached

[rkennedy]

I see errors in the log. These errors in mysqld.log have today's time stamp:

2017-01-30T13:32:58.547847Z 6036876 [Note] Aborted connection 6036876 to db: 'nagios' user: 'ndoutils' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T13:32:58.547981Z 6036875 [Note] Aborted connection 6036875 to db: 'nagiosxi' user: 'nagiosxi' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T13:32:58.549218Z 6036877 [Note] Aborted connection 6036877 to db: 'nagiosql' user: 'nagiosql' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T14:29:27.485516Z 5783805 [Note] Aborted connection 5783805 to db: 'nagios' user: 'ndoutils' host: '10.5.197.38' (Got an error reading communication packets)
2017-01-30T15:53:24.319782Z 6031989 [Note] Aborted connection 6031989 to db: 'nagios' user: 'ndoutils' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T15:53:24.319911Z 6031990 [Note] Aborted connection 6031990 to db: 'nagiosql' user: 'nagiosql' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-30T15:53:24.319994Z 6031988 [Note] Aborted connection 6031988 to db: 'nagiosxi' user: 'nagiosxi' host: '10.5.197.39' (Got timeout reading communication packets)

10.5.197.38 is my primary Nagios XI server
10.5.197.39 is my backup Nagios XI server

There is a character '@' in the password.

I'll attach the screen shots shortly.

Just to get on the same page - what log file is this server from? Your primary or backup XI server?

[corkyman]

This is from the MySQL server. The MySQL db there is shared between the two and only one server has ndo2db and nagios services running.