Page 2 of 3
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Mon Jan 30, 2017 5:50 pm
by 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.
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Fri Feb 03, 2017 9:40 am
by 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
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Fri Feb 03, 2017 10:17 am
by rkennedy
Can you actually run this against the remote database?
Code: Select all
mysql -unagiosxi -pn@gweb -h<iphere> -e "SELECT NOW();"
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Mon Feb 06, 2017 1:56 pm
by corkyman
-bash-4.1$ mysql -unagiosxi -pn@gweb -h10.7.123.76 -P3382 -e "SELECT NOW();"
+---------------------+
| NOW() |
+---------------------+
| 2017-02-06 18:55:37 |
+---------------------+
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Mon Feb 06, 2017 2:31 pm
by 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.
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Tue Feb 07, 2017 8:13 am
by 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.
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Tue Feb 07, 2017 10:38 am
by rkennedy
corkyman wrote: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.
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Thu Feb 09, 2017 9:39 am
by 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.
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Thu Feb 09, 2017 11:34 am
by 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.
Re: Wndows SNMP wizard does not create Wnd Service service c
Posted: Thu Feb 09, 2017 1:24 pm
by 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.