[rt-users] Setting up the database

[Ruslan U. Zakirov]

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