[solved] NDO not correctly populating the database

[pvillard]

Hi,

Here is my configuration :
Nagios : 4.1.1
Nagvis : 1.8.5
Ndoutils : 2.0.0

Nagios and Ndoutils seem to be correctly configured because ndoutils correctly insert data into the following tables :
- nagios_runtimevariables
- nagios_processevents
- nagios_configfilevariables

However it seems that all the other tables are not populated at all (0 row).

In nagios.cfg :

event_broker_options=1
broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg

For the file ndomod.o, I took the one foreseen for Nagios 4.x :
cp src/ndomod-4x.o /usr/local/nagios/bin/ndomod.o

The issue I am facing is that, when using Nagvis, I can't add any host/service :
I have the following error : Unable to fetch data from backend - falling back to input field.
And if force the addition of a host in a Nagvis map, I have the following error : NDO reports that Nagios is not running

Any idea ?

Thanks

[jolson]

I am not completely certain what's going on here - could you display any Nagvis configuration information you can to us? I am not too concerned about the tables that are unpopulated - that _could_ be regular behavior. nagios_runtimevariables is empty on one of my working boxes, while the other two don't seem relevant to what Nagvis is complaining about.

You might upload your entire ndomod.cfg and nagios.cfg files as well - I'd like to take a look at how you've integrated the two as well as how you've told Nagvis to communicate with them.

I'm also interested in your MySQL users table:

Code: Select all

echo 'select * from user \G;' | mysql -uroot -pnagiosxi mysql

[pvillard]

Hi jolson,

Here are the requested information.

/usr/local/nagios/etc/nagios.cfg :

Code: Select all

log_file=/usr/local/nagios/var/nagios.log
cfg_file=/usr/local/nagios/etc/objects/commands.cfg
cfg_file=/usr/local/nagios/etc/objects/contacts.cfg
cfg_file=/usr/local/nagios/etc/objects/timeperiods.cfg
cfg_file=/usr/local/nagios/etc/objects/templates.cfg
cfg_file=/usr/local/nagios/etc/objects/localhost.cfg
object_cache_file=/usr/local/nagios/var/objects.cache
precached_object_file=/usr/local/nagios/var/objects.precache
resource_file=/usr/local/nagios/etc/resource.cfg
status_file=/usr/local/nagios/var/status.dat
status_update_interval=10
nagios_user=nagios
nagios_group=appli
check_external_commands=1
command_file=/usr/local/nagios/var/rw/nagios.cmd
lock_file=/usr/local/nagios/var/nagios.lock
temp_file=/usr/local/nagios/var/nagios.tmp
temp_path=/tmp
event_broker_options=1
broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg
log_rotation_method=d
log_archive_path=/usr/local/nagios/var/archives
use_syslog=1
log_notifications=1
log_service_retries=1
log_host_retries=1
log_event_handlers=1
log_initial_states=0
log_current_states=1
log_external_commands=1
log_passive_checks=1
service_inter_check_delay_method=s
max_service_check_spread=30
service_interleave_factor=s
host_inter_check_delay_method=s
max_host_check_spread=30
max_concurrent_checks=0
check_result_reaper_frequency=10
max_check_result_reaper_time=30
check_result_path=/usr/local/nagios/var/spool/checkresults
max_check_result_file_age=3600
cached_host_check_horizon=15
cached_service_check_horizon=15
enable_predictive_host_dependency_checks=1
enable_predictive_service_dependency_checks=1
soft_state_dependencies=0
auto_reschedule_checks=0
auto_rescheduling_interval=30
auto_rescheduling_window=180
service_check_timeout=60
host_check_timeout=30
event_handler_timeout=30
notification_timeout=30
ocsp_timeout=5
perfdata_timeout=5
retain_state_information=1
state_retention_file=/usr/local/nagios/var/retention.dat
retention_update_interval=60
use_retained_program_state=1
use_retained_scheduling_info=1
retained_host_attribute_mask=0
retained_service_attribute_mask=0
retained_process_host_attribute_mask=0
retained_process_service_attribute_mask=0
retained_contact_host_attribute_mask=0
retained_contact_service_attribute_mask=0
interval_length=60
check_for_updates=1
bare_update_check=0
use_aggressive_host_checking=0
execute_service_checks=1
accept_passive_service_checks=1
execute_host_checks=1
accept_passive_host_checks=1
enable_notifications=1
enable_event_handlers=1
process_performance_data=0
obsess_over_services=0
obsess_over_hosts=0
translate_passive_host_checks=0
passive_host_checks_are_soft=0
check_for_orphaned_services=1
check_for_orphaned_hosts=1
check_service_freshness=1
service_freshness_check_interval=60
service_check_timeout_state=c
check_host_freshness=0
host_freshness_check_interval=60
additional_freshness_latency=15
enable_flap_detection=1
low_service_flap_threshold=5.0
high_service_flap_threshold=20.0
low_host_flap_threshold=5.0
high_host_flap_threshold=20.0
date_format=us
illegal_object_name_chars=`~!$%^&*|'"<>?,()=
illegal_macro_output_chars=`~$&|'"<>
use_regexp_matching=0
use_true_regexp_matching=0
admin_email=nagios@localhost
admin_pager=pagenagios@localhost
daemon_dumps_core=0
use_large_installation_tweaks=0
enable_environment_macros=0
debug_level=64
debug_verbosity=1
debug_file=/usr/local/nagios/var/nagios.debug
max_debug_file_size=1000000
allow_empty_hostgroup_assignment=0

