Status.dat contains current status. Retention.dat seems to contain messages and status that has to be persistent through service restarts...
However, neither contain the history used by the Icinga Core/Classic UI trend report and other reports. I tried looking in the source-code, but for my untrained open-source eyes it's a mess :P I can see calls made here and there but no actual definition of the database-file it reads from beyond the rotated log-files. I.e. I want to see further back than status.dat, further back than retention.dat, further back than /var/log/icinga/archives... Because that's what we can get from the Core/Classic UI queries made by the CGI-modules... Marko Vainiokangas Tekniker -----Ursprungligt meddelande----- Från: icinga-users-requ...@lists.sourceforge.net [mailto:icinga-users-requ...@lists.sourceforge.net] Skickat: den 12 april 2011 18:09 Till: icinga-users@lists.sourceforge.net Ämne: icinga-users Digest, Vol 24, Issue 4 Send icinga-users mailing list submissions to icinga-users@lists.sourceforge.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/icinga-users or, via email, send a message with subject or body 'help' to icinga-users-requ...@lists.sourceforge.net You can reach the person managing the list at icinga-users-ow...@lists.sourceforge.net When replying, please edit your Subject line so it is more specific than "Re: Contents of icinga-users digest..." Today's Topics: 1. How can I identify the DB used by an icinga installation? (Vainiokangas Marko) 2. Re: How can I identify the DB used by an icinga installation? (Assaf Flatto) 3. Re: How can I identify the DB used by an icinga installation? (Michael Friedrich) 4. LConf+MySQL? (William S.) 5. Re: LConf+MySQL? (Denny Schierz) 6. Re: LConf+MySQL? (William S.) ---------------------------------------------------------------------- Message: 1 Date: Mon, 11 Apr 2011 15:25:46 +0200 From: Vainiokangas Marko <marko.vainiokan...@atea.se> Subject: [icinga-users] How can I identify the DB used by an icinga installation? To: "icinga-users@lists.sourceforge.net" <icinga-users@lists.sourceforge.net> Message-ID: <c44046b1eed534479b558cc4c0bab8fe3f0f634...@satsmbxdkhos001.intra.atea.se> Content-Type: text/plain; charset="us-ascii" I've had the privilege to assume control over an old Icinga installation. However, this installation seems to have been done without PostgreSQL, MySQL and no IDOUtils... So I'm wondering, how can I trace/see where it's writing it's information and to which kind of database? It's installed on Ubuntu 9.04 through repository, so it's version 1.0.4 or something like that old. And how would I go about to do an upgrade/migration to a MySQL/PostgreSQL? //Marko V -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 2 Date: Mon, 11 Apr 2011 16:12:17 +0000 From: Assaf Flatto <ici...@flatto.net> Subject: Re: [icinga-users] How can I identify the DB used by an icinga installation? To: icinga-users@lists.sourceforge.net Message-ID: <4da32861.7000...@flatto.net> Content-Type: text/plain; charset=windows-1252; format=flowed Vainiokangas Marko wrote: > > I?ve had the privilege to assume control over an old Icinga > installation. However, this installation seems to have been done > without PostgreSQL, MySQL and no IDOUtils? > > So I?m wondering, how can I trace/see where it?s writing it?s > information and to which kind of database? It?s installed on Ubuntu > 9.04 through repository, so it?s version 1.0.4 or something like that old. > > And how would I go about to do an upgrade/migration to a MySQL/PostgreSQL? > > //Marko V > > ---------------------------------------------------------------------- > -- > > if the usual place of the cfg file shows no sign or data , did you try enabling the debug option to include all data and seeing might appear in that ? Assaf ------------------------------ Message: 3 Date: Mon, 11 Apr 2011 18:49:41 +0200 From: Michael Friedrich <michael.friedr...@univie.ac.at> Subject: Re: [icinga-users] How can I identify the DB used by an icinga installation? To: icinga-users@lists.sourceforge.net Message-ID: <4da33125.7040...@univie.ac.at> Content-Type: text/plain; charset="iso-8859-1" On 11.04.2011 15:25, Vainiokangas Marko wrote: > > I've had the privilege to assume control over an old Icinga > installation. However, this installation seems to have been done > without PostgreSQL, MySQL and no IDOUtils... > > So I'm wondering, how can I trace/see where it's writing it's > information and to which kind of database? It's installed on Ubuntu > 9.04 through repository, so it's version 1.0.4 or something like that old. > check icinga.cfg and the loaded event brokers. if there are none the core keeps doing it the classic way - writing the status.dat and such. 1.0.4 does not exist, this happened to be 1.2.0 straight up. you can verify the version by checking within the logs where a reload causes an entry too, or the classic ui would reflect that too in the left corner. > And how would I go about to do an upgrade/migration to a MySQL/PostgreSQL? > by installing icinga-idoutils as package and resolving its dependencies, next to enabling it in icinga.cfg (refer to the idoutils readme braucght by the debian package). likewise described here for debian: https://wiki.icinga.org/display/howtos/Setting+up+Icinga+with+IDOUtils+on+Debian > //Marko V > > > > ------------------------------------------------------------------------------ > Xperia(TM) PLAY > It's a major breakthrough. An authentic gaming > smartphone on the nation's most reliable network. > And it wants your games. > http://p.sf.net/sfu/verizon-sfdev > > > _______________________________________________ > icinga-users mailing list > icinga-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/icinga-users -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 4 Date: Tue, 12 Apr 2011 08:11:20 -0700 From: William S. <williams...@hotmail.com> Subject: [icinga-users] LConf+MySQL? To: <icinga-users@lists.sourceforge.net> Message-ID: <blu126-ds68e42202ef013806286f5a1...@phx.gbl> Content-Type: text/plain; charset="us-ascii" Is it possible to use LConf with MySQL instead of DBD? ------------------------------ Message: 5 Date: Tue, 12 Apr 2011 17:46:13 +0200 From: Denny Schierz <linuxm...@4lin.net> Subject: Re: [icinga-users] LConf+MySQL? To: icinga-users@lists.sourceforge.net Message-ID: <078c7324-ecb2-4ae5-8219-8c19f21a1...@4lin.net> Content-Type: text/plain; charset=us-ascii hi, Am 12.04.2011 um 17:11 schrieb William S.: > Is it possible to use LConf with MySQL instead of DBD? DBD/BDB is the backend from LDAP and not a standalone DB, so you can't use LConf (what is a _L_DAP _Conf_iguration). So, you can't. Take a look on NagiosQL, or. NagiosAdmin, or Centreon etc. pp. cu denny ------------------------------ Message: 6 Date: Tue, 12 Apr 2011 09:08:41 -0700 From: William S. <williams...@hotmail.com> Subject: Re: [icinga-users] LConf+MySQL? To: <icinga-users@lists.sourceforge.net> Message-ID: <blu126-ds11100439dfdf7fb39a28ca1...@phx.gbl> Content-Type: text/plain; charset="us-ascii" Note: I understand DBD is the storage for LDAP, and one doesn't work without the other so, moot point. I'm using Icinga so, the goal is to create an interop between Icinga and a back-end configuration storage. Thanks for the input. > -----Original Message----- > From: Denny Schierz [mailto:linuxm...@4lin.net] > Sent: Tuesday, April 12, 2011 8:46 AM > To: icinga-users@lists.sourceforge.net > Subject: Re: [icinga-users] LConf+MySQL? > > hi, > > Am 12.04.2011 um 17:11 schrieb William S.: > > > Is it possible to use LConf with MySQL instead of DBD? > > DBD/BDB is the backend from LDAP and not a standalone DB, so you can't > use LConf (what is a _L_DAP _Conf_iguration). > > So, you can't. Take a look on NagiosQL, or. NagiosAdmin, or Centreon etc. > pp. > > cu denny > ---------------------------------------------------------------------------- -- > Forrester Wave Report - Recovery time is now measured in hours and > minutes not days. Key insights are discussed in the 2010 Forrester Wave > Report as part of an in-depth evaluation of disaster recovery service > providers. > Forrester found the best-in-class provider in terms of services and vision. > Read this report now! http://p.sf.net/sfu/ibm-webcastpromo > _______________________________________________ > icinga-users mailing list > icinga-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/icinga-users ------------------------------ ------------------------------------------------------------------------------ Forrester Wave Report - Recovery time is now measured in hours and minutes not days. Key insights are discussed in the 2010 Forrester Wave Report as part of an in-depth evaluation of disaster recovery service providers. Forrester found the best-in-class provider in terms of services and vision. Read this report now! http://p.sf.net/sfu/ibm-webcastpromo ------------------------------ _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users End of icinga-users Digest, Vol 24, Issue 4 ******************************************* ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
