Lorenzo, Socket type refers to the socket that ido2db is CREATING. It does not refer to the socket it will use to communicate with MySQL. Set the socket type to unix.
Check /var/log/messages for the ido2db logging events. Best of luck, Joel On 3/14/13 3:44 PM, "Lorenzo Milesi" <max...@ufficyo.com> wrote: >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 ------------------------------------------------------------------------------ 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