/usr/local/nagios/etc/ndomod.cfg :

Code: Select all

instance_name=Central
output_type=unixsocket
output=/usr/local/nagios/var/ndo.sock
tcp_port=5668
use_ssl=0
output_buffer_items=5000
buffer_file=/usr/local/nagios/var/ndomod.tmp
file_rotation_interval=14400
file_rotation_timeout=60
reconnect_interval=15
reconnect_warning_interval=15
acknowledgement_data=1
adaptive_contact_data=1
adaptive_host_data=1
adaptive_program_data=1
adaptive_service_data=1
aggregated_status_data=1
comment_data=1
contact_status_data=1
downtime_data=1
event_handler_data=1
external_command_data=1
flapping_data=1
host_check_data=1
host_status_data=1
log_data=1
main_config_data=1
notification_data=1
object_config_data=1
process_data=1
program_status_data=1
retention_data=1
service_check_data=1
service_status_data=1
statechange_data=1
system_command_data=1
timed_event_data=1
config_output_options=2

/usr/local/nagios/etc/ndo2db.cfg :

Code: Select all

lock_file=/usr/local/nagios/var/ndo2db.lock
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/usr/local/nagios/var/ndo.sock
tcp_port=5668
use_ssl=0
db_servertype=mysql
db_host=localhost
db_port=3306
db_name=ndo
db_prefix=nagios_
db_user=ndouser
db_pass=ndopassword
max_timedevents_age=1440
max_systemcommands_age=10080
max_servicechecks_age=10080
max_hostchecks_age=10080
max_eventhandlers_age=44640
max_externalcommands_age=44640
max_notifications_age=44640
max_contactnotifications=44640
max_contactnotificationmethods=44640
max_logentries_age=129600
max_acknowledgements_age=44640
debug_level=-1
debug_verbosity=2
debug_file=/usr/local/nagios/var/ndo2db.debug
max_debug_file_size=1000000

Regarding the MySQL database :

Code: Select all

*************************** 1. row ***************************
                 Host: localhost
                 User: root
             Password: 
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
          Reload_priv: Y
        Shutdown_priv: Y
         Process_priv: Y
            File_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
         Show_db_priv: Y
           Super_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y
         Execute_priv: Y
      Repl_slave_priv: Y
     Repl_client_priv: Y
     Create_view_priv: Y
       Show_view_priv: Y
  Create_routine_priv: Y
   Alter_routine_priv: Y
     Create_user_priv: Y
           Event_priv: Y
         Trigger_priv: Y
             ssl_type: 
           ssl_cipher: 
          x509_issuer: 
         x509_subject: 
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0
*************************** 2. row ***************************
                 Host: srv-mcc-lgm1
                 User: root
             Password: 
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
          Reload_priv: Y
        Shutdown_priv: Y
         Process_priv: Y
            File_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
         Show_db_priv: Y
           Super_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y
         Execute_priv: Y
      Repl_slave_priv: Y
     Repl_client_priv: Y
     Create_view_priv: Y
       Show_view_priv: Y
  Create_routine_priv: Y
   Alter_routine_priv: Y
     Create_user_priv: Y
           Event_priv: Y
         Trigger_priv: Y
             ssl_type: 
           ssl_cipher: 
          x509_issuer: 
         x509_subject: 
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0
*************************** 3. row ***************************
                 Host: 127.0.0.1
                 User: root
             Password: 
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
          Reload_priv: Y
        Shutdown_priv: Y
         Process_priv: Y
            File_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
         Show_db_priv: Y
           Super_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y
         Execute_priv: Y
      Repl_slave_priv: Y
     Repl_client_priv: Y
     Create_view_priv: Y
       Show_view_priv: Y
  Create_routine_priv: Y
   Alter_routine_priv: Y
     Create_user_priv: Y
           Event_priv: Y
         Trigger_priv: Y
             ssl_type: 
           ssl_cipher: 
          x509_issuer: 
         x509_subject: 
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0
*************************** 4. row ***************************
                 Host: localhost
                 User: 
             Password: 
          Select_priv: N
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          Create_priv: N
            Drop_priv: N
          Reload_priv: N
        Shutdown_priv: N
         Process_priv: N
            File_priv: N
           Grant_priv: N
      References_priv: N
           Index_priv: N
           Alter_priv: N
         Show_db_priv: N
           Super_priv: N
Create_tmp_table_priv: N
     Lock_tables_priv: N
         Execute_priv: N
      Repl_slave_priv: N
     Repl_client_priv: N
     Create_view_priv: N
       Show_view_priv: N
  Create_routine_priv: N
   Alter_routine_priv: N
     Create_user_priv: N
           Event_priv: N
         Trigger_priv: N
             ssl_type: 
           ssl_cipher: 
          x509_issuer: 
         x509_subject: 
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0
*************************** 5. row ***************************
                 Host: srv-mcc-lgm1
                 User: 
             Password: 
          Select_priv: N
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          Create_priv: N
            Drop_priv: N
          Reload_priv: N
        Shutdown_priv: N
         Process_priv: N
            File_priv: N
           Grant_priv: N
      References_priv: N
           Index_priv: N
           Alter_priv: N
         Show_db_priv: N
           Super_priv: N
Create_tmp_table_priv: N
     Lock_tables_priv: N
         Execute_priv: N
      Repl_slave_priv: N
     Repl_client_priv: N
     Create_view_priv: N
       Show_view_priv: N
  Create_routine_priv: N
   Alter_routine_priv: N
     Create_user_priv: N
           Event_priv: N
         Trigger_priv: N
             ssl_type: 
           ssl_cipher: 
          x509_issuer: 
         x509_subject: 
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0
*************************** 6. row ***************************
                 Host: localhost
                 User: ndouser
             Password: *A3B014D91EE8046E397B9615B1FA8F0B23B599CB
          Select_priv: N
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          Create_priv: N
            Drop_priv: N
          Reload_priv: N
        Shutdown_priv: N
         Process_priv: N
            File_priv: N
           Grant_priv: N
      References_priv: N
           Index_priv: N
           Alter_priv: N
         Show_db_priv: N
           Super_priv: N
Create_tmp_table_priv: N
     Lock_tables_priv: N
         Execute_priv: N
      Repl_slave_priv: N
     Repl_client_priv: N
     Create_view_priv: N
       Show_view_priv: N
  Create_routine_priv: N
   Alter_routine_priv: N
     Create_user_priv: N
           Event_priv: N
         Trigger_priv: N
             ssl_type: 
           ssl_cipher: 
          x509_issuer: 
         x509_subject: 
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0

As a remark, here is the SQL initialization I did :

Code: Select all

# sudo mysqladmin -u root -p create ndo
# sudo mysql -u root -p mysql

mysql> GRANT ALL ON ndo.* TO "ndouser"@"localhost" IDENTIFIED BY "ndopassword";
mysql> FLUSH PRIVILEGES;
mysql> exit

Then :

Code: Select all

./installdb -u ndouser -p ndopassword -h localhost -d ndo

Let me know if I can provide you with more information.

Thanks for your help.

[tgriep]

Can you post your nagvis.ini.php file?
In there are the settings to use the MYSQL database so you may have to edit those settings to match your server's settings.

[ssax]

For Nagvis, you may want to look at these settings:

http://docs.nagvis.org/1.8/en_US/backend_ndomy.html

If that doesn't work you should reach out to the nagvis developers and see if they can help.


If you put more options in your nagios.cfg file does it populate the other tables?

Code: Select all

	acknowledgement_data=1
	adaptive_contact_data=1
	adaptive_host_data=1
	adaptive_program_data=1
	adaptive_service_data=1
	aggregated_status_data=1
	comment_data=1
	contact_status_data=1
	downtime_data=1
	event_handler_data=1
	external_command_data=1
	flapping_data=1
	host_check_data=1
	host_status_data=1
	log_data=1
	main_config_data=1
	notification_data=1
	object_config_data=1
	process_data=1
	program_status_data=1
	retention_data=1
	service_check_data=1
	service_status_data=1
	statechange_data=1
	system_command_data=1
	timed_event_data=1

What are you seeing in your nagios.log?

[pvillard]

Hi,

Here are the logs when Nagios is starting :

Code: Select all

[1452853734] Nagios 4.1.1 starting... (PID=29201)
[1452853734] Local time is Fri Jan 15 10:28:54 UTC 2016
[1452853734] LOG VERSION: 2.0
[1452853734] qh: Socket '/usr/local/nagios/var/rw/nagios.qh' successfully initialized
[1452853734] qh: core query handler registered
[1452853734] nerd: Channel hostchecks registered successfully
[1452853734] nerd: Channel servicechecks registered successfully
[1452853734] nerd: Channel opathchecks registered successfully
[1452853734] nerd: Fully initialized and ready to rock!
[1452853734] wproc: Successfully registered manager as @wproc with query handler
[1452853734] wproc: Registry request: name=Core Worker 29203;pid=29203
[1452853734] wproc: Registry request: name=Core Worker 29204;pid=29204
[1452853734] wproc: Registry request: name=Core Worker 29205;pid=29205
[1452853734] wproc: Registry request: name=Core Worker 29206;pid=29206
[1452853734] wproc: Registry request: name=Core Worker 29207;pid=29207
[1452853734] wproc: Registry request: name=Core Worker 29232;pid=29232
[1452853734] wproc: Registry request: name=Core Worker 29210;pid=29210
[1452853734] wproc: Registry request: name=Core Worker 29211;pid=29211
[1452853734] wproc: Registry request: name=Core Worker 29235;pid=29235
[1452853734] wproc: Registry request: name=Core Worker 29212;pid=29212
[1452853734] wproc: Registry request: name=Core Worker 29237;pid=29237
[1452853734] wproc: Registry request: name=Core Worker 29214;pid=29214
[1452853734] wproc: Registry request: name=Core Worker 29215;pid=29215
[1452853734] wproc: Registry request: name=Core Worker 29216;pid=29216
[1452853734] wproc: Registry request: name=Core Worker 29217;pid=29217
[1452853734] wproc: Registry request: name=Core Worker 29218;pid=29218
[1452853734] wproc: Registry request: name=Core Worker 29219;pid=29219
[1452853734] wproc: Registry request: name=Core Worker 29220;pid=29220
[1452853734] wproc: Registry request: name=Core Worker 29221;pid=29221
[1452853734] wproc: Registry request: name=Core Worker 29222;pid=29222
[1452853734] wproc: Registry request: name=Core Worker 29223;pid=29223
[1452853734] wproc: Registry request: name=Core Worker 29224;pid=29224
[1452853734] wproc: Registry request: name=Core Worker 29225;pid=29225
[1452853734] wproc: Registry request: name=Core Worker 29226;pid=29226
[1452853734] wproc: Registry request: name=Core Worker 29227;pid=29227
[1452853734] wproc: Registry request: name=Core Worker 29228;pid=29228
[1452853734] wproc: Registry request: name=Core Worker 29229;pid=29229
[1452853734] wproc: Registry request: name=Core Worker 29230;pid=29230
[1452853734] wproc: Registry request: name=Core Worker 29231;pid=29231
[1452853734] wproc: Registry request: name=Core Worker 29208;pid=29208
[1452853734] wproc: Registry request: name=Core Worker 29233;pid=29233
[1452853734] wproc: Registry request: name=Core Worker 29234;pid=29234
[1452853734] wproc: Registry request: name=Core Worker 29209;pid=29209
[1452853734] wproc: Registry request: name=Core Worker 29236;pid=29236
[1452853734] wproc: Registry request: name=Core Worker 29213;pid=29213
[1452853734] wproc: Registry request: name=Core Worker 29238;pid=29238
[1452853734] ndomod: NDOMOD 2.0.0 (02-28-2014) Copyright (c) 2009 Nagios Core Development Team and Community Contributors
[1452853734] ndomod: Successfully connected to data sink.  2 queued items to flush.
[1452853734] ndomod: Successfully flushed 2 queued items to data sink.
[1452853734] ndomod registered for process data
[1452853734] ndomod registered for timed event data
[1452853734] ndomod registered for log data'
[1452853734] ndomod registered for system command data'
[1452853734] ndomod registered for event handler data'
[1452853734] ndomod registered for notification data'
[1452853734] ndomod registered for service check data'
[1452853734] ndomod registered for host check data'
[1452853734] ndomod registered for comment data'
[1452853734] ndomod registered for downtime data'
[1452853734] ndomod registered for flapping data'
[1452853734] ndomod registered for program status data'
[1452853734] ndomod registered for host status data'
[1452853734] ndomod registered for service status data'
[1452853734] ndomod registered for adaptive program data'
[1452853734] ndomod registered for adaptive host data'
[1452853734] ndomod registered for adaptive service data'
[1452853734] ndomod registered for external command data'
[1452853734] ndomod registered for aggregated status data'
[1452853734] ndomod registered for retention data'
[1452853734] ndomod registered for contact data'
[1452853734] ndomod registered for contact notification data'
[1452853734] ndomod registered for acknowledgement data'
[1452853734] ndomod registered for contact status data'
[1452853734] ndomod registered for adaptive contact data'
[1452853734] Event broker module '/usr/local/nagios/bin/ndomod.o' initialized successfully.
[1452853740] Successfully launched command file worker with pid 29254

I tried to add more options in my nagios.cfg file but the options do not seem to be valid : "unrecognised option".

Regarding the Nagvis file :

Code: Select all

[global]
file_group="apache"
[paths]
[defaults]
backend="ndomy_1"
[index]
showrotations=0
[automap]
[wui]
[worker]
[backend_ndomy_1]
backendtype="ndomy"
dbhost="localhost"
dbport=3306
dbname="ndo"
dbuser="ndouser"
dbpass="ndopassword"
dbprefix="nagios_"
dbinstancename="Central"
maxtimewithoutupdate=180
htmlcgi="/nagios/cgi-bin"
[rotation_demo]
maps="demo-germany,demo-ham-racks,demo-load,demo-muc-srv1,demo-geomap,demo-automap"
interval=15
[states]

I would say that Nagvis is looking for information in the table nagios_programstatus, but since this table is empty, this is why "NDO reports that Nagios is not running".

There is nothing at all in nagios_hosts table for example... so I doubt that there is something wrong on Nagvis side.

Thanks !

[tgriep]

Try adding the following to the ndomod.cfg file to see if the empty tables start to get used.

Code: Select all

data_processing_options=-1

This option tells ndomod to put everything in to MYSQL
Restart nagios by running

Code: Select all

