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.mil...@yetopen.it YetOpen S.r.l. - http://www.yetopen.it/ ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
