icinga cookbook: http://community.opscode.com/cookbooks/icinga
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 Im not sure which sql to check for that grml* typo. Could you point me to it? related to make db-doc2sql? 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'; 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