service nagios restart

Let us know if this helps.

[pvillard]

Hi,

I added the option, and, after a nagios restart, I now see the following logs for ndo2db :

Code: Select all

[1453108574.550935] [002.0] [pid=26347] SELECT instance_id FROM nagios_instances WHERE instance_name='Central'
[1453108574.551276] [002.0] [pid=26347] INSERT INTO nagios_conninfo SET instance_id='1', connect_time=NOW(), last_checkin_time=NOW(), bytes_processed='0', lines_processed='0', entries_processed='0', agent_name='NDOMOD', agent_version='2.0.0', disposition='REALTIME', connect_source='UNIXSOCKET', connect_type='INITIAL', data_start_time=FROM_UNIXTIME(1453108574)
[1453108574.551536] [002.0] [pid=26347] SELECT object_id, objecttype_id, name1, name2 FROM nagios_objects WHERE instance_id='1'
[1453108574.551696] [002.0] [pid=26347] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_programstatus WHERE instance_id='1' ORDER BY status_update_time DESC LIMIT 0,1
[1453108574.551863] [002.0] [pid=26347] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_hoststatus WHERE instance_id='1' ORDER BY status_update_time DESC LIMIT 0,1
[1453108574.552010] [002.0] [pid=26347] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_servicestatus WHERE instance_id='1' ORDER BY status_update_time DESC LIMIT 0,1
[1453108574.552146] [002.0] [pid=26347] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_contactstatus WHERE instance_id='1' ORDER BY status_update_time DESC LIMIT 0,1
[1453108574.552272] [002.0] [pid=26347] SELECT UNIX_TIMESTAMP(queued_time) AS latest_time FROM nagios_timedeventqueue WHERE instance_id='1' ORDER BY queued_time DESC LIMIT 0,1
[1453108574.552397] [002.0] [pid=26347] SELECT UNIX_TIMESTAMP(entry_time) AS latest_time FROM nagios_comments WHERE instance_id='1' ORDER BY entry_time DESC LIMIT 0,1

and nagios.log :

Code: Select all

