Re: [Nagios-users] [PATCH] reduce notification load; fix $NOTIFICATIONRECIPIENTS$ macro #98

[Michael Friedrich]

On 21.11.2011 20:56, Andreas Ericsson wrote:
> On 11/01/2011 02:05 PM, Michael Friedrich wrote:
>> hi,
>>
>> recently we've been debugging on team icinga in the middle of
>> notifications and macros, and while investigating on a users problem,
>> we've digged a bit deeper into the notification viability checks,
>> resulting in deeper analysis of an Opsview patch to reduce the
>> notification load significantly by moving the viability checks from
>> the actual notification into the creation of the contacts notified,
>> passing only a list of 'qualified' contacts to the actual
>> notification logic. the only thing to remark over here is that the
>> checks against the valid notification_period now happen sooner, and
>> not actually when the notification is sent to each contact.
>>
>> while implementing that patch into current code (needs some macro
>> passing with current code), we did remember nagios bug #98 where the
>> $NOTIFICATIONRECEIPIENTS$ macro is demanded to be only populated with
>> the actual contacts to be notified, but not all of those assigned to
>> the host/service. while this is considered to be a real bug, further
>> investigation showed that thanks to the viability checks before
>> calling add_notification(), contacts won't be added to that macro as
>> the macro logic happens within that function too.
>>
>> so by applying the attached git patch, you will a. reduce
>> notification load and b. fix the $NOTIFICATIONRECEIPIENTS$ macro
>> holding all contacts, but not the viable contacts.
>>
>> since the code remains actually the same on icinga and nagios in this
>> stage, the tests can be found at the icinga dev tracker as usual.
>> https://dev.icinga.org/issues/1744
>> https://dev.icinga.org/issues/2023
>>
>
> I've started looking into this patch right now. It's good to get that
> issue (#98) fixed, but I fail to see any noticeable performance
> improvement. All contacts potentionally viable for being contacted are
> still looked at, but the difference with this patch is that it checks
> the viability before shipping it off to add_notification(), which does
> fix issue 98 but at the expense of quite a lot of code duplication.

normally, all contacts would have been added to the notification_list in 
memory, even those not actually passing the viability checks. but at 
this stage of the code, nobody is aware of that so the list gets 
populated either way by calling add_notification().

/* add all individual contacts for this host */
^^^

having that notification_list created, this remains fully linked in 
memory. let's say, you have a bunch of some 1k contacts for that 
service, and actually the alarm would hit only those in the nonworkhours 
or workhours timeperiod and only on critical, for the ops team e.g.
so by looping through the notification_list, you will encounter *all* 
contacts for that host, only the duplicates have been removed.

/* notify each contact (duplicates have been removed) */

then you'll fire up the actual notification with calling 
notify_contact_of_host - and actually in there, the current core checks 
the viability for the contact to be notified.

you are right, if each contact gets notified 24x7 on all 
notification_options, the algorithm stays the same. but if you happen to 
have a lot of different contacts assigned to hosts and services, not 
getting notified each time a notification is triggered, the overall 
amount of looping through notification_list will be shorter and save 
some cpu cycles, and probably on larger systems, a bit more than just 
some as this means a reduction of the looping for each contact to be 
checked to be notified on the actual end-of-the-line.

furthermore, where do you get the idea of code duplication from? the 
only changes made by this patch is actually moving the viability checks 
and therefore passing an additional function parameter which makes the 
diff a bit more bloated than it should be.


>
> I'll see if I can improve on that a bit.
>
>> kudos to Opsview Team for their initial patch as well as Icinga
>> Development Team for the further analysis on the macro bug.
>>
>> feel free to apply, matches against latest HEAD.
>>
>
> Not anymore, but I get the gist of it so I'll do something with it that
> keeps the spirit of the patch, as it were.
>


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

Lead Icinga Core Developer
http://www.icinga.org


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

Re: [Nagios-users] e-mail notifications not being sent

[Kaplan, Andrew H.]

Hi there --
 
I checked the nagios.log file, and the problem was due to the mail binary not
being at the /bin folder. I created a symbolic link
at that location to point to the /usr/bin/mail binary. Once that was done,
notifications were sent to the recipient. 
 
As a follow-up, the address of the Nagios server is shown to be
nagios@localdomain. I would like to change that to reflect the
name of the server. What file(s) do I need to modify in order to make that
happen?
 
Thanks. 



From: Claudio Kuenzler [mailto:c...@claudiokuenzler.com] 
Sent: Monday, November 21, 2011 3:25 PM
To: Nagios Users List
Subject: Re: [Nagios-users] e-mail notifications not being sent


Maybe you have to replace the mail program by something on your system, e.g.
/usr/bin/mailx.
That's always one of the first things I change in a new Nagios installation.
What OS are you using? Try to install the required programs (mail/mailx...) if
they can't be found in your system.


On Mon, Nov 21, 2011 at 8:25 PM, Kaplan, Andrew H. 
wrote:




Hi there -- 

I completed the installation of Nagios 3.3.1, and I am going through the
testing process. The server is able to successfully monitor

our various clients, but e-mail notifications for critical conditions
are not being sent to the intended recipient. The e-mail server that

is on the Nagios server is the Postfix message transfer agent. 

The troubleshooting steps that I have taken so far are the following: 

1. I have been able to send a test e-mail from the Nagios server to the
intended recipient using two different mail commands. The test 

e-mail was done from the command line using the mail and mailx
commands using the command syntax: 

mail  < /etc/fstab 
mailx -s "test"  < /etc/fstab 

2. I checked the contacts.cfg file, and confirmed the intended recipient
is listed with the correct address. 

3. I checked the nagios.log, and there were entries that were similar to
the following: 

[1321385615] Warning: Attempting to execute the command "/usr/bin/printf
"%b" "* Nagios 2.6 *\n\nNotification Type: PROBLEM\nHost: ... Date/Time:
Tue Nov 15 14:33:35 EST 2011\n" | 

/bin/mail -..." resulted in a return code of 127.  Make
sure the script or binary you are trying to execute actually exists...

I did a search for the mail binary, and there was none at that location.
To correct the problem, I created a symbolic that pointed to the actual 

location of the mail binary which was located at the /usr/bin/ folder. 

4. As far as I can tell, all hosts have e-mail notifications enabled on
them. 

What other steps do I need to take in order to get e-mail notifications
to work here? 

Thanks. 




The information in this e-mail is intended only for the person to whom
it is
addressed. If you believe this e-mail was sent to you in error and the
e-mail
contains patient information, please contact the Partners Compliance
HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you
in error
but does not contain patient information, please contact the sender and
properly
dispose of the e-mail.


--
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@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@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] e-mail notifications not being sent

