[rt-users] make-initialize failure during DBI connect.connection refused.

Mat Brletic mbrletic at visalia.k12.ca.us
Wed Jul 2 13:42:19 EDT 2003 

I could use some help.

I am trying to install RT3, but can never get past the make 
initialize-database step. I get the following error:

Password: DBI connect('dbname=template1;host=localhost','postgres',...) 
failed: PQconnectPoll() -- connect() failed: Connection refused at 
//opt/rt3/sbin/rt-set
up-database line 80
Failed to connect to dbi:Pg:dbname=template1;host=localhost as postgres: 
PQconnectPoll() -- connect() failed: Connection refused at 
//opt/rt3/sbin/rt-setup-data
base line 80, <STDIN> line 1.
make: *** [initialize-database] Error 255

I have Apache 1.2.34 and mod_perl 1.27. Everythings seems ok when I 
check for intalled modules (see below), and I have a valid Postgresql 
user and password defined in the ./configure statement. I can run
the psql client with no problem. I would appreciate any advice or help 
 on this problem.

Thanks,

Mat



root at isd_2:/tmp/rt/rt-3-0-3 > perl sbin/rt-test-dependencies 
--with-postgres --with-modperl1
MASON dependencies:
        Params::Validate 0.02...found
        Cache::Cache ...found
        Exception::Class ...found
        HTML::Mason 1.16...found
        MLDBM ...found
        Errno ...found
        FreezeThaw ...found
        Digest::MD5 ...found
        CGI::Cookie 1.20...found
        Storable ...found
        Apache::Session 1.53...found
MAILGATE dependencies:
        HTML::TreeBuilder ...found
        HTML::FormatText ...found
        Getopt::Long ...found
        LWP::UserAgent ...found
MODPERL1 dependencies:
        CGI ...found
        Apache::Request ...found
        Apache::DBI ...found
POSTGRESQL dependencies:
        DBD::Pg ...found
CLI dependencies:
        Getopt::Long 2.24...found
CORE dependencies:
        Digest::MD5 ...found
        DBI 1.18...found
        Test::Inline ...found
        Class::ReturnValue 0.40...found
        DBIx::SearchBuilder 0.86...found
        Text::Template ...found
        File::Spec 0.8...found
        HTML::Entities ...found
        Net::Domain ...found
        Log::Dispatch 2.0...found
        Locale::Maketext 1.04...found
        Locale::Maketext::Lexicon 0.25...found
        Locale::Maketext::Fuzzy ...found
        MIME::Entity 5.108...found
        Mail::Mailer 1.57...found
        Net::SMTP ...found
        Text::Wrapper ...found
        Time::ParseDate ...found
        File::Temp ...found
        Term::ReadKey ...found
        Text::Autoformat ...found
        Text::Quoted ...found
DEV dependencies:
        Regexp::Common ...found
        Time::HiRes ...found
        Test::Inline ...found
        WWW::Mechanize ...found
