[freeside-users] Integrated RT Installation Woes

[Muiz Motani]

> 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.

It looks like I need to run as root. Here is the result when running as freeside:

[freeside at vmwareserver freeside-1.7.3]$ make create-rt
cd rt; \
	cp config.layout.in config.layout; \
	perl -p -i -e "\
	  s'%%%FREESIDE_DOCUMENT_ROOT%%%'/var/www/freeside/html'g;\
	  s'%%%MASONDATA%%%'/var/lib/freeside/masondata'g;\
	" config.layout; \
	./configure --enable-layout=Freeside\
	            --with-db-type=Pg \
	            --with-db-dba=freeside \
	            --with-db-database=freeside \
	            --with-db-rt-user=freeside \
	            --with-db-rt-pass=freeside  \
	            --with-web-user=freeside \
	            --with-web-group=freeside \
	            --with-rt-group=freeside
cp: cannot create regular file `config.layout': Permission denied
checking for a BSD-compatible install... /usr/bin/install -c
checking for gawk... gawk
checking for perl... /usr/bin/perl
checking for chosen layout... Freeside
configure: creating ./config.status
config.status: creating sbin/rt-dump-database
config.status: creating sbin/rt-setup-database
config.status: creating sbin/rt-test-dependencies
config.status: creating bin/mason_handler.fcgi
config.status: creating bin/mason_handler.scgi
config.status: creating bin/standalone_httpd
config.status: creating bin/rt-crontool
config.status: creating bin/rt-mailgate
config.status: creating bin/rt
config.status: creating Makefile
config.status: creating etc/RT_Config.pm
config.status: creating lib/RT.pm
config.status: creating bin/mason_handler.svc
config.status: creating bin/webmux.pl
[ -d /opt           ] || mkdir /opt           #doh
[ -d /opt/rt3       ] || mkdir /opt/rt3       #
[ -d /opt/rt3/share ] || mkdir /opt/rt3/share #
cd rt; make install
make[1]: Entering directory `/home/freeside/freeside-1.7.3/rt'
mkdir -p //opt/rt3/etc	
cp etc/RT_Config.pm //opt/rt3/etc/RT_Config.pm
cp: cannot create regular file `//opt/rt3/etc/RT_Config.pm': Permission denied
make[1]: [config-install] Error 1 (ignored)
[ -f //opt/rt3/etc/RT_SiteConfig.pm ] || cp etc/RT_SiteConfig.pm //opt/rt3/etc/RT_SiteConfig.pm 
chgrp freeside //opt/rt3/etc/RT_Config.pm
chgrp: changing group of `//opt/rt3/etc/RT_Config.pm': Operation not permitted
make[1]: *** [config-install] Error 1
make[1]: Leaving directory `/home/freeside/freeside-1.7.3/rt'
make: *** [create-rt] Error 2



> 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?

I double checked the pg_hba.conf file. I changed the following lines:
[root at vmwareserver freeside-1.7.3]# find / -name pg_hba.conf
/var/lib/pgsql/data/pg_hba.conf

[root at vmwareserver freeside-1.7.3]# cat /var/lib/pgsql/data/pg_hba.conf 
# PostgreSQL Client Authentication Configuration File
# ===================================================

{...lines omitted - just comments ...}

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
#local   all         all                               ident sameuser
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          ident sameuser
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser

I made sure that I restarted /etc/init.d/postgresql after making these changes.

Any other ideas?

Regards,

Muiz Motani