[rt-users] make-initialize failure during DBI connect.connection refused.
Jesse Vincent
jesse at bestpractical.com
Wed Jul 2 14:24:56 EDT 2003
Perhaps you don't have postgres set to listen to TCP connections?
On Wed, Jul 02, 2003 at 10:42:19AM -0700, Mat Brletic wrote:
> 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 >
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>
--
http://www.bestpractical.com/rt -- Trouble Ticketing. Free.
More information about the rt-users
mailing list