<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body>
That was it. Thanks for the help.<br>
<br>
Jesse Vincent wrote:<br>
<blockquote type="cite" cite="mid20030702182456.GW12138@fsck.com">
  <pre wrap="">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:
  </pre>
  <blockquote type="cite">
    <pre wrap="">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@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
       <a class="moz-txt-link-freetext" href="MIME::Entity">MIME::Entity</a> 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, <STDIN> line 1.
make: *** [initialize-database] Error 255
root@isd_2:/tmp/rt/rt-3-0-3 >

_______________________________________________
rt-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.fsck.com">rt-users@lists.fsck.com</a>
<a class="moz-txt-link-freetext" href="http://lists.fsck.com/mailman/listinfo/rt-users">http://lists.fsck.com/mailman/listinfo/rt-users</a>

Have you read the FAQ? The RT FAQ Manager lives at <a class="moz-txt-link-freetext" href="http://fsck.com/rtfm">http://fsck.com/rtfm</a>

    </pre>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
</blockquote>
</body>
</html>