Setting up the database

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@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@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

To setup DB you need user more privileged then user that RT uses after
installation.
You need DBA credentials to make initdb.
see ./configure --help

Chris Berry wrote: