Thread: [Nagios-db-devel] Upgrade and rollback issues
Status: Beta
Brought to you by:
bench23
Menu
▾
▴
nagios-db-devel
|
From: Robert B. <rbi...@cy...> - 2005-03-11 00:45:40
|
I had nagios 2.0b1 working with nagios-db on RHEL3. I decided to upgrade to 2.0b2 and pulled the latest nagios-db code from cvs. Everything compiled fine, dropped the db and recreated the db with the new schema, but nagios would not start with the neb module. So then I pulled the 0.91 archive, same problem. After deciding to roll back to 2.0b1 and the nagios-db cvs snapshot that I had working previously, I am still throwing the same errors. If I run the "select empty_config()" from a psql session I am returned an empty recordset, which is what I would expect. The following is from the nagios log. Does anyone have any thoughts, I really need to get this back online. Thanks, Bob [1110500709] Nagios 2.0b1 starting... (PID=5391) [1110500709] LOG VERSION: 2.0 [1110500709] initializing nagios-db postgres inserter... [1110500709] nagios-db: inserter locked into db [1110500709] Event broker module '/usr/local/nagios/bin/inserter.o' initialized successfully. [1110500709] Warning: Host 'kcwebwt1' has no services associated with it! [1110500709] Warning: Contact 'brian' is not a member of any contact groups! [1110500709] Warning: Contact 'cheikh' is not a member of any contact groups! [1110500709] Warning: Contact 'dwain' is not a member of any contact groups! [1110500709] Warning: Contact 'eric' is not a member of any contact groups! [1110500709] Warning: Contact 'john' is not a member of any contact groups! [1110500709] Warning: Contact 'karen' is not a member of any contact groups! [1110500709] Warning: Contact 'liz' is not a member of any contact groups! [1110500709] Warning: Contact 'robert' is not a member of any contact groups! [1110500709] Warning: Contact 'russ' is not a member of any contact groups! [1110500709] Warning: Contact 'scott' is not a member of any contact groups! [1110500709] Warning: Contact 'van' is not a member of any contact groups! [1110500709] Warning: Contact group 'nagios-setup' is not used in any hostgroup/service definitions or host/hostgroup/service escala tions! [1110500709] Finished daemonizing... (New PID=5393) [1110500709] nagios-db: couldn't clear config info () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure ho' ( ) [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host ' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host ' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host usi' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host usi' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host u' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host u' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host usi' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nag' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nag' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'na' () [1110500709] nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using' () [1110500709] nagios-db: configured 23 hosts [1110500709] nagios-db: couldn't configure hostgroup using 'nagios-db: couldn't configure hostgroup using 'nagios' () [1110500709] Caught SIGSEGV, shutting down... |
|
From: Ben <be...@si...> - 2005-03-11 01:15:42
|
First (and most important to you) I don't see anything in the code that make it obvious why you would get the "couldn't clear config info" message unless the command failed, but then you should have had some reason, and I don't see that. So that's still a mystery. Therefore, I'm going to blame the victim and ask what version of the postgres libs you have installed, and ask that you make sure you're really linking to them. Second, I recommend you use 2.0b2. It fixed problems I was having and didn't hurt anything. Given that you have the same problems on both versions, you might as well have them on the better one. :) Third, I just checked in a file that should fix the unhelpful "nagios-db: couldn't configure host using 'nagios-db: couldn't configure host using 'nagios-db: couldn't configure host us' ()" crap. That won't help your big issue, but it might help others in the future.... On Thu, 10 Mar 2005, Robert Bilbrey wrote: > I had nagios 2.0b1 working with nagios-db on RHEL3. I decided to upgrade > to 2.0b2 and pulled the latest nagios-db code from cvs. Everything > compiled fine, dropped the db and recreated the db with the new schema, > but nagios would not start with the neb module. So then I pulled the > 0.91 archive, same problem. After deciding to roll back to 2.0b1 and the > nagios-db cvs snapshot that I had working previously, I am still > throwing the same errors. If I run the "select empty_config()" from a > psql session I am returned an empty recordset, which is what I would > expect. The following is from the nagios log. Does anyone have any > thoughts, I really need to get this back online. > Thanks, Bob > > [1110500709] Nagios 2.0b1 starting... (PID=5391) > [1110500709] LOG VERSION: 2.0 > [1110500709] initializing nagios-db postgres inserter... > [1110500709] nagios-db: inserter locked into db > [1110500709] Event broker module '/usr/local/nagios/bin/inserter.o' > initialized successfully. > [1110500709] Warning: Host 'kcwebwt1' has no services associated with it! > [1110500709] Warning: Contact 'brian' is not a member of any contact groups! > [1110500709] Warning: Contact 'cheikh' is not a member of any contact > groups! > [1110500709] Warning: Contact 'dwain' is not a member of any contact groups! > [1110500709] Warning: Contact 'eric' is not a member of any contact groups! > [1110500709] Warning: Contact 'john' is not a member of any contact groups! > [1110500709] Warning: Contact 'karen' is not a member of any contact groups! > [1110500709] Warning: Contact 'liz' is not a member of any contact groups! > [1110500709] Warning: Contact 'robert' is not a member of any contact > groups! > [1110500709] Warning: Contact 'russ' is not a member of any contact groups! > [1110500709] Warning: Contact 'scott' is not a member of any contact groups! > [1110500709] Warning: Contact 'van' is not a member of any contact groups! > [1110500709] Warning: Contact group 'nagios-setup' is not used in any > hostgroup/service definitions or host/hostgroup/service escala > tions! > [1110500709] Finished daemonizing... (New PID=5393) > [1110500709] nagios-db: couldn't clear config info () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure ho' ( > ) > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > ' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host' > () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > ' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > usi' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > usi' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > u' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > u' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > us' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > usi' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > using 'nag' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > using 'nag' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > using 'na' () > [1110500709] nagios-db: couldn't configure host using 'nagios-db: > couldn't configure host using 'nagios-db: couldn't configure host > using' () > [1110500709] nagios-db: configured 23 hosts > [1110500709] nagios-db: couldn't configure hostgroup using 'nagios-db: > couldn't configure hostgroup using 'nagios' () > [1110500709] Caught SIGSEGV, shutting down... > > > ------------------------------------------------------- > 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 > |
|
From: Robert B. <rbi...@na...> - 2005-03-11 04:58:07
|
Hi Ben, upgraded Nagios back up to 2.0b2 and pulled the latest nagios-db
code from cvs. Still no joy (:
What would you suggest I do next ?
Thanks, Bob
postgresql version:
nagios=# select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-42)
my makefile:
gcc -Wall -g -O2 -o inserter.o inserter.c -shared
-I/usr/local/src/nagios-2.0b2/include -I/usr/local/pgsql/include
/usr/local/pgsql/lib/libpq.a
nagios.log with latest nagios-db cvs pull:
[1110516022] Nagios 2.0b2 starting... (PID=8772)
[1110516022] LOG VERSION: 2.0
[1110516022] initializing nagios-db postgres inserter...
[1110516022] nagios-db: inserter locked into db
[1110516022] Event broker module '/usr/local/nagios/bin/inserter.o'
initialized successfully.
[1110516022] Warning: Host 'kcwebwt1' has no services associated with it!
[1110516022] Warning: Contact 'brian' is not a member of any contact groups!
[1110516022] Warning: Contact 'cheikh' is not a member of any contact
groups!
[1110516022] Warning: Contact 'dwain' is not a member of any contact groups!
[1110516022] Warning: Contact 'eric' is not a member of any contact groups!
[1110516022] Warning: Contact 'john' is not a member of any contact groups!
[1110516022] Warning: Contact 'karen' is not a member of any contact groups!
[1110516022] Warning: Contact 'liz' is not a member of any contact groups!
[1110516022] Warning: Contact 'robert' is not a member of any contact
groups!
[1110516022] Warning: Contact 'russ' is not a member of any contact groups!
[1110516022] Warning: Contact 'scott' is not a member of any contact groups!
[1110516022] Warning: Contact 'van' is not a member of any contact groups!
[1110516022] Warning: Contact group 'nagios-setup' is not used in any
hostgroup/service definitions or host/hostgroup/se
rvice escalations!
[1110516022] Finished daemonizing... (New PID=8774)
[1110516022] nagios-db: couldn't clear config info ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('OPX',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('clappwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('clbackw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('clsqlwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('clwebwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('intranet',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcacct',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcads',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,
TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcadw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcmailfw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
RUE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcmailw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcparadox',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
RUE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcsecl1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRU
E,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcsqldb',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRU
E,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcsqlwd1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcsqlwp2',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcwebwd1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('kcwebwt1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
UE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('pdoxtimer',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
RUE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('sunflower-chi-gw',TRUE,TRUE,TRUE,TRUE,TRUE
,TRUE,TRUE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('sunflower-nor-gw',TRUE,TRUE,TRUE,TRUE,TRUE
,TRUE,TRUE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('sunflower-op-gw',TRUE,TRUE,TRUE,TRUE,TRUE,
TRUE,TRUE,TRUE,FALSE)' ()
[1110516022] nagios-db: couldn't configure host using 'select
configure_host('sunflowerKC',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
,TRUE,TRUE,FALSE)' ()
[1110516022] nagios-db: configured 23 hosts
[1110516022] nagios-db: couldn't configure hostgroup using 'select
new_hostgroup('sunshine-colo','Sunshine Colo')' ()
Ben wrote:
> First (and most important to you) I don't see anything in the code that
> make it obvious why you would get the "couldn't clear config info" message
> unless the command failed, but then you should have had some reason, and I
> don't see that. So that's still a mystery. Therefore, I'm going to blame
> the victim and ask what version of the postgres libs you have installed,
> and ask that you make sure you're really linking to them.
>
> Second, I recommend you use 2.0b2. It fixed problems I was having and
> didn't hurt anything. Given that you have the same problems on both
> versions, you might as well have them on the better one. :)
>
> Third, I just checked in a file that should fix the unhelpful "nagios-db:
> couldn't configure host using 'nagios-db: couldn't configure host using
> 'nagios-db: couldn't configure host us' ()" crap. That won't help your big
> issue, but it might help others in the future....
>
>
> On Thu, 10 Mar 2005, Robert Bilbrey wrote:
>
>
>>I had nagios 2.0b1 working with nagios-db on RHEL3. I decided to upgrade
>>to 2.0b2 and pulled the latest nagios-db code from cvs. Everything
>>compiled fine, dropped the db and recreated the db with the new schema,
>>but nagios would not start with the neb module. So then I pulled the
>>0.91 archive, same problem. After deciding to roll back to 2.0b1 and the
>>nagios-db cvs snapshot that I had working previously, I am still
>>throwing the same errors. If I run the "select empty_config()" from a
>>psql session I am returned an empty recordset, which is what I would
>>expect. The following is from the nagios log. Does anyone have any
>>thoughts, I really need to get this back online.
>>Thanks, Bob
>>
>>[1110500709] Nagios 2.0b1 starting... (PID=5391)
>>[1110500709] LOG VERSION: 2.0
>>[1110500709] initializing nagios-db postgres inserter...
>>[1110500709] nagios-db: inserter locked into db
>>[1110500709] Event broker module '/usr/local/nagios/bin/inserter.o'
>>initialized successfully.
>>[1110500709] Warning: Host 'kcwebwt1' has no services associated with it!
>>[1110500709] Warning: Contact 'brian' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'cheikh' is not a member of any contact
>>groups!
>>[1110500709] Warning: Contact 'dwain' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'eric' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'john' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'karen' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'liz' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'robert' is not a member of any contact
>>groups!
>>[1110500709] Warning: Contact 'russ' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'scott' is not a member of any contact groups!
>>[1110500709] Warning: Contact 'van' is not a member of any contact groups!
>>[1110500709] Warning: Contact group 'nagios-setup' is not used in any
>>hostgroup/service definitions or host/hostgroup/service escala
>>tions!
>>[1110500709] Finished daemonizing... (New PID=5393)
>>[1110500709] nagios-db: couldn't clear config info ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure ho' (
>>)
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host'
>> ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>usi' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>usi' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>u' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>u' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>us' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>usi' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>using 'nag' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>using 'nag' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>using 'na' ()
>>[1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>couldn't configure host using 'nagios-db: couldn't configure host
>>using' ()
>>[1110500709] nagios-db: configured 23 hosts
>>[1110500709] nagios-db: couldn't configure hostgroup using 'nagios-db:
>>couldn't configure hostgroup using 'nagios' ()
>>[1110500709] Caught SIGSEGV, shutting down...
>>
>>
>>-------------------------------------------------------
>>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
>>
>
>
>
>
>
> -------------------------------------------------------
> 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
>
|
|
From: Ben <be...@si...> - 2005-03-11 06:33:16
Attachments:
inserter.c
|
Ok, so it turns out I apparently can't read documentation. I bet the problem is that you aren't successfully connecting to your database. Have you checked your permissions? Or, better yet, your postgres logs? I'm not in a place where I can try this out, so give it a shot. If it passes the compile test, then I'll check it in. If we're lucky, it might even tell you what's wrong. :) |
|
From: Robert B. <rbi...@na...> - 2005-03-11 06:51:37
|
That was it, don't know how it ever worked in the first place. I should
be able to take it from here. Thanks for the help. This is the relevant
nagios.log entry:
[1110523507] Nagios 2.0b2 starting... (PID=9223)
[1110523507] LOG VERSION: 2.0
[1110523507] initializing nagios-db postgres inserter...
[1110523507] nagios-db: inserter failed to establish postgres connection
(fe_sendauth: no password supplied
)
[1110523507] Event broker module '/usr/local/nagios/bin/inserter.o'
initialized successfully.
Ben wrote:
> Ok, so it turns out I apparently can't read documentation. I bet the
> problem is that you aren't successfully connecting to your database.
> Have you checked your permissions? Or, better yet, your postgres logs?
>
> I'm not in a place where I can try this out, so give it a shot. If it
> passes the compile test, then I'll check it in. If we're lucky, it might
> even tell you what's wrong. :)
>
>
> ------------------------------------------------------------------------
>
> #ifndef NSCORE
> #define NSCORE
> #endif
>
> /* we need this for postgres support */
> #include "libpq-fe.h"
>
> /* include the needed event broker header files */
> #include "../include/nebmodules.h"
> #include "../include/nebcallbacks.h"
> #include "../include/nebstructs.h"
> #include "../include/broker.h"
>
> /* include some Nagios stuff as well */
> #include "../include/config.h"
> #include "../include/common.h"
> #include "../include/nagios.h"
> #include "../include/objects.h"
>
> #include <sys/types.h>
> #include <string.h>
> #include <stdlib.h>
>
> #define UNIX_PATH_MAX 108
>
> /* specify event broker API version (required) */
> NEB_API_VERSION(CURRENT_NEB_API_VERSION);
>
> #define BUFFER_ALLOC_SIZE 1024
> #define NULL_STRING(x) (x?:"null")
> #define BOOLIFY_STRING(x) (x?"TRUE":"FALSE")
>
> #define FIRST_COMMAND_NUM NEBCALLBACK_PROCESS_DATA
>
> char * querify(char * src);
>
>
> extern hostgroup *hostgroup_list;
> extern servicegroup *servicegroup_list;
> extern host *host_list;
> extern service *service_list;
>
> extern int enable_flap_detection;
> extern int enable_notifications;
> extern int enable_event_handlers;
> extern int execute_service_checks;
> extern int execute_host_checks;
> extern int accept_passive_service_checks;
> extern int accept_passive_host_checks;
>
> static int processStart(int, void *);
> static int processStatus(int, void *);
> static int processCheck(int, void *);
>
>
> PGconn * pgconn = 0;
>
> /* this function gets called when the module is loaded by the event broker */
> int nebmodule_init(int flags, char *args, nebmodule *handle)
> {
> write_to_all_logs("initializing nagios-db postgres inserter...",NSLOG_INFO_MESSAGE);
>
> if(!(pgconn = PQconnectdb("host=meatshake port=5432 dbname=nag user=postgres")))
> {
> /* couldn't connect; this will be useless. */
> write_to_all_logs("nagios-db: inserter failed to allocate postgres connection",NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(CONNECTION_OK != PQstatus(pgconn))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: inserter failed to establish postgres connection (%s)",PQerrorMessage(pgconn));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> write_to_all_logs("nagios-db: inserter locked into db",NSLOG_INFO_MESSAGE);
> }
>
>
> neb_register_callback(NEBCALLBACK_TIMED_EVENT_DATA, 0, processStart);
>
> return 0;
> }
>
>
> /* this function gets called when the module is unoaded by the event broker */
> int nebmodule_deinit(int flags, int reason)
> {
> /* log a message to the Nagios log file */
>
> write_to_all_logs("nagios-db: inserter unloading...",NSLOG_INFO_MESSAGE);
>
> PQfinish(pgconn);
>
> neb_deregister_callback(NEBCALLBACK_HOST_STATUS_DATA, processStatus);
> neb_deregister_callback(NEBCALLBACK_SERVICE_STATUS_DATA, processStatus);
> neb_deregister_callback(NEBCALLBACK_HOST_CHECK_DATA, processCheck);
> neb_deregister_callback(NEBCALLBACK_SERVICE_CHECK_DATA, processCheck);
>
> pgconn = 0;
>
> return 0;
> }
>
> /* helper function to make a string ready for inclusion into a sql query */
> char *
> querify(char * src)
> {
> char * ret = 0;
> if(src)
> {
> int size = 2*strlen(src) + 3; /* +3 because we want to surround strings with single quotes, and we still need a null */
> int written = 0;
> if(!(ret = malloc(size)))
> {
> return 0;
> }
> ret[0] = '\'';
> written = PQescapeString(ret+1, src, strlen(src));
> ret[written + 1] = '\'';
> ret[written + 2] = 0;
> }
>
> return ret;
> }
>
> /* when Nagios starts up, we'll want to replicate configuration data into the database */
> static int processStart(int cmd, void * data)
> {
> host *hl = 0;
> service *sl = 0;
> hostgroup *hg = 0;
> PGresult *res = 0;
> int groupcount = 0;
> char q[2048];
>
> /* verify that we're dealing with the right kind of message. */
> if(cmd != NEBCALLBACK_TIMED_EVENT_DATA) return 0;
>
> /* verify that our config data has been initialized. */
> if(((nebstruct_timed_event_data*)data)->type != NEBTYPE_TIMEDEVENT_ADD) return 0;
>
> /* Clear out the previous config info.... */
> res = PQexec(pgconn,"select empty_config()");
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't clear config info (%s)", PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> PQclear(res);
>
> /* .... and insert new config info. Start with the hosts. */
> for(groupcount=0, hl = host_list; hl; hl = hl->next)
> {
> /* update this host */
> char *hostName = querify(hl->name);
>
> snprintf(q,sizeof(q),"select configure_host(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
> NULL_STRING(hostName),
> BOOLIFY_STRING(hl->checks_enabled),
> BOOLIFY_STRING(hl->accept_passive_host_checks),
> BOOLIFY_STRING(hl->event_handler_enabled),
> BOOLIFY_STRING(hl->flap_detection_enabled),
> BOOLIFY_STRING(hl->notifications_enabled),
> BOOLIFY_STRING(hl->failure_prediction_enabled),
> BOOLIFY_STRING(hl->process_performance_data),
> BOOLIFY_STRING(hl->obsess_over_host),
> BOOLIFY_STRING(hl->should_be_scheduled));
> if(hostName) free(hostName);
>
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't configure host using '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> PQclear(res);
>
> groupcount++;
> }
>
> snprintf(q,sizeof(q),"nagios-db: configured %d hosts", groupcount);
> write_to_all_logs(q,NSLOG_INFO_MESSAGE);
>
> /* add hostgroup membership */
> for(groupcount=0, hg=hostgroup_list; hg ; hg = hg->next)
> {
> hostgroupmember *hgm = 0;
> char *groupName, *groupAlias, *hostName;
> unsigned long groupid = 0;
>
> /* insert this hostgroup */
> groupName = querify(hg->group_name);
> groupAlias = querify(hg->alias);
> snprintf(q,sizeof(q),"select new_hostgroup(%s,%s)", NULL_STRING(groupName), NULL_STRING(groupAlias));
> if(groupName) free(groupName);
> if(groupAlias) free(groupAlias);
>
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't configure hostgroup using '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> groupid = atol(PQgetvalue(res,0,0));
> PQclear(res);
>
> for(hgm = hg->members; hgm; hgm = hgm->next)
> {
> /* add this host to the hostgroup */
> hostName = querify(hgm->host_name);
> snprintf(q,sizeof(q),"select append_to_hostgroup(%lu,%s)", groupid, NULL_STRING(hostName));
> if(hostName) free(hostName);
>
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't configure hostgroup membership using '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> PQclear(res);
> }
>
> groupcount++;
> }
>
> snprintf(q,sizeof(q),"nagios-db: loaded %d hostgroups", groupcount);
> write_to_all_logs(q,NSLOG_INFO_MESSAGE);
>
> /* mark all the configured services as such */
> for(groupcount=0, sl = service_list; sl; sl = sl->next)
> {
> /* update this service */
> char *hostName = querify(sl->host_name);
> char *serviceDesc = querify(sl->description);
>
> snprintf(q,sizeof(q),"select configure_service(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
> NULL_STRING(hostName),
> NULL_STRING(serviceDesc),
> BOOLIFY_STRING(sl->checks_enabled),
> BOOLIFY_STRING(sl->accept_passive_service_checks),
> BOOLIFY_STRING(sl->event_handler_enabled),
> BOOLIFY_STRING(sl->flap_detection_enabled),
> BOOLIFY_STRING(sl->notifications_enabled),
> BOOLIFY_STRING(sl->failure_prediction_enabled),
> BOOLIFY_STRING(sl->process_performance_data),
> BOOLIFY_STRING(sl->obsess_over_service),
> BOOLIFY_STRING(sl->should_be_scheduled));
> if(hostName) free(hostName);
> if(serviceDesc) free(serviceDesc);
>
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't configure service using '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> PQclear(res);
>
> groupcount++;
> }
>
> snprintf(q,sizeof(q),"nagios-db: set configured flag on %d services", groupcount);
> write_to_all_logs(q,NSLOG_INFO_MESSAGE);
>
> /* also insert various config parameters that we might want */
> snprintf(q,sizeof(q),"select replace_config_param('accept_passive_host_checks',%d)",accept_passive_host_checks);
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", q, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
> PQclear(res);
>
> snprintf(q,sizeof(q),"select replace_config_param('execute_host_checks',%d)",execute_host_checks);
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", q, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
> PQclear(res);
>
> snprintf(q,sizeof(q),"select replace_config_param('accept_passive_service_checks',%d)",accept_passive_service_checks);
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", q, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
> PQclear(res);
>
> snprintf(q,sizeof(q),"select replace_config_param('execute_service_checks',%d)",execute_service_checks);
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", q, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
> PQclear(res);
>
> snprintf(q,sizeof(q),"select replace_config_param('enable_flap_detection',%d)",enable_flap_detection);
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", q, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
> PQclear(res);
>
> snprintf(q,sizeof(q),"select replace_config_param('enable_notifications',%d)",enable_notifications);
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", q, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
> PQclear(res);
>
> snprintf(q,sizeof(q),"select replace_config_param('enable_event_handlers',%d)",enable_event_handlers);
> res = PQexec(pgconn,q);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", q, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", q, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
> PQclear(res);
>
> write_to_all_logs("nagios-db: configuration complete. Registering for status notifications...",NSLOG_INFO_MESSAGE);
>
> neb_deregister_callback(NEBCALLBACK_TIMED_EVENT_DATA, processStart);
> neb_register_callback(NEBCALLBACK_HOST_STATUS_DATA, 0, processStatus);
> neb_register_callback(NEBCALLBACK_SERVICE_STATUS_DATA, 0, processStatus);
> neb_register_callback(NEBCALLBACK_HOST_CHECK_DATA, 0, processCheck);
> neb_register_callback(NEBCALLBACK_SERVICE_CHECK_DATA, 0, processCheck);
>
> return 0;
> }
>
>
>
> static int processCheck(int cmd, void * data)
> {
> PGresult *res;
> char temp_buffer[1024];
>
> bzero(temp_buffer, sizeof(temp_buffer));
>
> switch(cmd)
> {
> case NEBCALLBACK_HOST_CHECK_DATA:
> {
> nebstruct_host_check_data * host_check_data = (nebstruct_host_check_data *) data;
>
> if(host_check_data->type != NEBTYPE_HOSTCHECK_PROCESSED) return 0;
>
> char *safeName = querify(host_check_data->host_name);
>
> snprintf(temp_buffer, sizeof(temp_buffer), "select host_checked(%s)",NULL_STRING(safeName));
>
> if(safeName) free(safeName);
> }
> break;
>
> case NEBCALLBACK_SERVICE_CHECK_DATA:
> {
> nebstruct_service_check_data * service_check_data = (nebstruct_service_check_data *) data;
>
> if(service_check_data->type != NEBTYPE_SERVICECHECK_PROCESSED) return 0;
>
> char *safeName = querify(service_check_data->host_name);
> char *safeServiceDescription = querify(service_check_data->service_description);
>
> snprintf(temp_buffer, sizeof(temp_buffer), "select service_checked(%s,%s)", NULL_STRING(safeName), NULL_STRING(safeServiceDescription));
>
> if(safeName) free(safeName);
> if(safeServiceDescription) free(safeServiceDescription);
> }
> break;
>
> default:
> snprintf(temp_buffer,sizeof(temp_buffer),"nagios-db: processCheck ignoring unknown NEB command %i",cmd);
> write_to_all_logs(temp_buffer,NSLOG_INFO_MESSAGE);
> return 0;
> break;
> }
>
> res = PQexec(pgconn,temp_buffer);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", temp_buffer, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", temp_buffer, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
>
> PQclear(res);
>
> return 0;
> }
>
>
>
> static int processStatus(int cmd, void * data)
> {
> PGresult *res;
> char temp_buffer[5120];
> service *tmp_service;
> host *tmp_host;
>
> bzero(temp_buffer, sizeof(temp_buffer));
> switch(cmd)
> {
> case NEBCALLBACK_HOST_STATUS_DATA:
> {
> nebstruct_host_status_data * host_status_data = (nebstruct_host_status_data *) data;
> tmp_host = (host *) host_status_data->object_ptr;
> char *safeName = querify(tmp_host->name);
> char *safeEventHandler = querify(tmp_host->event_handler);
> char *safePluginOutput = querify(tmp_host->plugin_output);
> char *safeHostCheckCommand = querify(tmp_host->host_check_command);
> char *safePerfData = querify(tmp_host->perf_data);
>
>
> snprintf(temp_buffer, sizeof(temp_buffer), "select update_host(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%lu,%s,%s,%s,%d,%d,%s,%d,%s,%f,%f,%lu,%lu,%d,%lu,%lu,%s,%s,%d)",
> NULL_STRING(safeName),
> BOOLIFY_STRING(tmp_host->checks_enabled),
> BOOLIFY_STRING(tmp_host->accept_passive_host_checks),
> BOOLIFY_STRING(tmp_host->event_handler_enabled),
> BOOLIFY_STRING(tmp_host->flap_detection_enabled),
> BOOLIFY_STRING(tmp_host->notifications_enabled),
> BOOLIFY_STRING(tmp_host->failure_prediction_enabled),
> BOOLIFY_STRING(tmp_host->process_performance_data),
> BOOLIFY_STRING(tmp_host->obsess_over_host),
> NULL_STRING(safeEventHandler),
> tmp_host->modified_attributes,
> BOOLIFY_STRING(tmp_host->has_been_checked),
> BOOLIFY_STRING(tmp_host->should_be_scheduled),
> BOOLIFY_STRING(tmp_host->is_flapping),
> tmp_host->current_state,
> tmp_host->last_hard_state,
> NULL_STRING(safePluginOutput),
> tmp_host->current_attempt,
> NULL_STRING(safeHostCheckCommand),
> tmp_host->execution_time,
> tmp_host->latency,
> tmp_host->last_check,
> tmp_host->next_check,
> tmp_host->max_attempts,
> tmp_host->last_host_notification,
> tmp_host->next_host_notification,
> BOOLIFY_STRING(tmp_host->no_more_notifications),
> NULL_STRING(safePerfData),
> tmp_host->check_type);
>
> if(safeName) free(safeName);
> if(safeEventHandler) free(safeEventHandler);
> if(safePluginOutput) free(safePluginOutput);
> if(safeHostCheckCommand) free(safeHostCheckCommand);
> if(safePerfData) free(safePerfData);
> }
> break;
>
> case NEBCALLBACK_SERVICE_STATUS_DATA:
> {
> nebstruct_service_status_data * service_status_data = (nebstruct_service_status_data *) data;
> tmp_service = (service *) service_status_data->object_ptr;
>
> char *safeName = querify(tmp_service->host_name);
> char *safeServiceDescription = querify(tmp_service->description);
> char *safeEventHandler = querify(tmp_service->event_handler);
> char *safePluginOutput = querify(tmp_service->plugin_output);
> char *safeServiceCheckCommand = querify(tmp_service->service_check_command);
> char *safePerfData = querify(tmp_service->perf_data);
>
>
> snprintf(temp_buffer, sizeof(temp_buffer), "select update_service(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%lu,%s,%s,%s,%d,%d,%s,%d,%s,%f,%f,%lu,%lu,%d,%lu,%lu,%s,%s,%d)",
> NULL_STRING(safeName),
> NULL_STRING(safeServiceDescription),
> BOOLIFY_STRING(tmp_service->checks_enabled),
> BOOLIFY_STRING(tmp_service->accept_passive_service_checks),
> BOOLIFY_STRING(tmp_service->event_handler_enabled),
> BOOLIFY_STRING(tmp_service->flap_detection_enabled),
> BOOLIFY_STRING(tmp_service->notifications_enabled),
> BOOLIFY_STRING(tmp_service->failure_prediction_enabled),
> BOOLIFY_STRING(tmp_service->process_performance_data),
> BOOLIFY_STRING(tmp_service->obsess_over_service),
> NULL_STRING(safeEventHandler),
> tmp_service->modified_attributes,
> BOOLIFY_STRING(tmp_service->has_been_checked),
> BOOLIFY_STRING(tmp_service->should_be_scheduled),
> BOOLIFY_STRING(tmp_service->is_flapping),
> tmp_service->current_state,
> tmp_service->last_hard_state,
> NULL_STRING(safePluginOutput),
> tmp_service->current_attempt,
> NULL_STRING(safeServiceCheckCommand),
> tmp_service->execution_time,
> tmp_service->latency,
> tmp_service->last_check,
> tmp_service->next_check,
> tmp_service->max_attempts,
> tmp_service->last_notification,
> tmp_service->next_notification,
> BOOLIFY_STRING(tmp_service->no_more_notifications),
> NULL_STRING(safePerfData),
> tmp_service->check_type);
>
> if(safeName) free(safeName);
> if(safeServiceDescription) free(safeServiceDescription);
> if(safeEventHandler) free(safeEventHandler);
> if(safePluginOutput) free(safePluginOutput);
> if(safeServiceCheckCommand) free(safeServiceCheckCommand);
> if(safePerfData) free(safePerfData);
> }
> break;
>
> default:
> snprintf(temp_buffer,sizeof(temp_buffer),"nagios-db: processStatus ignoring unknown NEB command %i",cmd);
> write_to_all_logs(temp_buffer,NSLOG_INFO_MESSAGE);
> return 0;
> break;
> }
>
> res = PQexec(pgconn,temp_buffer);
> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res) == PGRES_TUPLES_OK))
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)", temp_buffer, PQresultErrorMessage(res));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> else
> {
> if(atoi(PQgetvalue(res,0,0)) < 0)
> {
> char str[2048];
> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back %s", temp_buffer, PQgetvalue(res,0,0));
> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
> }
> }
>
> PQclear(res);
>
> return 0;
> }
>
>
>
>
> ------------------------------------------------------------------------
>
>
>
> On Mar 10, 2005, at 8:57 PM, Robert Bilbrey wrote:
>
>> Hi Ben, upgraded Nagios back up to 2.0b2 and pulled the latest
>> nagios-db code from cvs. Still no joy (:
>> What would you suggest I do next ?
>> Thanks, Bob
>>
>>
>> postgresql version:
>> nagios=# select version();
>> version
>> -----------------------------------------------------------------------
>> -----------------------------------
>> PostgreSQL 7.4.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
>> 3.2.3 20030502 (Red Hat Linux 3.2.3-42)
>>
>> my makefile:
>> gcc -Wall -g -O2 -o inserter.o inserter.c -shared
>> -I/usr/local/src/nagios-2.0b2/include -I/usr/local/pgsql/include
>> /usr/local/pgsql/lib/libpq.a
>>
>> nagios.log with latest nagios-db cvs pull:
>>
>> [1110516022] Nagios 2.0b2 starting... (PID=8772)
>> [1110516022] LOG VERSION: 2.0
>> [1110516022] initializing nagios-db postgres inserter...
>> [1110516022] nagios-db: inserter locked into db
>> [1110516022] Event broker module '/usr/local/nagios/bin/inserter.o'
>> initialized successfully.
>> [1110516022] Warning: Host 'kcwebwt1' has no services associated with
>> it!
>> [1110516022] Warning: Contact 'brian' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'cheikh' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'dwain' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'eric' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'john' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'karen' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'liz' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'robert' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'russ' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'scott' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact 'van' is not a member of any contact
>> groups!
>> [1110516022] Warning: Contact group 'nagios-setup' is not used in any
>> hostgroup/service definitions or host/hostgroup/se
>> rvice escalations!
>> [1110516022] Finished daemonizing... (New PID=8774)
>> [1110516022] nagios-db: couldn't clear config info ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('OPX',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('clappwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('clbackw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('clsqlwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('clwebwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('intranet',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcacct',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
>> ,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcads',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,
>> TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcadw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
>> ,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcmailfw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
>> RUE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcmailw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcparadox',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
>> RUE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcsecl1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRU
>> E,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcsqldb',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRU
>> E,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcsqlwd1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcsqlwp2',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcwebwd1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('kcwebwt1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>> UE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('pdoxtimer',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
>> RUE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('sunflower-chi-gw',TRUE,TRUE,TRUE,TRUE,TRUE
>> ,TRUE,TRUE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('sunflower-nor-gw',TRUE,TRUE,TRUE,TRUE,TRUE
>> ,TRUE,TRUE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('sunflower-op-gw',TRUE,TRUE,TRUE,TRUE,TRUE,
>> TRUE,TRUE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: couldn't configure host using 'select
>> configure_host('sunflowerKC',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
>> ,TRUE,TRUE,FALSE)' ()
>> [1110516022] nagios-db: configured 23 hosts
>> [1110516022] nagios-db: couldn't configure hostgroup using 'select
>> new_hostgroup('sunshine-colo','Sunshine Colo')' ()
>>
>> Ben wrote:
>>
>>> First (and most important to you) I don't see anything in the code
>>> that make it obvious why you would get the "couldn't clear config
>>> info" message unless the command failed, but then you should have
>>> had some reason, and I don't see that. So that's still a mystery.
>>> Therefore, I'm going to blame the victim and ask what version of the
>>> postgres libs you have installed, and ask that you make sure you're
>>> really linking to them. Second, I recommend you use 2.0b2. It fixed
>>> problems I was having and didn't hurt anything. Given that you have
>>> the same problems on both versions, you might as well have them on
>>> the better one. :)
>>> Third, I just checked in a file that should fix the unhelpful
>>> "nagios-db: couldn't configure host using 'nagios-db: couldn't
>>> configure host using 'nagios-db: couldn't configure host us' ()"
>>> crap. That won't help your big
>>> issue, but it might help others in the future....
>>> On Thu, 10 Mar 2005, Robert Bilbrey wrote:
>>>
>>>> I had nagios 2.0b1 working with nagios-db on RHEL3. I decided to
>>>> upgrade to 2.0b2 and pulled the latest nagios-db code from cvs.
>>>> Everything compiled fine, dropped the db and recreated the db with
>>>> the new schema, but nagios would not start with the neb module. So
>>>> then I pulled the 0.91 archive, same problem. After deciding to
>>>> roll back to 2.0b1 and the nagios-db cvs snapshot that I had
>>>> working previously, I am still throwing the same errors. If I run
>>>> the "select empty_config()" from a psql session I am returned an
>>>> empty recordset, which is what I would expect. The following is
>>>> from the nagios log. Does anyone have any thoughts, I really need
>>>> to get this back online.
>>>> Thanks, Bob
>>>>
>>>> [1110500709] Nagios 2.0b1 starting... (PID=5391)
>>>> [1110500709] LOG VERSION: 2.0
>>>> [1110500709] initializing nagios-db postgres inserter...
>>>> [1110500709] nagios-db: inserter locked into db
>>>> [1110500709] Event broker module '/usr/local/nagios/bin/inserter.o'
>>>> initialized successfully.
>>>> [1110500709] Warning: Host 'kcwebwt1' has no services associated
>>>> with it!
>>>> [1110500709] Warning: Contact 'brian' is not a member of any
>>>> contact groups!
>>>> [1110500709] Warning: Contact 'cheikh' is not a member of any
>>>> contact groups!
>>>> [1110500709] Warning: Contact 'dwain' is not a member of any
>>>> contact groups!
>>>> [1110500709] Warning: Contact 'eric' is not a member of any contact
>>>> groups!
>>>> [1110500709] Warning: Contact 'john' is not a member of any contact
>>>> groups!
>>>> [1110500709] Warning: Contact 'karen' is not a member of any
>>>> contact groups!
>>>> [1110500709] Warning: Contact 'liz' is not a member of any contact
>>>> groups!
>>>> [1110500709] Warning: Contact 'robert' is not a member of any
>>>> contact groups!
>>>> [1110500709] Warning: Contact 'russ' is not a member of any contact
>>>> groups!
>>>> [1110500709] Warning: Contact 'scott' is not a member of any
>>>> contact groups!
>>>> [1110500709] Warning: Contact 'van' is not a member of any contact
>>>> groups!
>>>> [1110500709] Warning: Contact group 'nagios-setup' is not used in
>>>> any hostgroup/service definitions or host/hostgroup/service escala
>>>> tions!
>>>> [1110500709] Finished daemonizing... (New PID=5393)
>>>> [1110500709] nagios-db: couldn't clear config info ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure ho' (
>>>> )
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> ' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host'
>>>> ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> ' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> usi' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> usi' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> u' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> u' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> us' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> usi' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> using 'nag' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> using 'nag' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> using 'na' ()
>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>> using' ()
>>>> [1110500709] nagios-db: configured 23 hosts
>>>> [1110500709] nagios-db: couldn't configure hostgroup using
>>>> 'nagios-db: couldn't configure hostgroup using 'nagios' ()
>>>> [1110500709] Caught SIGSEGV, shutting down...
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> 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
>>>>
>>> -------------------------------------------------------
>>> 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
|
|
From: Ben <be...@si...> - 2005-03-11 06:54:15
|
Excellent, glad you find it useful.
On Mar 10, 2005, at 10:51 PM, Robert Bilbrey wrote:
> That was it, don't know how it ever worked in the first place. I
> should be able to take it from here. Thanks for the help. This is the
> relevant nagios.log entry:
> [1110523507] Nagios 2.0b2 starting... (PID=9223)
> [1110523507] LOG VERSION: 2.0
> [1110523507] initializing nagios-db postgres inserter...
> [1110523507] nagios-db: inserter failed to establish postgres
> connection (fe_sendauth: no password supplied
> )
> [1110523507] Event broker module '/usr/local/nagios/bin/inserter.o'
> initialized successfully.
>
> Ben wrote:
>> Ok, so it turns out I apparently can't read documentation. I bet the
>> problem is that you aren't successfully connecting to your database.
>> Have you checked your permissions? Or, better yet, your postgres
>> logs?
>> I'm not in a place where I can try this out, so give it a shot. If it
>> passes the compile test, then I'll check it in. If we're lucky, it
>> might even tell you what's wrong. :)
>> ----------------------------------------------------------------------
>> --
>> #ifndef NSCORE
>> #define NSCORE
>> #endif
>> /* we need this for postgres support */
>> #include "libpq-fe.h"
>> /* include the needed event broker header files */
>> #include "../include/nebmodules.h"
>> #include "../include/nebcallbacks.h"
>> #include "../include/nebstructs.h"
>> #include "../include/broker.h"
>> /* include some Nagios stuff as well */
>> #include "../include/config.h"
>> #include "../include/common.h"
>> #include "../include/nagios.h"
>> #include "../include/objects.h"
>> #include <sys/types.h>
>> #include <string.h>
>> #include <stdlib.h>
>> #define UNIX_PATH_MAX 108
>> /* specify event broker API version (required) */
>> NEB_API_VERSION(CURRENT_NEB_API_VERSION);
>> #define BUFFER_ALLOC_SIZE 1024
>> #define NULL_STRING(x) (x?:"null")
>> #define BOOLIFY_STRING(x) (x?"TRUE":"FALSE")
>> #define FIRST_COMMAND_NUM NEBCALLBACK_PROCESS_DATA
>> char * querify(char * src);
>> extern hostgroup *hostgroup_list;
>> extern servicegroup *servicegroup_list;
>> extern host *host_list;
>> extern service *service_list;
>> extern int enable_flap_detection;
>> extern int enable_notifications;
>> extern int enable_event_handlers;
>> extern int execute_service_checks;
>> extern int execute_host_checks;
>> extern int accept_passive_service_checks;
>> extern int accept_passive_host_checks;
>> static int processStart(int, void *);
>> static int processStatus(int, void *);
>> static int processCheck(int, void *);
>> PGconn * pgconn = 0;
>> /* this function gets called when the module is loaded by the event
>> broker */
>> int nebmodule_init(int flags, char *args, nebmodule *handle)
>> {
>> write_to_all_logs("initializing nagios-db postgres
>> inserter...",NSLOG_INFO_MESSAGE);
>> if(!(pgconn = PQconnectdb("host=meatshake port=5432 dbname=nag
>> user=postgres")))
>> {
>> /* couldn't connect; this will be useless. */
>> write_to_all_logs("nagios-db: inserter failed to allocate postgres
>> connection",NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(CONNECTION_OK != PQstatus(pgconn))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: inserter failed to establish
>> postgres connection (%s)",PQerrorMessage(pgconn));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> write_to_all_logs("nagios-db: inserter locked into
>> db",NSLOG_INFO_MESSAGE);
>> }
>> neb_register_callback(NEBCALLBACK_TIMED_EVENT_DATA, 0, processStart);
>> return 0;
>> }
>> /* this function gets called when the module is unoaded by the event
>> broker */
>> int nebmodule_deinit(int flags, int reason)
>> {
>> /* log a message to the Nagios log file */
>> write_to_all_logs("nagios-db: inserter
>> unloading...",NSLOG_INFO_MESSAGE);
>> PQfinish(pgconn);
>> neb_deregister_callback(NEBCALLBACK_HOST_STATUS_DATA, processStatus);
>> neb_deregister_callback(NEBCALLBACK_SERVICE_STATUS_DATA,
>> processStatus);
>> neb_deregister_callback(NEBCALLBACK_HOST_CHECK_DATA, processCheck);
>> neb_deregister_callback(NEBCALLBACK_SERVICE_CHECK_DATA,
>> processCheck);
>> pgconn = 0;
>> return 0;
>> }
>> /* helper function to make a string ready for inclusion into a sql
>> query */
>> char *
>> querify(char * src)
>> {
>> char * ret = 0;
>> if(src)
>> {
>> int size = 2*strlen(src) + 3; /* +3 because we want to surround
>> strings with single quotes, and we still need a null */
>> int written = 0;
>> if(!(ret = malloc(size)))
>> {
>> return 0;
>> }
>> ret[0] = '\'';
>> written = PQescapeString(ret+1, src, strlen(src));
>> ret[written + 1] = '\'';
>> ret[written + 2] = 0;
>> }
>> return ret;
>> }
>> /* when Nagios starts up, we'll want to replicate configuration data
>> into the database */
>> static int processStart(int cmd, void * data)
>> {
>> host *hl = 0;
>> service *sl = 0;
>> hostgroup *hg = 0;
>> PGresult *res = 0;
>> int groupcount = 0;
>> char q[2048];
>> /* verify that we're dealing with the right kind of message. */
>> if(cmd != NEBCALLBACK_TIMED_EVENT_DATA) return 0;
>> /* verify that our config data has been initialized. */
>> if(((nebstruct_timed_event_data*)data)->type !=
>> NEBTYPE_TIMEDEVENT_ADD) return 0;
>> /* Clear out the previous config info.... */
>> res = PQexec(pgconn,"select empty_config()");
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't clear config info
>> (%s)", PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> PQclear(res);
>> /* .... and insert new config info. Start with the hosts. */
>> for(groupcount=0, hl = host_list; hl; hl = hl->next)
>> {
>> /* update this host */
>> char *hostName = querify(hl->name);
>> snprintf(q,sizeof(q),"select
>> configure_host(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
>> NULL_STRING(hostName),
>> BOOLIFY_STRING(hl->checks_enabled),
>> BOOLIFY_STRING(hl->accept_passive_host_checks),
>> BOOLIFY_STRING(hl->event_handler_enabled),
>> BOOLIFY_STRING(hl->flap_detection_enabled),
>> BOOLIFY_STRING(hl->notifications_enabled),
>> BOOLIFY_STRING(hl->failure_prediction_enabled),
>> BOOLIFY_STRING(hl->process_performance_data),
>> BOOLIFY_STRING(hl->obsess_over_host),
>> BOOLIFY_STRING(hl->should_be_scheduled));
>> if(hostName) free(hostName);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't configure host using
>> '%s' (%s)", q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> PQclear(res);
>> groupcount++;
>> }
>> snprintf(q,sizeof(q),"nagios-db: configured %d hosts", groupcount);
>> write_to_all_logs(q,NSLOG_INFO_MESSAGE);
>> /* add hostgroup membership */
>> for(groupcount=0, hg=hostgroup_list; hg ; hg = hg->next)
>> {
>> hostgroupmember *hgm = 0;
>> char *groupName, *groupAlias, *hostName;
>> unsigned long groupid = 0;
>> /* insert this hostgroup */
>> groupName = querify(hg->group_name);
>> groupAlias = querify(hg->alias);
>> snprintf(q,sizeof(q),"select new_hostgroup(%s,%s)",
>> NULL_STRING(groupName), NULL_STRING(groupAlias));
>> if(groupName) free(groupName);
>> if(groupAlias) free(groupAlias);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't configure hostgroup
>> using '%s' (%s)", q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> groupid = atol(PQgetvalue(res,0,0));
>> PQclear(res);
>> for(hgm = hg->members; hgm; hgm = hgm->next)
>> {
>> /* add this host to the hostgroup */
>> hostName = querify(hgm->host_name);
>> snprintf(q,sizeof(q),"select append_to_hostgroup(%lu,%s)",
>> groupid, NULL_STRING(hostName));
>> if(hostName) free(hostName);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK ||
>> PQresultStatus(res) == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't configure hostgroup
>> membership using '%s' (%s)", q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> PQclear(res);
>> }
>> groupcount++;
>> }
>> snprintf(q,sizeof(q),"nagios-db: loaded %d hostgroups", groupcount);
>> write_to_all_logs(q,NSLOG_INFO_MESSAGE);
>> /* mark all the configured services as such */
>> for(groupcount=0, sl = service_list; sl; sl = sl->next)
>> {
>> /* update this service */
>> char *hostName = querify(sl->host_name);
>> char *serviceDesc = querify(sl->description);
>> snprintf(q,sizeof(q),"select
>> configure_service(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
>> NULL_STRING(hostName),
>> NULL_STRING(serviceDesc),
>> BOOLIFY_STRING(sl->checks_enabled),
>> BOOLIFY_STRING(sl->accept_passive_service_checks),
>> BOOLIFY_STRING(sl->event_handler_enabled),
>> BOOLIFY_STRING(sl->flap_detection_enabled),
>> BOOLIFY_STRING(sl->notifications_enabled),
>> BOOLIFY_STRING(sl->failure_prediction_enabled),
>> BOOLIFY_STRING(sl->process_performance_data),
>> BOOLIFY_STRING(sl->obsess_over_service),
>> BOOLIFY_STRING(sl->should_be_scheduled));
>> if(hostName) free(hostName);
>> if(serviceDesc) free(serviceDesc);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't configure service
>> using '%s' (%s)", q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> PQclear(res);
>>
>> groupcount++;
>> }
>> snprintf(q,sizeof(q),"nagios-db: set configured flag on %d
>> services", groupcount);
>> write_to_all_logs(q,NSLOG_INFO_MESSAGE);
>> /* also insert various config parameters that we might want */
>> snprintf(q,sizeof(q),"select
>> replace_config_param('accept_passive_host_checks',%d)",accept_passive_
>> host_checks);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", q, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> snprintf(q,sizeof(q),"select
>> replace_config_param('execute_host_checks',%d)",execute_host_checks);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", q, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> snprintf(q,sizeof(q),"select
>> replace_config_param('accept_passive_service_checks',%d)",accept_passi
>> ve_service_checks);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", q, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> snprintf(q,sizeof(q),"select
>> replace_config_param('execute_service_checks',%d)",execute_service_che
>> cks);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", q, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> snprintf(q,sizeof(q),"select
>> replace_config_param('enable_flap_detection',%d)",enable_flap_detectio
>> n);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", q, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> snprintf(q,sizeof(q),"select
>> replace_config_param('enable_notifications',%d)",enable_notifications)
>> ;
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", q, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> snprintf(q,sizeof(q),"select
>> replace_config_param('enable_event_handlers',%d)",enable_event_handler
>> s);
>> res = PQexec(pgconn,q);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> q, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", q, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> write_to_all_logs("nagios-db: configuration complete. Registering
>> for status notifications...",NSLOG_INFO_MESSAGE);
>> neb_deregister_callback(NEBCALLBACK_TIMED_EVENT_DATA, processStart);
>> neb_register_callback(NEBCALLBACK_HOST_STATUS_DATA, 0,
>> processStatus);
>> neb_register_callback(NEBCALLBACK_SERVICE_STATUS_DATA, 0,
>> processStatus);
>> neb_register_callback(NEBCALLBACK_HOST_CHECK_DATA, 0, processCheck);
>> neb_register_callback(NEBCALLBACK_SERVICE_CHECK_DATA, 0,
>> processCheck);
>> return 0;
>> }
>> static int processCheck(int cmd, void * data) {
>> PGresult *res;
>> char temp_buffer[1024];
>> bzero(temp_buffer, sizeof(temp_buffer));
>> switch(cmd) {
>> case NEBCALLBACK_HOST_CHECK_DATA:
>> {
>> nebstruct_host_check_data * host_check_data =
>> (nebstruct_host_check_data *) data;
>> if(host_check_data->type != NEBTYPE_HOSTCHECK_PROCESSED) return 0;
>> char *safeName = querify(host_check_data->host_name);
>> snprintf(temp_buffer, sizeof(temp_buffer), "select
>> host_checked(%s)",NULL_STRING(safeName));
>> if(safeName) free(safeName);
>> }
>> break;
>> case NEBCALLBACK_SERVICE_CHECK_DATA:
>> {
>> nebstruct_service_check_data * service_check_data =
>> (nebstruct_service_check_data *) data;
>> if(service_check_data->type != NEBTYPE_SERVICECHECK_PROCESSED)
>> return 0;
>> char *safeName = querify(service_check_data->host_name);
>> char *safeServiceDescription =
>> querify(service_check_data->service_description);
>> snprintf(temp_buffer, sizeof(temp_buffer), "select
>> service_checked(%s,%s)", NULL_STRING(safeName),
>> NULL_STRING(safeServiceDescription));
>> if(safeName) free(safeName);
>> if(safeServiceDescription) free(safeServiceDescription);
>> }
>> break;
>> default:
>> snprintf(temp_buffer,sizeof(temp_buffer),"nagios-db: processCheck
>> ignoring unknown NEB command %i",cmd);
>> write_to_all_logs(temp_buffer,NSLOG_INFO_MESSAGE);
>> return 0;
>> break;
>> }
>> res = PQexec(pgconn,temp_buffer);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> temp_buffer, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", temp_buffer, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> return 0;
>> }
>> static int processStatus(int cmd, void * data) {
>> PGresult *res;
>> char temp_buffer[5120];
>> service *tmp_service;
>> host *tmp_host;
>> bzero(temp_buffer, sizeof(temp_buffer));
>> switch(cmd) {
>> case NEBCALLBACK_HOST_STATUS_DATA:
>> {
>> nebstruct_host_status_data * host_status_data =
>> (nebstruct_host_status_data *) data;
>> tmp_host = (host *) host_status_data->object_ptr;
>> char *safeName = querify(tmp_host->name);
>> char *safeEventHandler = querify(tmp_host->event_handler);
>> char *safePluginOutput = querify(tmp_host->plugin_output);
>> char *safeHostCheckCommand = querify(tmp_host->host_check_command);
>> char *safePerfData = querify(tmp_host->perf_data);
>> snprintf(temp_buffer, sizeof(temp_buffer), "select
>> update_host(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%lu,%s,%s,%s,%d,%d,%s,%d,%s,
>> %f,%f,%lu,%lu,%d,%lu,%lu,%s,%s,%d)",
>> NULL_STRING(safeName),
>> BOOLIFY_STRING(tmp_host->checks_enabled),
>> BOOLIFY_STRING(tmp_host->accept_passive_host_checks),
>> BOOLIFY_STRING(tmp_host->event_handler_enabled),
>> BOOLIFY_STRING(tmp_host->flap_detection_enabled),
>> BOOLIFY_STRING(tmp_host->notifications_enabled),
>> BOOLIFY_STRING(tmp_host->failure_prediction_enabled),
>> BOOLIFY_STRING(tmp_host->process_performance_data),
>> BOOLIFY_STRING(tmp_host->obsess_over_host),
>> NULL_STRING(safeEventHandler),
>> tmp_host->modified_attributes,
>> BOOLIFY_STRING(tmp_host->has_been_checked),
>> BOOLIFY_STRING(tmp_host->should_be_scheduled),
>> BOOLIFY_STRING(tmp_host->is_flapping),
>> tmp_host->current_state,
>> tmp_host->last_hard_state,
>> NULL_STRING(safePluginOutput),
>> tmp_host->current_attempt,
>> NULL_STRING(safeHostCheckCommand),
>> tmp_host->execution_time,
>> tmp_host->latency,
>> tmp_host->last_check,
>> tmp_host->next_check,
>> tmp_host->max_attempts,
>> tmp_host->last_host_notification,
>> tmp_host->next_host_notification,
>> BOOLIFY_STRING(tmp_host->no_more_notifications),
>> NULL_STRING(safePerfData),
>> tmp_host->check_type);
>> if(safeName) free(safeName);
>> if(safeEventHandler) free(safeEventHandler);
>> if(safePluginOutput) free(safePluginOutput);
>> if(safeHostCheckCommand) free(safeHostCheckCommand);
>> if(safePerfData) free(safePerfData);
>> }
>> break;
>> case NEBCALLBACK_SERVICE_STATUS_DATA:
>> {
>> nebstruct_service_status_data * service_status_data =
>> (nebstruct_service_status_data *) data;
>> tmp_service = (service *) service_status_data->object_ptr;
>> char *safeName = querify(tmp_service->host_name);
>> char *safeServiceDescription = querify(tmp_service->description);
>> char *safeEventHandler = querify(tmp_service->event_handler);
>> char *safePluginOutput = querify(tmp_service->plugin_output);
>> char *safeServiceCheckCommand =
>> querify(tmp_service->service_check_command);
>> char *safePerfData = querify(tmp_service->perf_data);
>> snprintf(temp_buffer, sizeof(temp_buffer), "select
>> update_service(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%lu,%s,%s,%s,%d,%d,%s,
>> %d,%s,%f,%f,%lu,%lu,%d,%lu,%lu,%s,%s,%d)",
>> NULL_STRING(safeName),
>> NULL_STRING(safeServiceDescription),
>> BOOLIFY_STRING(tmp_service->checks_enabled),
>> BOOLIFY_STRING(tmp_service-
>> >accept_passive_service_checks),
>> BOOLIFY_STRING(tmp_service->event_handler_enabled),
>> BOOLIFY_STRING(tmp_service->flap_detection_enabled),
>> BOOLIFY_STRING(tmp_service->notifications_enabled),
>> BOOLIFY_STRING(tmp_service->failure_prediction_enabled),
>> BOOLIFY_STRING(tmp_service->process_performance_data),
>> BOOLIFY_STRING(tmp_service->obsess_over_service),
>> NULL_STRING(safeEventHandler),
>> tmp_service->modified_attributes,
>> BOOLIFY_STRING(tmp_service->has_been_checked),
>> BOOLIFY_STRING(tmp_service->should_be_scheduled),
>> BOOLIFY_STRING(tmp_service->is_flapping),
>> tmp_service->current_state,
>> tmp_service->last_hard_state,
>> NULL_STRING(safePluginOutput),
>> tmp_service->current_attempt,
>> NULL_STRING(safeServiceCheckCommand),
>> tmp_service->execution_time,
>> tmp_service->latency,
>> tmp_service->last_check,
>> tmp_service->next_check,
>> tmp_service->max_attempts,
>> tmp_service->last_notification,
>> tmp_service->next_notification,
>> BOOLIFY_STRING(tmp_service->no_more_notifications),
>> NULL_STRING(safePerfData),
>> tmp_service->check_type);
>> if(safeName) free(safeName);
>> if(safeServiceDescription) free(safeServiceDescription);
>> if(safeEventHandler) free(safeEventHandler);
>> if(safePluginOutput) free(safePluginOutput);
>> if(safeServiceCheckCommand) free(safeServiceCheckCommand);
>> if(safePerfData) free(safePerfData);
>> }
>> break;
>> default:
>> snprintf(temp_buffer,sizeof(temp_buffer),"nagios-db: processStatus
>> ignoring unknown NEB command %i",cmd);
>> write_to_all_logs(temp_buffer,NSLOG_INFO_MESSAGE);
>> return 0;
>> break;
>> }
>> res = PQexec(pgconn,temp_buffer);
>> if(!(PQresultStatus(res) == PGRES_COMMAND_OK || PQresultStatus(res)
>> == PGRES_TUPLES_OK))
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: couldn't execute '%s' (%s)",
>> temp_buffer, PQresultErrorMessage(res));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> else
>> {
>> if(atoi(PQgetvalue(res,0,0)) < 0)
>> {
>> char str[2048];
>> snprintf(str,sizeof(str),"nagios-db: executed '%s' and got back
>> %s", temp_buffer, PQgetvalue(res,0,0));
>> write_to_all_logs(str,NSLOG_INFO_MESSAGE);
>> }
>> }
>> PQclear(res);
>> return 0;
>> }
>> ----------------------------------------------------------------------
>> --
>> On Mar 10, 2005, at 8:57 PM, Robert Bilbrey wrote:
>>> Hi Ben, upgraded Nagios back up to 2.0b2 and pulled the latest
>>> nagios-db code from cvs. Still no joy (:
>>> What would you suggest I do next ?
>>> Thanks, Bob
>>>
>>>
>>> postgresql version:
>>> nagios=# select version();
>>> version
>>> ---------------------------------------------------------------------
>>> -- -----------------------------------
>>> PostgreSQL 7.4.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
>>> 3.2.3 20030502 (Red Hat Linux 3.2.3-42)
>>>
>>> my makefile:
>>> gcc -Wall -g -O2 -o inserter.o inserter.c -shared
>>> -I/usr/local/src/nagios-2.0b2/include -I/usr/local/pgsql/include
>>> /usr/local/pgsql/lib/libpq.a
>>>
>>> nagios.log with latest nagios-db cvs pull:
>>>
>>> [1110516022] Nagios 2.0b2 starting... (PID=8772)
>>> [1110516022] LOG VERSION: 2.0
>>> [1110516022] initializing nagios-db postgres inserter...
>>> [1110516022] nagios-db: inserter locked into db
>>> [1110516022] Event broker module '/usr/local/nagios/bin/inserter.o'
>>> initialized successfully.
>>> [1110516022] Warning: Host 'kcwebwt1' has no services associated
>>> with it!
>>> [1110516022] Warning: Contact 'brian' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'cheikh' is not a member of any
>>> contact groups!
>>> [1110516022] Warning: Contact 'dwain' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'eric' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'john' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'karen' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'liz' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'robert' is not a member of any
>>> contact groups!
>>> [1110516022] Warning: Contact 'russ' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'scott' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact 'van' is not a member of any contact
>>> groups!
>>> [1110516022] Warning: Contact group 'nagios-setup' is not used in
>>> any hostgroup/service definitions or host/hostgroup/se
>>> rvice escalations!
>>> [1110516022] Finished daemonizing... (New PID=8774)
>>> [1110516022] nagios-db: couldn't clear config info ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('OPX',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('clappwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('clbackw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('clsqlwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('clwebwp1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('intranet',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcacct',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
>>> ,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcads',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,
>>> TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcadw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
>>> ,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcmailfw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
>>> RUE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcmailw1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcparadox',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
>>> RUE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcsecl1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRU
>>> E,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcsqldb',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRU
>>> E,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcsqlwd1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcsqlwp2',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcwebwd1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('kcwebwt1',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TR
>>> UE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('pdoxtimer',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,T
>>> RUE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('sunflower-chi-gw',TRUE,TRUE,TRUE,TRUE,TRUE
>>> ,TRUE,TRUE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('sunflower-nor-gw',TRUE,TRUE,TRUE,TRUE,TRUE
>>> ,TRUE,TRUE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('sunflower-op-gw',TRUE,TRUE,TRUE,TRUE,TRUE,
>>> TRUE,TRUE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: couldn't configure host using 'select
>>> configure_host('sunflowerKC',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE
>>> ,TRUE,TRUE,FALSE)' ()
>>> [1110516022] nagios-db: configured 23 hosts
>>> [1110516022] nagios-db: couldn't configure hostgroup using 'select
>>> new_hostgroup('sunshine-colo','Sunshine Colo')' ()
>>>
>>> Ben wrote:
>>>
>>>> First (and most important to you) I don't see anything in the code
>>>> that make it obvious why you would get the "couldn't clear config
>>>> info" message unless the command failed, but then you should have
>>>> had some reason, and I don't see that. So that's still a mystery.
>>>> Therefore, I'm going to blame the victim and ask what version of
>>>> the postgres libs you have installed, and ask that you make sure
>>>> you're really linking to them. Second, I recommend you use 2.0b2.
>>>> It fixed problems I was having and didn't hurt anything. Given
>>>> that you have the same problems on both versions, you might as
>>>> well have them on the better one. :)
>>>> Third, I just checked in a file that should fix the unhelpful
>>>> "nagios-db: couldn't configure host using 'nagios-db: couldn't
>>>> configure host using 'nagios-db: couldn't configure host us' ()"
>>>> crap. That won't help your big
>>>> issue, but it might help others in the future....
>>>> On Thu, 10 Mar 2005, Robert Bilbrey wrote:
>>>>
>>>>> I had nagios 2.0b1 working with nagios-db on RHEL3. I decided to
>>>>> upgrade to 2.0b2 and pulled the latest nagios-db code from cvs.
>>>>> Everything compiled fine, dropped the db and recreated the db with
>>>>> the new schema, but nagios would not start with the neb module.
>>>>> So then I pulled the 0.91 archive, same problem. After deciding
>>>>> to roll back to 2.0b1 and the nagios-db cvs snapshot that I had
>>>>> working previously, I am still throwing the same errors. If I
>>>>> run the "select empty_config()" from a psql session I am returned
>>>>> an empty recordset, which is what I would expect. The following
>>>>> is from the nagios log. Does anyone have any thoughts, I really
>>>>> need to get this back online.
>>>>> Thanks, Bob
>>>>>
>>>>> [1110500709] Nagios 2.0b1 starting... (PID=5391)
>>>>> [1110500709] LOG VERSION: 2.0
>>>>> [1110500709] initializing nagios-db postgres inserter...
>>>>> [1110500709] nagios-db: inserter locked into db
>>>>> [1110500709] Event broker module
>>>>> '/usr/local/nagios/bin/inserter.o' initialized successfully.
>>>>> [1110500709] Warning: Host 'kcwebwt1' has no services associated
>>>>> with it!
>>>>> [1110500709] Warning: Contact 'brian' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'cheikh' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'dwain' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'eric' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'john' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'karen' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'liz' is not a member of any contact
>>>>> groups!
>>>>> [1110500709] Warning: Contact 'robert' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'russ' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'scott' is not a member of any
>>>>> contact groups!
>>>>> [1110500709] Warning: Contact 'van' is not a member of any contact
>>>>> groups!
>>>>> [1110500709] Warning: Contact group 'nagios-setup' is not used in
>>>>> any hostgroup/service definitions or host/hostgroup/service escala
>>>>> tions!
>>>>> [1110500709] Finished daemonizing... (New PID=5393)
>>>>> [1110500709] nagios-db: couldn't clear config info ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure ho' (
>>>>> )
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> ' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host'
>>>>> ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> ' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> usi' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> usi' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> u' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> u' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> us' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> usi' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> using 'nag' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> using 'nag' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> using 'na' ()
>>>>> [1110500709] nagios-db: couldn't configure host using 'nagios-db:
>>>>> couldn't configure host using 'nagios-db: couldn't configure host
>>>>> using' ()
>>>>> [1110500709] nagios-db: configured 23 hosts
>>>>> [1110500709] nagios-db: couldn't configure hostgroup using
>>>>> 'nagios-db: couldn't configure hostgroup using 'nagios' ()
>>>>> [1110500709] Caught SIGSEGV, shutting down...
>>>>>
>>>>>
>>>>> -------------------------------------------------------
>>>>> 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
>>>>>
>>>> -------------------------------------------------------
>>>> 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
>
>
> -------------------------------------------------------
> 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
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X