[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