Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id F02059FBB9E for ; Wed, 8 Aug 2007 12:11:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 14223-10 for ; Wed, 8 Aug 2007 12:11:43 -0300 (ADT) X-Greylist: delayed 00:51:16.721852 by SQLgrey-1.7.5 Received: from mail.ringways.co.uk (unknown [80.193.83.130]) by postgresql.org (Postfix) with ESMTP id CF2B09FB734 for ; Wed, 8 Aug 2007 12:11:42 -0300 (ADT) Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.62) (envelope-from ) id 1IImGd-0000MX-4J for pgsql-admin@postgresql.org; Wed, 08 Aug 2007 15:12:08 +0100 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: RT3 - Pg database connection - authentication failed User-Agent: KMail/1.9.5 MIME-Version: 1.0 Content-Disposition: inline Date: Wed, 8 Aug 2007 15:16:21 +0100 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200708081516.22602.gary@ringways.co.uk> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/74 X-Sequence-Number: 26405 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= 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 , ''); 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