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@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.friedr...@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@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@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.friedr...@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@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@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.friedr...@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@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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
