[icinga-users] no data in icinga-web

Michael Friedrich michael.friedrich at univie.ac.at
Tue Aug 30 18:31:43 CEST 2011


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





More information about the icinga-users mailing list