nagios-db-devel Mailing List for Nagios-DB (Page 2)
Status: Beta
Brought to you by:
bench23
Menu
▾
▴
nagios-db-devel — An easy way for Nagios-DB developers to contact each other.
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(62) |
Feb
(9) |
Mar
(27) |
Apr
(9) |
May
(17) |
Jun
|
Jul
(7) |
Aug
(11) |
Sep
(5) |
Oct
|
Nov
(7) |
Dec
|
| 2006 |
Jan
|
Feb
(2) |
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2007 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Ben <be...@si...> - 2005-08-10 14:21:18
|
Thanks Peter. Next time I get a chance to work on nagios-db I'll apply the patch. On Aug 10, 2005, at 4:21 AM, Peter Bieringer wrote: > Hi, > > looks like noone uses nagios-db with current b4...source doesn't > work no more (also not on b3). Digging into the source and > comparing with the example module I found the reason, the neb > registration was changed. > > Patch is attached, works now. > > Peter > -- > Dr. Peter Bieringer http://www.bieringer.de/pb/ > GPG/PGP Key 0x958F422D mailto: pb at bieringer dot de > Deep Space 6 Co-Founder and Core Member http://www.deepspace6.net/ > <inserter.c-fix-nebregistration.diff> |
|
From: Peter B. <pb...@bi...> - 2005-08-10 11:22:22
|
Hi, looks like noone uses nagios-db with current b4...source doesn't work no more (also not on b3). Digging into the source and comparing with the example module I found the reason, the neb registration was changed. Patch is attached, works now. Peter -- Dr. Peter Bieringer http://www.bieringer.de/pb/ GPG/PGP Key 0x958F422D mailto: pb at bieringer dot de Deep Space 6 Co-Founder and Core Member http://www.deepspace6.net/ |
|
From: Peter B. <pb...@bi...> - 2005-08-04 11:17:43
|
Hi,
during working on bringing this NEB to work I found two bugs in the offset
calculation:
@@ -149,7 +149,7 @@
free(db);
return 0;
}
- if(!(val = pullValue(tok+8)))
+ if(!(val = pullValue(tok+9)))
{
/* well, this isn't going to fly. */
write_to_all_logs("nagios-db postgres inserter failed to
find valid wrapper vacation value in arguement string",NSLOG_INFO_MESSAGE);
@@ -169,7 +169,7 @@
free(db);
return 0;
}
- if(!(val = pullValue(tok+8)))
+ if(!(val = pullValue(tok+7)))
{
/* well, this isn't going to fly. */
write_to_all_logs("nagios-db postgres inserter failed to
find valid wrapper write limit in arguement string",NSLOG_INFO_MESSAGE);
This will solve:
[1123119267] nagios-db postgres inserter failed to find valid wrapper write
limit in arguement string
[1123119267] Event broker module '/usr/local/nagios/neb/inserter.o'
initialized successfully.
On:
host=localhost db=nagios timeout=10 vacation=0 writes=0 user=nagios
password=secret
BTW: is there no description what the values vacation and writes are mean?
BTW2: order of options are fixed, too, this can be sure improved in the
future.
Peter
--
Dr. Peter Bieringer http://www.bieringer.de/pb/
GPG/PGP Key 0x958F422D mailto: pb at bieringer dot de
Deep Space 6 Co-Founder and Core Member http://www.deepspace6.net/
|
|
From: Kevin M. <km...@te...> - 2005-07-23 00:10:51
|
We currently have state stalking on so we get alert info for every check regardless of it changing. Is there any way to get this into the database? or is there a method to get it in there already that im just missing? =20 Thanks in advanced |
|
From: Kevin M. <km...@te...> - 2005-07-12 00:41:14
|
I grabbed the most recent CVS before the current one and this worked fine. Thanks -----Original Message----- From: Ben [mailto:be...@si...]=20 Sent: Monday, July 11, 2005 6:38 PM To: Kevin Mau Cc: nag...@li... Subject: Re: [Nagios-db-devel] Segfault Ah, yes, this problem. I knew there were some good fixes in CVS that weren't in a released version. I recall that Ethan "recently" made a checkin to nagios which fixed the compile warnings you're seeing. I don't honestly remember what else it fixed. Do you have a recent version of Nagios? Do you have a recent cvs version of nagios?=20 On Mon, 11 Jul 2005, Kevin Mau wrote: > Im currently using a redhat ES 4 box with Nagios 2.0 beta 3 with > Nagios-db-0.91 > =20 > I have nagios up and running perfectly. > Ive unpacked and modified the make file and inserter.c with the=20 > correct information Everything compiles without error Ive put the=20 > inserter.o into /usr/local/nagios/neb and modified the nagios.cfg to=20 > point to this this. > When I start up nagios it segfaults and in the nagios log I have the=20 > following > =20 > [1121118074] Nagios 2.0b3 starting... (PID=3D1825) [1121118074] LOG=20 > VERSION: 2.0 [1121118074] initializing nagios-db postgres inserter... > [1121118074] nagios-db: inserter locked into db [1121118074] Event=20 > broker module '/usr/local/nagios/neb/inserter.o' > initialized successfully. > [1121118074] nagios-db: couldn't clear config info () [1121118074]=20 > nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host usi' > () > [1121118074] nagios-db: configured 1 hosts [1121118074] nagios-db:=20 > couldn't configure hostgroup using 'nagios-db: > couldn't configure hostgroup using 'nagios-db: couldn't configure=20 > hostgroup using 'nagios-db: couldn't configure ho' () [1121118074]=20 > Caught SIGSEGV, shutting down... > =20 > =20 > Ive tried the current version from CVS and during the compile i=20 > receieve > =20 > =20 > In file included from pgwrapper.c:7: > /install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE" > redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from pgwrapper.c:5: > /usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the=20 > location of the previous definition In file included from=20 > pgwrapper.c:7: > /install/nagios-2.0b3/include/../include/common.h:311:1: warning: > "FALSE" redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from pgwrapper.c:5: > /usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the=20 > location of the previous definition In file included from=20 > /install/nagios-2.0b3/include/../include/objects.h:31, > from > /install/nagios-2.0b3/include/../include/nebstructs.h:30, > from inserter.c:11: > /install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE" > redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from inserter.c:6: > /usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the=20 > location of the previous definition In file included from=20 > /install/nagios-2.0b3/include/../include/objects.h:31, > from > /install/nagios-2.0b3/include/../include/nebstructs.h:30, > from inserter.c:11: > /install/nagios-2.0b3/include/../include/common.h:311:1: warning: > "FALSE" redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from inserter.c:6: > /usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the=20 > location of the previous definition >=20 > It looks like it compiles fine however this causes nagios to SegFault=20 > right away > =20 > Any support for either of these versions would be greatly appreciated. > =20 >=20 |
|
From: Lindsay W. <li...@ul...> - 2005-07-11 23:47:42
|
I'm not sure about the seg fault but I certainly got the same error message when I had not altered inerter.c to use the correct host, port number and DB username. After doing that and recompiling it started to work. Search for 'connect' or 'Connect' in inserter.c. I couldn't find a way to add a password (I'm sure it's possible, just need to better understand PQConnect?) so I just set up a passwordless DB account. The above instructions are for the 0.9.1 release. CVS does things completely differently and I believe you provide arguments in the nagios.cfg when calling the inserter.o to authenticate to the DB, though I've not had time to test that out yet. Hope that helps. Lindsay Kevin Mau wrote: > Im currently using a redhat ES 4 box with Nagios 2.0 beta 3 with > Nagios-db-0.91 > > I have nagios up and running perfectly. > Ive unpacked and modified the make file and inserter.c with the correct > information > Everything compiles without error > Ive put the inserter.o into /usr/local/nagios/neb and modified the > nagios.cfg to point to this this. > When I start up nagios it segfaults and in the nagios log I have the > following > > [1121118074] Nagios 2.0b3 starting... (PID=1825) > [1121118074] LOG VERSION: 2.0 > [1121118074] initializing nagios-db postgres inserter... > [1121118074] nagios-db: inserter locked into db > [1121118074] Event broker module '/usr/local/nagios/neb/inserter.o' > initialized successfully. > [1121118074] nagios-db: couldn't clear config info () > [1121118074] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host usi' () > [1121118074] nagios-db: configured 1 hosts > [1121118074] nagios-db: couldn't configure hostgroup using 'nagios-db: > couldn't configure hostgroup using 'nagios-db: couldn't configure > hostgroup using 'nagios-db: couldn't configure ho' () > [1121118074] Caught SIGSEGV, shutting down... > > > Ive tried the current version from CVS and during the compile i receieve > > > In file included from pgwrapper.c:7: > /install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE" > redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from pgwrapper.c:5: > /usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the > location of the previous definition > In file included from pgwrapper.c:7: > /install/nagios-2.0b3/include/../include/common.h:311:1: warning: > "FALSE" redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from pgwrapper.c:5: > /usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the > location of the previous definition > In file included from /install/nagios-2.0b3/include/../include/objects.h:31, > from > /install/nagios-2.0b3/include/../include/nebstructs.h:30, > from inserter.c:11: > /install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE" > redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from inserter.c:6: > /usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the > location of the previous definition > In file included from /install/nagios-2.0b3/include/../include/objects.h:31, > from > /install/nagios-2.0b3/include/../include/nebstructs.h:30, > from inserter.c:11: > /install/nagios-2.0b3/include/../include/common.h:311:1: warning: > "FALSE" redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from inserter.c:6: > /usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the > location of the previous definition > It looks like it compiles fine however this causes nagios to SegFault > right away > > Any support for either of these versions would be greatly appreciated. > |
|
From: Ben <be...@si...> - 2005-07-11 23:37:58
|
Ah, yes, this problem. I knew there were some good fixes in CVS that weren't in a released version. I recall that Ethan "recently" made a checkin to nagios which fixed the compile warnings you're seeing. I don't honestly remember what else it fixed. Do you have a recent version of Nagios? Do you have a recent cvs version of nagios? On Mon, 11 Jul 2005, Kevin Mau wrote: > Im currently using a redhat ES 4 box with Nagios 2.0 beta 3 with > Nagios-db-0.91 > > I have nagios up and running perfectly. > Ive unpacked and modified the make file and inserter.c with the correct > information > Everything compiles without error > Ive put the inserter.o into /usr/local/nagios/neb and modified the > nagios.cfg to point to this this. > When I start up nagios it segfaults and in the nagios log I have the > following > > [1121118074] Nagios 2.0b3 starting... (PID=1825) > [1121118074] LOG VERSION: 2.0 > [1121118074] initializing nagios-db postgres inserter... > [1121118074] nagios-db: inserter locked into db > [1121118074] Event broker module '/usr/local/nagios/neb/inserter.o' > initialized successfully. > [1121118074] nagios-db: couldn't clear config info () > [1121118074] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host usi' > () > [1121118074] nagios-db: configured 1 hosts > [1121118074] nagios-db: couldn't configure hostgroup using 'nagios-db: > couldn't configure hostgroup using 'nagios-db: couldn't configure > hostgroup using 'nagios-db: couldn't configure ho' () > [1121118074] Caught SIGSEGV, shutting down... > > > Ive tried the current version from CVS and during the compile i receieve > > > In file included from pgwrapper.c:7: > /install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE" > redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from pgwrapper.c:5: > /usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the > location of the previous definition > In file included from pgwrapper.c:7: > /install/nagios-2.0b3/include/../include/common.h:311:1: warning: > "FALSE" redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from pgwrapper.c:5: > /usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the > location of the previous definition > In file included from > /install/nagios-2.0b3/include/../include/objects.h:31, > from > /install/nagios-2.0b3/include/../include/nebstructs.h:30, > from inserter.c:11: > /install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE" > redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from inserter.c:6: > /usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the > location of the previous definition > In file included from > /install/nagios-2.0b3/include/../include/objects.h:31, > from > /install/nagios-2.0b3/include/../include/nebstructs.h:30, > from inserter.c:11: > /install/nagios-2.0b3/include/../include/common.h:311:1: warning: > "FALSE" redefined > In file included from /usr/lib/glib-2.0/include/glibconfig.h:9, > from /usr/include/glib-2.0/glib/gtypes.h:30, > from /usr/include/glib-2.0/glib/galloca.h:30, > from /usr/include/glib-2.0/glib.h:30, > from pgwrapper.h:4, > from inserter.c:6: > /usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the > location of the previous definition > > It looks like it compiles fine however this causes nagios to SegFault > right away > > Any support for either of these versions would be greatly appreciated. > > |
|
From: Kevin M. <km...@te...> - 2005-07-11 21:35:42
|
Im currently using a redhat ES 4 box with Nagios 2.0 beta 3 with
Nagios-db-0.91
=20
I have nagios up and running perfectly.
Ive unpacked and modified the make file and inserter.c with the correct
information
Everything compiles without error
Ive put the inserter.o into /usr/local/nagios/neb and modified the
nagios.cfg to point to this this.
When I start up nagios it segfaults and in the nagios log I have the
following
=20
[1121118074] Nagios 2.0b3 starting... (PID=3D1825)
[1121118074] LOG VERSION: 2.0
[1121118074] initializing nagios-db postgres inserter...
[1121118074] nagios-db: inserter locked into db
[1121118074] Event broker module '/usr/local/nagios/neb/inserter.o'
initialized successfully.
[1121118074] nagios-db: couldn't clear config info ()
[1121118074] nagios-db: couldn't configure host using 'nagios-db:
couldn't configure host using 'nagios-db: couldn't configure host usi'
()
[1121118074] nagios-db: configured 1 hosts
[1121118074] nagios-db: couldn't configure hostgroup using 'nagios-db:
couldn't configure hostgroup using 'nagios-db: couldn't configure
hostgroup using 'nagios-db: couldn't configure ho' ()
[1121118074] Caught SIGSEGV, shutting down...
=20
=20
Ive tried the current version from CVS and during the compile i receieve
=20
=20
In file included from pgwrapper.c:7:
/install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE"
redefined
In file included from /usr/lib/glib-2.0/include/glibconfig.h:9,
from /usr/include/glib-2.0/glib/gtypes.h:30,
from /usr/include/glib-2.0/glib/galloca.h:30,
from /usr/include/glib-2.0/glib.h:30,
from pgwrapper.h:4,
from pgwrapper.c:5:
/usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the
location of the previous definition
In file included from pgwrapper.c:7:
/install/nagios-2.0b3/include/../include/common.h:311:1: warning:
"FALSE" redefined
In file included from /usr/lib/glib-2.0/include/glibconfig.h:9,
from /usr/include/glib-2.0/glib/gtypes.h:30,
from /usr/include/glib-2.0/glib/galloca.h:30,
from /usr/include/glib-2.0/glib.h:30,
from pgwrapper.h:4,
from pgwrapper.c:5:
/usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the
location of the previous definition
In file included from
/install/nagios-2.0b3/include/../include/objects.h:31,
from
/install/nagios-2.0b3/include/../include/nebstructs.h:30,
from inserter.c:11:
/install/nagios-2.0b3/include/../include/common.h:310:1: warning: "TRUE"
redefined
In file included from /usr/lib/glib-2.0/include/glibconfig.h:9,
from /usr/include/glib-2.0/glib/gtypes.h:30,
from /usr/include/glib-2.0/glib/galloca.h:30,
from /usr/include/glib-2.0/glib.h:30,
from pgwrapper.h:4,
from inserter.c:6:
/usr/include/glib-2.0/glib/gmacros.h:147:1: warning: this is the
location of the previous definition
In file included from
/install/nagios-2.0b3/include/../include/objects.h:31,
from
/install/nagios-2.0b3/include/../include/nebstructs.h:30,
from inserter.c:11:
/install/nagios-2.0b3/include/../include/common.h:311:1: warning:
"FALSE" redefined
In file included from /usr/lib/glib-2.0/include/glibconfig.h:9,
from /usr/include/glib-2.0/glib/gtypes.h:30,
from /usr/include/glib-2.0/glib/galloca.h:30,
from /usr/include/glib-2.0/glib.h:30,
from pgwrapper.h:4,
from inserter.c:6:
/usr/include/glib-2.0/glib/gmacros.h:143:1: warning: this is the
location of the previous definition
It looks like it compiles fine however this causes nagios to SegFault
right away
=20
Any support for either of these versions would be greatly appreciated.
=20
|
|
From: Ben <be...@si...> - 2005-07-08 01:16:42
|
Hey Lindsay, nice to hear somebody else finds it useful. It was intentional to not remove things if they've been removed from the nagios configuration. While they are marked as removed, in my environment I need to keep track of machine's uptime history even if it no longer exists. So I wrote nagios-db to support that. :) Look at the configured field for more info. On Mon, 4 Jul 2005, Lindsay Whitbread wrote: > Hi, > > Over the weekend I installed and configured Nagios-DB to log to a Mysql > database. > > The tool itself is fantastic and the provided UI looks like a useful > code base to start building a fully featured reporting console. > > The only problem I've noticed so far is that some Nagios entities such > as hostgroups and servicegroups are not removed from the database > following their removal from the Nagios configuration. > > I have not had a close enough look at the code and database to know > whether these groups have been flagged as disabled in the DB and that > the UI can then be changed to deal with the situation in sane manner or not. > > Could somebody please give me an idea of whether this is a known issue > or whether there is some perfectly good reason why nagios-db behaves in > such a way. > > Cheers, > Lindsay > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click > _______________________________________________ > Nagios-db-devel mailing list > Nag...@li... > https://lists.sourceforge.net/lists/listinfo/nagios-db-devel > |
|
From: Lindsay W. <li...@ul...> - 2005-07-04 04:09:05
|
Hi, Over the weekend I installed and configured Nagios-DB to log to a Mysql database. The tool itself is fantastic and the provided UI looks like a useful code base to start building a fully featured reporting console. The only problem I've noticed so far is that some Nagios entities such as hostgroups and servicegroups are not removed from the database following their removal from the Nagios configuration. I have not had a close enough look at the code and database to know whether these groups have been flagged as disabled in the DB and that the UI can then be changed to deal with the situation in sane manner or not. Could somebody please give me an idea of whether this is a known issue or whether there is some perfectly good reason why nagios-db behaves in such a way. Cheers, Lindsay |
|
From: Ben <be...@si...> - 2005-05-24 07:08:42
|
Yes, hardcoded strings are a pain and yes, they have been fixed in CVS. As for a timely release of 0.92.... does the fact that I'm doing work-related emails past midnight give you a clue when that might happen? :) On May 23, 2005, at 8:27 PM, mi...@vi... wrote: > Hi All, > > I've had a bit of a play with nagios-db 0.91 but having the parameters > such as database name, database host, database port etc hardcoded > precludes me using it in our customers' environments. > > Does the latest CVS version allow you to pass arguments to the NEB > in the > nagios.cfg file? > > Also... erm any timeline for release of nagios-db 0.92? > > Cheers > Alex > > > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click > _______________________________________________ > Nagios-db-devel mailing list > Nag...@li... > https://lists.sourceforge.net/lists/listinfo/nagios-db-devel > |
|
From: Andreas E. <ae...@op...> - 2005-05-24 05:52:51
|
mi...@vi... wrote: > Hi All, > > I've had a bit of a play with nagios-db 0.91 but having the parameters > such as database name, database host, database port etc hardcoded > precludes me using it in our customers' environments. > > Does the latest CVS version allow you to pass arguments to the NEB in the > nagios.cfg file? > Yes. Each module can be given exactly one argument (that is, a string of chars) when loaded with the broker_module config option. Clever modules should use it to designate their own configuration file. -- Andreas Ericsson and...@op... OP5 AB www.op5.se Lead Developer |
|
From: <mi...@vi...> - 2005-05-24 03:27:33
|
Hi All, I've had a bit of a play with nagios-db 0.91 but having the parameters such as database name, database host, database port etc hardcoded precludes me using it in our customers' environments. Does the latest CVS version allow you to pass arguments to the NEB in the nagios.cfg file? Also... erm any timeline for release of nagios-db 0.92? Cheers Alex |
|
From: Michael H. <mic...@ax...> - 2005-05-13 00:40:16
|
Sorry Ben I no-longer have access to the system otherwise I'd include the log here. I believe the first error was the module calling a stored procedure to clear the configuration: 135 res =3D PQexec(pgconn,"select empty_config()"); which resulted in this message being printed: 138 snprintf(q,sizeof(q),"nagios-db: couldn't clear config info (%s)", PQresultErrorMessage(res)); with an empty string from PQresultErrorMessage(). From there the log just filled with error messages until Nagios shut itself down. Thanks, Michael > -----Original Message----- > From: Ben [mailto:be...@si...]=20 > Sent: Thursday, 12 May 2005 4:38 AM > To: Michael Henry > Cc: nag...@li... > Subject: RE: [Nagios-db-devel] Error loading module >=20 > Sorry to hear you couldn't get the postgres one to work. You=20 > wouldn't by chance remember the error you were getting? >=20 > On Tue, 10 May 2005, Michael Henry wrote: >=20 > >=20 > > I was eventually able to compile a module which loaded into=20 > Nagios and=20 > > initialised correctly, but it complained that it wasn't=20 > able to clear=20 > > the configuration. Try as I might, I just couldn't get it to work. > >=20 > > I downloaded and installed MySQL and tried the MySQL NEB module. > > I had to add zlib to the list of libraries during compilation but=20 > > after that it worked with no problems. > >=20 > > Thanks to Ben and Thibault for your help, and to Matthew Kent for=20 > > writing the MySQL module. > >=20 > > Michael > >=20 > >=20 > >=20 > > > -----Original Message----- > > > From: Ben [mailto:be...@si...] > > > Sent: Saturday, 7 May 2005 1:15 AM > > > To: Michael Henry > > > Cc: nag...@li... > > > Subject: Re: [Nagios-db-devel] Error loading module > > >=20 > > > I do want to make a new release. However, I was hoping I=20 > could get=20 > > > some documentation into it...... unfortunately I've just been too=20 > > > busy to write it. > > >=20 > > > On May 5, 2005, at 4:57 PM, Michael Henry wrote: > > >=20 > > > > I modified the makefile with the correct locations of=20 > the postgres=20 > > > > libraries and Nagios headers for my system: > > > > > > > > all: > > > > gcc -Wall -g -O2 -o inserter.o inserter.c=20 > -shared -I/usr/=20 > > > > local/src/nagios-2.0b3/include -I/usr/local/pgsql/include=20 > > > > /usr/lib/ libpq.a > > > > > > > > and did "make all". In hindsight the pgsql include=20 > directory did=20 > > > > nothing as that directory doesn't exist but the postgres > > > header is in > > > > /usr/include (rpm install of postgres) so it all worked=20 > out in the=20 > > > > end. I copied the resulting inserter.o to my nagios=20 > installation. > > > > > > > > I am using the tarball from sourceforge; I'm not a > > > developer and don't > > > > have CVS set up. > > > > > > > > Is there any chance that you could do a new release?=20 > Being able to=20 > > > > configure the module would be a really nice feature to=20 > have... :) > > > > > > > > Also if you could add a paragraph to README about how to > > > add the NEB > > > > module to nagios (ie use a "broker_module" directive in > > > > nagios.cfg) this would be appreciated. As with all things > > > it's obvious > > > > in hindsight but I did spend some time yesterday wondering > > > WTF I was > > > > supposed to do with inserter.o. > > > > > > > > Thanks! > > > > > > > > Michael > > > > > > > > > > > > > > > > From: Ben [mailto:be...@si...] > > > > Sent: Fri 6/05/2005 9:37 AM > > > > To: Michael Henry > > > > Cc: nag...@li... > > > > Subject: Re: [Nagios-db-devel] Error loading module > > > > > > > > How did you compile the module? Somebody else had a similar > > > issue, but > > > > they had ommited some libraries. > > > > > > > > If you pull from CVS, you can set the connection params in > > > your nagios > > > > config file. If you pull the most recent tarball (0.91 I > > > believe) then > > > > you have to modify inserter.c to change your connection=20 > settings. > > > > > > > > On Thu, 5 May 2005, Michael Henry wrote: > > > > > > > > > Hi, > > > > > > > > > > I get the following error in my nagios.log when I=20 > configure > > > > Nagios to use the provided postgres module: > > > > > > > > > > [1115279003] Error: Could not load module=20 > > > > > '/usr/local/nagios/neb/ > > > > inserter.o' -> /usr/local/nagios/neb/inserter.o:=20 > undefined symbol: =20 > > > > BIO_new_mem_buf > > > > > > > > > > Also: How do I configure the module to connect to my dat >=20 >=20 >=20 |
|
From: Ben <be...@si...> - 2005-05-11 18:37:54
|
Sorry to hear you couldn't get the postgres one to work. You wouldn't by chance remember the error you were getting? On Tue, 10 May 2005, Michael Henry wrote: > > I was eventually able to compile a module which loaded into Nagios and > initialised correctly, but it complained that it wasn't able to clear > the configuration. Try as I might, I just couldn't get it to work. > > I downloaded and installed MySQL and tried the MySQL NEB module. > I had to add zlib to the list of libraries during compilation but after > that it worked with no problems. > > Thanks to Ben and Thibault for your help, and to Matthew Kent for > writing > the MySQL module. > > Michael > > > > > -----Original Message----- > > From: Ben [mailto:be...@si...] > > Sent: Saturday, 7 May 2005 1:15 AM > > To: Michael Henry > > Cc: nag...@li... > > Subject: Re: [Nagios-db-devel] Error loading module > > > > I do want to make a new release. However, I was hoping I > > could get some documentation into it...... unfortunately I've > > just been too busy to write it. > > > > On May 5, 2005, at 4:57 PM, Michael Henry wrote: > > > > > I modified the makefile with the correct locations of the postgres > > > libraries and Nagios headers for my system: > > > > > > all: > > > gcc -Wall -g -O2 -o inserter.o inserter.c -shared -I/usr/ > > > local/src/nagios-2.0b3/include -I/usr/local/pgsql/include /usr/lib/ > > > libpq.a > > > > > > and did "make all". In hindsight the pgsql include directory did > > > nothing as that directory doesn't exist but the postgres > > header is in > > > /usr/include (rpm install of postgres) so it all worked out in the > > > end. I copied the resulting inserter.o to my nagios installation. > > > > > > I am using the tarball from sourceforge; I'm not a > > developer and don't > > > have CVS set up. > > > > > > Is there any chance that you could do a new release? Being able to > > > configure the module would be a really nice feature to have... :) > > > > > > Also if you could add a paragraph to README about how to > > add the NEB > > > module to nagios (ie use a "broker_module" directive in > > > nagios.cfg) this would be appreciated. As with all things > > it's obvious > > > in hindsight but I did spend some time yesterday wondering > > WTF I was > > > supposed to do with inserter.o. > > > > > > Thanks! > > > > > > Michael > > > > > > > > > > > > From: Ben [mailto:be...@si...] > > > Sent: Fri 6/05/2005 9:37 AM > > > To: Michael Henry > > > Cc: nag...@li... > > > Subject: Re: [Nagios-db-devel] Error loading module > > > > > > How did you compile the module? Somebody else had a similar > > issue, but > > > they had ommited some libraries. > > > > > > If you pull from CVS, you can set the connection params in > > your nagios > > > config file. If you pull the most recent tarball (0.91 I > > believe) then > > > you have to modify inserter.c to change your connection settings. > > > > > > On Thu, 5 May 2005, Michael Henry wrote: > > > > > > > Hi, > > > > > > > > I get the following error in my nagios.log when I configure > > > Nagios to use the provided postgres module: > > > > > > > > [1115279003] Error: Could not load module '/usr/local/nagios/neb/ > > > inserter.o' -> /usr/local/nagios/neb/inserter.o: undefined symbol: > > > BIO_new_mem_buf > > > > > > > > Also: How do I configure the module to connect to my dat |
|
From: Michael H. <mic...@ax...> - 2005-05-10 01:25:03
|
I was eventually able to compile a module which loaded into Nagios and initialised correctly, but it complained that it wasn't able to clear the configuration. Try as I might, I just couldn't get it to work. I downloaded and installed MySQL and tried the MySQL NEB module. I had to add zlib to the list of libraries during compilation but after that it worked with no problems. Thanks to Ben and Thibault for your help, and to Matthew Kent for writing the MySQL module. Michael > -----Original Message----- > From: Ben [mailto:be...@si...]=20 > Sent: Saturday, 7 May 2005 1:15 AM > To: Michael Henry > Cc: nag...@li... > Subject: Re: [Nagios-db-devel] Error loading module >=20 > I do want to make a new release. However, I was hoping I=20 > could get some documentation into it...... unfortunately I've=20 > just been too busy to write it. >=20 > On May 5, 2005, at 4:57 PM, Michael Henry wrote: >=20 > > I modified the makefile with the correct locations of the postgres=20 > > libraries and Nagios headers for my system: > > > > all: > > gcc -Wall -g -O2 -o inserter.o inserter.c -shared -I/usr/=20 > > local/src/nagios-2.0b3/include -I/usr/local/pgsql/include /usr/lib/=20 > > libpq.a > > > > and did "make all". In hindsight the pgsql include directory did=20 > > nothing as that directory doesn't exist but the postgres=20 > header is in=20 > > /usr/include (rpm install of postgres) so it all worked out in the=20 > > end. I copied the resulting inserter.o to my nagios installation. > > > > I am using the tarball from sourceforge; I'm not a=20 > developer and don't=20 > > have CVS set up. > > > > Is there any chance that you could do a new release? Being able to=20 > > configure the module would be a really nice feature to have... :) > > > > Also if you could add a paragraph to README about how to=20 > add the NEB=20 > > module to nagios (ie use a "broker_module" directive in > > nagios.cfg) this would be appreciated. As with all things=20 > it's obvious=20 > > in hindsight but I did spend some time yesterday wondering=20 > WTF I was=20 > > supposed to do with inserter.o. > > > > Thanks! > > > > Michael > > > > > > > > From: Ben [mailto:be...@si...] > > Sent: Fri 6/05/2005 9:37 AM > > To: Michael Henry > > Cc: nag...@li... > > Subject: Re: [Nagios-db-devel] Error loading module > > > > How did you compile the module? Somebody else had a similar=20 > issue, but=20 > > they had ommited some libraries. > > > > If you pull from CVS, you can set the connection params in=20 > your nagios=20 > > config file. If you pull the most recent tarball (0.91 I=20 > believe) then=20 > > you have to modify inserter.c to change your connection settings. > > > > On Thu, 5 May 2005, Michael Henry wrote: > > > > > Hi, > > > > > > I get the following error in my nagios.log when I configure > > Nagios to use the provided postgres module: > > > > > > [1115279003] Error: Could not load module '/usr/local/nagios/neb/ > > inserter.o' -> /usr/local/nagios/neb/inserter.o: undefined symbol: =20 > > BIO_new_mem_buf > > > > > > Also: How do I configure the module to connect to my database? Is > > it hard-coded in the source? > > > > > > Thanks, > > > > > > Michael > > > > > > > > > > > > > > > > > > >=20 >=20 |
|
From: Ben <be...@si...> - 2005-05-06 15:14:50
|
I do want to make a new release. However, I was hoping I could get some documentation into it...... unfortunately I've just been too busy to write it. On May 5, 2005, at 4:57 PM, Michael Henry wrote: > I modified the makefile with the correct locations of the postgres > libraries and Nagios headers for my system: > > all: > gcc -Wall -g -O2 -o inserter.o inserter.c -shared -I/usr/ > local/src/nagios-2.0b3/include -I/usr/local/pgsql/include /usr/lib/ > libpq.a > > and did "make all". In hindsight the pgsql include directory did > nothing as that directory doesn't exist but the postgres header is > in /usr/include (rpm install of postgres) so it all worked out in > the end. I copied the resulting inserter.o to my nagios installation. > > I am using the tarball from sourceforge; I'm not a developer and > don't have CVS set up. > > Is there any chance that you could do a new release? Being able to > configure the module would be a really nice feature to have... :) > > Also if you could add a paragraph to README about how to add the > NEB module to nagios (ie use a "broker_module" directive in > nagios.cfg) this would be appreciated. As with all things it's > obvious in hindsight but I did spend some time yesterday wondering > WTF I was supposed to do with inserter.o. > > Thanks! > > Michael > > > > From: Ben [mailto:be...@si...] > Sent: Fri 6/05/2005 9:37 AM > To: Michael Henry > Cc: nag...@li... > Subject: Re: [Nagios-db-devel] Error loading module > > How did you compile the module? Somebody else had a similar issue, but > they had ommited some libraries. > > If you pull from CVS, you can set the connection params in your nagios > config file. If you pull the most recent tarball (0.91 I believe) > then you > have to modify inserter.c to change your connection settings. > > On Thu, 5 May 2005, Michael Henry wrote: > > > Hi, > > > > I get the following error in my nagios.log when I configure > Nagios to use the provided postgres module: > > > > [1115279003] Error: Could not load module '/usr/local/nagios/neb/ > inserter.o' -> /usr/local/nagios/neb/inserter.o: undefined symbol: > BIO_new_mem_buf > > > > Also: How do I configure the module to connect to my database? Is > it hard-coded in the source? > > > > Thanks, > > > > Michael > > > > > > > > > > > |
|
From: Thibault G. <thi...@sr...> - 2005-05-06 15:01:52
|
You need to tweak the makefile provided with inserter.c to add the libs = that contain BIO_new_mem_buf and some other functions. Those libs are = commented out, below the active lines: "-lssl -lkrb5 -lcrypt". Of course = you need the corresponding libs installed. And yes the connection string is hardcoded, at the line 78. Just put = your server and DB name here ________________________________________ De=A0: Michael Henry [mailto:mic...@ax...]=20 Envoy=E9=A0: jeudi 5 mai 2005 10:02 =C0=A0: nag...@li... Objet=A0: [Nagios-db-devel] Error loading module Hi, =A0 =A0=A0=A0 I get the following error in my nagios.log when I configure = Nagios to use the provided postgres module: =A0 [1115279003] Error: Could not load module = '/usr/local/nagios/neb/inserter.o' -> /usr/local/nagios/neb/inserter.o: = undefined symbol: BIO_new_mem_buf Also: How do I configure the module to connect to my database? Is it = hard-coded in the source? =A0 Thanks, =A0 =A0=A0=A0 Michael =A0 =A0 =A0 |
|
From: Ben <be...@si...> - 2005-05-06 00:01:33
|
How did you compile the module? Somebody else had a similar issue, but they had ommited some libraries. If you pull from CVS, you can set the connection params in your nagios config file. If you pull the most recent tarball (0.91 I believe) then you have to modify inserter.c to change your connection settings. On Thu, 5 May 2005, Michael Henry wrote: > Hi, > > I get the following error in my nagios.log when I configure Nagios to use the provided postgres module: > > [1115279003] Error: Could not load module '/usr/local/nagios/neb/inserter.o' -> /usr/local/nagios/neb/inserter.o: undefined symbol: BIO_new_mem_buf > > Also: How do I configure the module to connect to my database? Is it hard-coded in the source? > > Thanks, > > Michael > > > > |
|
From: Michael H. <mic...@ax...> - 2005-05-05 23:52:08
|
I modified the makefile with the correct locations of the postgres =
libraries and Nagios headers for my system:
=20
all:
gcc -Wall -g -O2 -o inserter.o inserter.c -shared =
-I/usr/local/src/nagios-2.0b3/include -I/usr/local/pgsql/include =
/usr/lib/libpq.a
=20
and did "make all". In hindsight the pgsql include directory did nothing =
as that directory doesn't exist but the postgres header is in =
/usr/include (rpm install of postgres) so it all worked out in the end. =
I copied the resulting inserter.o to my nagios installation.
=20
I am using the tarball from sourceforge; I'm not a developer and don't =
have CVS set up.
=20
Is there any chance that you could do a new release? Being able to =
configure the module would be a really nice feature to have... :)
=20
Also if you could add a paragraph to README about how to add the NEB =
module to nagios (ie use a "broker_module" directive in nagios.cfg) this =
would be appreciated. As with all things it's obvious in hindsight but I =
did spend some time yesterday wondering WTF I was supposed to do with =
inserter.o.
=20
Thanks!
=20
Michael
=20
=20
________________________________
From: Ben [mailto:be...@si...]
Sent: Fri 6/05/2005 9:37 AM
To: Michael Henry
Cc: nag...@li...
Subject: Re: [Nagios-db-devel] Error loading module
How did you compile the module? Somebody else had a similar issue, but
they had ommited some libraries.
If you pull from CVS, you can set the connection params in your nagios
config file. If you pull the most recent tarball (0.91 I believe) then =
you
have to modify inserter.c to change your connection settings.
On Thu, 5 May 2005, Michael Henry wrote:
> Hi,
>=20
> I get the following error in my nagios.log when I configure Nagios =
to use the provided postgres module:
>=20
> [1115279003] Error: Could not load module =
'/usr/local/nagios/neb/inserter.o' -> /usr/local/nagios/neb/inserter.o: =
undefined symbol: BIO_new_mem_buf
>
> Also: How do I configure the module to connect to my database? Is it =
hard-coded in the source?
>=20
> Thanks,
>=20
> Michael
>=20
>=20
>=20
>
|
|
From: Michael H. <mic...@ax...> - 2005-05-05 07:56:27
|
Hi,
=20
I get the following error in my nagios.log when I configure Nagios =
to use the provided postgres module:
=20
[1115279003] Error: Could not load module =
'/usr/local/nagios/neb/inserter.o' -> /usr/local/nagios/neb/inserter.o: =
undefined symbol: BIO_new_mem_buf
Also: How do I configure the module to connect to my database? Is it =
hard-coded in the source?
=20
Thanks,
=20
Michael
=20
=20
=20
|
|
From: Thibault G. <thi...@sr...> - 2005-05-04 15:16:32
|
First of all, the update_views has no problem. It just doesn't contain = the data I wanted. Now with the 'bug'=20 De=A0: Ben [mailto:be...@si...]=20 Envoy=E9=A0: mercredi 4 mai 2005 17:03 >Oh, so you're saying that the plugin output may not update correctly?=20 >That's certainly possible.... I seem to recall thinking this should=20 >work, but not having enough time to give it more than a cursory test,=20 >and perhaps my test wasn't good enough. >Let me know what you find.... The function update_service(), around line 211, contains code that = updates the content of the history for a service. There is the following = block: IF (state_is_the_same_as_before) IF (it_is_an_error_state) Update the history END IF (*) ELSE Update the history And Insert a row with the new state END IF Now what happens if some test is still in the same, non-error state as = for the previous check ? It does nothing ! So I have hacked my script by adding an update on the PluginOuput member = where I put an asterisk (*) above, and it works. Now the host_detail = view contains the right, Nagios synchronized values. More values than the single PluginOuput might also need to be updated at = this point, but I don't know Nagios-DB enough as of now to tell. On May 4, 2005, at 5:04 AM, Thibault GENESSAY wrote: > After a deeper analysis, it appears that not all the information is=20 > outdated, only some subset of it. Logging the updates in the NEB=20 > module, I see that nagios-DB is notified when something changes, but=20 > the history is not updated correctly. See: > > File: /database/postgres/SPs/service.sql > Function: update_service() > Line 211: > update service_history set current_attempt =3D CurrentAttempt,=20 > plugin_output =3D PluginOutput where serviceid =3D thisServiceID and=20 > lasted is null; > > It seems that either this line does not update the PluginOuput=20 > correctly or it gets the outdated value. > I'm investigating this (unless I've missed something) and keep you=20 > guys in touch > > ________________________________________ > De=A0: Thibault GENESSAY > Envoy=E9=A0: mercredi 4 mai 2005 11:06 > =C0=A0: nag...@li... > Objet=A0: [Nagios-db-devel] Postgres Views not updated > > Hello > > I've been using nagios-db for a few days only so please apologize if=20 > it's a dummy question, but I'm going crazy with it. > 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=20 > use the update_views.sql script as stated in the doc. The php=20 > interface reflects the information in the service_history table and=20 > host_details view, which is completely outdated. On the other hand,=20 > the service_check table contains the correct, latest information that=20 > nagios' CGIs show. > Any clues ? > > Regards > > Thibault > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: NEC IT Guy Games. > Get your fingers limbered up and give it your best shot. 4 great=20 > events, 4 > opportunities to win big! Highest score wins.NEC IT Guy Games. Play to > win an NEC 61 plasma display. Visit http://www.necitguy.com/?r > _______________________________________________ > Nagios-db-devel mailing list > Nag...@li... > https://lists.sourceforge.net/lists/listinfo/nagios-db-devel |
|
From: Ben <be...@si...> - 2005-05-04 15:03:21
|
Oh, so you're saying that the plugin output may not update correctly?=20 That's certainly possible.... I seem to recall thinking this should=20 work, but not having enough time to give it more than a cursory test,=20 and perhaps my test wasn't good enough. Let me know what you find.... On May 4, 2005, at 5:04 AM, Thibault GENESSAY wrote: > After a deeper analysis, it appears that not all the information is=20 > outdated, only some subset of it. Logging the updates in the NEB=20 > module, I see that nagios-DB is notified when something changes, but=20= > the history is not updated correctly. See: > > File: /database/postgres/SPs/service.sql > Function: update_service() > Line 211: > update service_history set current_attempt =3D CurrentAttempt,=20= > plugin_output =3D PluginOutput where serviceid =3D thisServiceID and=20= > lasted is null; > > It seems that either this line does not update the PluginOuput=20 > correctly or it gets the outdated value. > I'm investigating this (unless I've missed something) and keep you=20 > guys in touch > > ________________________________________ > De=A0: Thibault GENESSAY > Envoy=E9=A0: mercredi 4 mai 2005 11:06 > =C0=A0: nag...@li... > Objet=A0: [Nagios-db-devel] Postgres Views not updated > > Hello > > I've been using nagios-db for a few days only so please apologize if=20= > it's a dummy question, but I'm going crazy with it. > 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=20= > use the update_views.sql script as stated in the doc. The php=20 > interface reflects the information in the service_history table and=20 > host_details view, which is completely outdated. On the other hand,=20 > the service_check table contains the correct, latest information that=20= > nagios' CGIs show. > Any clues ? > > Regards > > Thibault > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: NEC IT Guy Games. > Get your fingers limbered up and give it your best shot. 4 great=20 > events, 4 > opportunities to win big! Highest score wins.NEC IT Guy Games. Play to > win an NEC 61 plasma display. Visit http://www.necitguy.com/?r > _______________________________________________ > Nagios-db-devel mailing list > Nag...@li... > https://lists.sourceforge.net/lists/listinfo/nagios-db-devel |
|
From: Ben <be...@si...> - 2005-05-04 14:54:43
|
Are you saying that the contents of the views do not change if you run=20= update_views.sql? If that's the case, then there is certainly something=20= wrong. Perhaps you might try looking in your postgres log file. On May 4, 2005, at 2:05 AM, Thibault GENESSAY wrote: > > Hello > =A0 > I=92ve been using nagios-db for a few days only so please apologize if=20= > it=92s a dummy question, but I=92m going crazy with it. > 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=20= > use the update_views.sql script as stated in the doc. The php=20 > interface reflects the information in the service_history table and=20 > host_details view, which is completely outdated. On the other hand,=20 > the service_check table contains the correct, latest information that=20= > nagios=92 CGIs show. > Any clues ? > =A0 > Regards > =A0 > Thibault |
|
From: Thibault G. <thi...@sr...> - 2005-05-04 12:05:05
|
After a deeper analysis, it appears that not all the information is = outdated, only some subset of it. Logging the updates in the NEB module, = I see that nagios-DB is notified when something changes, but the history = is not updated correctly. See: File: /database/postgres/SPs/service.sql Function: update_service() Line 211: update service_history set current_attempt =3D CurrentAttempt, = plugin_output =3D PluginOutput where serviceid =3D thisServiceID and = lasted is null; It seems that either this line does not update the PluginOuput correctly = or it gets the outdated value. I'm investigating this (unless I've missed something) and keep you guys = in touch ________________________________________ De=A0: Thibault GENESSAY=20 Envoy=E9=A0: mercredi 4 mai 2005 11:06 =C0=A0: nag...@li... Objet=A0: [Nagios-db-devel] Postgres Views not updated Hello 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 ? Regards Thibault |
