Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

Host and Services not display in home page.No data display

https://support.nagios.com/forum/viewtopic.php?t=49734

Page 1 of 2

Host and Services not display in home page.No data display

Posted: Thu Aug 02, 2018 10:45 am
by Drishti
Hi,

I have configured few hosts and services through - Core configuration -> services, but it is not displaying in home -> services status or host status or graph.

Re: Host and Services not display in home page.No data displ

Posted: Thu Aug 02, 2018 4:17 pm
by scottwilkerson
Did you Apply Configuration?

If so and it succeeded, then lets do the following

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
service nagios stop
killall -9 nagios
service nagios start

Re: Host and Services not display in home page.No data displ

Posted: Fri Aug 03, 2018 8:21 am
by Drishti
Service nagios not found.
NagiosXI not working if I stop apache2 service.

Output of repair_database.sh

Code: Select all

DATABASE: nagios
TABLE:
/var/lib/mysql/nagios /usr/local/nagiosxi/scripts
mysql stop/waiting
- recovering (with sort) MyISAM-table 'nagios_acknowledgements'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commands'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commenthistory'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_comments'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfiles'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfilevariables'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_conninfo'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_contact_addresses'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroup_members'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotifications'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactstatus'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_customvariables'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_customvariablestatus'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with keycache) MyISAM-table 'nagios_dbversion'
Data records: 1

---------

- recovering (with sort) MyISAM-table 'nagios_downtimehistory'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_eventhandlers'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_externalcommands'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_flappinghistory'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_hostchecks'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostdependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroup_members'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_parenthosts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hosts'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_hoststatus'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_instances'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_logentries'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_notifications'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_objects'
Data records: 118
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_processevents'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_programstatus'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_runtimevariables'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicechecks'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_service_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicedependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroup_members'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_parentservices'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_services'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_servicestatus'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_statehistory'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_systemcommands'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_timedeventqueue'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timedevents'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiods'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges'
Data records: 0
- Fixing index 1
- Fixing index 2
mysql start/running, process 19022
/usr/local/nagiosxi/scripts

===============
REPAIR COMPLETE
===============
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql /usr/local/nagiosxi/scripts
No *.MYI files found, skipping nagiosql...
DATABASE: nagiosxi
TABLE:
/var/lib/mysql/nagiosxi /usr/local/nagiosxi/scripts
No *.MYI files found, skipping nagiosxi...
Stopping ndo2db: done.
Starting ndo2db: done.
Stopping nagios: done.
Starting nagios: done.

=======================
nagios database repair succeeded
nagiosql database repair skipped, no *.MYI files found
nagiosxi database repair skipped, no *.MYI files found

Re: Host and Services not display in home page.No data displ

Posted: Fri Aug 03, 2018 12:28 pm
by scottwilkerson
This error is concerning

Code: Select all

nagiosql database repair skipped, no *.MYI files found
Seems your database is gone.

Do you have a recent backup that you can restore?

Re: Host and Services not display in home page.No data displ

Posted: Sat Aug 04, 2018 12:43 am
by Drishti
Hi,

Thanks for your reply @scottwilkerson.

I have configured only 2 host and few services for testing. this is fresh installation. I didn't configured anything important still now.

Can you pls help me to delete current database and recreate new database .?

Re: Host and Services not display in home page.No data displ

Posted: Mon Aug 06, 2018 7:10 am
by scottwilkerson
Can you show the output of the following

Code: Select all

ll /store/backups/mysql/daily/nagiosql/

Re: Host and Services not display in home page.No data displ

Posted: Mon Aug 06, 2018 7:44 am
by Drishti

Code: Select all

 ll /store/backups/mysql/daily/nagiosql/
total 44
drwxr-xr-x 2 root root  4096 Aug  3 07:00 ./
drwxr-xr-x 7 root root  4096 Aug  3 07:00 ../
-rw-r--r-- 1 root root 33224 Aug  3 07:00 nagiosql_2018-08-03_07h00m.Friday.sql.gz

Code: Select all

 ll /store/backups/mysql/daily/nagiosxi/
