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 >> > -- 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