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, 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@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@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@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, line 1.
make: *** [initialize-database] Error 255
root@isd_2:/tmp/rt/rt-3-0-3 >