I am trying to install RT 3.8.1 with Postgresql 8.1.9 for the database.
I configured RT with
./configure --with-db-type=Pg --with-db-dba=postgres
then did a ‘make testdeps’ which returned that all was OK. Next, I did
a ‘make install’, again all seemingly OK.
However, at the step ‘make initialize-database’ I get the following error:
[root@WEB rt-3.8.1]# make initialize-database
/usr/bin/perl sbin/rt-setup-database --action init --dba postgres
In order to create or update your RT database, this script needs to
connect to your Pg instance on localhost as postgres
Please specify that user’s database password below. If the user has no database
password, just press return.
Failed to connect to dbi:Pg:dbname=template1;host=localhost as user
’postgres’: FATAL: Ident authentication failed for user
"postgres"make: *** [initialize-database] Error 255
If I go into Postgresql and have the postgres user info shown, there
appears to be no password set for this user, yet it seems that the
authentication fails for an empty password. I don’t know the postgres
user password, if there is one set. I could reset it but there are
other applications running on this server that use Postgresql and the
user postgres, so I don’t want to blow them away.
I have searched the mailing list archives for answers and while I can
see that other people have had problems with RT and Postgresql, I have
not found an answer to my problem yet. I have also gone through the RT
book, but didn’t find the solution in there either.
Any ideas? Thx.