[Claudio Kuenzler]

Maybe you have to replace the mail program by something on your system,
e.g. /usr/bin/mailx.
That's always one of the first things I change in a new Nagios installation.
What OS are you using? Try to install the required programs (mail/mailx...)
if they can't be found in your system.

On Mon, Nov 21, 2011 at 8:25 PM, Kaplan, Andrew H. wrote:

> **
>
> Hi there --
>
> I completed the installation of Nagios 3.3.1, and I am going through the
> testing process. The server is able to successfully monitor
>
> our various clients, but e-mail notifications for critical conditions are
> not being sent to the intended recipient. The e-mail server that
>
> is on the Nagios server is the Postfix message transfer agent.
>
> The troubleshooting steps that I have taken so far are the following:
>
> 1. I have been able to send a test e-mail from the Nagios server to the
> intended recipient using two different mail commands. The test
>
> e-mail was done from the command line using the mail and mailx
> commands using the command syntax:
>
> mail  < /etc/fstab
> mailx -s "test"  < /etc/fstab
>
> 2. I checked the contacts.cfg file, and confirmed the intended recipient
> is listed with the correct address.
>
> 3. I checked the nagios.log, and there were entries that were similar to
> the following:
>
> [1321385615] Warning: Attempting to execute the command "/usr/bin/printf
> "%b" "* Nagios 2.6 *\n\nNotification Type: PROBLEM\nHost: ...
> Date/Time: Tue Nov 15 14:33:35 EST 2011\n" |
>
> /bin/mail -…" resulted in a return code of 127.  Make sure
> the script or binary you are trying to execute actually exists…
>
> I did a search for the mail binary, and there was none at that location.
> To correct the problem, I created a symbolic that pointed to the actual
>
> location of the mail binary which was located at the /usr/bin/ folder.
>
> 4. As far as I can tell, all hosts have e-mail notifications enabled on
> them.
>
> What other steps do I need to take in order to get e-mail notifications to
> work here?
>
> Thanks.
>
>
>
> The information in this e-mail is intended only for the person to whom it
> is
> addressed. If you believe this e-mail was sent to you in error and the
> e-mail
> contains patient information, please contact the Partners Compliance
> HelpLine at
> http://www.partners.org/complianceline . If the e-mail was sent to you in
> error
> but does not contain patient information, please contact the sender and
> properly
> dispose of the e-mail.
>
>
> --
> 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@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@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] [PATCH] reduce notification load; fix $NOTIFICATIONRECIPIENTS$ macro #98

[Andreas Ericsson]

On 11/01/2011 02:05 PM, Michael Friedrich wrote:
> hi,
> 
> recently we've been debugging on team icinga in the middle of
> notifications and macros, and while investigating on a users problem,
> we've digged a bit deeper into the notification viability checks,
> resulting in deeper analysis of an Opsview patch to reduce the
> notification load significantly by moving the viability checks from
> the actual notification into the creation of the contacts notified,
> passing only a list of 'qualified' contacts to the actual
> notification logic. the only thing to remark over here is that the
> checks against the valid notification_period now happen sooner, and
> not actually when the notification is sent to each contact.
> 
> while implementing that patch into current code (needs some macro
> passing with current code), we did remember nagios bug #98 where the
> $NOTIFICATIONRECEIPIENTS$ macro is demanded to be only populated with
> the actual contacts to be notified, but not all of those assigned to
> the host/service. while this is considered to be a real bug, further
> investigation showed that thanks to the viability checks before
> calling add_notification(), contacts won't be added to that macro as
> the macro logic happens within that function too.
> 
> so by applying the attached git patch, you will a. reduce
> notification load and b. fix the $NOTIFICATIONRECEIPIENTS$ macro
> holding all contacts, but not the viable contacts.
> 
> since the code remains actually the same on icinga and nagios in this
> stage, the tests can be found at the icinga dev tracker as usual. 
> https://dev.icinga.org/issues/1744 
> https://dev.icinga.org/issues/2023
> 

I've started looking into this patch right now. It's good to get that
issue (#98) fixed, but I fail to see any noticeable performance
improvement. All contacts potentionally viable for being contacted are
still looked at, but the difference with this patch is that it checks
the viability before shipping it off to add_notification(), which does
fix issue 98 but at the expense of quite a lot of code duplication.

I'll see if I can improve on that a bit.

> kudos to Opsview Team for their initial patch as well as Icinga
> Development Team for the further analysis on the macro bug.
> 
> feel free to apply, matches against latest HEAD.
> 

Not anymore, but I get the gist of it so I'll do something with it that
keeps the spirit of the patch, as it were.

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

--
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@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] e-mail notifications not being sent

[Kaplan, Andrew H.]

Hi there --

I completed the installation of Nagios 3.3.1, and I am going through the testing
process. The server is able to successfully monitor
our various clients, but e-mail notifications for critical conditions are not
being sent to the intended recipient. The e-mail server that
is on the Nagios server is the Postfix message transfer agent. 

The troubleshooting steps that I have taken so far are the following:

1. I have been able to send a test e-mail from the Nagios server to the intended
recipient using two different mail commands. The test 
e-mail was done from the command line using the mail and mailx commands
using the command syntax:

mail  < /etc/fstab 
mailx -s "test"  < /etc/fstab

2. I checked the contacts.cfg file, and confirmed the intended recipient is
listed with the correct address.

3. I checked the nagios.log, and there were entries that were similar to the
following:

