I’m configuring a new RT 4.4.2 installation and am following the guide here: https://rt-wiki.bestpractical.com/wiki/CentOS7Install. The dependency installation went by just fine and I haven’t had any issues up until this point.
The issue I’m having is that at the database initialization step:
I’m apparently having trouble with the RT service connecting to the database via the default postgresql user.
Now I’ve changed the password using the following:
sudo -u postgres psql
ALTER USER postgres PASSWORD ‘xxx’;
And I can log in just fine using the same line and my updated password on the command line. The full error I get at the command line if using sudo make initialize-database is:
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
My /var/lib/pgsql/data/pg.hba file looks like:
TYPE DATABASE USER ADDRESS METHOD
#“local” is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident
And if I’m trying the web configuration page I get an error at the top:
Failed to connect to database: FATAL: Ident authentication failed for user “postgres”
All of this makes me think my password is incorrect, but I’ve changed it many times and can log in just fine via terminal.
This is for installing RT 4.4.2. I am on PostgreSQL version 9.2.23, CentOS Linux 7 Kernel: Linux 3.10.0-862.3.2.el7.x86_64