Philipp Herz - Profihost AG wrote: > Hi, > > maybe I am wrong, but what about icinga.cfg. > > Just to be sure. Is there a line (around 250) where you enabled the so > called "borker_module" like
hrhr. borker_module. you just made my day > broker_module=/usr/local/icinga/bin/idomod.o > config_file=/usr/local/icinga/etc/idomod.cfg make sure it's a one line. idomod will complain about missing config either way - syslog. check that in the first place in case of errors. > Another option might be to enable > > cfg_dir=/usr/local/icinga/etc/modules > > around line 55. and having idoutils.cfg there with a module definition. > kind regards - Philipp > > Am 31.08.2011 09:07, schrieb Michael Friedrich: >> Michael Friedrich wrote: >>> John Larsen wrote: >>>> Ok I downloaded the api and installed as per instructions: >>>> >>>> ./configure --datarootdir=/usr/local/icinga/share \ >>>> --sysconfdir=/usr/local/icinga/etc \ >>>> --with-command-user=icinga-cmd \ >>>> --with-command-group=icinga-cmd \ >>>> --with-icinga-user=icinga \ >>>> --with-icinga-group=icinga \ >>>> --with-web-user=www-data \ >>>> --with-web-group=www-data >>>> and then make install >>>> >>>> restarted ido2db and icinga. >>>> >>>> Still no data. >>> no no no. >>> >>> you need the core dumping data to idomod (loaded neb module) writing to >>> ido.sock and ido2db reading from that, pushing to your database. if that >>> does not happen for various reasons, you don't have any data in the >>> database. it doesn't matter if you change the api, or web install or >>> whatever, if you use the queries / view on the database i tried to give >>> you. the web does not source from any other config/historical/status >>> information than idoutils db. >>> >>> so. >>> >>> show me the following outputs >>> >>> cat /var/log/messages | grep icinga >>> >>> cat /var/log/messages | grep iido >> cat /var/log/messages | grep ido >> >>> ps aux | grep ido >>> >>> >>>> John Kip Larsen >>>> Integration/Deployment Engineer >>>> Addolux LLC >>>> >>>> >>>> >>>> >>>> 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 >>>> >> > ------------------------------------------------------------------------------ > 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
