RT3 - Pg database connection - authentication failed

From: Gary Stainburn <gary(at)ringways(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: RT3 - Pg database connection - authentication failed
Date: 2007-08-08 14:16:21
Message-ID: 200708081516.22602.gary@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-08-08 14:34:05 Re: Transaction-Overflow
Previous Message Ashish Karalkar 2007-08-08 14:06:05 Re: Postgresql Login problem