total 28
drwxr-xr-x 2 root root  4096 Aug  3 07:00 ./
drwxr-xr-x 7 root root  4096 Aug  3 07:00 ../
-rw-r--r-- 1 root root 16745 Aug  3 07:00 nagiosxi_2018-08-03_07h00m.Friday.sql.gz

Re: Host and Services not display in home page.No data displ

Posted: Mon Aug 06, 2018 8:08 am
by scottwilkerson
This should restore the nagiosql database

Code: Select all

cd /store/backups/mysql/daily/nagiosql/
gunzip nagiosql_2018-08-03_07h00m.Friday.sql.gz
cat nagiosql_2018-08-03_07h00m.Friday.sql |mysql -pnagiosxi

Re: Host and Services not display in home page.No data displ

Posted: Mon Aug 06, 2018 9:05 am
by Drishti
Hi,

I did it but still getting error.

Code: Select all

sudo ./repair_databases.sh
[sudo] password for akshay:
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios /usr/local/nagiosxi/scripts
mysql stop/waiting
- recovering (with sort) MyISAM-table 'nagios_acknowledgements'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commands'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commenthistory'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_comments'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfiles'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfilevariables'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_conninfo'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_contact_addresses'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroup_members'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotifications'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactstatus'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_customvariables'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_customvariablestatus'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with keycache) MyISAM-table 'nagios_dbversion'
Data records: 1

---------

- recovering (with sort) MyISAM-table 'nagios_downtimehistory'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_eventhandlers'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_externalcommands'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_flappinghistory'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_hostchecks'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostdependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroup_members'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_parenthosts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hosts'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_hoststatus'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_instances'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_logentries'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_notifications'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_objects'
Data records: 133
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_processevents'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_programstatus'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_runtimevariables'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicechecks'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_service_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicedependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroup_members'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_parentservices'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_services'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_servicestatus'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_statehistory'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_systemcommands'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_timedeventqueue'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timedevents'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiods'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges'
Data records: 0
- Fixing index 1
- Fixing index 2
mysql start/running, process 535
/usr/local/nagiosxi/scripts

===============
REPAIR COMPLETE
===============
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql /usr/local/nagiosxi/scripts
No *.MYI files found, skipping nagiosql...
DATABASE: nagiosxi
TABLE:
/var/lib/mysql/nagiosxi /usr/local/nagiosxi/scripts
No *.MYI files found, skipping nagiosxi...
Stopping ndo2db: done.
Starting ndo2db: done.
Stopping nagios: .done.
Starting nagios: done.

=======================
nagios database repair succeeded
nagiosql database repair skipped, no *.MYI files found
nagiosxi database repair skipped, no *.MYI files found

Code: Select all

