nagios-db-devel — An easy way for Nagios-DB developers to contact each other.

[Nagios-db-devel] Postgres Views not updated

[Thibault G. <thi...@sr...>]

Hello

=20

I've been using nagios-db for a few days only so please apologize if
it's a dummy question, but I'm going crazy with it.=20

First, I am using nagios-db-0.91 with Postgres NEB.

It seems that the data from the views does not get updated, even if I
use the update_views.sql script as stated in the doc. The php interface
reflects the information in the service_history table and host_details
view, which is completely outdated. On the other hand, the service_check
table contains the correct, latest information that nagios' CGIs show.=20

Any clues ?

=20

Regards

=20

Thibault

[Nagios-db-devel] update or insert

[Robert B. <rbi...@na...>]

I am pulling the data written by nagios-db via odbc/dts package into sql 
server for reporting using cognos. Looking at the data, it looks like 
the service_check table is updated, rather than inserts as checks 
happen. Is this the case? If it is, then it looks like the meat for 
reporting purposes lies in the service_history and host_history tables. 
Is this a correct assumption? Any thoughts, comments or advise is and 
will be appreciated.
Thanks, Bob

RE: [Nagios-db-devel] performance query

[Ben <be...@si...>]

On Thu, 28 Apr 2005, Dan Hopkins wrote:

> > The other potential gotcha is that nagios has to write the value of 
> > each check into the db to complete a check, and if the db is slammed, 
> > this will take an increasing amount of time. This was causing me very 
> > bad latency problems (thousands of seconds) until recently, when I 
> > implemented some thread pool action in the NEB and now my 
> > latency times 
> > tend to hover around 15 seconds.
> 
> This is the sort of issue that's hitting us: nagios is slow writing it's
> updates in aggregated mode (we're talking 10-20 seconds for less than 4000
> services in worst case) that some of our scripts (inhouse php customised
> replacements) just hang on queries waiting for the locks to free. And too
> many users accessing the scripts cause nagios to lag obtaining locks to dump
> its updates. Enter non-aggregated updates .... and the massive jump in load
> on the nagios host. Still, the user facing scripts appear quicker at least
> ;) But it did make me wonder how the neb's fare with thousands of status
> updates, now I see from another thread you've got over 8k services on the go
> ? - that's promising stuff, are you distributing this over multiple nagios
> hosts or a single centralised one?

I've got a single dual xeon with 2.5GB of ram running nagios and making
all the active checks (I only have active checks). It does agregate writes
to a ram disk for the nagios logs. I've got another dual xeon with 4GB of
ram and a fast scsi raid holding the db. And I've got a third wimpy box
running the php UI.

My problem is the way nagios' scheduler works. I don't know if you're
familiar with it, so let me just tell you how it works. Everything nagios
does gets scheduled and piped through an event queue. There are low
priority events (like kicking off checks at a specified time) and high
priority events (like reaping outstanding check results). Well, all the
high priority events get handled before any low priority ones. So what
eneds up happening is that nagios starts kicking off low priority checks
until the results come back - and then it spends a lot of time (10 seconds
at least) processing those results. Nagios-DB only makes this worse.  
During those 10 seconds, no more events are kicked off, meaning things get 
progressively worse.

> > That thread pool-enabled version of nagios still lives in CVS only; 
> > once I write some documentation, I'll be making another release.
> 
> I look forward to having a play with this.

Just to clarily, I meant a thread pool-enabled version of the postgres 
nagios-db NEB is in CVS. :)

RE: [Nagios-db-devel] performance query

[Dan H. <dan...@uk...>]

> -----Original Message-----
> From: Ben [mailto:be...@si...]
> Sent: 28 April 2005 16:09
> To: Dan Hopkins
> Cc: 'nag...@li...'
> Subject: Re: [Nagios-db-devel] performance query

<snip>
 
> There are two potential gotchas. First, the postgres nagios-db uses 
> snapshot materialized views, meaning they refresh 
> periodically, not in 
> realtime. I have pretty beefy hardware, so I can set mine to refresh 
> every minute, but for a tool that's supposed to tell you when things 
> are down, I think updating every minute is pretty overkill. 
> Once every 
> 5 minutes would probably be just fine.

This is my next step too, although I'm using MySQL so pgsql's nice
materialized views will either be hand rolled snapshot tables :), or I may
try replication to a reader db. I'd intended to do the snapshots fairly
quickly, a couple of times a minute (we're only talking a few thousand rows
at the moment, so it's no big deal to the db) but I've not done any testing
yet so this could be optimistic considering there are multiple nagios
instances running off the same db backend hosts. We shall see...

> The other potential gotcha is that nagios has to write the value of 
> each check into the db to complete a check, and if the db is slammed, 
> this will take an increasing amount of time. This was causing me very 
> bad latency problems (thousands of seconds) until recently, when I 
> implemented some thread pool action in the NEB and now my 
> latency times 
> tend to hover around 15 seconds.

This is the sort of issue that's hitting us: nagios is slow writing it's
updates in aggregated mode (we're talking 10-20 seconds for less than 4000
services in worst case) that some of our scripts (inhouse php customised
replacements) just hang on queries waiting for the locks to free. And too
many users accessing the scripts cause nagios to lag obtaining locks to dump
its updates. Enter non-aggregated updates .... and the massive jump in load
on the nagios host. Still, the user facing scripts appear quicker at least
;) But it did make me wonder how the neb's fare with thousands of status
updates, now I see from another thread you've got over 8k services on the go
? - that's promising stuff, are you distributing this over multiple nagios
hosts or a single centralised one?

> That thread pool-enabled version of nagios still lives in CVS only; 
> once I write some documentation, I'll be making another release.

I look forward to having a play with this.

Thanks for the info,
Dan

Re: [Nagios-db-devel] performance query

[Ben <be...@si...>]

Well, I can only speak to the postgres module, but here's what I found:

Nagios 2 works a lot better than Nagios 1. I can't recall how much 
better, but I do recall it still wasn't scalable enough for our 
purposes. So, enter Nagios-DB. The big point of nagios-db for me was to 
precompute as much data as was possible with the use of materialized 
views. That way, when the interface wanted to see some metrics, 
gathering those metrics is usually little more than pulling numbers 
straights from a static table. Nice and fast. So from an interface 
point of view, nagios-db works wonderfully.

