Haha, it's nice to have a laugh after beating my head against this most of the pm.
Well, I ran "make initialize-database" and it completed successfully. The rt4 database exists, as does rt_user. If I su to rt_user, I can do this: [root@tracker ~]# su -l rt_user [rt_user@tracker ~]$ psql -d rt4 -U rt_user psql (9.2.1) Type "help" for help. rt4=> \q As the postgres user, I GRANT'ed ALL PRIVILEGES ON DATABASE rt4 TO rt_user; But apache still won't start :) -----Original Message----- From: Graeme Ruthven [mailto:[email protected]] Sent: Tuesday, October 16, 2012 5:32 PM To: [email protected] Cc: [email protected]; 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 +0000, Mike James wrote: 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
