[Nagios-users] Nagios Historical Data Question
Hi, I'm new with Nagios. I have questions. 1.) Can Nagios keeps the historical data ? How? 2.) Now,I'm use flat file to keep the data.Can I get the historical data? 3.) Can Nagios work with MySQL? How? Thank you.. -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
On 11/15/2010 09:06 AM, Korrawit Yindeeyoungyeon wrote: Hi, I'm new with Nagios. I have questions. 1.) Can Nagios keeps the historical data ? How? Yes. The log-files store all state-changes. 2.) Now,I'm use flat file to keep the data.Can I get the historical data? From the logfiles, yes. 3.) Can Nagios work with MySQL? How? Via eventbroker modules such as Merlin or NDOUtils, Nagios can store information in a database. The standard UI doesn't work with either of those database backends though. The only free UI I know of that has full support for everything and uses mysql as a backend is Ninja, which works with the Merlin schema. Google will help you further. -- Andreas Ericsson andreas.erics...@op5.se OP5 AB www.op5.se Tel: +46 8-230225 Fax: +46 8-230231 Considering the successes of the wars on alcohol, poverty, drugs and terror, I think we should give some serious thought to declaring war on peace. -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
On Nov 15, 2010, at 2:06 AM, Korrawit Yindeeyoungyeon wrote: Hi, I'm new with Nagios. I have questions. 1.) Can Nagios keeps the historical data ? How? Yes, it does this by default. Historical data is kept in the archive directory, typically /usr/local/nagios/var/archives. 2.) Now,I'm use flat file to keep the data.Can I get the historical data? Yes. Nagios only uses flat files for data. No special action is necessary and the web interface is used to display that data or you can parse the files and use the data on your own. 3.) Can Nagios work with MySQL? How? Not directly but there are addons available at http://exchange.nagios.org to tie nagios to MySQL for both configuration (i.e. front ends that store their data in MySQL, then generate the flat file with configuration data that nagios requires) and data retention for parsing/presentation by other third party apps (i.e. merlin or other alternative front end.) -- Marc -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
Thank Andreas Ericsson On Mon, Nov 15, 2010 at 3:15 PM, Andreas Ericsson a...@op5.se wrote: On 11/15/2010 09:06 AM, Korrawit Yindeeyoungyeon wrote: Hi, I'm new with Nagios. I have questions. 1.) Can Nagios keeps the historical data ? How? Yes. The log-files store all state-changes. 2.) Now,I'm use flat file to keep the data.Can I get the historical data? From the logfiles, yes. 3.) Can Nagios work with MySQL? How? Via eventbroker modules such as Merlin or NDOUtils, Nagios can store information in a database. The standard UI doesn't work with either of those database backends though. The only free UI I know of that has full support for everything and uses mysql as a backend is Ninja, which works with the Merlin schema. Google will help you further. -- Andreas Ericsson andreas.erics...@op5.se OP5 AB www.op5.se Tel: +46 8-230225 Fax: +46 8-230231 Considering the successes of the wars on alcohol, poverty, drugs and terror, I think we should give some serious thought to declaring war on peace. -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
Thank Marc Powell On Mon, Nov 15, 2010 at 3:21 PM, Marc Powell li...@xodus.org wrote: On Nov 15, 2010, at 2:06 AM, Korrawit Yindeeyoungyeon wrote: Hi, I'm new with Nagios. I have questions. 1.) Can Nagios keeps the historical data ? How? Yes, it does this by default. Historical data is kept in the archive directory, typically /usr/local/nagios/var/archives. 2.) Now,I'm use flat file to keep the data.Can I get the historical data? Yes. Nagios only uses flat files for data. No special action is necessary and the web interface is used to display that data or you can parse the files and use the data on your own. 3.) Can Nagios work with MySQL? How? Not directly but there are addons available at http://exchange.nagios.org to tie nagios to MySQL for both configuration (i.e. front ends that store their data in MySQL, then generate the flat file with configuration data that nagios requires) and data retention for parsing/presentation by other third party apps (i.e. merlin or other alternative front end.) -- Marc -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
Note that by default Nagios only retains a history of state changes - it does NOT retain the results of service checks for trending, If you want to maintain results for trending purposes You will need to modify your service checks to write the relevant performance trend data to a database or file to be processed by a trending tool (such as cacti). Also if you are running SUSE 11 the default installation auto-archives the archive folders with a cron job in the /etc/cron.weekly folder. This basically bzip's each daily archive file which will prevent Nagios from being able to read them when you run the state history trends. -Original Message- From: Korrawit Yindeeyoungyeon [mailto:skaaa.a...@gmail.com] Sent: Monday, November 15, 2010 4:25 AM To: Nagios Users List Subject: Re: [Nagios-users] Nagios Historical Data Question Thank Marc Powell On Mon, Nov 15, 2010 at 3:21 PM, Marc Powell li...@xodus.org wrote: On Nov 15, 2010, at 2:06 AM, Korrawit Yindeeyoungyeon wrote: Hi, I'm new with Nagios. I have questions. 1.) Can Nagios keeps the historical data ? How? Yes, it does this by default. Historical data is kept in the archive directory, typically /usr/local/nagios/var/archives. 2.) Now,I'm use flat file to keep the data.Can I get the historical data? Yes. Nagios only uses flat files for data. No special action is necessary and the web interface is used to display that data or you can parse the files and use the data on your own. 3.) Can Nagios work with MySQL? How? Not directly but there are addons available at http://exchange.nagios.org to tie nagios to MySQL for both configuration (i.e. front ends that store their data in MySQL, then generate the flat file with configuration data that nagios requires) and data retention for parsing/presentation by other third party apps (i.e. merlin or other alternative front end.) -- Marc -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
Hi Korrawit, On Mon, Nov 15, 2010 at 9:15 AM, Andreas Ericsson a...@op5.se wrote: 3.) Can Nagios work with MySQL? How? Via eventbroker modules such as Merlin or NDOUtils, Nagios can store information in a database. The standard UI doesn't work with either of those database backends though. The only free UI I know of that has full support for everything and uses mysql as a backend is Ninja, which works with the Merlin schema. There is also the Centreon software which provide a very nice UI and some new features to Nagios. http://www.centreon.com http://demo.centreon.com/ Best regards. -- Romain LE MERLUS -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
Where can I find the standard database schema of Nagios ? or I need to find in source code of 3rd party front-end software? On Mon, Nov 15, 2010 at 4:33 PM, Romain Le Merlus rlemer...@merethis.com wrote: Hi Korrawit, On Mon, Nov 15, 2010 at 9:15 AM, Andreas Ericsson a...@op5.se wrote: 3.) Can Nagios work with MySQL? How? Via eventbroker modules such as Merlin or NDOUtils, Nagios can store information in a database. The standard UI doesn't work with either of those database backends though. The only free UI I know of that has full support for everything and uses mysql as a backend is Ninja, which works with the Merlin schema. There is also the Centreon software which provide a very nice UI and some new features to Nagios. http://www.centreon.com http://demo.centreon.com/ Best regards. -- Romain LE MERLUS -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
On Nov 15, 2010, at 8:05 AM, Korrawit Yindeeyoungyeon wrote: Where can I find the standard database schema of Nagios ? or I need to find in source code of 3rd party front-end software? You'll need to look at the third party software to determine how they get data into a database. Nagios doesn't use a database so has no standard database schema. Each addon either has it's own specific schema or utilizes one of other common event broker - database addons (such as ndoutils). -- Marc -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
Marc Powell wrote: On Nov 15, 2010, at 8:05 AM, Korrawit Yindeeyoungyeon wrote: Where can I find the standard database schema of Nagios ? or I need to find in source code of 3rd party front-end software? You'll need to look at the third party software to determine how they get data into a database. Nagios doesn't use a database so has no standard database schema. Each addon either has it's own specific schema or utilizes one of other common event broker - database addons (such as ndoutils). -- Marc Maybe he's looking for this: http://nagios.sourceforge.net/docs/ndoutils/NDOUtils_DB_Model.pdf the DB schema used by NDOUtils. -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Nagios Historical Data Question
On Nov 15, 2010, at 9:33 AM, Paul M. Dubuc wrote: Maybe he's looking for this: http://nagios.sourceforge.net/docs/ndoutils/NDOUtils_DB_Model.pdf the DB schema used by NDOUtils. Could be, but I stopped trying to read people's minds about a decade ago. He's so far asked about configuration and retention so who knows... -- Marc -- Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today http://p.sf.net/sfu/msIE9-sfdev2dev ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
