Database integration

[Marc Powell]

> -----Original Message-----
> From: eduardo moura [mailto:eduardo.moura at telway.com.br]
> Sent: Tuesday, October 28, 2003 5:19 PM
> To: Marc Powell
> 
> Marc,
> 
> Regarding your questions:
> 
> Did you modify the database definitions in cgi.cfg appropriately?
> 
> yes. Bellow follow a portion of my cgi.cfg file:

[snip]

> # DB DOWNTIME DATA (Read-Only For CGIs)
> # Note: These config directives are only used if you compiled
> # in database support for downtime data!
> # The user you specify here only needs SELECT privileges on the
> # 'hostdowntime', and 'servicedowntime' tables in the database,
> # as these values are only used by the CGIs.  The core program
> # will read the directives you specify in a resource file.
> 
> xdddb_host=localhost
> xdddb_port=5432
> xdddb_database=nagios
> xdddb_username=postgres
> xdddb_password=
> 

I am assuming that the user postgres is able to access the database with no password from localhost. Other than that, you appear to be missing an xrddb* section. Not sure if this is important but it could be.

xrddb_host=localhost
xrddb_port=5432
xrddb_username=postgres
xrddb_password=
xrddb_database=nagios

> The postgresql server is in the same server of nagios process.
> 
> Have you verified that the data is actually being inserted into postgres
> by
> nagios?
> 
> yes. the nagios database have some data in the hostretentio table.

How about the servicestatus and hoststatus tables? Those are what the CGI's are reading. It could be that the permissions in the db are fine for hostretention, but not the other tables. In fact, I would verify permissions on all the objects in the database to be sure.

> What problem are you seeing with the CGI's exactly?
> 
> accessing the tactical overview or any other options in the main menu the
> message:
> 
> Whoops!
> Error: Could not read host and service status information!
> 

Is there any further information? Does it complain that the nagios process might not be running? That's a typical error message when using a DB for retention as the default nagios_check_command assumes that you are using flat files

http://www.nagios.org/faqs/viewfaq.php?faq_id=170&expand=false&showdesc=true


> is showed. It´s seem some compilation problem. I have used the configure
> shell has follows:
> 
> 
> ./configure --with-pgsql-xdata --with-pgsql-status  --with-pgsql-comments
> --
> with-pgsql-extinfo --with-pgsql-retention --with-pgsql-downtime

--with-pgsql-xdata implies all the others, but I don't think that's an issue. What makes you think it's a compilation problem? Did you see any errors during ./configure or make all that might be pertinent?


--
Marc


-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null