SOLVED postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

RT Users
1

Great, that’s the answer! Thanks!-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Tuesday, October 16, 2012 5:39 PM
To: rt-users@lists.bestpractical.com
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 +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…

I suspect SELinux shenanigans. Try disabling SELinux and trying again.

  • Alex

Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training

We’re hiring! Careers — Best Practical Solutions

2

Or better yet, update your SELinux rules to allow it to work properly.

Cheers,
KenOn Tue, Oct 16, 2012 at 09:59:59PM +0000, Mike James wrote:

Great, that’s the answer! Thanks!

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Tuesday, October 16, 2012 5:39 PM
To: rt-users@lists.bestpractical.com
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 +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…

I suspect SELinux shenanigans. Try disabling SELinux and trying again.

  • Alex

Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training

We’re hiring! Careers — Best Practical Solutions

Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training

We’re hiring! Careers — Best Practical Solutions

3

I’m no expert with SELinux - but I agree this is the better answer. I’ll see if I can figure out how to do it. Thx.From: ktm@rice.edu [mailto:ktm@rice.edu]
Sent: Wednesday, October 17, 2012 9:17 AM
To: Mike James
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] SOLVED postgres 9.2.1, RT 4.0.5 - RT couldn’t connect to database

Or better yet, update your SELinux rules to allow it to work properly.

Cheers,
Ken

4

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1On 10/17/2012 10:26 AM, Mike James wrote:

I’m no expert with SELinux - but I agree this is the better answer.
I’ll see if I can figure out how to do it. Thx.

I believe you’re going to need to set one or more of the selinux booleans.

Try:

setsebool httpd_can_network_connect_db true

If that fixes the problem, then to make that persist across boots do:

setsebool -P httpd_can_network_connect_db true

You may also need to set httpd_can_network_connect to true as well.

Barry

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFQfyZ3CFu3bIiwtTARArYdAJ0QyPLXShjOZxJkX4DRqCJjkz92swCeKyAG
jdH7TO/xm7HqynwG4W7YlAA=
=eYYK
-----END PGP SIGNATURE-----