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.friedr...@gmail.com twitter: https://twitter.com/dnsmichi jabber: dnsmi...@jabber.ccc.de irc: irc.freenode.net/icinga dnsmichi icinga open source monitoring position: lead core developer url: https://www.icinga.org ------------------------------------------------------------------------------ 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
