I've had to build a new server and install RT3 on it. I rebuilt the database
no problem, and can access it using psql, see listing 1.
I can also access it via DBI in a small perl script, see listing 2.
If I supply incorrect passwords to either of these I get the approriate error
message.
However, when I try to use RT3 I get an error complaining about the password.
The RT_Config.pm extract is listing 3, and the error is listing 4.
RT3 built and installed with no errors. Anyone got any ideas?
*** Listing 1
[EMAIL PROTECTED] ~]# export PGHOST=127.0.0.1
[EMAIL PROTECTED] ~]# export PGUSER=rt_user
[EMAIL PROTECTED] ~]# export PGDATABASE=rt3
[EMAIL PROTECTED] ~]# export PGPASSWORD=<password>
[EMAIL PROTECTED] ~]# psql
Welcome to psql 8.1.9, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
rt3=>
*** listing 2
[EMAIL PROTECTED] ~]# more t
#!/usr/bin/perl -w
use DBI;
my $dbh=DBI->connect('dbi:Pg:dbname=rt3;host=127.0.0.1',
'rt_user','<password>');
die $DBI::errstr unless ($dbh);
$dbh->disconnect;
[EMAIL PROTECTED] ~]#
*** listing 3
Set($DatabaseType , 'Pg');
Set($DatabaseHost , 'localhost'); # also tried 127.0.0.1
Set($DatabaseRTHost , 'localhost');
Set($DatabasePort , '');
Set($DatabaseUser , 'rt_user');
Set($DatabasePassword , '<password>');
Set($DatabaseName , 'rt3');
*** listing 4
[Thu Aug 09 09:10:59 2007] [error] [client 10.2.1.3] Connect Failed FATAL:
password authentication failed for user
"rt_user"\n\n at /opt/rt3/lib/RT.pm line 205\n
--
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
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