[1321385615] Warning: Attempting to execute the command "/usr/bin/printf "%b"
"* Nagios 2.6 *\n\nNotification Type: PROBLEM\nHost: ... Date/Time: Tue
Nov 15 14:33:35 EST 2011\n" | 
/bin/mail -..." resulted in a return code of 127.  Make sure the
script or binary you are trying to execute actually exists...

I did a search for the mail binary, and there was none at that location. To
correct the problem, I created a symbolic that pointed to the actual 
location of the mail binary which was located at the /usr/bin/ folder.

4. As far as I can tell, all hosts have e-mail notifications enabled on them.

What other steps do I need to take in order to get e-mail notifications to work
here?

Thanks. 




The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
--
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@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] R: importing files inside NagiosQL

[Giorgio Zarrelli]

Hi,

drop the database, then recreate it using the file

nagiosQL_v31_db_mysql.sql

you find in the install/sql directory.


Giorgio



> Well
>
> How can I purge the DB ? I performed a "Delete config files" .. is it
> enough
> ? I'm afraid not ...
>
>
> -Messaggio originale-
> Da: Giorgio Zarrelli [mailto:zarre...@linux.it]
> Inviato: lunedì 21 novembre 2011 14:17
> A: Nagios Users List
> Oggetto: Re: [Nagios-users] importing files inside NagiosQL
>
> Hi,
>
> maybe some remnants from previous import tries? Purge MySQL db and try a
> new
> import, following the suggested (on import page) order of file processing.
>
> Giorgio
>
>
> 
>> Hi all
>>
>>
>>
>> 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 ?
>>
>> Regards
>>
>>
>>
>> Marco Borsani
>>
>> Unix and Monitoring Sysadmin
>>
>> Technical Operations Dpt.
>>
>> tel: +39 010 4310115
>>
>> fax: +39 02 30130311
>>
>> cell: +39 329 5953944
>>
>> ITnet Srl
>>
>> Società con socio unico
>>
>> Direzione e Coordinamento di …
>>
>>
>>
>> --
>>  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@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@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@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] 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:j...@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  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@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@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] R: importing files inside NagiosQL

[Marco Borsani]

Well

How can I purge the DB ? I performed a "Delete config files" .. is it enough
? I'm afraid not ...


-Messaggio originale-
Da: Giorgio Zarrelli [mailto:zarre...@linux.it] 
Inviato: lunedì 21 novembre 2011 14:17
A: Nagios Users List
Oggetto: Re: [Nagios-users] importing files inside NagiosQL

Hi,

maybe some remnants from previous import tries? Purge MySQL db and try a new
import, following the suggested (on import page) order of file processing.

Giorgio



> Hi all
>
>
>
> 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 ?
>
> Regards
>
>
>
> Marco Borsani
>
> Unix and Monitoring Sysadmin
>
> Technical Operations Dpt.
>
> tel: +39 010 4310115
>
> fax: +39 02 30130311
>
> cell: +39 329 5953944
>
> ITnet Srl
>
> Società con socio unico
>
> Direzione e Coordinamento di …
>
>
>
> --
>  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@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@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@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] importing files inside NagiosQL

[Jim Avery]

On 21 November 2011 13:10, Marco Borsani  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.html

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@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] importing files inside NagiosQL

[Giorgio Zarrelli]

Hi,

maybe some remnants from previous import tries? Purge MySQL db and try a
new import, following the suggested (on import page) order of file
processing.

Giorgio



> Hi all
>
>
>
> 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 ?
>
> Regards
>
>
>
> Marco Borsani
>
> Unix and Monitoring Sysadmin
>
> Technical Operations Dpt.
>
> tel: +39 010 4310115
>
> fax: +39 02 30130311
>
> cell: +39 329 5953944
>
> ITnet Srl
>
> Società con socio unico
>
> Direzione e Coordinamento di …
>
>
>
> --
> 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@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@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] importing files inside NagiosQL

[Marco Borsani]

Hi all

 

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 ?

Regards

 

Marco Borsani

Unix and Monitoring Sysadmin

Technical Operations Dpt.

tel: +39 010 4310115

fax: +39 02 30130311

cell: +39 329 5953944

ITnet Srl

Società con socio unico

Direzione e Coordinamento di …

 

