Vainiokangas Marko wrote: > 1. It's apparently version 1.0.2 ok. that's rather ancient, but due to package policy this has been kept as stable in debian for a long time.
> 2. It's writing current status into status.dat, and there are numerous > logfiles found under /var/log/icinga/archives, however the logfile are only > about 3 months old and we can query through the UI for information as far > back as a year. So there's data somewhere else.. so I'm wonder what "and > such" means in "- writing the status.dat and such" that's the normal way the core stores its information "and such" was meant to be retention data in case you happen to have that enabled in your icinga.cfg - without any config snippets it's rather hard to guess if it's a default setup, or varies in several ways. read further on the docs about how storing data can be achieved. > 3. The debug shows me no relevant data regarding where it stores old data. if there is no idoutils installed, it's the default way which is still being used either way. the idoutils rdbms backend is just another option to store data, dumped from the core - configs, status and historical data. > 4. When installing IDOutils/MySQL, how do I ensure that the previously stored > data is imported into the SQL-database? Is that handled automatically? We > need the history for trend-reports and comparisons by year. i am not aware of any officially supported tool to import the state history out of retention.dat (if you have that) into the statehistory table of idoutils. the log2ido can handle the logentries table, but calculation over the past $timeperiod and creating statehistory within a relational database would be up to you. or you'll keep the classic ui with the old trends and reports, and use the idoutils db against icinga-web+icinga-reporting from now on. if you develop such a tool/script yourself - we are happy about contributions so we might add that to the official releases then after being well tested (and ofc implemented ;)) kind regards, michael > > //Marko V > -----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 > ******************************************* > > ------------------------------------------------------------------------------ > 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 > -- 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 fax: +43 1 4277 14338 web: http://www.univie.ac.at/zid http://www.aco.net Icinga Core& IDOUtils Developer http://www.icinga.org ------------------------------------------------------------------------------ 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
