[icinga-users] ido2db and remote mysql db

Michael Friedrich michael.friedrich at gmail.com
Fri Mar 15 09:48:02 CET 2013


On 14.03.2013 23:44, Lorenzo Milesi 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.

- ubuntu version
- icinga version
- package revision

maybe you hit an old bug which was fixed in debian already but ubuntu 
didn't merge it.

>
> 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
>
>


-- 
DI (FH) Michael Friedrich

mail:     michael.friedrich at gmail.com
twitter:  https://twitter.com/dnsmichi
jabber:   dnsmichi at jabber.ccc.de
irc:      irc.freenode.net/icinga dnsmichi

icinga open source monitoring
position: lead core developer
url:      https://www.icinga.org




More information about the icinga-users mailing list