Nagios Support Forum

Posted: **Wed Jan 02, 2019 2:26 pm**

Object Does Not Exist

when i click on the service details, i get object does not exist, i have looked all the config files, the user have permission to access. when i navigate to service status, all the hosts are grayed out. I am using Nagios Xi 5.5.6.

Thanks,

Posted: **Wed Jan 02, 2019 4:32 pm**

Is this the same server from your other post that is having the MYSQL database issue?
If so, the issue with the MYSQL database needs to be resolved as that would cause the "Object Does Not Exist" errors.

Can you get a System Profile from the server and post it here or PM it to me so we can check the log files for any errors?
To get your system profile. Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and upload it to the post or PM it to me if you prefer.

Posted: **Wed Jan 02, 2019 4:45 pm**

tgriep wrote:Is this the same server from your other post that is having the MYSQL database issue?
If so, the issue with the MYSQL database needs to be resolved as that would cause the "Object Does Not Exist" errors.

Can you get a System Profile from the server and post it here or PM it to me so we can check the log files for any errors?
To get your system profile. Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and upload it to the post or PM it to me if you prefer.

yes, this is the same server having the DB issue, DB issue is seen only in some users where as objects does not exists are shown in all users .

System profile is sent in PM, please have a look.
Thanks,

Posted: **Wed Jan 02, 2019 5:56 pm**

Thanks I received the Profile.
Your MYSQL server is offloaded to a remote server so to repair the databases, run the following on the Nagios server but replace xxx.xxx.xxx.xxx with the IP address of the MYSQL server.

Code: Select all

mysqlcheck -f -r -u nagiosxi -pnagios --database nagiosxi -h xxx.xxx.xxx.xxx
mysqlcheck -f -r -u nagios -pnagios --databases nagios  -h xxx.xxx.xxx.xxx
mysqlcheck -f -r -u nagiosql -pnagios --database nagiosql -h xxx.xxx.xxx.xxx

Post here if that fixes the issue.

Posted: **Thu Jan 03, 2019 9:14 am**

tgriep wrote:Thanks I received the Profile.
Your MYSQL server is offloaded to a remote server so to repair the databases, run the following on the Nagios server but replace xxx.xxx.xxx.xxx with the IP address of the MYSQL server.
Code: Select all
mysqlcheck -f -r -u nagiosxi -pnagios --database nagiosxi -h xxx.xxx.xxx.xxx
mysqlcheck -f -r -u nagios -pnagios --databases nagios  -h xxx.xxx.xxx.xxx
mysqlcheck -f -r -u nagiosql -pnagios --database nagiosql -h xxx.xxx.xxx.xxx
Post here if that fixes the issue.

It didn't work out.

Code: Select all

mysqlcheck -f -r -u nagiosxi -pnagiosxi --database nagiosxi -h xxx.xxx.xxx.xxx
nagiosxi.xi_auditlog
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_auth_tokens
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_cmp_trapdata
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_cmp_trapdata_log
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_commands
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_eventqueue
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_events
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_incidents
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_meta
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_options
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_sessions
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_sysstat
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_usermeta
note     : The storage engine for the table doesn't support repair
nagiosxi.xi_users
note     : The storage engine for the table doesn't support repair

Code: Select all

