Success! Aug 31 17:27:19 icinga1 icinga: idomod: Successfully connected to data sink. 0 queued items to flush.
I removed the icinga install folder and let chef re-install with my changes done there. John On Aug 31, 2011, at 1:00 AM, Philipp Herz - Profihost AG wrote: > Yes, > > and additional always check icinga.log on startup and shutdown of the > daemon for lines like > > on startup: > idomod: Successfully connected to data sink. 0 queued items to flush. > [1314741631] Event broker module '/usr/local/icinga/bin/idomod.o' > initialized successfully. > > on shutdown: > idomod: Shutdown complete. > [1314741630] Event broker module '/usr/local/icinga/bin/idomod.o' > deinitialized successfully. > > make sure ido2db is started before you fire up icinga daemon. > > Philipp > > Am 31.08.2011 09:49, schrieb Michael Friedrich: >> 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 >>> >> >> > > ------------------------------------------------------------------------------ > 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
