Wndows SNMP wizard does not create Wnd Service service check

[tgriep]

Lets run a repair of the MYSQL database and see if that fixes the issue.
Login as root to the Nagios server and run the following command.

Code: Select all

mysqlcheck -f -r -u nagiosql -pnagios --database nagiosql -h 10.7.123.76 -P 3382

After this, try the wizard again and see it that fixes the issue.

[corkyman]

Sorry for the delay. I ran the repair and it looks like the db is ok. The wizard did not create the check after I tried it.

Code: Select all

nagiosql.tbl_command                               OK
nagiosql.tbl_contact                               OK
nagiosql.tbl_contactgroup                          OK
nagiosql.tbl_contacttemplate                       OK
nagiosql.tbl_domain                                OK
nagiosql.tbl_host                                  OK
nagiosql.tbl_hostdependency                        OK
nagiosql.tbl_hostescalation                        OK
nagiosql.tbl_hostextinfo                           OK
nagiosql.tbl_hostgroup                             OK
nagiosql.tbl_hosttemplate                          OK
nagiosql.tbl_info                                  OK
nagiosql.tbl_lnkContactToCommandHost               OK
nagiosql.tbl_lnkContactToCommandService            OK
nagiosql.tbl_lnkContactToContactgroup              OK
nagiosql.tbl_lnkContactToContacttemplate           OK
nagiosql.tbl_lnkContactToVariabledefinition        OK
nagiosql.tbl_lnkContactgroupToContact              OK
nagiosql.tbl_lnkContactgroupToContactgroup         OK
nagiosql.tbl_lnkContacttemplateToCommandHost       OK
nagiosql.tbl_lnkContacttemplateToCommandService    OK
nagiosql.tbl_lnkContacttemplateToContactgroup      OK
nagiosql.tbl_lnkContacttemplateToContacttemplate   OK
nagiosql.tbl_lnkContacttemplateToVariabledefinition OK
nagiosql.tbl_lnkHostToContact                      OK
nagiosql.tbl_lnkHostToContactgroup                 OK
nagiosql.tbl_lnkHostToHost                         OK
nagiosql.tbl_lnkHostToHostgroup                    OK
nagiosql.tbl_lnkHostToHosttemplate                 OK
nagiosql.tbl_lnkHostToVariabledefinition           OK
nagiosql.tbl_lnkHostdependencyToHost_DH            OK
nagiosql.tbl_lnkHostdependencyToHost_H             OK
nagiosql.tbl_lnkHostdependencyToHostgroup_DH       OK
nagiosql.tbl_lnkHostdependencyToHostgroup_H        OK
nagiosql.tbl_lnkHostescalationToContact            OK
nagiosql.tbl_lnkHostescalationToContactgroup       OK
nagiosql.tbl_lnkHostescalationToHost               OK
nagiosql.tbl_lnkHostescalationToHostgroup          OK
nagiosql.tbl_lnkHostgroupToHost                    OK
nagiosql.tbl_lnkHostgroupToHostgroup               OK
nagiosql.tbl_lnkHosttemplateToContact              OK
nagiosql.tbl_lnkHosttemplateToContactgroup         OK
nagiosql.tbl_lnkHosttemplateToHost                 OK
nagiosql.tbl_lnkHosttemplateToHostgroup            OK
nagiosql.tbl_lnkHosttemplateToHosttemplate         OK
nagiosql.tbl_lnkHosttemplateToVariabledefinition   OK
nagiosql.tbl_lnkServiceToContact                   OK
nagiosql.tbl_lnkServiceToContactgroup              OK
nagiosql.tbl_lnkServiceToHost                      OK
nagiosql.tbl_lnkServiceToHostgroup                 OK
nagiosql.tbl_lnkServiceToServicegroup              OK
nagiosql.tbl_lnkServiceToServicetemplate           OK
nagiosql.tbl_lnkServiceToVariabledefinition        OK
nagiosql.tbl_lnkServicedependencyToHost_DH         OK
nagiosql.tbl_lnkServicedependencyToHost_H          OK
nagiosql.tbl_lnkServicedependencyToHostgroup_DH    OK
nagiosql.tbl_lnkServicedependencyToHostgroup_H     OK
nagiosql.tbl_lnkServicedependencyToService_DS      OK
nagiosql.tbl_lnkServicedependencyToService_S       OK
nagiosql.tbl_lnkServiceescalationToContact         OK
nagiosql.tbl_lnkServiceescalationToContactgroup    OK
nagiosql.tbl_lnkServiceescalationToHost            OK
nagiosql.tbl_lnkServiceescalationToHostgroup       OK
nagiosql.tbl_lnkServiceescalationToService         OK
nagiosql.tbl_lnkServicegroupToService              OK
nagiosql.tbl_lnkServicegroupToServicegroup         OK
nagiosql.tbl_lnkServicetemplateToContact           OK
nagiosql.tbl_lnkServicetemplateToContactgroup      OK
nagiosql.tbl_lnkServicetemplateToHost              OK
nagiosql.tbl_lnkServicetemplateToHostgroup         OK
nagiosql.tbl_lnkServicetemplateToServicegroup      OK
nagiosql.tbl_lnkServicetemplateToServicetemplate   OK
nagiosql.tbl_lnkServicetemplateToVariabledefinition OK
nagiosql.tbl_lnkTimeperiodToTimeperiod             OK
nagiosql.tbl_logbook                               OK
nagiosql.tbl_mainmenu                              OK
nagiosql.tbl_service                               OK
nagiosql.tbl_servicedependency                     OK
nagiosql.tbl_serviceescalation                     OK
nagiosql.tbl_serviceextinfo                        OK
nagiosql.tbl_servicegroup                          OK
nagiosql.tbl_servicetemplate                       OK
nagiosql.tbl_settings                              OK
nagiosql.tbl_submenu                               OK
nagiosql.tbl_timedefinition                        OK
nagiosql.tbl_timeperiod                            OK
nagiosql.tbl_user                                  OK
nagiosql.tbl_variabledefinition                    OK

