Re: [Nagios-users] Fwd: Question about NDOUtils DB population
Ok yes my retain_state_information=1, and use_retained_program_state=1 so I am ok there. I will set config_output_options=3 and restart the environment. How long can I expect to run before all the configuration data gets populated? On 06/07/2011 3:20 AM, Michael Friedrich wrote: Gene Horodecki wrote: Ok great information, thank you. data_processing_options is -1 (process all) which looks correct. Also the data broker is correct for Nagios 2. My config_output_options are set to 2 however. From what I have read, this would explain why the rest of my database is not getting populated. I will assume I have too much load to run at 1 or 3 for long. What is the correct and lowest impact process for updating the table now? Set the option to 3, reload ndo2db, then set back to 2 and reload again? retention data must be enabled in nagios.cfg whilst doing a core restart will dump that data into ndomod. just reloading ndo2db won't affect that, it's the core which is required. if you happen to need original configs, you can use the combined '3' for config_output_options in order to dump both (only difference will be the config_type column then, and those being used will be marked as is_active in the objects table. read up here for further information on the table structure ... http://docs.icinga.org/latest/en/ch12.html Will this work, or any other better ways of doing it? Thanks. On 6/6/2011 11:03 AM, Michael Friedrich wrote: Gene Horodecki wrote: Sorry if this is a repost. I jumped the gun and posted before I was a member of the list and didn't see my emali go through. Hi there, I have a production environment that runs Nagios + NDOUtils and I got called in because the environment got neglected for a year. When I look at the NDOUtils database, it looks like someone tried to rebuild it because it is populating with statehistory but the hosts, hostgroups, and services tables are blank. make sure config_output_options are set in ndomod.cfg furthermore, check data_process_options for config data to be dumped (and respective nagios.cfg event broker options too) I'd like to try to fill these tables in but I don't really understand when NDOUtils populates these tables. I found the original dbconfig script but it just creates the schema with no data. Somehow NDOUtils still knows what the ids are for the services because the keys are there and I might be able to work backwards and populate everything but obviously it would be easier to just understand how ndoutils builds the data and reproduce it. the objects table keeps active objects alive, even if the config is not yet dumped. Thanks for the help! - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1511/3684 - Release Date: 06/06/11 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ 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 -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-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] Fwd: Question about NDOUtils DB population
On 07.06.2011 18:28, Gene Horodecki wrote: Ok yes my retain_state_information=1, and use_retained_program_state=1 so I am ok there. retention.dat should be written accordingly to this information. I will set config_output_options=3 and restart the environment. How long can I expect to run before all the configuration data gets populated? that depends on your config size and the interferring housekeeping on the overall startup procedure. but most likely when the core starts checking hosts and services, the population should be completed either way. make sure ndo2db is running while restarting/reloading nagios core and maybe tail the debug log to see the queries on the tables ... On 06/07/2011 3:20 AM, Michael Friedrich wrote: Gene Horodecki wrote: Ok great information, thank you. data_processing_options is -1 (process all) which looks correct. Also the data broker is correct for Nagios 2. My config_output_options are set to 2 however. From what I have read, this would explain why the rest of my database is not getting populated. I will assume I have too much load to run at 1 or 3 for long. What is the correct and lowest impact process for updating the table now? Set the option to 3, reload ndo2db, then set back to 2 and reload again? retention data must be enabled in nagios.cfg whilst doing a core restart will dump that data into ndomod. just reloading ndo2db won't affect that, it's the core which is required. if you happen to need original configs, you can use the combined '3' for config_output_options in order to dump both (only difference will be the config_type column then, and those being used will be marked as is_active in the objects table. read up here for further information on the table structure ... http://docs.icinga.org/latest/en/ch12.html Will this work, or any other better ways of doing it? Thanks. On 6/6/2011 11:03 AM, Michael Friedrich wrote: Gene Horodecki wrote: Sorry if this is a repost. I jumped the gun and posted before I was a member of the list and didn't see my emali go through. Hi there, I have a production environment that runs Nagios + NDOUtils and I got called in because the environment got neglected for a year. When I look at the NDOUtils database, it looks like someone tried to rebuild it because it is populating with statehistory but the hosts, hostgroups, and services tables are blank. make sure config_output_options are set in ndomod.cfg furthermore, check data_process_options for config data to be dumped (and respective nagios.cfg event broker options too) I'd like to try to fill these tables in but I don't really understand when NDOUtils populates these tables. I found the original dbconfig script but it just creates the schema with no data. Somehow NDOUtils still knows what the ids are for the services because the keys are there and I might be able to work backwards and populate everything but obviously it would be easier to just understand how ndoutils builds the data and reproduce it. the objects table keeps active objects alive, even if the config is not yet dumped. Thanks for the help! - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1511/3684 - Release Date: 06/06/11 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ 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 -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-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
[Nagios-users] Fwd: Question about NDOUtils DB population
Sorry if this is a repost. I jumped the gun and posted before I was a member of the list and didn't see my emali go through. Hi there, I have a production environment that runs Nagios + NDOUtils and I got called in because the environment got neglected for a year. When I look at the NDOUtils database, it looks like someone tried to rebuild it because it is populating with statehistory but the hosts, hostgroups, and services tables are blank. I'd like to try to fill these tables in but I don't really understand when NDOUtils populates these tables. I found the original dbconfig script but it just creates the schema with no data. Somehow NDOUtils still knows what the ids are for the services because the keys are there and I might be able to work backwards and populate everything but obviously it would be easier to just understand how ndoutils builds the data and reproduce it. Thanks for the help! - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1511/3684 - Release Date: 06/06/11 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ 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] Fwd: Question about NDOUtils DB population
Gene Horodecki wrote: Sorry if this is a repost. I jumped the gun and posted before I was a member of the list and didn't see my emali go through. Hi there, I have a production environment that runs Nagios + NDOUtils and I got called in because the environment got neglected for a year. When I look at the NDOUtils database, it looks like someone tried to rebuild it because it is populating with statehistory but the hosts, hostgroups, and services tables are blank. make sure config_output_options are set in ndomod.cfg furthermore, check data_process_options for config data to be dumped (and respective nagios.cfg event broker options too) I'd like to try to fill these tables in but I don't really understand when NDOUtils populates these tables. I found the original dbconfig script but it just creates the schema with no data. Somehow NDOUtils still knows what the ids are for the services because the keys are there and I might be able to work backwards and populate everything but obviously it would be easier to just understand how ndoutils builds the data and reproduce it. the objects table keeps active objects alive, even if the config is not yet dumped. Thanks for the help! - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1511/3684 - Release Date: 06/06/11 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ 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 -- 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 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ 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] Fwd: Question about NDOUtils DB population
Ok great information, thank you. data_processing_options is -1 (process all) which looks correct. Also the data broker is correct for Nagios 2. My config_output_options are set to 2 however. From what I have read, this would explain why the rest of my database is not getting populated. I will assume I have too much load to run at 1 or 3 for long. What is the correct and lowest impact process for updating the table now? Set the option to 3, reload ndo2db, then set back to 2 and reload again? Will this work, or any other better ways of doing it? Thanks. On 6/6/2011 11:03 AM, Michael Friedrich wrote: Gene Horodecki wrote: Sorry if this is a repost. I jumped the gun and posted before I was a member of the list and didn't see my emali go through. Hi there, I have a production environment that runs Nagios + NDOUtils and I got called in because the environment got neglected for a year. When I look at the NDOUtils database, it looks like someone tried to rebuild it because it is populating with statehistory but the hosts, hostgroups, and services tables are blank. make sure config_output_options are set in ndomod.cfg furthermore, check data_process_options for config data to be dumped (and respective nagios.cfg event broker options too) I'd like to try to fill these tables in but I don't really understand when NDOUtils populates these tables. I found the original dbconfig script but it just creates the schema with no data. Somehow NDOUtils still knows what the ids are for the services because the keys are there and I might be able to work backwards and populate everything but obviously it would be easier to just understand how ndoutils builds the data and reproduce it. the objects table keeps active objects alive, even if the config is not yet dumped. Thanks for the help! - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1511/3684 - Release Date: 06/06/11 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ 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 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ 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