--
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@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] External command-id CHANGE_SVC_CHECK_COMMAND not working

[Michael Sverdlik]

Thanks Michael.
Too bad no word about it in the official docs...


From: Michael Friedrich [mailto:michael.friedr...@univie.ac.at]
Sent: Monday, November 21, 2011 11:11 AM
To: nagios-users@lists.sourceforge.net
Subject: Re: [Nagios-users] External command-id CHANGE_SVC_CHECK_COMMAND not 
working

Michael Sverdlik wrote:
Hi,
System Info:
Nagios Core 3.2.3 (also checked on 3.3.1)
Ubuntu 10.4 LTS

It looks like Nagios ignores CHANGE_SVC_CHECK_COMMAND that I'm sending to 
command file.

Here a  test script I did which _worked_ as should (comment for the service 
added):
#!/bin/sh
now=`date +%s`
commandfile='/usr/local/nagios/var/rw/nagios.cmd'
/bin/echo "[$now] ADD_SVC_COMMENT;server.com;service;0;nagiosadmin;this is a 
test" > $commandfile

However when I try to do almost exactly the same with CHANGE_SVC_CHECK_COMMAND, 
nothing happens:
#!/bin/sh
now=`date +%s`
commandfile='/usr/local/nagios/var/rw/nagios.cmd'
/bin/echo "[$now] CHANGE_SVC_CHECK_COMMAND;server.com;service;check_service" > 
$commandfile

I can see command received both in nagios log and debug log:
Nagios log
[1321800018] EXTERNAL COMMAND: 
CHANGE_SVC_CHECK_COMMAND;server.com;service;check_service

Nagios debug log
[1321800018.303659] [128.1] [pid=31683] External Command Type: 128
[1321800018.303671] [128.1] [pid=31683] Command Entry Time: 1321800018
[1321800018.303681] [128.1] [pid=31683] Command Arguments: 
server.com;service;check_service

Note: server,service and command names were changed.
I also checked same scenario on Nagios 3.3.1 with same results.
Any advice/ideas?

http://www.nagios.org/projects/nagioscore/history/core-3x

3.0.6 adaptive check commands



Thanks,
Michael.




--

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



Lead Icinga Core Developer

http://www.icinga.org
--
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@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] External command-id CHANGE_SVC_CHECK_COMMAND not working

[Michael Friedrich]

Michael Sverdlik wrote:


Hi,

System Info:

Nagios Core 3.2.3 (also checked on 3.3.1)

Ubuntu 10.4 LTS

It looks like Nagios ignores CHANGE_SVC_CHECK_COMMAND that I'm sending 
to command file.


Here a  test script I did which _/worked/_ as should (comment for the 
service added):


#!/bin/sh

now=`date +%s`

commandfile='/usr/local/nagios/var/rw/nagios.cmd'

/bin/echo "[$now] 
ADD_SVC_COMMENT;server.com;service;0;nagiosadmin;this is a test" > 
$commandfile


However when I try to do almost exactly the same with 
CHANGE_SVC_CHECK_COMMAND, nothing happens:


#!/bin/sh

now=`date +%s`

commandfile='/usr/local/nagios/var/rw/nagios.cmd'

/bin/echo "[$now] 
CHANGE_SVC_CHECK_COMMAND;server.com;service;check_service" > $commandfile


I can see command received both in nagios log and debug log:

Nagios log

[1321800018] EXTERNAL COMMAND: 
CHANGE_SVC_CHECK_COMMAND;server.com;service;check_service


Nagios debug log

[1321800018.303659] [128.1] [pid=31683] External Command Type: 128

[1321800018.303671] [128.1] [pid=31683] Command Entry Time: 1321800018

[1321800018.303681] [128.1] [pid=31683] Command Arguments: 
server.com;service;check_service


Note: server,service and command names were changed.

I also checked same scenario on Nagios 3.3.1 with same results.

Any advice/ideas?



http://www.nagios.org/projects/nagioscore/history/core-3x

3.0.6 adaptive check commands


Thanks,

Michael.



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

Lead Icinga Core Developer
http://www.icinga.org

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