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