mysql>
mysql>
mysql> use nagiosql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+--------------------------------------------+
| Tables_in_nagiosql                         |
+--------------------------------------------+
| tbl_command                                |
| tbl_contact                                |
| tbl_contactgroup                           |
| tbl_contacttemplate                        |
| tbl_domain                                 |
| tbl_host                                   |
| tbl_hostdependency                         |
| tbl_hostescalation                         |
| tbl_hostextinfo                            |
| tbl_hostgroup                              |
| tbl_hosttemplate                           |
| tbl_info                                   |
| tbl_lnkContactToCommandHost                |
| tbl_lnkContactToCommandService             |
| tbl_lnkContactToContactgroup               |
| tbl_lnkContactToContacttemplate            |
| tbl_lnkContactToVariabledefinition         |
| tbl_lnkContactgroupToContact               |
| tbl_lnkContactgroupToContactgroup          |
| tbl_lnkContacttemplateToCommandHost        |
| tbl_lnkContacttemplateToCommandService     |
| tbl_lnkContacttemplateToContactgroup       |
| tbl_lnkContacttemplateToContacttemplate    |
| tbl_lnkContacttemplateToVariabledefinition |
| tbl_lnkHostToContact                       |
| tbl_lnkHostToContactgroup                  |
| tbl_lnkHostToHost                          |
| tbl_lnkHostToHostgroup                     |
| tbl_lnkHostToHosttemplate                  |
| tbl_lnkHostToVariabledefinition            |
| tbl_lnkHostdependencyToHost_DH             |
| tbl_lnkHostdependencyToHost_H              |
| tbl_lnkHostdependencyToHostgroup_DH        |
| tbl_lnkHostdependencyToHostgroup_H         |
| tbl_lnkHostescalationToContact             |
| tbl_lnkHostescalationToContactgroup        |
| tbl_lnkHostescalationToHost                |
| tbl_lnkHostescalationToHostgroup           |
| tbl_lnkHostgroupToHost                     |
| tbl_lnkHostgroupToHostgroup                |
| tbl_lnkHosttemplateToContact               |
| tbl_lnkHosttemplateToContactgroup          |
| tbl_lnkHosttemplateToHost                  |
| tbl_lnkHosttemplateToHostgroup             |
| tbl_lnkHosttemplateToHosttemplate          |
| tbl_lnkHosttemplateToVariabledefinition    |
| tbl_lnkServiceToContact                    |
| tbl_lnkServiceToContactgroup               |
| tbl_lnkServiceToHost                       |
| tbl_lnkServiceToHostgroup                  |
| tbl_lnkServiceToServicegroup               |
| tbl_lnkServiceToServicetemplate            |
| tbl_lnkServiceToVariabledefinition         |
| tbl_lnkServicedependencyToHost_DH          |
| tbl_lnkServicedependencyToHost_H           |
| tbl_lnkServicedependencyToHostgroup_DH     |
| tbl_lnkServicedependencyToHostgroup_H      |
| tbl_lnkServicedependencyToService_DS       |
| tbl_lnkServicedependencyToService_S        |
| tbl_lnkServiceescalationToContact          |
| tbl_lnkServiceescalationToContactgroup     |
| tbl_lnkServiceescalationToHost             |
| tbl_lnkServiceescalationToHostgroup        |
| tbl_lnkServiceescalationToService          |
| tbl_lnkServicegroupToService               |
| tbl_lnkServicegroupToServicegroup          |
| tbl_lnkServicetemplateToContact            |
| tbl_lnkServicetemplateToContactgroup       |
| tbl_lnkServicetemplateToHost               |
| tbl_lnkServicetemplateToHostgroup          |
| tbl_lnkServicetemplateToServicegroup       |
| tbl_lnkServicetemplateToServicetemplate    |
| tbl_lnkServicetemplateToVariabledefinition |
| tbl_lnkTimeperiodToTimeperiod              |
| tbl_logbook                                |
| tbl_mainmenu                               |
| tbl_permission                             |
| tbl_permission_inactive                    |
| tbl_service                                |
| tbl_servicedependency                      |
| tbl_serviceescalation                      |
| tbl_serviceextinfo                         |
| tbl_servicegroup                           |
| tbl_servicetemplate                        |
| tbl_session                                |
| tbl_session_locks                          |
| tbl_settings                               |
| tbl_submenu                                |
| tbl_timedefinition                         |
| tbl_timeperiod                             |
| tbl_user                                   |
| tbl_variabledefinition                     |
+--------------------------------------------+
92 rows in set (0.00 sec)

Code: Select all

mysql> use nagiosxi
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
    -> ;
+---------------------+
| Tables_in_nagiosxi  |
+---------------------+
| xi_auditlog         |
| xi_auth_tokens      |
| xi_cmp_trapdata     |
| xi_cmp_trapdata_log |
| xi_commands         |
| xi_eventqueue       |
| xi_events           |
| xi_incidents        |
| xi_meta             |
| xi_options          |
| xi_sessions         |
| xi_sysstat          |
| xi_usermeta         |
| xi_users            |
+---------------------+
14 rows in set (0.00 sec)

mysql>

Re: Host and Services not display in home page.No data displ

Posted: Mon Aug 06, 2018 10:50 am
by scottwilkerson
Was this a fresh 5.5.x install?

If so this is not a problem as the new database installs InnoDB as the engine for the nagiosql database, so this error would be normal on the repair_database script.
All times are UTC-05:00
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited