[Nagiosplug-help] Problem NDOutils

[Oliver Devoogdt]

Hi,


I am installing the NDO utils on a working nagios server.

Server: Redhat5.1
Nagios 2.11
NDOutils 1.47b


Problem is that nothing is written to the mysql database:

[root at nagios-vm nagios]# mysql -u nagios -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> status
--------------
mysql  Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using readline 5.0

Connection id:          17
Current database:
Current user:           nagios at localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.22
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 3 hours 8 min 35 sec

Threads: 1  Questions: 725  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 63  Queries per second avg: 0.064
--------------

mysql>


Part of my nagios.log:

[1224845877] Nagios 2.11 starting... (PID=23149)
[1224845877] LOG VERSION: 2.0
[1224845877] ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad (nagios
@nagios.org)
[1224845877] ndomod: Successfully connected to data sink.  111 queued items to flush.
[1224845877] ndomod: Successfully flushed 111 queued items to data sink.
[1224845877] Event broker module '/etc/nagios/bin/ndomod-2x.o' initialized successfully.
[1224845877] Finished daemonizing... (New PID=23151)
[1224845877] ndomod: Error writing to data sink!  Some output may get lost...
[1224845893] ndomod: Successfully reconnected to data sink!  0 items lost, 264 queued items
to flush.
[1224845893] ndomod: Error writing to data sink!  Some output may get lost.  4 queued items
to flush.



/etc/nagios/ndo2db.cfg:

ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/etc/nagios/var/ndo.sock
tcp_port=5668
db_servertype=mysql
db_host=localhost
db_port=3306
db_name=nagios
db_prefix=nagios_
db_user=nagios
db_pass=nagios
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=/var/log/nagios/ndo2db.debug
max_debug_file_size=1000000

/etc/nagios/ndomod.cfg:

instance_name=default
output_type=unixsocket
output=/etc/nagios/var/ndo.sock
output_buffer_items=5000
buffer_file=/etc/nagios/var/ndomod.tmp
file_rotation_interval=14400
file_rotation_timeout=60
reconnect_interval=15
reconnect_warning_interval=15
data_processing_options=-1
config_output_options=2

Nagios.cfg:

log_file=/var/log/nagios/nagios.log
cfg_file=/etc/nagios/commands.cfg
cfg_file=/etc/nagios/localhost.cfg
cfg_file=/etc/nagios/contactgroups.cfg
cfg_file=/etc/nagios/contacts.cfg
cfg_file=/etc/nagios/hostgroups.cfg
cfg_file=/etc/nagios/hosts.cfg
cfg_file=/etc/nagios/services.cfg
object_cache_file=/var/log/nagios/objects.cache
resource_file=/etc/nagios/resource.cfg
status_file=/var/log/nagios/status.dat
nagios_user=nagios
nagios_group=nagios
check_external_commands=0
command_check_interval=-1
command_file=/var/log/nagios/rw/nagios.cmd
external_command_buffer_slots=4096
comment_file=/var/log/nagios/comments.dat
downtime_file=/var/log/nagios/downtime.dat
lock_file=/var/lock/nagios.pid
temp_file=/var/log/nagios/nagios.tmp
event_broker_options=-1
broker_module=/etc/nagios/bin/ndomod-2x.o config_file=/etc/nagios/ndomod.cfg
log_rotation_method=d
log_archive_path=/var/log/nagios/archives
use_syslog=1
log_notifications=1
log_service_retries=1
log_host_retries=1
log_event_handlers=1
log_initial_states=0
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
service_reaper_frequency=10
check_result_buffer_slots=4096
auto_reschedule_checks=0
auto_rescheduling_interval=30
auto_rescheduling_window=180
sleep_time=0.25
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=/var/log/nagios/retention.dat
retention_update_interval=60
use_retained_program_state=1
use_retained_scheduling_info=0
interval_length=60
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
check_for_orphaned_services=1
check_service_freshness=1
service_freshness_check_interval=60
check_host_freshness=0
host_freshness_check_interval=60
aggregate_status_updates=1
status_update_interval=15
enable_flap_detection=0
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
p1_file=/usr/bin/p1.pl
illegal_object_name_chars=`~!$%^&*|'"<>?,()=
illegal_macro_output_chars=`~$&|'"<>
use_regexp_matching=0
use_true_regexp_matching=0
admin_email=infra at itsmtaxud.europe.eu
admin_pager=pagenagios
daemon_dumps_core=0


*the modules compiled ok:
        [root at nagios-vm nagios]# ll bin
        total 432
        -rwxr-xr-x 1 nagios nagios  30469 Oct 24 14:04 file2sock
        -rwxr-xr-x 1 nagios nagios  32033 Oct 24 14:04 log2ndo
        -rwxr-xr-x 1 nagios nagios 199136 Oct 24 14:05 ndo2db-2x
        -rwxr-xr-x 1 nagios nagios 118388 Oct 24 14:05 ndomod-2x.o
        -rwxr-xr-x 1 nagios nagios  27982 Oct 24 14:05 sockdebug
*SElinux in permissive mode
*IPtables disabled
*Database created and I can do whatever I want in the database with the specified user.
*daemons are running fine:
        nagios    6727     1  0 15:02 ?        00:00:00 /etc/nagios/bin/ndo2db-2x -c /etc/nagios/ndo2db.cfg
        nagios    6729     1  0 15:02 ?        00:00:01 /usr/bin/nagios -d /etc/nagios/nagios.cfg


Any other thoughts that might help ?


Thanks,


Oliver