There are two potential gotchas. First, the postgres nagios-db uses 
snapshot materialized views, meaning they refresh periodically, not in 
realtime. I have pretty beefy hardware, so I can set mine to refresh 
every minute, but for a tool that's supposed to tell you when things 
are down, I think updating every minute is pretty overkill. Once every 
5 minutes would probably be just fine.

The other potential gotcha is that nagios has to write the value of 
each check into the db to complete a check, and if the db is slammed, 
this will take an increasing amount of time. This was causing me very 
bad latency problems (thousands of seconds) until recently, when I 
implemented some thread pool action in the NEB and now my latency times 
tend to hover around 15 seconds.

That thread pool-enabled version of nagios still lives in CVS only; 
once I write some documentation, I'll be making another release.

On Apr 28, 2005, at 1:54 AM, Dan Hopkins wrote:

> Hi Ben and co,
> How are you finding performance with the NEB db modules? I ask because 
> I'm
> assuming it's the closest thing to Nagios1.2+db support with aggregated
> updates turned off (?), and having done this recently (on a 3gig xeon 
> with
> 2gig ram running around 3700 services across 3500 hosts) the load 
> increased
> from a palatable 1-2 to a more hefty 4-5. Still perfectly usable, but 
> it did
> make me wonder how the event based neb modules perform - I'll be 
> upgrading
> to 2.x+NEB as soon as the 2 branch is officially stable.
>
> Has anyone done scalability testing they could share?
>
> Thanks
> -- 
> Dan Hopkins
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software development plans!
> Take this survey and enter to win a one-year sub to SourceForge.net
> Plus IDC's 2005 look-ahead and a copy of this survey
> Click here to start!  http://www.idcswdc.com/cgi-bin/survey?id=105hix
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

[Nagios-db-devel] performance query

[Dan H. <dan...@uk...>]

Hi Ben and co,
How are you finding performance with the NEB db modules? I ask because I'm
assuming it's the closest thing to Nagios1.2+db support with aggregated
updates turned off (?), and having done this recently (on a 3gig xeon with
2gig ram running around 3700 services across 3500 hosts) the load increased
from a palatable 1-2 to a more hefty 4-5. Still perfectly usable, but it did
make me wonder how the event based neb modules perform - I'll be upgrading
to 2.x+NEB as soon as the 2 branch is officially stable.

Has anyone done scalability testing they could share?

Thanks
-- 
Dan Hopkins

RE: [Nagios-db-devel] Problem with loading the inserter.o NEB module

[Ben <be...@si...>]

Heh. Glad I could help. :)

On Wed, 27 Apr 2005, Jonathan Bibeau wrote:

