[icinga-users] ido2db and remote mysql db

Joel Salas Joel.Salas at mgo.com
Fri Mar 15 00:03:39 CET 2013


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" <maxxer at 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.milesi at 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 at lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/icinga-users





More information about the icinga-users mailing list