[rt-users] Setting up the database

[Chris Berry]

I'm using Mandrake 10.1 Official, Apache 2, FastCGI, PostgreSQL 7.4.5

I've gotten through the manaual install up to the make install 
successfully.  At this point I'm attempting to make initialize-database, 
but having a few problems.  I've edited /opt/rt3/etc/RT_SiteConfig.pm to 
set the $DatabaseUser and $DatabasePassword variables, and added the 
database user to PostgreSQL.  For some reason it looks like it's still 
trying to use root to login.  I also tried putting the settings in 
/usr/local/src/rt-3.4.2/etc/RT_SiteConfig.pm, but that didn't seem to 
make a difference.  Here's the output:

[root at hermes /usr/local/src/rt-3.4.2]$ make initialize-database
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root 
--prompt-for-dba-password
In order to create or update your RT database,this script needs to 
connect to your Pg instance on localhost as root.
Please specify that user's database password below. If the user has no 
database
password, just press return.

Password:
DBI connect('dbname=template1;host=localhost','root',...) failed: could 
not connect to server: Connection refused
         Is the server running on host "localhost" and accepting
         TCP/IP connections on port 5432?
  at //opt/rt3/sbin/rt-setup-database line 101
Failed to connect to dbi:Pg:dbname=template1;host=localhost as root: 
could not connect to server: Connection refused
         Is the server running on host "localhost" and accepting
         TCP/IP connections on port 5432?
make: *** [initialize-database] Error 255

-- 
Chris Berry
chris_berry at jm-associates.com
Information Advisory Manager
JM Associates

"There is nothing so useless as doing efficiently that which should not 
be done at all." --Peter Drucker