[Nagios-db-devel] Postgres Views not updated - Continued

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

After a deeper analysis, it appears that not all the information is =
outdated, only some subset of it. Logging the updates in the NEB module, =
I see that nagios-DB is notified when something changes, but the history =
is not updated correctly. See:

File: /database/postgres/SPs/service.sql
Function: update_service()
Line 211:
	update service_history set current_attempt =3D CurrentAttempt, =
plugin_output =3D PluginOutput where serviceid =3D thisServiceID and =
lasted is null;

It seems that either this line does not update the PluginOuput correctly =
or it gets the outdated value.
I'm investigating this (unless I've missed something) and keep you guys =
in touch

________________________________________
De=A0: Thibault GENESSAY=20
Envoy=E9=A0: mercredi 4 mai 2005 11:06
=C0=A0: nag...@li...
Objet=A0: [Nagios-db-devel] Postgres Views not updated

Hello

I've been using nagios-db for a few days only so please apologize if =
it's a dummy question, but I'm going crazy with it.=20
First, I am using nagios-db-0.91 with Postgres NEB.
It seems that the data from the views does not get updated, even if I =
use the update_views.sql script as stated in the doc. The php interface =
reflects the information in the service_history table and host_details =
view, which is completely outdated. On the other hand, the service_check =
table contains the correct, latest information that nagios' CGIs show.=20
Any clues ?

Regards

Thibault