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
