[rt-users] port problem

Andy Harrison ajharrison at gwi.net
Tue Apr 1 10:59:06 EST 2003


-----BEGIN PGP SIGNED MESSAGE-----

this is seriously kicking my ass...


When I try to access my rt install, I get the Internal Server Error, and in the
httpd error log I see:

[Tue Apr  1 10:51:03 2003] [error] Connect Failed could not connect to server:
Connection refused
 at /opt/rt3/lib/RT.pm line 123

When I look in /var/log/messages, I see:

Apr  1 10:36:59 andy RT: DBI
connect('dbname=rt3;host=localhost;port=65432','rt',...) failed: could not
connect to server: Connection refused at
/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 119 
(/opt/rt3/lib/RT.pm:222)  

Why is it using port 65432 still???  (i was using this previously to test with
postgres 7.2.4 on that port).  I just can't figger it out!


watch this:


(269)[aharriso at andy.gwi] [/usr/download/rt] # rm -rf rt-3-0-0
(270)[aharriso at andy.gwi] [/usr/download/rt] # tar zxf rt-3-0-0.tar.gz
(271)[aharriso at andy.gwi] [/usr/download/rt] # rm -rf /opt/rt3
(272)[aharriso at andy.gwi] [/usr/download/rt] # cd rt-3-0-0
(274)[aharriso at andy.gwi] [/usr/download/rt/rt-3-0-0] # ./configure
- --with-db-type=Pg --with-db-dba=pgsql --with-db-port=5432 --with-db-rt-user=rt
- --with-db-rt-pass=xxxxxx
    (i have tried this with and without the port=)


checking for a BSD-compatible install... /usr/bin/install -c
checking for perl... /usr/bin/perl
checking for chosen layout... RT3
configure: creating ./config.status
config.status: creating sbin/rt-setup-database
config.status: creating sbin/rt-test-dependencies
config.status: creating Makefile
config.status: creating etc/RT_Config.pm
config.status: creating lib/RT.pm
config.status: creating lib/t/00smoke.t
config.status: creating lib/t/01harness.t
config.status: creating lib/t/02regression.t
config.status: creating lib/t/03web.pl
config.status: creating bin/mason_handler.fcgi
config.status: creating bin/mason_handler.svc
config.status: creating bin/rt-commit-handler
config.status: creating bin/rt-crontool
config.status: creating bin/rt-mailgate
config.status: creating bin/webmux.pl                  

(276)[aharriso at andy.gwi] [/usr/download/rt/rt-3-0-0] #
sbin/rt-test-dependencies --with-postgresql --with-fastcgi
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
FASTCGI dependencies:
        CGI ...found
        FCGI ...found
        CGI::Fast ...found
MAILGATE dependencies:
        HTML::TreeBuilder ...found
        HTML::FormatText ...found
        Getopt::Long ...found
        LWP::UserAgent ...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.80...found
        Text::Template ...found
        File::Spec 0.8...found
        HTML::Entities ...found
        Net::Domain ...found
        Log::Dispatch 2.0...found
        Locale::Maketext ...found
        Locale::Maketext::Lexicon 0.10...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