[rkennedy]

Can you actually run this against the remote database?

Code: Select all

mysql -unagiosxi -pn@gweb -h<iphere> -e "SELECT NOW();"

[corkyman]

-bash-4.1$ mysql -unagiosxi -pn@gweb -h10.7.123.76 -P3382 -e "SELECT NOW();"
+---------------------+
| NOW() |
+---------------------+
| 2017-02-06 18:55:37 |
+---------------------+

[rkennedy]

Can you also show us the date / time on the local XI machines, when running the offloaded time? We'll need a comparison to make sure the time is indeed lining up here.

[corkyman]

On the primary server vhlgnngxi071

-bash-4.1$ date
Tue Feb 7 13:03:40 UTC 2017
-bash-4.1$ mysql -unagiosxi -pn@gweb -h10.7.123.76 -P3382 -e "SELECT NOW();"
+---------------------+
| NOW() |
+---------------------+
| 2017-02-07 13:04:27 |
+---------------------+
-bash-4.1$ date
Tue Feb 7 13:04:29 UTC 2017
-bash-4.1$


On the backup server vhlgnngxi072

[c601018@vhlgnngxi072 ~]$ date
Tue Feb 7 08:04:31 EST 2017
[c601018@vhlgnngxi072 ~]$ sudo su - nagios
-bash-4.1$ service nagios status
No lock file found in /usr/local/nagios/var/nagios.lock
-bash-4.1$ service ndo2db status
ndo2db is not running

The backup server stayed on EST even after changing it to UTC in Admin -> System Settings -> Timezone Settings. Please see the screen shot attached. The services are down on 072 so it should not matter for in this instance.

[rkennedy]

On the primary server vhlgnngxi071

-bash-4.1$ date
Tue Feb 7 13:03:40 UTC 2017
-bash-4.1$ mysql -unagiosxi -pn@gweb -h10.7.123.76 -P3382 -e "SELECT NOW();"
+---------------------+
| NOW() |
+---------------------+
| 2017-02-07 13:04:27 |
+---------------------+
-bash-4.1$ date
Tue Feb 7 13:04:29 UTC 2017
-bash-4.1$


On the backup server vhlgnngxi072

[c601018@vhlgnngxi072 ~]$ date
Tue Feb 7 08:04:31 EST 2017
[c601018@vhlgnngxi072 ~]$ sudo su - nagios
-bash-4.1$ service nagios status
No lock file found in /usr/local/nagios/var/nagios.lock
-bash-4.1$ service ndo2db status
ndo2db is not running

The backup server stayed on EST even after changing it to UTC in Admin -> System Settings -> Timezone Settings. Please see the screen shot attached. The services are down on 072 so it should not matter for in this instance.

This is going to be a problem - you'll need to have the times line up all across the board, including with PHP.

[corkyman]

The times were changed to UTC across the board by the Linux admin. I rerun the wizard and still it does not create any checks.

[rkennedy]

Let's take the wizard out of play here - if you run through and create a brand new host or command or any object in general on the XI system through the Core Config Manager - then apply configuration - does it properly add to the system, or what do you see happen? Please provide as much information as possible.

[corkyman]

Yes, creating objects in Core works just fine--this is how I currently circumventing this problem. The attached document shows the steps of creating a cpu service check on a server by copying an existing one. Another document shows similar steps done though the wizard to create a memory service check.