error on writing to postgres

[Andreas Ericsson]

Nancy Bronstein wrote:
> I have installed nagios 1.2 on a server running debian with a 2.4.25
> kernel. I did not use the debian package, I downloaded the source and I
> compiled in all of the suppport for postgresql (that is described in the
> nagios documentation) and I have granted all permissions to the nagios
> username I'm using and that user owns all of the tables and yet I still
> get this error on starting nagios:
> 
> Error: Could not insert/update status record for program in table
> 'programstatus' of database 'nagios'
> 
> Any ideas on where I've gone astray will be much appreciated.

Things to check;
Is pgsql running?
Does the database exist?
Is the tablestructure exactly as it's supposed to be?
Is the nagios configuration correct?
Are there any messages in the pgsql logfiles?
Is nagios trying to connect through local or via networking socket?
If networking, do you have any tcpwrappers enabled?
If so, are there any messages in its logfiles?
Can you browse around in the database with the username and password 
that nagios uses, from the host nagios runs on, as the user nagios runs 
as (unix user, not pgsql)?
Have you made any typos?

-- 
Mvh
Andreas Ericsson
OP5 AB
+46 (0)733 709032
andreas.ericsson at op5.se


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
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