> I just found the problem. I needed to install the package "libkrb5-dev" and
> then I used the other portion of your makefile that builds it with:
> 
> all:
>         gcc -Wall -g -O2 -o inserter.o inserter.c -shared
> -I/usr/src/nagios-2.0b3/include -I/usr/include/postgresql /usr/lib/libpq.a
> -lssl -lkrb5 -lcrypt
> 
> This worked and its now writing to the database properly. Thanks again for
> your help!
> 
> Regards,
> Jon
> 
> -----Original Message-----
> From: nag...@li...
> [mailto:nag...@li...] On Behalf Of Jonathan
> Bibeau
> Sent: Wednesday, April 27, 2005 3:11 PM
> To: 'Ben'
> Cc: nag...@li...
> Subject: RE: [Nagios-db-devel] Problem with loading the inserter.o NEB
> module
> 
> Hi Ben,
> 
> Here is the output from that command.
> 
> nms:/usr/src/nagios-db-0.91/neb/mysql# ldd
> /usr/local/nagios/modules/inserter.o
>                 libc.so.6 => /lib/tls/libc.so.6 (0x40023000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) 
> 
> Regards,
> Jon
> 
> -----Original Message-----
> From: nag...@li...
> [mailto:nag...@li...] On Behalf Of Ben
> Sent: Wednesday, April 27, 2005 3:04 PM
> To: Jonathan Bibeau
> Cc: nag...@li...
> Subject: Re: [Nagios-db-devel] Problem with loading the inserter.o NEB
> module
> 
> What does `ldd /usr/local/nagios/modules/inserter.o` say?
> 
> On Wed, 27 Apr 2005, Jonathan Bibeau wrote:
> 
> > Greetings.
> >  
> > I'm running Debian unstable, compiled and installed Nagios 2.0b3 (with 
> > Event Broker support), and was working on setting up nagios-db, but 
> > ran into some problems. I've compiled the inserter.o under both your 
> > release branch and the version in CVS without any problems, but when 
> > Nagios tried to load the module, it throws off this error:
> >  
> > Apr 27 14:42:32 localhost nagios: Nagios 2.0b3 starting... (PID=1503) 
> > Apr 27 14:42:32 localhost nagios: LOG VERSION: 2.0 Apr 27 14:42:32 
> > localhost nagios: Error: Could not load module 
> > '/usr/local/nagios/modules/inserter.o' ->
> > /usr/local/nagios/modules/inserter.o: undefined symbol: 
> > BIO_new_mem_buf
> > 
> > I'm using the PgSQL NEB module just because I couldn't compile the 
> > MySQL one. I got the following error when trying to compile the MySQL
> module.
> >  
> > nms:/usr/src/nagios-db-0.91/neb/mysql# make gcc -g -O2 -Wall -o 
> > inserter.o inserter.c -shared -I/usr/src/nagios-2.0b3/include 
> > -I/usr/include/mysql -lmysqlclient -fPIC
> > inserter.c: In function `nebmodule_init':
> > inserter.c:130: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use 
> > in this function)
> > inserter.c:130: error: (Each undeclared identifier is reported only 
> > once
> > inserter.c:130: error: for each function it appears in.)
> > make: *** [all] Error 1
> > 
> > I browsed around your message lists and tried a few things based on 
> > what I found. I tried back tracking to Nagios 2.0b1, but that didn't 
> > change anything.
> >  
> > Any thoughts?
> >  
> > Best regards,
> >  
> > Jonathan Bibeau < <mailto:jb...@c-...> jb...@c-...> System 
> > Administrator, CIS Technical Services
> > 33 Main Street, Suite 302
> > Nashua, NH 03064
> > (603) 889-4684 (Local)
> > (603) 889-0534 (Fax)
> >  
> > 
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software development plans!
> Take this survey and enter to win a one-year sub to SourceForge.net Plus
> IDC's 2005 look-ahead and a copy of this survey Click here to start!
> http://www.idcswdc.com/cgi-bin/survey?id=105hix
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software development plans!
> Take this survey and enter to win a one-year sub to SourceForge.net Plus
> IDC's 2005 look-ahead and a copy of this survey Click here to start!
> http://www.idcswdc.com/cgi-bin/survey?id=105hix
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
> 
> 

RE: [Nagios-db-devel] Problem with loading the inserter.o NEB module

[Jonathan B. <jb...@c-...>]

I just found the problem. I needed to install the package "libkrb5-dev" and
then I used the other portion of your makefile that builds it with:

all:
        gcc -Wall -g -O2 -o inserter.o inserter.c -shared
-I/usr/src/nagios-2.0b3/include -I/usr/include/postgresql /usr/lib/libpq.a
-lssl -lkrb5 -lcrypt

This worked and its now writing to the database properly. Thanks again for
your help!

Regards,
Jon

-----Original Message-----
From: nag...@li...
[mailto:nag...@li...] On Behalf Of Jonathan
Bibeau
Sent: Wednesday, April 27, 2005 3:11 PM
To: 'Ben'
Cc: nag...@li...
Subject: RE: [Nagios-db-devel] Problem with loading the inserter.o NEB
module

Hi Ben,

Here is the output from that command.

nms:/usr/src/nagios-db-0.91/neb/mysql# ldd
/usr/local/nagios/modules/inserter.o
                libc.so.6 => /lib/tls/libc.so.6 (0x40023000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) 

Regards,
Jon

-----Original Message-----
From: nag...@li...
[mailto:nag...@li...] On Behalf Of Ben
Sent: Wednesday, April 27, 2005 3:04 PM
To: Jonathan Bibeau
Cc: nag...@li...
Subject: Re: [Nagios-db-devel] Problem with loading the inserter.o NEB
module

What does `ldd /usr/local/nagios/modules/inserter.o` say?

On Wed, 27 Apr 2005, Jonathan Bibeau wrote:

> Greetings.
>  
> I'm running Debian unstable, compiled and installed Nagios 2.0b3 (with 
> Event Broker support), and was working on setting up nagios-db, but 
> ran into some problems. I've compiled the inserter.o under both your 
> release branch and the version in CVS without any problems, but when 
> Nagios tried to load the module, it throws off this error:
>  
> Apr 27 14:42:32 localhost nagios: Nagios 2.0b3 starting... (PID=1503) 
> Apr 27 14:42:32 localhost nagios: LOG VERSION: 2.0 Apr 27 14:42:32 
> localhost nagios: Error: Could not load module 
> '/usr/local/nagios/modules/inserter.o' ->
> /usr/local/nagios/modules/inserter.o: undefined symbol: 
> BIO_new_mem_buf
> 
> I'm using the PgSQL NEB module just because I couldn't compile the 
> MySQL one. I got the following error when trying to compile the MySQL
module.
>  
> nms:/usr/src/nagios-db-0.91/neb/mysql# make gcc -g -O2 -Wall -o 
> inserter.o inserter.c -shared -I/usr/src/nagios-2.0b3/include 
> -I/usr/include/mysql -lmysqlclient -fPIC
> inserter.c: In function `nebmodule_init':
> inserter.c:130: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use 
> in this function)
> inserter.c:130: error: (Each undeclared identifier is reported only 
> once
> inserter.c:130: error: for each function it appears in.)
> make: *** [all] Error 1
> 
> I browsed around your message lists and tried a few things based on 
> what I found. I tried back tracking to Nagios 2.0b1, but that didn't 
> change anything.
>  
> Any thoughts?
>  
> Best regards,
>  
> Jonathan Bibeau < <mailto:jb...@c-...> jb...@c-...> System 
> Administrator, CIS Technical Services
> 33 Main Street, Suite 302
> Nashua, NH 03064
> (603) 889-4684 (Local)
> (603) 889-0534 (Fax)
>  
> 




-------------------------------------------------------
SF.Net email is sponsored by: Tell us your software development plans!
Take this survey and enter to win a one-year sub to SourceForge.net Plus
IDC's 2005 look-ahead and a copy of this survey Click here to start!
http://www.idcswdc.com/cgi-bin/survey?id=105hix
_______________________________________________
Nagios-db-devel mailing list
Nag...@li...
https://lists.sourceforge.net/lists/listinfo/nagios-db-devel



-------------------------------------------------------
SF.Net email is sponsored by: Tell us your software development plans!
Take this survey and enter to win a one-year sub to SourceForge.net Plus
IDC's 2005 look-ahead and a copy of this survey Click here to start!
http://www.idcswdc.com/cgi-bin/survey?id=105hix
_______________________________________________
Nagios-db-devel mailing list
Nag...@li...
https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

RE: [Nagios-db-devel] Problem with loading the inserter.o NEB module

[Jonathan B. <jb...@c-...>]

Hi Ben,

Here is the output from that command.

nms:/usr/src/nagios-db-0.91/neb/mysql# ldd
/usr/local/nagios/modules/inserter.o
                libc.so.6 => /lib/tls/libc.so.6 (0x40023000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) 

Regards,
Jon

-----Original Message-----
From: nag...@li...
[mailto:nag...@li...] On Behalf Of Ben
Sent: Wednesday, April 27, 2005 3:04 PM
To: Jonathan Bibeau
Cc: nag...@li...
Subject: Re: [Nagios-db-devel] Problem with loading the inserter.o NEB
module

What does `ldd /usr/local/nagios/modules/inserter.o` say?

