Monitoring-Portal

Source code

Jul 6 13:51:42 Icingapnp icinga: idomod: Still unable to connect to data sink. 311 items lost, 5000 queued items to flush. Is ido2db running and processing data?

Source code

[1341784818] idomod: Still unable to connect to data sink. 187393 items lost, 5000 queued items to flush. Is ido2db running and processing data?

Source code

Jul 9 12:39:50 Icingapnp icinga: idomod: Successfully connected to data sink. 13 queued items to flush.
Jul 9 12:39:50 Icingapnp icinga: idomod: Successfully flushed 13 queued items to data sink.
Jul 9 12:39:50 Icingapnp icinga: Event broker module 'IDOMOD' version '1.7.1' from '/usr/local/icinga/lib/idomod.so' initialized successfully.
Jul 9 12:39:50 Icingapnp ido2db: Handling client connection...
Jul 9 12:39:50 Icingapnp ido2db: Successfully connected to mysql database

Source code

################################################################################                                                             	############################
##############################	Icinga Sanitycheck and Reporting Script 	##                                                             	############################
##############################  by Frankstar / Team Quality Assurance & VM	##                                                             	############################
################################################################################                                                             	############################

Mysql Found! - Try to connect via ido2db.cfg
ido2db.cfg Mysql Connection Test OK!
################################################################################                                                             	############################
############################         	Verbose Informations          	#####                                                             	############################
################################################################################                                                             	############################
Perlversion: v5.10.1
Current Date/Time on Server: Tue Jul 10 15:13:29 2012

OS Information:
  Description: Debian GNU/Linux 6.0.3 (squeeze)
  Kernel Version: 2.6.32-5-amd64 unknown
  LC_LANG: de_AT.UTF-8
  Selinux Status: selinux binary not found

Webserver Information:
  Server version: Apache/2.2.16 (Debian)
  Server's Module Magic Number: 20051115:24
  Server loaded:  APR 1.4.2, APR-Util 1.3.9
  Architecture:   64-bit

PHP Information:
 PHP 5.3.3-7+squeeze13 with Suhosin-Patch (cli) (built: Jun 10 2012 07:31:32)

MySQL Information:
 mysql  Ver 14.14 Distrib 5.1.49

Icinga General Information:
 DB-Version: 1.7.0
 icinga version: 1.7.1
 ido2db version: 1.7.1
 ido2db Processes: 2
 idomod Connections: 1
 ido2db last Connection Info:
 id: 123 2012-07-09 13:03:33
 id: 122 2012-07-10 15:13:00

Icinga.cfg/resource.cfg Information:
 External Commands(1=on,0=off): 1
 Log External Commands(1=on,0=off): 1
 Icinga User: icinga
 Icinga Group: icinga
 User Shell: /bin/bash
 Plugin Path: /usr/local/icinga/libexec
 broker modul cfg: no broker_module defined in icinga.cfg
 broker modul dir: idoutils.cfg in /usr/local/icinga/etc/modules aktiv.

Icinga Web:
 DB-Version: icinga-web/v1.7.0
 DB-last modified: 2012-07-05 15:10:08

ido2db Information:
 Server Type: mysql
 SSL Status: 0
 Socket Type: unix
 Socket Name: /usr/local/icinga/var/ido.sock
 TCP Port: 5668
 SLA Status(1=on,0=off): no 'enable_sla' option found

idomod Information:
 idomod.o check: Couldn't find idomod.o
 idomod.so check: /usr/local/icinga/etc/../lib/idomod.so
 Output Type: unix
 Output: /usr/local/icinga/var/ido.sock
 SSL Status: 0
 TCP Port: 5668

ido2db Errors in Syslog:


Plugin Check with User Rights:
(check_disk - Checks local HDD for free Space)
 DISK OK - free space: / 5764 MB (63% inode=78%)

Source code

root@Icingapnp:/usr/local/icinga/etc# cat idomod.cfg | grep instance_name
instance_name=default

Source code

mysql> select * from icinga_instances;
+-------------+---------------+----------------------+
| instance_id | instance_name | instance_description |
+-------------+---------------+----------------------+
|       	1 | default   	|                  	|
+-------------+---------------+----------------------+
1 row in set (0.00 sec)

Source code

#output_type=tcpsocket
output_type=unixsocket

Source code

 mysql> select count(*) from icinga_hosts
	-> join icinga_objects on icinga_hosts.host_object_id=icinga_objects.object_id 
	-> join icinga_instances on icinga_hosts.instance_id=icinga_instances.instance_id  
	-> where icinga_instances.instance_name='default' and icinga_objects.is_active=1;   
+----------+
| count(*) |
+----------+
|    	6 |
+----------+
1 row in set (0.00 sec)