mysqlcheck -f -r -u nagios -pnagios --databases nagios  -h xx.xxx.xx
nagios.nagios_acknowledgements                     OK
nagios.nagios_commands                             OK
nagios.nagios_commenthistory                       OK
nagios.nagios_comments                             OK
nagios.nagios_configfiles                          OK
nagios.nagios_configfilevariables                  OK
nagios.nagios_conninfo                             OK
nagios.nagios_contact_addresses                    OK
nagios.nagios_contact_notificationcommands         OK
nagios.nagios_contactgroup_members                 OK
nagios.nagios_contactgroups                        OK
nagios.nagios_contactnotificationmethods           OK
nagios.nagios_contactnotifications                 OK
nagios.nagios_contacts                             OK
nagios.nagios_contactstatus                        OK
nagios.nagios_customvariables                      OK
nagios.nagios_customvariablestatus                 OK
nagios.nagios_dbversion                            OK
nagios.nagios_downtimehistory                      OK
nagios.nagios_eventhandlers                        OK
nagios.nagios_externalcommands                     OK
nagios.nagios_flappinghistory                      OK
nagios.nagios_host_contactgroups                   OK
nagios.nagios_host_contacts                        OK
nagios.nagios_host_parenthosts                     OK
nagios.nagios_hostchecks                           OK
nagios.nagios_hostdependencies                     OK
nagios.nagios_hostescalation_contactgroups         OK
nagios.nagios_hostescalation_contacts              OK
nagios.nagios_hostescalations                      OK
nagios.nagios_hostgroup_members                    OK
nagios.nagios_hostgroups                           OK
nagios.nagios_hosts                                OK
nagios.nagios_hoststatus                           OK
nagios.nagios_instances                            OK
nagios.nagios_logentries                           OK
nagios.nagios_notifications                        OK
nagios.nagios_objects                              OK
nagios.nagios_processevents                        OK
nagios.nagios_programstatus                        OK
nagios.nagios_runtimevariables                     OK
nagios.nagios_scheduleddowntime                    OK
nagios.nagios_service_contactgroups                OK
nagios.nagios_service_contacts                     OK
nagios.nagios_service_parentservices               OK
nagios.nagios_servicechecks                        OK
nagios.nagios_servicedependencies                  OK
nagios.nagios_serviceescalation_contactgroups      OK
nagios.nagios_serviceescalation_contacts           OK
nagios.nagios_serviceescalations                   OK
nagios.nagios_servicegroup_members                 OK
nagios.nagios_servicegroups                        OK
nagios.nagios_services                             OK
nagios.nagios_servicestatus                        OK
nagios.nagios_statehistory                         OK
nagios.nagios_systemcommands                       OK
nagios.nagios_timedeventqueue                      OK
nagios.nagios_timedevents                          OK
nagios.nagios_timeperiod_timeranges                OK
nagios.nagios_timeperiods                          OK

Code: Select all

# mysqlcheck -f -r -u nagiosql -pnagios --database nagiosql -h xx.xxx.xxx
nagiosql.tbl_command
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_contact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_contactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_contacttemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_domain
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_host
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_hostdependency
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_hostescalation
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_hostextinfo
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_hostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_hosttemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_info
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContactToCommandHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContactToCommandService
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContactToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContactToContacttemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContactToVariabledefinition
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContactgroupToContact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContactgroupToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContacttemplateToCommandHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContacttemplateToCommandService
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContacttemplateToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContacttemplateToContacttemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkContacttemplateToVariabledefinition
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostToContact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostToHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostToHostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostToHosttemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostToVariabledefinition
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostdependencyToHost_DH
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostdependencyToHost_H
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostdependencyToHostgroup_DH
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostdependencyToHostgroup_H
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostescalationToContact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostescalationToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostescalationToHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostescalationToHostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostgroupToHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHostgroupToHostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHosttemplateToContact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHosttemplateToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHosttemplateToHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHosttemplateToHostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHosttemplateToHosttemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkHosttemplateToVariabledefinition
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceToContact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceToHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceToHostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceToServicegroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceToServicetemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceToVariabledefinition
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicedependencyToHost_DH
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicedependencyToHost_H
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicedependencyToHostgroup_DH
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicedependencyToHostgroup_H
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicedependencyToService_DS
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicedependencyToService_S
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceescalationToContact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceescalationToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceescalationToHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceescalationToHostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServiceescalationToService
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicegroupToService
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicegroupToServicegroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicetemplateToContact
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicetemplateToContactgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicetemplateToHost
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicetemplateToHostgroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicetemplateToServicegroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicetemplateToServicetemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkServicetemplateToVariabledefinition
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_lnkTimeperiodToTimeperiod
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_logbook
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_mainmenu
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_permission
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_permission_inactive
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_service
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_servicedependency
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_serviceescalation
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_serviceextinfo
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_servicegroup
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_servicetemplate
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_session
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_session_locks
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_settings
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_submenu
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_timedefinition
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_timeperiod
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_user
note     : The storage engine for the table doesn't support repair
nagiosql.tbl_variabledefinition
note     : The storage engine for the table doesn't support repair

Posted: **Thu Jan 03, 2019 1:05 pm**

I did not find any errors in the profile so can you provide more details on the remote MYSQL server?
What OS and Release it is running?
Do you have any other Nagios server at your site and is the other server pointing to the same offloaded MYSQL server?
Did you login to the offloaded MYSQL server and check the database log files for any errors?
Can you get the MYSQL server config files and post them here?

Code: Select all

/etc/my.cnf

and all of the files from the following folder.

Code: Select all

/etc/my.cnf.d

Can you login to the nagios server. run the following commands and post the output here?

Code: Select all

su - nagios
cd /usr/local/nagiosxi/scripts
./reconfigure_nagios.sh

Thanks

Nagios Support Forum

Object does not exist

Object does not exist

Re: Object does not exist

Re: Object does not exist

Re: Object does not exist

Re: Object does not exist

Re: Object does not exist