On Wed, 27 Apr 2005, Jonathan Bibeau wrote:

> Greetings.
>  
> I'm running Debian unstable, compiled and installed Nagios 2.0b3 (with 
> Event Broker support), and was working on setting up nagios-db, but 
> ran into some problems. I've compiled the inserter.o under both your 
> release branch and the version in CVS without any problems, but when 
> Nagios tried to load the module, it throws off this error:
>  
> Apr 27 14:42:32 localhost nagios: Nagios 2.0b3 starting... (PID=1503) 
> Apr 27 14:42:32 localhost nagios: LOG VERSION: 2.0 Apr 27 14:42:32 
> localhost nagios: Error: Could not load module 
> '/usr/local/nagios/modules/inserter.o' ->
> /usr/local/nagios/modules/inserter.o: undefined symbol: 
> BIO_new_mem_buf
> 
> I'm using the PgSQL NEB module just because I couldn't compile the 
> MySQL one. I got the following error when trying to compile the MySQL
module.
>  
> nms:/usr/src/nagios-db-0.91/neb/mysql# make gcc -g -O2 -Wall -o 
> inserter.o inserter.c -shared -I/usr/src/nagios-2.0b3/include 
> -I/usr/include/mysql -lmysqlclient -fPIC
> inserter.c: In function `nebmodule_init':
> inserter.c:130: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use 
> in this function)
> inserter.c:130: error: (Each undeclared identifier is reported only 
> once
> inserter.c:130: error: for each function it appears in.)
> make: *** [all] Error 1
> 
> I browsed around your message lists and tried a few things based on 
> what I found. I tried back tracking to Nagios 2.0b1, but that didn't 
> change anything.
>  
> Any thoughts?
>  
> Best regards,
>  
> Jonathan Bibeau < <mailto:jb...@c-...> jb...@c-...> System 
> Administrator, CIS Technical Services
> 33 Main Street, Suite 302
> Nashua, NH 03064
> (603) 889-4684 (Local)
> (603) 889-0534 (Fax)
>  
> 




-------------------------------------------------------
SF.Net email is sponsored by: Tell us your software development plans!
Take this survey and enter to win a one-year sub to SourceForge.net Plus
IDC's 2005 look-ahead and a copy of this survey Click here to start!
http://www.idcswdc.com/cgi-bin/survey?id=105hix
_______________________________________________
Nagios-db-devel mailing list
Nag...@li...
https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

Re: [Nagios-db-devel] Problem with loading the inserter.o NEB module

[Ben <be...@si...>]

What does `ldd /usr/local/nagios/modules/inserter.o` say?

On Wed, 27 Apr 2005, Jonathan Bibeau wrote:

> Greetings.
>  
> I'm running Debian unstable, compiled and installed Nagios 2.0b3 (with Event
> Broker support), and was working on setting up nagios-db, but ran into some
> problems. I've compiled the inserter.o under both your release branch and
> the version in CVS without any problems, but when Nagios tried to load the
> module, it throws off this error:
>  
> Apr 27 14:42:32 localhost nagios: Nagios 2.0b3 starting... (PID=1503)
> Apr 27 14:42:32 localhost nagios: LOG VERSION: 2.0
> Apr 27 14:42:32 localhost nagios: Error: Could not load module
> '/usr/local/nagios/modules/inserter.o' ->
> /usr/local/nagios/modules/inserter.o: undefined symbol: BIO_new_mem_buf
> 
> I'm using the PgSQL NEB module just because I couldn't compile the MySQL
> one. I got the following error when trying to compile the MySQL module.
>  
> nms:/usr/src/nagios-db-0.91/neb/mysql# make
> gcc -g -O2 -Wall -o inserter.o inserter.c -shared
> -I/usr/src/nagios-2.0b3/include -I/usr/include/mysql -lmysqlclient -fPIC
> inserter.c: In function `nebmodule_init':
> inserter.c:130: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use in
> this function)
> inserter.c:130: error: (Each undeclared identifier is reported only once
> inserter.c:130: error: for each function it appears in.)
> make: *** [all] Error 1
> 
> I browsed around your message lists and tried a few things based on what I
> found. I tried back tracking to Nagios 2.0b1, but that didn't change
> anything.
>  
> Any thoughts?
>  
> Best regards,
>  
> Jonathan Bibeau < <mailto:jb...@c-...> jb...@c-...>
> System Administrator,
> CIS Technical Services
> 33 Main Street, Suite 302
> Nashua, NH 03064
> (603) 889-4684 (Local)
> (603) 889-0534 (Fax)
>  
> 

[Nagios-db-devel] Problem with loading the inserter.o NEB module

[Jonathan B. <jb...@c-...>]

Greetings.
 
I'm running Debian unstable, compiled and installed Nagios 2.0b3 (with Event
Broker support), and was working on setting up nagios-db, but ran into some
problems. I've compiled the inserter.o under both your release branch and
the version in CVS without any problems, but when Nagios tried to load the
module, it throws off this error:
 
Apr 27 14:42:32 localhost nagios: Nagios 2.0b3 starting... (PID=1503)
Apr 27 14:42:32 localhost nagios: LOG VERSION: 2.0
Apr 27 14:42:32 localhost nagios: Error: Could not load module
'/usr/local/nagios/modules/inserter.o' ->
/usr/local/nagios/modules/inserter.o: undefined symbol: BIO_new_mem_buf

I'm using the PgSQL NEB module just because I couldn't compile the MySQL
one. I got the following error when trying to compile the MySQL module.
 