root at isd_2:/tmp/rt/rt-3-0-3 > make install
mkdir -p //opt/rt3/etc
cp etc/RT_Config.pm //opt/rt3/etc/RT_Config.pm
[ -f //opt/rt3/etc/RT_SiteConfig.pm ] || cp etc/RT_SiteConfig.pm 
//opt/rt3/etc/RT_SiteConfig.pm
chgrp rt //opt/rt3/etc/RT_Config.pm
chown root //opt/rt3/etc/RT_Config.pm
chgrp rt //opt/rt3/etc/RT_SiteConfig.pm
chown root //opt/rt3/etc/RT_SiteConfig.pm
Installed configuration. about to install rt in  /opt/rt3
mkdir -p //opt/rt3/var/log
mkdir -p //opt/rt3/var/mason_data
mkdir -p //opt/rt3/var/mason_data/cache
mkdir -p //opt/rt3/var/mason_data/etc
mkdir -p //opt/rt3/var/mason_data/obj
mkdir -p //opt/rt3/var/session_data
mkdir -p //opt/rt3/share/html
mkdir -p //opt/rt3/local/html
mkdir -p //opt/rt3/local/etc
mkdir -p //opt/rt3/local/po
[ -d //opt/rt3/lib ] || mkdir //opt/rt3/lib
cp -rp lib/* //opt/rt3/lib
mkdir -p //opt/rt3/etc
cp -rp \
etc/acl.* \
        etc/initialdata \
        etc/schema.* \
        //opt/rt3/etc
mkdir -p //opt/rt3/bin
chmod +x bin/rt-mailgate \
        bin/rt-crontool
cp -rp \
        bin/rt-mailgate \
        bin/mason_handler.fcgi \
        bin/mason_handler.svc \
        bin/webmux.pl \
        bin/rt-crontool \
        //opt/rt3/bin
mkdir -p //opt/rt3/sbin
chmod +x sbin/rt-setup-database \
        sbin/rt-test-dependencies
cp -rp \
        sbin/rt-setup-database \
        sbin/rt-test-dependencies \
        //opt/rt3/sbin
[ -d //opt/rt3/share/html ] || mkdir //opt/rt3/share/html
cp -rp ./html/* //opt/rt3/share/html
cp -rp ./local/html/* //opt/rt3/local/html
cp: cannot stat `./local/html/*': No such file or directory
make: [local-install] Error 1 (ignored)
cp -rp ./local/po/* //opt/rt3/local/po
cp: cannot stat `./local/po/*': No such file or directory
make: [local-install] Error 1 (ignored)
cp -rp ./local/etc/* //opt/rt3/local/etc
cp: cannot stat `./local/etc/*': No such file or directory
make: [local-install] Error 1 (ignored)
# RT 3.0.0 - RT 3.0.2 would accidentally create a file instead of a dir
[ -f //opt/rt3/share/doc ] && rm //opt/rt3/share/doc
make: [doc-install] Error 1 (ignored)
[ -d //opt/rt3/share/doc ] || mkdir //opt/rt3/share/doc
cp -rp ./README //opt/rt3/share/doc
# Make the libraries readable
chmod 0755 //opt/rt3
chown -R root //opt/rt3/lib
chgrp -R bin //opt/rt3/lib
chmod -R  u+rwX,go-w,go+rX      //opt/rt3/lib
chmod 0755 //opt/rt3/bin
chmod 0755 //opt/rt3/bin
chmod 0755 //opt/rt3/etc
chmod 0500 //opt/rt3/etc/*
#TODO: the config file should probably be able to have its
# owner set seperately from the binaries.
chown -R root //opt/rt3/etc
chgrp -R rt //opt/rt3/etc
chmod 0550 //opt/rt3/etc/RT_Config.pm
chmod 0550 //opt/rt3/etc/RT_SiteConfig.pm
# Make the interfaces executable and setgid rt
chown root //opt/rt3/bin/webmux.pl //opt/rt3/bin/rt-mailgate 
//opt/rt3/bin/rt-crontool //opt/rt3/bin/mason_handler.fcgi 
//opt/rt3/bin/mason_handler.svc
chgrp rt //opt/rt3/bin/webmux.pl //opt/rt3/bin/rt-mailgate 
//opt/rt3/bin/rt-crontool //opt/rt3/bin/mason_handler.fcgi 
//opt/rt3/bin/mason_handler.svc
chmod 0755  //opt/rt3/bin/webmux.pl //opt/rt3/bin/rt-mailgate 
//opt/rt3/bin/rt-crontool //opt/rt3/bin/mason_handler.fcgi 
//opt/rt3/bin/mason_handler.svc
chmod g+s //opt/rt3/bin/mason_handler.fcgi //opt/rt3/bin/mason_handler.svc
# Make the web ui readable by all.
chmod -R  u+rwX,go-w,go+rX      //opt/rt3/share/html \
                                //opt/rt3/local/html \
                                //opt/rt3/local/po
chown -R root   //opt/rt3/share/html \
                        //opt/rt3/local/html
chgrp -R bin    //opt/rt3/share/html \
                        //opt/rt3/local/html
# Make the web ui's data dir writable
chmod 0770      //opt/rt3/var/mason_data \
                //opt/rt3/var/session_data
chown -R www    //opt/rt3/var/mason_data \
                        //opt/rt3/var/session_data
chgrp -R www    //opt/rt3/var/mason_data \
                        //opt/rt3/var/session_data
Congratulations. RT has been installed.


You must now configure RT by editing /opt/rt3/etc/RT_SiteConfig.pm.

(You will definitely need to set RT's database password before continuing.
 Not doing so could be very dangerous)

After that, you need to initialize RT's database by running
 'make initialize-database'
root at isd_2:/tmp/rt/rt-3-0-3 > make initialize-database
/usr/local/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba 
postgres --prompt-for-dba-password
In order to create a new database and grant RT access to that database,
this script needs to connect to your Pg instance on localhost as postgres.
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','postgres',...) 
failed: PQconnectPoll() -- connect() failed: Connection refused at 
//opt/rt3/sbin/rt-set
up-database line 80
Failed to connect to dbi:Pg:dbname=template1;host=localhost as postgres: 
PQconnectPoll() -- connect() failed: Connection refused at 
//opt/rt3/sbin/rt-setup-data
base line 80, <STDIN> line 1.
make: *** [initialize-database] Error 255
root at isd_2:/tmp/rt/rt-3-0-3 >

More information about the rt-users mailing list