[icinga-users] no data in icinga-web

John Larsen john.larsen at addolux.com
Wed Aug 31 03:17:44 CEST 2011


I missed your message earlier so late reply.

Ok successfully ran query but no data: Empty set.

Thanks!

John



On Aug 30, 2011, at 12:41 PM, Michael Friedrich wrote:

> hi,
> 
> On 30.08.2011 19:09, John Larsen wrote:
>> icinga cookbook: http://community.opscode.com/cookbooks/icinga
> 
> ah ok. i wasn't aware of that, thanks for the pointer!
> 
>> 
>> I just upgraded to 1.5 by changing version in the attributes.
>> 
>> ok icinga_objects table does exist, but error is still the same.
>> ERROR 1146 (42S02): Table 'icinga.icinga_ojects' doesn't exist
> 
> fix the typo in the query i gave you and try to re-run. or open the the 
> mysql db with your preferred gui and check for data. sending sql queries 
> is the easiest - if not adding typos.
>> 
>> Im not sure which sql to check for that grml* typo. Could you point me to it?
> 
> sorry. "*grml*" is an expression in german language for being annoyed. i 
> was a bit tired today.
> 
>> 
>> related to make db-doc2sql?
> 
> that is icinga-web only, you won't find that with core+idoutils. forget 
> that for now.
>> 
>> or icinga-core/module/idoutils/db/mysql/mysql.sql?
>> 
>> CREATE TABLE IF NOT EXISTS icinga_objects (
>>   object_id serial,
>>   instance_id bigint unsigned default 0,
>>   objecttype_id bigint unsigned default 0,
>>   name1 varchar(128) character set latin1 collate latin1_general_cs  default '',
>>   name2 varchar(128) character set latin1 collate latin1_general_cs default NULL,
>>   is_active smallint default 0,
>>   PRIMARY KEY  (object_id),
>>   KEY objecttype_id (objecttype_id,name1,name2)
>> ) ENGINE=InnoDB  COMMENT='Current and historical objects of all kinds';
> 
> the sql query joins 2 tables
> 
> - hosts
> - objects
> 
> icinga idoutils saves hosts, services, contacts, timeperiods, etc as 
> objects in the database table, and creates a relation to the config 
> table "icinga_hosts" where you will find the more attributes on the host 
> itsself.
> within the objects table, name1 = hostname, name2 = null (for hosts, for 
> services it will be service desc). the flag is_active will tell you if 
> the core dumped config still is in use, or if the information remains 
> outdated (changed previous configs, removed a host, or similar).
> the object_id is the primary key with matches on the foreign 
> host_object_id key in the icinga_hosts table. therefore it is being used 
> as join condition, providing the correct data then - selecting by a 
> hostname (name1) but getting all valuable information to compare with 
> the objects.cache the core is using to store it's object configuration 
> locally. you can then compare if the dumped configuration in the 
> database is accurate or not.
> 
> if you wanna check for the status of a host/service instead, you will 
> need to query the icinga_hoststatus table, again using the join with the 
> icinga_objects table. you can still use icinga_hosts as secondary join 
> to gather even more valuable information. this is basically the way 
> icinga-web fetches its data.
> 
> select *
> from icinga_hosts
> join icinga_objects
> on icinga_hosts.host_object_id=icinga_objects.object_id
> join icinga_hoststatus
> on icinga_hoststatus.host_object_id=icinga_objects.object_id
> where icinga_objects.name1='YOURHOSTNAME'
> and is_active=1;
> 
> i've also updated the icinga-web testing guide with it
> 
> https://wiki.icinga.org/display/Dev/Icinga+Web+Testing
> 
> feel free to propose further tests for that, if applicable on resolving 
> your error.
> 
> kind regards,
> Michael
> 
>> 
>> 
>> 
>> Thanks!
>> 
>> 
>> John
>> 
>> 
>> 
>> 
>> On Aug 30, 2011, at 9:31 AM, Michael Friedrich wrote:
>> 
>>> John Larsen wrote:
>>>> Hello Michael,
>>>> 
>>>> ido2db is running yes
>>>> idomod was not enabled. I have mv module/idoutils.cfg_sample to idoutils.cfg
>>>> ido2db.cfg has correct mysql config.
>>>> 
>>>> After the changes above, I have restarted ido2db and icinga. But still something missing.
>>> 
>>> what's the syslog saying about idomod and ido2db?
>>> 
>>>> mysql>   use icinga;
>>>> Reading table information for completion of table and column names
>>>> You can turn off this feature to get a quicker startup with -A
>>>> 
>>>> Database changed
>>>> mysql>   select * from icinga_hosts join icinga_ojects on  host_object_id=object_id where name1='yourhostname' and is_active=1;
>>>> ERROR 1146 (42S02): Table 'icinga.icinga_ojects' doesn't exist
>>> 
>>> *grml* that was a typo - it's icinga_objects. verify that in your
>>> imported sql schema with show create tables; ...
>>> 
>>>> The reason for 1.4.2 is because i am using icinga chef cookbook that i started out with. I will update it to install 1.5.
>>> 
>>> icinga chef cookbook? url?
>>> 
>>>> 
>>>> John
>>>> 
>>>> 
>>>> 
>>>> 
>>>> On Aug 30, 2011, at 12:49 AM, Michael Friedrich wrote:
>>>> 
>>>>> John Larsen wrote:
>>>>>> Hello,
>>>>>> 
>>>>>> I am very new to this and have spent a lot of time going through the documentation. I still cannot figure this one out.
>>>>>> 
>>>>>> I had installed core with IDOUtils
>>>>>> then installed new web frontend.
>>>>>> 
>>>>>> However, the problem I am having is core doesn't seem to be writing data to icinga database so that icinga-web can pull from. I am not exactly sure how it works because the docs seem to be scattered on this subject. I am assuming the ido2db is responsible for pushing data from core to incinga database. I have configured contacts, hosts, commands and services within /usr/local/icinga/etc/ and while I can see this data in the cgi web, there is nothing in the tables on icinga db for icinga-web to draw from.
>>>>>> 
>>>>>> Any ideas what i might be missing?
>>>>> ido2db running?
>>>>> idomod enabled through icinga.cfg or as module/idoutils.cfg ?
>>>>> logs stating errors?
>>>>> mysql>   select * from icinga_hosts join icinga_ojects on
>>>>> host_object_id=object_id where name1='yourhostname' and is_active=1;
>>>>> 
>>>>> https://wiki.icinga.org/display/Dev/Icinga+Web+Testing
>>>>>> running ubuntu server with php, mysql
>>>>>> 
>>>>>> icinga-core 1.4.2
>>>>> why not 1.5.0 for the core?
>>>>> 
>>>>>> icinga-web 1.5.1
>>>>>> 
>>>>>> Thanks!
>>>>>> 
>>>>>> 
>>>>>> John
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> ------------------------------------------------------------------------------
>>>>>> Special Offer -- Download ArcSight Logger for FREE!
>>>>>> Finally, a world-class log management solution at an even better
>>>>>> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
>>>>>> download Logger. Secure your free ArcSight Logger TODAY!
>>>>>> http://p.sf.net/sfu/arcsisghtdev2dev
>>>>>> _______________________________________________
>>>>>> icinga-users mailing list
>>>>>> icinga-users at lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/icinga-users
>>>>>> 
>>>>> 
>>>>> -- 
>>>>> DI (FH) Michael Friedrich
>>>>> 
>>>>> Vienna University Computer Center
>>>>> Universitaetsstrasse 7 A-1010 Vienna, Austria
>>>>> 
>>>>> email: 	michael.friedrich at univie.ac.at
>>>>> phone: 	+43 1 4277 14359
>>>>> mobile: +43 664 60277 14359
>>>>> fax: 	+43 1 4277 14338
>>>>> web:	http://www.univie.ac.at/zid
>>>>> 	http://www.aco.net
>>>>> 
>>>>> Icinga Core&    IDOUtils Developer
>>>>> http://www.icinga.org
>>>>> 
>>>>> 
>>>>> ------------------------------------------------------------------------------
>>>>> Special Offer -- Download ArcSight Logger for FREE!
>>>>> Finally, a world-class log management solution at an even better
>>>>> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
>>>>> download Logger. Secure your free ArcSight Logger TODAY!
>>>>> http://p.sf.net/sfu/arcsisghtdev2dev
>>>>> _______________________________________________
>>>>> icinga-users mailing list
>>>>> icinga-users at lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/icinga-users
>>>> 
>>>> ------------------------------------------------------------------------------
>>>> Special Offer -- Download ArcSight Logger for FREE!
>>>> Finally, a world-class log management solution at an even better
>>>> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
>>>> download Logger. Secure your free ArcSight Logger TODAY!
>>>> http://p.sf.net/sfu/arcsisghtdev2dev
>>>> _______________________________________________
>>>> icinga-users mailing list
>>>> icinga-users at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/icinga-users
>>>> 
>>> 
>>> 
>>> -- 
>>> DI (FH) Michael Friedrich
>>> 
>>> Vienna University Computer Center
>>> Universitaetsstrasse 7 A-1010 Vienna, Austria
>>> 
>>> email: 	michael.friedrich at univie.ac.at
>>> phone: 	+43 1 4277 14359
>>> mobile: +43 664 60277 14359
>>> fax: 	+43 1 4277 14338
>>> web:	http://www.univie.ac.at/zid
>>> 	http://www.aco.net
>>> 
>>> Icinga Core&   IDOUtils Developer
>>> http://www.icinga.org
>>> 
>>> 
>>> ------------------------------------------------------------------------------
>>> Special Offer -- Download ArcSight Logger for FREE!
>>> Finally, a world-class log management solution at an even better
>>> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
>>> download Logger. Secure your free ArcSight Logger TODAY!
>>> http://p.sf.net/sfu/arcsisghtdev2dev
>>> _______________________________________________
>>> icinga-users mailing list
>>> icinga-users at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/icinga-users
>> 
>> 
>> ------------------------------------------------------------------------------
>> Special Offer -- Download ArcSight Logger for FREE!
>> Finally, a world-class log management solution at an even better
>> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
>> download Logger. Secure your free ArcSight Logger TODAY!
>> http://p.sf.net/sfu/arcsisghtdev2dev
>> _______________________________________________
>> icinga-users mailing list
>> icinga-users at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/icinga-users
>> 
> 
> -- 
> DI (FH) Michael Friedrich
> 
> Vienna University Computer Center
> Universitaetsstrasse 7 A-1010 Vienna, Austria
> 
> email:     michael.friedrich at univie.ac.at
> phone:     +43 1 4277 14359
> mobile:    +43 664 60277 14359
> fax:	   +43 1 4277 14338
> web:       http://www.univie.ac.at/zid
>            http://www.aco.net
> 
> Icinga Core&  IDOUtils Developer
> http://www.icinga.org
> 
> 
> ------------------------------------------------------------------------------
> Special Offer -- Download ArcSight Logger for FREE!
> Finally, a world-class log management solution at an even better 
> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
> download Logger. Secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsisghtdev2dev
> _______________________________________________
> icinga-users mailing list
> icinga-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20110830/8a268452/attachment-0001.html>


More information about the icinga-users mailing list