nms:/usr/src/nagios-db-0.91/neb/mysql# make
gcc -g -O2 -Wall -o inserter.o inserter.c -shared
-I/usr/src/nagios-2.0b3/include -I/usr/include/mysql -lmysqlclient -fPIC
inserter.c: In function `nebmodule_init':
inserter.c:130: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use in
this function)
inserter.c:130: error: (Each undeclared identifier is reported only once
inserter.c:130: error: for each function it appears in.)
make: *** [all] Error 1

I browsed around your message lists and tried a few things based on what I
found. I tried back tracking to Nagios 2.0b1, but that didn't change
anything.
 
Any thoughts?
 
Best regards,
 
Jonathan Bibeau < <mailto:jb...@c-...> jb...@c-...>
System Administrator,
CIS Technical Services
33 Main Street, Suite 302
Nashua, NH 03064
(603) 889-4684 (Local)
(603) 889-0534 (Fax)
 

Re: [Nagios-db-devel] Retain State

[Ben <be...@si...>]

Hm, actually, come to think of it, I realized that everything I said in 
my first reply was kinda wrong. So ignore that. :)

Here's what nagios-db does. On a restart, all hosts and services are
marked as pending. Services will be checked as quickly as specified by
max_service_check_spread, and host checks will happen whenever nagios
thinks it needs them. Because Nagios doesn't do host checks that often, it
most hosts stay pending for quite some time. Nagios-DB strives to be
"correct", and so it says a check is pending if it really doesn't know
what the status is.

So, the short answer is, yes, nagios-db sees the previous state, but at 
the same time it ignores it. I had imagined that, in most environments, 
nagios will be run for long periods of time uninterrupted, and balanced 
the tradeoffs accordingly.

If you can't increase max_service_check_spread to something smaller, and
if you can't just live with things being pending until they're checked :),
then the data is in the database, but you'll have to hack some of the
stored procs and the php to mimic the CGI's implementation of state 
retention.

On Thu, 24 Mar 2005, jl wrote:

> I guess I was more looking at services being marked as pending upon a 
> nagios restart.  I have a bunch of services that only report back 
> hourly (raid status and freespace as examples) that get marked as 
> pending after a nagios restart.  We end up having to restart nagios a 
> fair amount right now because of changes to our network and 'loose' the 
> last state of those services until they report again.  Is there a way 
> around this?
> 
> Sorry if I'm missing something obvious.
> 
> jl
> 
> 
> On Mar 24, 2005, at 11:43 AM, Ben wrote:
> 
> > Well, a couple things.
> >
> > First, nagios-db does retain the last state. (In fact, there's really 
> > no
> > way not to retain state.) However, it doesn't use it for hosts and 
> > doesn't
> > trust it for services. This was intentional. If nagios has to restart,
> > there's no way to know what happened when it was down.
> >
> > Second, there is a big difference between pending and unknown, at least
> > when it comes to services.
> >
> > So.... unlike the nagios CGIs, the nagios-db UI does the most accurate
> > thing it can: it a service had been up before restart, nagios-db marks 
> > the
> > host as "up and pending". It still sort counts as up, but it's 
> > untrusted,
> > because nagios may well have missed it going down.
> >
> > If this doesn't work for you, why not?
> >
> > On Thu, 24 Mar 2005, jl wrote:
> >
> >> I've noticed that when nagios resetarts, nagios-db does not retain the
> >> current state.  I have set nagios to retain state, and verified that 
> >> it
> >> does.  This creates some holes of 'unknown' for services that don't
> >> report very often.  Is there a way to make nagios-db retain state or 
> >> is
> >> that a limitation of nagios?
> >>
> >> jl
> >>
> >>
> >>
> >> -------------------------------------------------------
> >> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 
> >> 2005
> >> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest 
> >> Windows
> >> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  
> >> Register
> >> by 3/29 & save $300 
> >> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> >> _______________________________________________
> >> Nagios-db-devel mailing list
> >> Nag...@li...
> >> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
> >>
> >
> >
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
> 

Re: [Nagios-db-devel] Retain State

[jl <jla...@em...>]

I guess I was more looking at services being marked as pending upon a 
nagios restart.  I have a bunch of services that only report back 
hourly (raid status and freespace as examples) that get marked as 
pending after a nagios restart.  We end up having to restart nagios a 
fair amount right now because of changes to our network and 'loose' the 
last state of those services until they report again.  Is there a way 
around this?

Sorry if I'm missing something obvious.

jl


On Mar 24, 2005, at 11:43 AM, Ben wrote:

> Well, a couple things.
>
> First, nagios-db does retain the last state. (In fact, there's really 
> no
> way not to retain state.) However, it doesn't use it for hosts and 
> doesn't
> trust it for services. This was intentional. If nagios has to restart,
> there's no way to know what happened when it was down.
>
> Second, there is a big difference between pending and unknown, at least
> when it comes to services.
>
> So.... unlike the nagios CGIs, the nagios-db UI does the most accurate
> thing it can: it a service had been up before restart, nagios-db marks 
> the
> host as "up and pending". It still sort counts as up, but it's 
> untrusted,
> because nagios may well have missed it going down.
>
> If this doesn't work for you, why not?
>
> On Thu, 24 Mar 2005, jl wrote:
>
>> I've noticed that when nagios resetarts, nagios-db does not retain the
>> current state.  I have set nagios to retain state, and verified that 
>> it
>> does.  This creates some holes of 'unknown' for services that don't
>> report very often.  Is there a way to make nagios-db retain state or 
>> is
>> that a limitation of nagios?
>>
>> jl
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 
>> 2005
>> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest 
>> Windows
>> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  
>> Register
>> by 3/29 & save $300 
>> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
>> _______________________________________________
>> Nagios-db-devel mailing list
>> Nag...@li...
>> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
>>
>
>

Re: [Nagios-db-devel] Retain State

[Ben <be...@si...>]

Well, a couple things. 

First, nagios-db does retain the last state. (In fact, there's really no
way not to retain state.) However, it doesn't use it for hosts and doesn't
trust it for services. This was intentional. If nagios has to restart,
there's no way to know what happened when it was down.

Second, there is a big difference between pending and unknown, at least 
when it comes to services.

So.... unlike the nagios CGIs, the nagios-db UI does the most accurate
thing it can: it a service had been up before restart, nagios-db marks the
host as "up and pending". It still sort counts as up, but it's untrusted,
because nagios may well have missed it going down.

If this doesn't work for you, why not?

On Thu, 24 Mar 2005, jl wrote:

> I've noticed that when nagios resetarts, nagios-db does not retain the 
> current state.  I have set nagios to retain state, and verified that it 
> does.  This creates some holes of 'unknown' for services that don't 
> report very often.  Is there a way to make nagios-db retain state or is 
> that a limitation of nagios?
> 
> jl
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
> by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
> 

[Nagios-db-devel] Retain State

[jl <jla...@em...>]

I've noticed that when nagios resetarts, nagios-db does not retain the 
current state.  I have set nagios to retain state, and verified that it 
does.  This creates some holes of 'unknown' for services that don't 
report very often.  Is there a way to make nagios-db retain state or is 
that a limitation of nagios?

jl

Re: [Nagios-db-devel] nagios-db

[Ben <be...@si...>]

Have you attempted to read the readme? I tried to give an explanation 
of how it works in there..... if it makes no sense to you, what part 
should be rewritten?

On Mar 23, 2005, at 8:00 PM, Brett Stevens wrote:

> Great, can you let me know and Ill assist with testing and doco if you 
> like.
> I have a real need to get a thorough understandin on how this works. 
> What I
> want to do is integrate nagios and cacti. If I can get enough info on 
> how
> this works I think this would be the way.
>
> Thanks
>
> Brett Stevens
>
> -----Original Message-----
> From: Ben [mailto:be...@si...]
> Sent: Thursday, March 24, 2005 2:29 PM
> To: Brett Stevens
> Cc: 'barry haycock'; nag...@li...
> Subject: Re: [Nagios-db-devel] nagios-db
>
>
> Wow, I didn't realize people would find it so challenging. Then again,
> I guess I did write it, so maybe I'm not an average user.
>
> I'm currently making (what I hope will be) a massive performance
> improvement for the postgres inserter, and once I'm satisfied with that
> work, I'll make some actual documentation.
>
> On Mar 23, 2005, at 6:38 PM, Brett Stevens wrote:
>
>> I had the same question last week, tho it was for postgres. What I did
>> was to check out the latest inserter.c Modify inserter.c to give the
>> correct details for db login
>> 	if(!(pgconn = PQconnectdb("host=I.P.a.d port=whatever
>> dbname=ultrasecret user=whatever"))) Make
>> Copied the file inserter.o to nagios/bin
>> Chown to correct user
>> Modify nagios.cfg
>>    	event_broker_options=-1
>> 	broker_module=/usr/local/nagios/bin/inserter.o
>> Started database server
>> Created and configured db schema as follows
>> Order is important here.
>>
>> 1. Create your database.
>> 2. Apply handlers.sql.
>> 3. Apply schema.sql.
>> 4. Apply types.sql
>> 5. Apply SPs/*.
>> 6. Apply views.sql.
>>
>> This will be different for mysql but the readme in the database/mysql
>> dir
>> will tell you exactly what you will need to build your db
>> Kill -HUP nagios -- all done
>>
>> This was after much pain and angst, I think Ill have to write this up
>> a little better and submit it to the team.
>>
>> Good luck and let us know how you made out.
>>
>> Brett Stevens
>>
>>
>> -----Original Message-----
>> From: barry haycock [mailto:sat...@ya...]
>> Sent: Thursday, March 24, 2005 1:27 PM
>> To: nag...@li...
>> Subject: [Nagios-db-devel] nagios-db
>>
>>
>> Hi, I have recently aquired nagios-db to plug into our
>> nagios (2.0b2) system. looking through the software
>> and this list there doesn't seem to be any docs to
>> configure it.
>>
>> i have built the software for use with mysql and
>> compiled the src files. but how do i configure nagios
>> to work with nagios-db???
>>
>> i have a number of years experience with nagios and
>> it's predececor netsaint so i am familar with the
>> config files.
>>
>> any notes would help, I wouldn't mind submitting my
>> final notes as part of the documentation when i get
>> the system working.
>>
>> Barry
>>
>> Find local movie times and trailers on Yahoo! Movies.
>> http://au.movies.yahoo.com
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon
>> 2005
>> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest 
>> Windows
>> Embedded(r) & Windows Mobile(tm) platforms, applications & content.
>> Register by 3/29 & save $300
>> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
>> _______________________________________________
>> Nagios-db-devel mailing list Nag...@li...
>> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon
>> 2005
>> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest 
>> Windows
>> Embedded(r) & Windows Mobile(tm) platforms, applications & content.
>> Register
>> by 3/29 & save $300
>> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
>> _______________________________________________
>> Nagios-db-devel mailing list
>> Nag...@li...
>> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

RE: [Nagios-db-devel] nagios-db

[Brett S. <bre...@hu...>]

Great, can you let me know and Ill assist with testing and doco if you like.
I have a real need to get a thorough understandin on how this works. What I
want to do is integrate nagios and cacti. If I can get enough info on how
this works I think this would be the way.

Thanks

Brett Stevens

-----Original Message-----
From: Ben [mailto:be...@si...] 
Sent: Thursday, March 24, 2005 2:29 PM
To: Brett Stevens
Cc: 'barry haycock'; nag...@li...
Subject: Re: [Nagios-db-devel] nagios-db


Wow, I didn't realize people would find it so challenging. Then again, 
I guess I did write it, so maybe I'm not an average user.

I'm currently making (what I hope will be) a massive performance 
improvement for the postgres inserter, and once I'm satisfied with that 
work, I'll make some actual documentation.

On Mar 23, 2005, at 6:38 PM, Brett Stevens wrote:

> I had the same question last week, tho it was for postgres. What I did 
> was to check out the latest inserter.c Modify inserter.c to give the 
> correct details for db login
> 	if(!(pgconn = PQconnectdb("host=I.P.a.d port=whatever 
> dbname=ultrasecret user=whatever"))) Make
> Copied the file inserter.o to nagios/bin
> Chown to correct user
> Modify nagios.cfg
>    	event_broker_options=-1
> 	broker_module=/usr/local/nagios/bin/inserter.o
> Started database server
> Created and configured db schema as follows
> Order is important here.
>
> 1. Create your database.
> 2. Apply handlers.sql.
> 3. Apply schema.sql.
> 4. Apply types.sql
> 5. Apply SPs/*.
> 6. Apply views.sql.
>
> This will be different for mysql but the readme in the database/mysql
> dir
> will tell you exactly what you will need to build your db
> Kill -HUP nagios -- all done
>
> This was after much pain and angst, I think Ill have to write this up 
> a little better and submit it to the team.
>
> Good luck and let us know how you made out.
>
> Brett Stevens
>
>
> -----Original Message-----
> From: barry haycock [mailto:sat...@ya...]
> Sent: Thursday, March 24, 2005 1:27 PM
> To: nag...@li...
> Subject: [Nagios-db-devel] nagios-db
>
>
> Hi, I have recently aquired nagios-db to plug into our
> nagios (2.0b2) system. looking through the software
> and this list there doesn't seem to be any docs to
> configure it.
>
> i have built the software for use with mysql and
> compiled the src files. but how do i configure nagios
> to work with nagios-db???
>
> i have a number of years experience with nagios and
> it's predececor netsaint so i am familar with the
> config files.
>
> any notes would help, I wouldn't mind submitting my
> final notes as part of the documentation when i get
> the system working.
>
> Barry
>
> Find local movie times and trailers on Yahoo! Movies. 
> http://au.movies.yahoo.com
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon
> 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.
> Register by 3/29 & save $300
> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> _______________________________________________
> Nagios-db-devel mailing list Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon
> 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  
> Register
> by 3/29 & save $300 
> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

Re: [Nagios-db-devel] nagios-db

[Ben <be...@si...>]

Wow, I didn't realize people would find it so challenging. Then again, 
I guess I did write it, so maybe I'm not an average user.

I'm currently making (what I hope will be) a massive performance 
improvement for the postgres inserter, and once I'm satisfied with that 
work, I'll make some actual documentation.

On Mar 23, 2005, at 6:38 PM, Brett Stevens wrote:

> I had the same question last week, tho it was for postgres.
> What I did was to check out the latest inserter.c
> Modify inserter.c to give the correct details for db login
> 	if(!(pgconn = PQconnectdb("host=I.P.a.d port=whatever
> dbname=ultrasecret user=whatever")))
> Make
> Copied the file inserter.o to nagios/bin
> Chown to correct user
> Modify nagios.cfg
>    	event_broker_options=-1
> 	broker_module=/usr/local/nagios/bin/inserter.o
> Started database server
> Created and configured db schema as follows
> Order is important here.
>
> 1. Create your database.
> 2. Apply handlers.sql.
> 3. Apply schema.sql.
> 4. Apply types.sql
> 5. Apply SPs/*.
> 6. Apply views.sql.
>
> This will be different for mysql but the readme in the database/mysql 
> dir
> will tell you exactly what you will need to build your db
> Kill -HUP nagios -- all done
>
> This was after much pain and angst, I think Ill have to write this up a
> little better and submit it to the team.
>
> Good luck and let us know how you made out.
>
> Brett Stevens
>
>
> -----Original Message-----
> From: barry haycock [mailto:sat...@ya...]
> Sent: Thursday, March 24, 2005 1:27 PM
> To: nag...@li...
> Subject: [Nagios-db-devel] nagios-db
>
>
> Hi, I have recently aquired nagios-db to plug into our
> nagios (2.0b2) system. looking through the software
> and this list there doesn't seem to be any docs to
> configure it.
>
> i have built the software for use with mysql and
> compiled the src files. but how do i configure nagios
> to work with nagios-db???
>
> i have a number of years experience with nagios and
> it's predececor netsaint so i am familar with the
> config files.
>
> any notes would help, I wouldn't mind submitting my
> final notes as part of the documentation when i get
> the system working.
>
> Barry
>
> Find local movie times and trailers on Yahoo! Movies.
> http://au.movies.yahoo.com
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 
> 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.
> Register by 3/29 & save $300
> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> _______________________________________________
> Nagios-db-devel mailing list Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 
> 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  
> Register
> by 3/29 & save $300 
> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

RE: [Nagios-db-devel] nagios-db

[Brett S. <bre...@hu...>]

I had the same question last week, tho it was for postgres.
What I did was to check out the latest inserter.c
Modify inserter.c to give the correct details for db login
	if(!(pgconn = PQconnectdb("host=I.P.a.d port=whatever
dbname=ultrasecret user=whatever")))
Make 
Copied the file inserter.o to nagios/bin
Chown to correct user
Modify nagios.cfg 
   	event_broker_options=-1
	broker_module=/usr/local/nagios/bin/inserter.o
Started database server
Created and configured db schema as follows
Order is important here.

1. Create your database.
2. Apply handlers.sql.
3. Apply schema.sql.
4. Apply types.sql
5. Apply SPs/*.
6. Apply views.sql.

This will be different for mysql but the readme in the database/mysql dir
will tell you exactly what you will need to build your db
Kill -HUP nagios -- all done

This was after much pain and angst, I think Ill have to write this up a
little better and submit it to the team.

Good luck and let us know how you made out.

Brett Stevens


-----Original Message-----
From: barry haycock [mailto:sat...@ya...] 
Sent: Thursday, March 24, 2005 1:27 PM
To: nag...@li...
Subject: [Nagios-db-devel] nagios-db


Hi, I have recently aquired nagios-db to plug into our
nagios (2.0b2) system. looking through the software
and this list there doesn't seem to be any docs to
configure it.

i have built the software for use with mysql and
compiled the src files. but how do i configure nagios
to work with nagios-db???

i have a number of years experience with nagios and
it's predececor netsaint so i am familar with the
config files.

any notes would help, I wouldn't mind submitting my
final notes as part of the documentation when i get
the system working.

Barry

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com


-------------------------------------------------------
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.
Register by 3/29 & save $300
http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
_______________________________________________
Nagios-db-devel mailing list Nag...@li...
https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

[Nagios-db-devel] nagios-db

[barry h. <sat...@ya...>]

Hi, I have recently aquired nagios-db to plug into our
nagios (2.0b2) system. looking through the software
and this list there doesn't seem to be any docs to
configure it.

i have built the software for use with mysql and
compiled the src files. but how do i configure nagios
to work with nagios-db???

i have a number of years experience with nagios and
it's predececor netsaint so i am familar with the
config files.

any notes would help, I wouldn't mind submitting my
final notes as part of the documentation when i get
the system working.

Barry

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com

[Nagios-db-devel] Re: Nagios DB Install

[Ben <be...@si...>]

It works pretty well for me. I'm not so familiar with the mysql version,
but the general idea is the same. You should be able to run the makefile
in the mysql neb directory, and then move the resultant .o file to
wherever you want, and then reference that from your nagios config file.
What part of this process isn't working for you?

Read the READMEs that are included - they should have this info. If it's
confusing, what is confusing about it? If you feel there are steps
missing, what do you feel is missing? I suppose we should get around to
making docs.


On Tue, 22 Mar 2005, Steve Nuffer wrote:

> Message body follows:
> 
> How well does this work with Nagios 2.x?  I am having a 
> problem installing the software since I can't find any 
> instructions.  
> 
> I'm using MySQL and I have created the database.  I'm 
> assuming that the inserter.c under mysql is the program to 
> insert entries into the database.  The compile won't work 
> since there are no include files in the distribution.
> 
> Any help would be appreciated.
> 
> Steve Nuffer
> 
> --
> This message has been sent to you, a registered SourceForge.net user,
> by another site user, through the SourceForge.net site.  This message
> has been delivered to your SourceForge.net mail alias.  You may reply
> to this message using the "Reply" feature of your email client, or
> using the messaging facility of SourceForge.net at:
> https://sourceforge.net/sendmessage.php?touser=1156104
> 

Re: [Nagios-db-devel] Nagios Neb posgress howto

[Ben <be...@si...>]

Well, most likely nagios-db cannot connect to postgres. Grab the latest 
inserter.c out of cvs; it has better logging, including fixing the bug 
that you're seeing below.

And no, there are no install docs other than the token READMEs. Feel 
free to contribute some. ;)

On Mar 17, 2005, at 3:09 AM, Brett Stevens wrote:

> Hi all. Firstly let me appologize if this has been asked before but. Is
> there any install doco for installing and using neb and nagios-db?
>
> Ive tried an install using postgress I think I have postgress installed
> correctly
> I then modified the inserter.c file to reflect my db settings and 
> compiled
> ok
> copied and chmodded inserter.o and edited nagios.cfg to point to the 
> file
> when I restart nagios I get
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host ' ()
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host ' ()
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host ' ()
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host ' ()
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host ' ()
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host ' ()
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host using 'na' ()
> [1111052423] nagios-db: couldn't configure host using 'nagios-db: 
> couldn't
> configure host using 'nagios-db: couldn't configure host using 'nagi' 
> ()
> [1111052423] nagios-db: configured 83 hosts
> [1111052423] nagios-db: couldn't configure hostgroup using 'nagios-db:
> couldn't configure hostgroup using 'nagios-db' ()
>
> many more entries at the begining but you get the drift.
>
> Nagios works ok with out the neb module entry in the config and this 
> is the
> only thing Im changing.
>
> Am I just a bit dopey or have I missed something?
>
>
> any help is greatly appreciated.
>
> Again,
> thanks
>
> Brett Stevens
>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real 
> users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel

[Nagios-db-devel] Nagios Neb posgress howto

[Brett S. <bre...@hu...>]

Hi all. Firstly let me appologize if this has been asked before but. Is
there any install doco for installing and using neb and nagios-db?

Ive tried an install using postgress I think I have postgress installed
correctly 
I then modified the inserter.c file to reflect my db settings and compiled
ok
copied and chmodded inserter.o and edited nagios.cfg to point to the file
when I restart nagios I get 
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host ' ()
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host ' ()
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host ' ()
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host ' ()
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host ' ()
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host ' ()
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host using 'na' ()
[1111052423] nagios-db: couldn't configure host using 'nagios-db: couldn't
configure host using 'nagios-db: couldn't configure host using 'nagi' ()
[1111052423] nagios-db: configured 83 hosts
[1111052423] nagios-db: couldn't configure hostgroup using 'nagios-db:
couldn't configure hostgroup using 'nagios-db' ()

many more entries at the begining but you get the drift.

Nagios works ok with out the neb module entry in the config and this is the
only thing Im changing.

Am I just a bit dopey or have I missed something?


any help is greatly appreciated.

Again,
thanks

Brett Stevens
 

Re: [Nagios-db-devel] Installing nagios-db

[Matthew K. <mk...@ma...>]

On Fri, 2005-11-03 at 08:49 -0600, jl wrote:
> I think I must be missing something obvious right in front of me since 
> I can't seem to find the answer to this question - how do you install 
> and configure neb modules? (This one in particular).
> 
> I've gotten the module compiled by coping the neb/mysql directory into 
> the nagios directory and running make.  Do I compile nagios after that 
> and it gets included in or does the .o (object?) file need to be copied 
> somewhere else.  After I get this where it needs to be, how do I 
> configure the database parameters?  I'm sorry if this is an obvious 
> question, but for the life of me I cannot find the answer.
> 
> Thanks,
> jl
> 

Well first off, both the neb modules aren't quite feature complete. You
have to actually edit the inserter.c code and change the database
connection parameters by hand. You then have to edit the Makefile (in
the same directory) to point it to your mysql header files (usually
you'll need some kind of mysql-dev mysql-devel package installed) and
the nagios sources. You then do a 'make' - it hopefully compiles and you
edit your main nagios.cfg to point to the generated inserter.o file.
-- 
Matthew Kent <mk...@ma...>
http://magoazul.com

[Nagios-db-devel] Installing nagios-db

[jl <jla...@em...>]

I think I must be missing something obvious right in front of me since 
I can't seem to find the answer to this question - how do you install 
and configure neb modules? (This one in particular).

I've gotten the module compiled by coping the neb/mysql directory into 
the nagios directory and running make.  Do I compile nagios after that 
and it gets included in or does the .o (object?) file need to be copied 
somewhere else.  After I get this where it needs to be, how do I 
configure the database parameters?  I'm sorry if this is an obvious 
question, but for the life of me I cannot find the answer.

Thanks,
jl