[1453108574] Nagios 4.1.1 starting... (PID=26308)
[1453108574] Local time is Mon Jan 18 09:16:14 UTC 2016
[1453108574] LOG VERSION: 2.0
[1453108574] qh: Socket '/usr/local/nagios/var/rw/nagios.qh' successfully initialized
[1453108574] qh: core query handler registered
[1453108574] nerd: Channel hostchecks registered successfully
[1453108574] nerd: Channel servicechecks registered successfully
[1453108574] nerd: Channel opathchecks registered successfully
[1453108574] nerd: Fully initialized and ready to rock!
[1453108574] wproc: Successfully registered manager as @wproc with query handler
[1453108574] wproc: Registry request: name=Core Worker 26310;pid=26310
[1453108574] wproc: Registry request: name=Core Worker 26311;pid=26311
[1453108574] wproc: Registry request: name=Core Worker 26312;pid=26312
[1453108574] wproc: Registry request: name=Core Worker 26313;pid=26313
[1453108574] wproc: Registry request: name=Core Worker 26314;pid=26314
[1453108574] wproc: Registry request: name=Core Worker 26339;pid=26339
[1453108574] wproc: Registry request: name=Core Worker 26317;pid=26317
[1453108574] wproc: Registry request: name=Core Worker 26316;pid=26316
[1453108574] wproc: Registry request: name=Core Worker 26318;pid=26318
[1453108574] wproc: Registry request: name=Core Worker 26319;pid=26319
[1453108574] wproc: Registry request: name=Core Worker 26320;pid=26320
[1453108574] wproc: Registry request: name=Core Worker 26321;pid=26321
[1453108574] wproc: Registry request: name=Core Worker 26322;pid=26322
[1453108574] wproc: Registry request: name=Core Worker 26323;pid=26323
[1453108574] wproc: Registry request: name=Core Worker 26324;pid=26324
[1453108574] wproc: Registry request: name=Core Worker 26325;pid=26325
[1453108574] wproc: Registry request: name=Core Worker 26326;pid=26326
[1453108574] wproc: Registry request: name=Core Worker 26327;pid=26327
[1453108574] wproc: Registry request: name=Core Worker 26328;pid=26328
[1453108574] wproc: Registry request: name=Core Worker 26329;pid=26329
[1453108574] wproc: Registry request: name=Core Worker 26330;pid=26330
[1453108574] wproc: Registry request: name=Core Worker 26331;pid=26331
[1453108574] wproc: Registry request: name=Core Worker 26332;pid=26332
[1453108574] wproc: Registry request: name=Core Worker 26333;pid=26333
[1453108574] wproc: Registry request: name=Core Worker 26334;pid=26334
[1453108574] wproc: Registry request: name=Core Worker 26335;pid=26335
[1453108574] wproc: Registry request: name=Core Worker 26336;pid=26336
[1453108574] wproc: Registry request: name=Core Worker 26337;pid=26337
[1453108574] wproc: Registry request: name=Core Worker 26338;pid=26338
[1453108574] wproc: Registry request: name=Core Worker 26315;pid=26315
[1453108574] wproc: Registry request: name=Core Worker 26340;pid=26340
[1453108574] wproc: Registry request: name=Core Worker 26341;pid=26341
[1453108574] wproc: Registry request: name=Core Worker 26342;pid=26342
[1453108574] wproc: Registry request: name=Core Worker 26343;pid=26343
[1453108574] wproc: Registry request: name=Core Worker 26344;pid=26344
[1453108574] wproc: Registry request: name=Core Worker 26345;pid=26345
[1453108574] ndomod: NDOMOD 2.0.0 (02-28-2014) Copyright (c) 2009 Nagios Core Development Team and Community Contributors
[1453108574] ndomod: Successfully connected to data sink.  0 queued items to flush.
[1453108574] ndomod registered for timed event data
[1453108574] ndomod registered for log data'
[1453108574] ndomod registered for system command data'
[1453108574] ndomod registered for event handler data'
[1453108574] ndomod registered for notification data'
[1453108574] ndomod registered for service check data'
[1453108574] ndomod registered for host check data'
[1453108574] ndomod registered for comment data'
[1453108574] ndomod registered for downtime data'
[1453108574] ndomod registered for flapping data'
[1453108574] ndomod registered for program status data'
[1453108574] ndomod registered for host status data'
[1453108574] ndomod registered for service status data'
[1453108574] ndomod registered for adaptive program data'
[1453108574] ndomod registered for adaptive host data'
[1453108574] ndomod registered for adaptive service data'
[1453108574] ndomod registered for external command data'
[1453108574] ndomod registered for aggregated status data'
[1453108574] ndomod registered for retention data'
[1453108574] ndomod registered for contact data'
[1453108574] ndomod registered for contact notification data'
[1453108574] ndomod registered for acknowledgement data'
[1453108574] ndomod registered for contact status data'
[1453108574] ndomod registered for adaptive contact data'
[1453108574] Event broker module '/usr/local/nagios/bin/ndomod.o' initialized successfully.
[1453108580] Successfully launched command file worker with pid 26350

However if run the SQL command :

Code: Select all

mysql> SELECT instance_id FROM nagios_instances WHERE instance_name='Central';
+-------------+
| instance_id |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT object_id, objecttype_id, name1, name2 FROM nagios_objects WHERE instance_id='1';
Empty set (0.00 sec)

mysql> SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_programstatus WHERE instance_id='1' ORDER BY status_update_time DESC LIMIT 0,1;
Empty set (0.00 sec)

I never see any INSERT query for the programstatus table. Should it be initialized when installing the MySQL database for NDO ? If not, when is there any insertion in this table ?

[tgriep]

Edit your nagios.cfg file and change the following line from

Code: Select all

event_broker_options=1

to

Code: Select all

event_broker_options=-1

Save it out and restart nagios.
This setting change will broker everything and that should populate the data in the MYSQL database.
Try that out and let us know if this helps.

[pvillard]

Hi,
I changed this parameter and it is now working correctly.
Thanks for your time and your help tgriep !