[rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-16 Thread Mike James
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

Re: [rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-16 Thread Graeme Ruthven
On Tue, 2012-10-16 at 20:55 +, 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

Re: [rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-16 Thread Alex Vandiver
On Tue, 2012-10-16 at 20:55 +, 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… I suspect SELinux shenanigans. Try disabling SELinux and trying again.

Re: [rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-16 Thread Mike James
@lists.bestpractical.com Cc: rt-users@lists.bestpractical.com; Mike James Subject: Re: [rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database On Tue, 2012-10-16 at 20:55 +, Mike James wrote: At the risk of teaching my grandmother to suck eggs, have you: - created the PosetrgreSQL

Re: [rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-16 Thread Paul Tomblin
On Tue, Oct 16, 2012 at 5:56 PM, Mike James mja...@profitpoint.com wrote: [root@tracker ~]# su -l rt_user [rt_user@tracker ~]$ psql -d rt4 -U rt_user psql (9.2.1) Type help for help. How about if you try psql -H localhost -U rt_user rt4 That will tell you if you've configured postgres to