More on: Re: error on writing to postgres

[Nancy Bronstein]

After wrangling with this installation further I have more info that I'm
hoping will ring a bell with someone. To capsulize:
--running nagios 1.2
--postgres 7.2.1
--am getting this error message on starting nagios:

	Error: Could not insert/update status record for program in table
'programstatus' of database

--and in syslog, this error message:

	 ERROR:  Bad abstime external representation'1081953908'

--postgres info:

nagios=# \d programstatus
                             Table "programstatus"
            Column             |           Type           |    
Modifiers
-------------------------------+--------------------------+--------------------
 last_update                   | timestamp with time zone | not null
 program_start                 | timestamp with time zone | not null
 daemon_mode                   | smallint                 | not null
default 0
 enable_notifications          | smallint                 | not null
default 0
 last_command_check            | timestamp with time zone | not null
 last_log_rotation             | timestamp with time zone | not null
 execute_service_checks        | smallint                 | not null
default 0
 accept_passive_service_checks | smallint                 | not null
default 0
 enable_event_handlers         | smallint                 | not null
default 0
 obsess_over_services          | smallint                 | not null
default 0
 nagios_pid                    | bigint                   | not null
default 0
 enable_flap_detection         | smallint                 | not null
default 0
 enable_failure_prediction     | smallint                 | not null
default 0
 process_performance_data      | smallint                 | not null
default 0
 

Any and all help will be greatly, massively appreciated.


Nancy





On Tue, 2004-04-13 at 12:20, Nancy Bronstein wrote:
> Andreas,
> Thanks for the input. I forgot to mention that I wrote a php script that
> checked to see if it could write to the nagios database as the nagios
> username and it was able to, also:
> On Tue, 2004-04-13 at 09:26, Andreas Ericsson wrote:
> > 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?
> --yes is running since I can write to the database via php function
> pg_connect
> > Does the database exist?
> --same as above
> > Is the tablestructure exactly as it's supposed to be?
> --I used the script supplied with the program
> > Is the nagios configuration correct?
> --I thought it was
> > Are there any messages in the pgsql logfiles?
> --no
> > Is nagios trying to connect through local or via networking socket?
> --local
> > If networking, do you have any tcpwrappers enabled
> --no
> > 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)?
> --yes and write to it
> > Have you made any typos?
> --I can't find any
-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~
Nancy Bronstein
Simon's Rock College
Computer & Media Services
(413)528-7471
~~~~~~~~~~~~~~~~~~~~~~~~~~



-------------------------------------------------------
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