centreon show 0 hosts

[MPL]

hi i have now installed centreon centreon-2.0-b3 but when i opening the "hosts" or "services" on the "monitoring" i got notwhing :/

hosts are enabled ... watch at the pics plz

[WAtt]

Hi

Have you start and config NDO ?

[MPL]

yes

[JAIL]1352 root@xxxxx:/usr/local/nagios/var# ps aux |grep ndo
nagios 5636 0.0 0.0 4384 368 ? Ss 12:57 0:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios 5651 0.0 0.0 5604 1652 ? S 12:57 0:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
root 21820 0.0 0.0 360 96 pts/0 R+ 13:54 0:00 grep ndo


/usr/local/nagios/etc/ndo2db.cfg
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
#socket_type=tcp
socket_name=/usr/local/nagios/var/ndo.sock
tcp_port=5668
db_servertype=mysql
db_host=127.0.0.1
db_port=3306
db_name=nagios
db_prefix=nagios_
db_user=nagios
db_pass=secret
max_timedevents_age=1440
max_systemcommands_age=10080
max_servicechecks_age=10080
max_hostchecks_age=10080
max_eventhandlers_age=44640
debug_level=2
debug_verbosity=2
debug_file=@localstatedir@/ndo2db.debug
max_debug_file_size=1000000


/usr/local/nagios/etc/ndomod.cfg
instance_name=default
#output_type=file
#output_type=tcpsocket
output_type=unixsocket
#output=/usr/local/nagios/var/ndo.dat
#output=127.0.0.1
output=/usr/local/nagios/var/ndo.sock
tcp_port=5668
output_buffer_items=5000
buffer_file=/usr/local/nagios/var/ndomod.tmp
file_rotation_interval=14400
#file_rotation_command=rotate_ndo_log
file_rotation_timeout=60
reconnect_interval=15
reconnect_warning_interval=15
#reconnect_warning_interval=900
data_processing_options=-1
config_output_options=2


mysql:

cfg_ndo2db

cfg_ndo2db` (`id`, `description`, `ndo2db_user`, `ndo2db_group`, `local`, `ns_nagios_server`, `socket_type`, `socket_name`, `tcp_port`, `db_servertype`, `db_host`, `db_name`, `db_port`, `db_prefix`, `db_user`, `db_pass`, `max_timedevents_age`, `max_systemcommands_age`, `max_servicechecks_age`, `max_hostchecks_age`, `max_eventhandlers_age`, `activate`) VALUES
(1, 'Principal', 'nagios', 'nagios', '1', 1, 'unix', '/usr/local/nagios/var/ndo.sock', 5668, 'mysql', '127.0.0.1', 'nagios', '3306', 'nagios_', 'nagios', 'secret', '1440', '1440', '1440', '1440', '1440', '1');



mysql> SELECT check_type , state_type, current_state FROM nagios_hoststatus;
+------------+------------+---------------+
| check_type | state_type | current_state |
+------------+------------+---------------+
| 0 | 1 | 0 |
+------------+------------+---------------+
1 row in set (0.00 sec)

[falc410]

Restart Nagios and look into your /usr/local/nagios/var/nagios.log see if there is something like this:

[1212660776] Nagios 3.0.1 starting... (PID=8645)
[1212660776] Local time is Thu Jun 05 12:12:56 CEST 2008
[1212660776] LOG VERSION: 2.0
[1212660776] ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad (nagios@nagios.org)
[1212660776] ndomod: Successfully connected to data sink. 0 queued items to flush.
[1212660776] Event broker module '/usr/local/nagios/bin/ndomod-3x.o' initialized successfully.


If not check your nagios.cfg like I have described here: http://forum.centreon.com/showthread.php?t=5913

[MPL]

[1212693801] Caught SIGTERM, shutting down...
[1212693801] Successfully shutdown... (PID=14063)
[1212693801] ndomod: Shutdown complete.
[1212693801] Event broker module '/usr/local/nagios/ndo/ndomod.o' deinitialized successfully.
[1212693807] Nagios 3.0.2 starting... (PID=15188)
[1212693807] Local time is Thu Jun 05 21:23:27 CEST 2008
[1212693807] LOG VERSION: 2.0
[1212693807] ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad (nagios@nagios.org)
[1212693807] ndomod: Successfully connected to data sink. 0 queued items to flush.
[1212693807] Event broker module '/usr/local/nagios/ndo/ndomod.o' initialized successfully.
[1212693807] Finished daemonizing... (New PID=15192)


i have checked all configs... and cant find any errors

[busterblues]

I have got the exact same problem I think. I get absolutely no error either, and it appears like Centreon is having troubles saving configuration data into the nagios database.

Could you do a 'show databases' command on your mysql database?