Fwd: Question about NDOUtils DB population

[Michael Friedrich]

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 at 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 at 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