pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gary Stainburn <gary@ringways.co.uk>
To: pgsql-admin@postgresql.org
Subject: RT3 - Pg database connection - authentication failed
Date: Wed, 8 Aug 2007 15:16:21 +0100
Message-ID: <200708081516.22602.gary@ringways.co.uk> (raw)

Hi folks.

I've just had to move my RT3 install onto a new box and all's going well until 
I try to use it.  When I try to bring the login page up I get Internal Server 
Error.

The log file shows:
[Wed Aug 08 11:18:06 2007] [error] [client 10.1.1.118] Connect Failed FATAL:  
password authentication failed for user "rt_user"\n\n at /opt/rt3/lib/RT.pm 
line 205\n

If I try to access the database using:

export PGDATABASE=rt3
export PGHOST=127.0.0.1
export PGPASSWORD=<password>
export PGUSER=rt_user
psql

it lets me in no problem, but RT fails.  my RT_Config.pm includes:

Set($DatabaseType , 'Pg');
Set($DatabaseHost   , 'localhost');
Set($DatabaseRTHost , 'localhost');
Set($DatabasePort , '');
Set($DatabaseUser , 'rt_user');
Set($DatabasePassword , '<password>');
Set($DatabaseName , 'rt3');
Set($DatabaseRequireSSL , undef);

Anyone got any suggestions
-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     




Message-ID: <200708081516.22602.gary@ringways.co.uk>
Permalink:  ../200708081516.22602.gary@ringways.co.uk/
Also on:    postgresql.org/message-id/200708081516.22602.gary@ringways.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gary@ringways.co.uk
  Subject: Re: RT3 - Pg database connection - authentication failed
  In-Reply-To: <200708081516.22602.gary@ringways.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox