R: importing files inside NagiosQL

[Marco Borsani]

You are right , I will post in the other forum :-p

Just to answer your question regarding the importing sequence...

I can't' follow exactly what you write , because I have some files those
contain both contact, contact-groups, host, host-groups and services.
So my import steps are four:
Commands -> timeperiods -> ALL templates -> ALL other 

Regards
Marco

-----Messaggio originale-----
Da: Jim Avery [mailto:jim at jimavery.me.uk] 
Inviato: lunedì 21 novembre 2011 14:23
A: Nagios Users List
Oggetto: Re: [Nagios-users] importing files inside NagiosQL

On 21 November 2011 13:10, Marco Borsani <m.borsani at it.net> wrote:
> I am testing NagiosQL and try to import old configuration files inside 
> its DB.
>
>
>
> No warnings/errors without NagiosQL, but when I import the data inside 
> the DB I see strange situations:
>
> 1)      ALL hosts/services keep only the first contact-groups 
> associated (usually are three or six)
>
> 2)      Appear some inactive contacts (seven contacts) similar at 
> existing other , that are not anywhere in the original files.
>
> 3)      Appear some inactive contact-groups (five contact-group) 
> similar at existing other , that are not anywhere in the original files.
>
> 4)      Appear some inactive hosts (ten hosts) similar at existing 
> other , that are not anywhere in the original files.
>
> 5)      Appear some inactive contacts (twenty services) similar at 
> existing other , that are not anywhere in the original files.
>
>
>
> Any idea ?


Have you applied the various hotfixes?

http://www.nagiosql.org/forum/solved-issues/1940-hotfixes-for-311-issues.htm
l

Make sure you import the objects in the recommended order:-

commands -> timeperiods -> contacttemplates -> contacts -> contactgroups ->
hosttemplates -> hosts -> hostgroups -> servicetemplates -> services ->
servicegroups

I found I had to re-organise my Nagios config files so I could import them
in the right order.  Even so there were a few anomalies which I had to fix
once I had imported in to NagiosQL.

You are probably best off discussing issues with NagiosQL in the NagiosQL
forum rather than here (or if you are using it as part of Nagios XI, then on
the relevant forum for Nagios XI support).

hth,

Jim

----------------------------------------------------------------------------
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security threats,
fraudulent activity, and more. Splunk takes this data and makes sense of it.
IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
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


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
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