On Tue, 2012-10-16 at 20:55 +0000, Mike James wrote: > Fresh install of Centos 6.3, fully patched. Added the postgresql repo > and installed posgresql-9.2.1. RT 4.0.5 is config’d and looks ready to > go. Just one last problem… > > If I start the standalone rt-server (/opt/rt4/sbin/rt-server –port > 8080), I can connect to RT and login as root without a problem. > However, apache fails to start with the following error: > > [root@tracker rt4]# service httpd start > > Starting httpd: DBI connect('dbname=rt4;host=localhost','rt_user',...) > failed: could not connect to server: Permission denied > > Is the server running on host "localhost" (::1) and accepting > > TCP/IP connections on port 5432? > > could not connect to server: Permission denied
At the risk of teaching my grandmother to suck eggs, have you: - created the PosetrgreSQL database rt4 - created the user rt_user and granted rights to rt4 - updated pg_hba.conf to suit? - tested with "psql -u rt_user rt4"? Regards Graeme -------- Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs