[freeside-users] Integrated RT Installation Woes

[Kristian Hoffmann]

It looks like you have postgresql's pg_hba.conf file configured with the
default ident authentication method.  Using those settings, your UNIX
user must equal your postgresql user when you connect to the database.
Since you're logged in as root, but trying to connect as freeside,
you're getting the "Ident authentication failed..." error.

Try running "make create-rt" as the freeside user (not sure if this
needs to be run as root or not), or double check your pg_hba.conf file.
Perhaps you didn't restart postgresql after changing your pg_hba.conf
file?

Regards,

-- 
Kristian Hoffmann
System Administrator
khoff at fire2wire.com
http://www.fire2wire.com  

Office - 209-543-1800 | Fax - 209-545-1469 | Toll Free - 800-905-FIRE


On Tue, 2008-05-27 at 10:27 -0700, Muiz Motani wrote:
> I am trying to install Freeside 1.7.3 on CentOS with Postgres 8.1.11-1.
> I have installed freeside itself successfully under the freeside user. I
> am following the instructions in the wiki at
> http://www.freeside.biz/mediawiki/index.php/Freeside:1.7:Documentation:RT_ Installation to install RT. The "make create-rt" step returns the following errors: 
> 
> rt/sbin/rt-setup-database --dba 'freeside' \
> -dba-password 'freeside ' \                                   -action
> schema \          || true DBI
> connect('dbname=freeside;host=localhost','freeside',...) failed: FATAL:
> Ident authentication failed for user "freeside" at
> rt/sbin/rt-setup-database line 173 Failed to connect to
> dbi:Pg:dbname=template1;host=localhost as freeside: FATAL:  Ident
> authentication failed for user "freeside" at rt/sbin/rt-setup-database
> line 173. rt/sbin/rt-setup-database --action insert_initial \         &&
> rt/sbin/rt-setup-database --action insert --datafile
>         /opt/rt3/etc/initialdata \ || true [Tue May 27 05:25:21 2008]
> [crit]: Connect Failed FATAL:  Ident authentication failed for user
> "freeside"  at rt/sbin/rt-setup-database line 394
>  (/opt/rt3/lib/RT.pm:295) Connect Failed FATAL:  Ident authentication
> failed for user "freeside"  at rt/sbin/rt-setup-database line 394 
> 
> I am running this as root. I have checked the password for the freeside
> user in Postgres and confirmed that the password setting in
> rt/etc/RT_Config.pm is correct. I have also followed the advice in the
> wiki to edit pg_hba.conf settings for local authentication. 
> 
> None of this has seemed to work to solve the problem I would really
> appreciate some help with this. 
> 
> Any Ideas? 
> 
> Regards, 
> 
> Muiz Motani
> 
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users