[icinga-users] ido2db and remote mysql db

Lorenzo Milesi maxxer at ufficyo.com
Thu Mar 14 23:44:04 CET 2013


Hi.
I installed icinga on ubuntu using packages and automatic local mysql config, but I've a remote mysql server which I'd rather use.

My /etc/icinga/ido2db.cfg looks as follows [1], but still I get compliants in the log it cannot connect using local socket.

Mar 14 23:43:13 monitor ido2db: Client connected, data available.
Mar 14 23:43:13 monitor icinga: idomod: Successfully reconnected to data sink!  0 items lost, 309 queued items to flush.
Mar 14 23:43:13 monitor ido2db: Handling client connection...
Mar 14 23:43:13 monitor ido2db: Error: Could not connect to mysql database: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Mar 14 23:43:13 monitor ido2db: Error: database connection failed, forced client disconnect...
Mar 14 23:43:13 monitor icinga: idomod: Error writing to data sink!  Some output may get lost.  68 queued items to flush.
Mar 14 23:43:13 monitor ido2db: Successfully shutdown... (PID=16517)

Why is it trying to use socket, if I have socket_type=tcp ?

thanks 



# cat ido2db.cfg |grep -v ^# | grep -v ^$
lock_file=/var/run/icinga/ido2db.pid
ido2db_user=nagios
ido2db_group=nagios
socket_type=tcp
socket_name=/var/lib/icinga/ido.sock
socket_perm=0755
tcp_port=5668
use_ssl=0
db_servertype=mysql
db_host=10.10.10.193
db_port=3306
db_name=icinga_ido
db_prefix=icinga_
db_user=icinga
db_pass="password"
max_timedevents_age=60
max_systemcommands_age=1440
max_servicechecks_age=1440
max_hostchecks_age=1440
max_eventhandlers_age=10080
max_externalcommands_age=10080
max_logentries_age=44640
max_acknowledgements_age=44640
max_notifications_age=44640
max_contactnotifications_age=44640
max_contactnotificationmethods_age=44640
clean_realtime_tables_on_core_startup=1
clean_config_tables_on_core_startup=1
trim_db_interval=3600
housekeeping_thread_startup_delay=300
debug_level=2
debug_verbosity=2
debug_file=/var/log/icinga/ido2db.debug
max_debug_file_size=100000000
debug_readable_timestamp=0
oci_errors_to_syslog=1
oracle_trace_level=0
enable_sla=0


-- 
Lorenzo Milesi - lorenzo.milesi at yetopen.it

YetOpen S.r.l. - http://www.yetopen.it/




More information about the icinga-users mailing list