(277)[aharriso at andy.gwi] [/usr/download/rt/rt-3-0-0] # 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/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
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
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: ./local/html/*: No such file or directory
*** Error code 1 (ignored)
cp -rp ./local/po/* //opt/rt3/local/po
cp: ./local/po/*: No such file or directory
*** Error code 1 (ignored)
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'



(278)[aharriso at andy.gwi] [/usr/download/rt/rt-3-0-0] # make dropdb
/usr/bin/perl   //opt/rt3/sbin/rt-setup-database --action drop --dba pgsql
- --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 pgsql.
Please specify that user's database password below. If the user has no database
password, just press return.

Password: 
About to drop Pg database rt3 on localhost.
WARNING: This will erase all data in rt3.

Proceed [y/N]:y
Dropping Pg database rt3.



(279)[aharriso at andy.gwi] [/usr/download/rt/rt-3-0-0] # make initialize-database
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba pgsql
- --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 pgsql.
Please specify that user's database password below. If the user has no database
password, just press return.

Password: Now creating a database for RT.
Creating Pg database rt3.
Now populating database schema.
Creating database schema.
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'attachments_pkey' for table 'attachments'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'queues_pkey'
for table 'queues'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'links_pkey' for
table 'links'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'principals_pkey' for table 'principals'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'groups_pkey'
for table 'groups'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'scripconditions_pkey' for table 'scripconditions'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'transactions_pkey' for table 'transactions'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'scrips_pkey'
for table 'scrips'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'acl_pkey' for
table 'acl'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'groupmembers_pkey' for table 'groupmembers'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'cachedgroupmembers_pkey' for table 'cachedgroupmembers'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'users_pkey' for
table 'users'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'tickets_pkey'
for table 'tickets'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'scripactions_pkey' for table 'scripactions'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'templates_pkey'
for table 'templates'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'ticketcustomfieldvalues_pkey' for table 'ticketcustomfieldvalues'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'customfields_pkey' for table 'customfields'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'customfieldvalues_pkey' for table 'customfieldvalues'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'sessions_pkey'
for table 'sessions'
schema sucessfully inserted
Now inserting database ACLs
Now inserting RT core system objects
Checking for existing system user...not found.  This appears to be a new
installation.
Creating system user...done.
Now inserting RT data
Creating Superuser  ACL...Creating groups...3.4.5.6.7.8.9.done.
Creating users...10.12.done.
Creating ACL...2.3.done.
Creating queues...1.2.done.
Creating ScripActions...1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.done.
Creating ScripConditions...1.2.3.4.5.6.7.8.9.done.
Creating templates...1.2.3.4.5.6.7.8.9.done.
Creating scrips...1.2.3.4.5.6.7.8.9.10.11.12.13.done.



(280)[aharriso at andy.gwi] [/usr/download/rt/rt-3-0-0] # tail -50
/usr/local/etc/apache/httpd.conf | grep '^[^#]'
<VirtualHost 192.168.1.231>
    ServerName rt.andy.gwi
    DocumentRoot /opt/rt3/share/html
    AddDefaultCharset UTF-8
        AddRadiusAuth radiusserver:1812 xxxxxxxxxxxxxxxx
    ## this line applies to Apache2+mod_perl2 only
    #PerlModule Apache2 Apache::compat
    PerlModule Apache::DBI
    PerlRequire /opt/rt3/bin/webmux.pl
    <Location />
        SetHandler perl-script
        PerlHandler RT::Mason
    </Location>
    <Directory /opt/rt3/share/html/>
        AuthRadiusAuthoritative on
        AuthRadiusCookieValid 480
        AuthName "WebRT"
        AuthType Basic
        AuthGroupFile /usr/local/etc/apache/auth/webrt.group
        AuthUserFile /usr/local/etc/apache/auth/webrt.auth
        require group gwi
        Options FollowSymLinks +Includes ExecCGI MultiViews
        AllowOverride AuthConfig Limit
    </Directory>
</VirtualHost>





Any clues?  I've done "find . -type f | xargs grep 65432" through several
directories and don't turn up any indication of port 65432 in any of the
files...  (my rt2 install was also using this port, but I have tarred it up and
removed the files).  This is trippin me out...

And in case you're wondering if I might have also installed rt somewhere else,
I've never used anything but the default of /opt to install rt[23] and I DID go
and confirm that it wasn't installed anywhere else.




~~ 
Andy Harrison
Great Works Internet
System Operations
(full headers for details)

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPom3SFPEkLgodAWVAQEoUQP8Dv/6qBaLfL8Fy2viL0Mc/rH+57c6XCN2
jADEbdNqjhGIhqSLPZ51ndvexLVXtT6wUq81NM6mW+1gBDM28glTdoFLmdUDW+bV
50nZlH6+jzqr6yJadD7W4ZJigeMLyKyOBqXkNY8HwrCaMQxXXN32Rq3QElI91CzU
saPpoF+l+kE=
=mUZ1
-----END PGP SIGNATURE-----



More information about the rt-users mailing list