Port problem

-----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@andy.gwi] [/usr/download/rt] # rm -rf rt-3-0-0
(270)[aharriso@andy.gwi] [/usr/download/rt] # tar zxf rt-3-0-0.tar.gz
(271)[aharriso@andy.gwi] [/usr/download/rt] # rm -rf /opt/rt3
(272)[aharriso@andy.gwi] [/usr/download/rt] # cd rt-3-0-0
(274)[aharriso@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@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@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@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@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@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

SetHandler perl-script
PerlHandler RT::Mason

<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

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-----

because that it remembers these values… edit rt-3-0-0/Makefile to
reflect that DB/port/type change and re-do make install

hopefully that will work (for me, from time to time, it doesn’t, so i had
to reopen the tarball and do it all over again, but that’s like 2
minutes…)On Tue, 1 Apr 2003, Andy Harrison wrote:

-----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@andy.gwi] [/usr/download/rt] # rm -rf rt-3-0-0
(270)[aharriso@andy.gwi] [/usr/download/rt] # tar zxf rt-3-0-0.tar.gz
(271)[aharriso@andy.gwi] [/usr/download/rt] # rm -rf /opt/rt3
(272)[aharriso@andy.gwi] [/usr/download/rt] # cd rt-3-0-0
(274)[aharriso@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@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@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@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@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@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

SetHandler perl-script
PerlHandler RT::Mason

<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

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-----


rt-users mailing list
rt-users@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

Best regards,
Shimi

“Outlook is a massive flaming horrid blatant security violation, which
also happens to be a mail reader.”

“Sure UNIX is user friendly; it’s just picky about who its friends are.”

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

On 01-Apr-2003, shimi wrote message “Re: [rt-users] port problem”

because that it remembers these values… edit rt-3-0-0/Makefile to
reflect that DB/port/type change and re-do make install

hopefully that will work (for me, from time to time, it doesn’t, so i had
to reopen the tarball and do it all over again, but that’s like 2
minutes…)

This would have turned up when I used the find command. Plus I have removed
the directory and extracted a fresh copy from the tarball.

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

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

iQCVAwUBPom7n1PEkLgodAWVAQF/VQP/RRxrsUyLCqgBxATYGQI/OYvn0ZBZibqw
oxPGJSKCftLXkfqmd6nAXphkU8V6AkLkTy3JScvr5MX/SSJiOITJgCT/vXI6haGo
wxNfcZ1HO4dTTjZ1CMN1ynEPhu3uUrx7xxP4tdcwC9VzSrBcICgCyfQqMmQsFlY+
SrVReDHkTyg=
=A9l4
-----END PGP SIGNATURE-----

and you did make install? because i think it reads the actual
config from the already installed stuff (i.e. what in /opt/rt3, or
whatever path you chose in configure) (i only think that way, only jesse
could say.)On Tue, 1 Apr 2003, Andy Harrison wrote:

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

On 01-Apr-2003, shimi wrote message "Re: [rt-users] port problem"

because that it remembers these values… edit rt-3-0-0/Makefile to
reflect that DB/port/type change and re-do make install

hopefully that will work (for me, from time to time, it doesn’t, so i had
to reopen the tarball and do it all over again, but that’s like 2
minutes…)

This would have turned up when I used the find command. Plus I have removed
the directory and extracted a fresh copy from the tarball.

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

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

iQCVAwUBPom7n1PEkLgodAWVAQF/VQP/RRxrsUyLCqgBxATYGQI/OYvn0ZBZibqw
oxPGJSKCftLXkfqmd6nAXphkU8V6AkLkTy3JScvr5MX/SSJiOITJgCT/vXI6haGo
wxNfcZ1HO4dTTjZ1CMN1ynEPhu3uUrx7xxP4tdcwC9VzSrBcICgCyfQqMmQsFlY+
SrVReDHkTyg=
=A9l4
-----END PGP SIGNATURE-----


rt-users mailing list
rt-users@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

Best regards,
Shimi

“Outlook is a massive flaming horrid blatant security violation, which
also happens to be a mail reader.”

“Sure UNIX is user friendly; it’s just picky about who its friends are.”

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

On 01-Apr-2003, shimi wrote message “Re: [rt-users] port problem”

and you did make install? because i think it reads the actual
config from the already installed stuff (i.e. what in /opt/rt3, or
whatever path you chose in configure) (i only think that way, only jesse
could say.)

I my politest voice, would you mind taking a look at my entire original post?
I’d appreciate it, thanx.

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

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

iQCVAwUBPom+FVPEkLgodAWVAQGKqwP+PAiU04vPOh4vgThodw8Aj8gS3TO54jRd
WwVF/LZKzPmBh8/e69p+zrFfE8MjiQKNL6yhJtGQATNpE7iwhHFTkZeOeUBvkRBc
eDGj5f/xA9IcpesNM0ewa0fXvQhiUhikCrT3t22gE0pSsveSmdhATyOPZ1i84OIe
VPsy/TVHk74=
=3dKW
-----END PGP SIGNATURE-----

Actually, rather than ever touching the makefile directly, rerun
configure.On Tue, Apr 01, 2003 at 07:07:19PM +0300, shimi wrote:

because that it remembers these values… edit rt-3-0-0/Makefile to
reflect that DB/port/type change and re-do make install

hopefully that will work (for me, from time to time, it doesn’t, so i had
to reopen the tarball and do it all over again, but that’s like 2
minutes…)

On Tue, 1 Apr 2003, Andy Harrison wrote:

-----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@andy.gwi] [/usr/download/rt] # rm -rf rt-3-0-0
(270)[aharriso@andy.gwi] [/usr/download/rt] # tar zxf rt-3-0-0.tar.gz
(271)[aharriso@andy.gwi] [/usr/download/rt] # rm -rf /opt/rt3
(272)[aharriso@andy.gwi] [/usr/download/rt] # cd rt-3-0-0
(274)[aharriso@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@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@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@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@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@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

SetHandler perl-script
PerlHandler RT::Mason

<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

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-----


rt-users mailing list
rt-users@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

Best regards,
Shimi


“Outlook is a massive flaming horrid blatant security violation, which
also happens to be a mail reader.”

“Sure UNIX is user friendly; it’s just picky about who its friends are.”


rt-users mailing list
rt-users@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.

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

On 01-Apr-2003, shimi wrote message “Re: [rt-users] port problem”

sorry about that. it happens to me on some really long letters…

look, all I know is that the Apache instance reads his stuff from:
INSTALLDIR/etc/RT_Config.pm - and that’s where you should look for. I
think you didn’t look there, originally, as far as I could read from your
post. If I am wrong, I can’t help no more

sorry…

Yep, that was one of the places I looked… :frowning:

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

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

iQCVAwUBPonHkFPEkLgodAWVAQGr0gQAgnM2St5DJZxqaB0JjTl6UlxTljgZeQoG
P8irvAJF0/feRhWuJxAtlokgvuE9w6h1bbkR+toD20BaWoe9zsqJsaZ8al8dfTwJ
YHYHwuuwCe4+o+62LeIS0bE2jzjB3VE6scfDx40lnKCj91NBQKychyCFJhKYfaJ1
M1dtZoBnk7Y=
=iP5Q
-----END PGP SIGNATURE-----

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

On 01-Apr-2003, Jesse Vincent wrote message “Re: [rt-users] port problem”

Actually, rather than ever touching the makefile directly, rerun
configure.

I can see that the Makefile is correct.

(309)[aharriso@andy.gwi] [/usr/download/rt/rt-3-0-0] # grep 5432 *
Makefile:DB_PORT = 5432
config.log: $ ./configure --with-db-type=Pg --with-db-dba=pgsql

  • –with-db-port=5432 --with-db-rt-user=rt --with-db-rt-pass=xxxxxx
    config.status: with options "’–with-db-type=Pg’ ‘–with-db-dba=pgsql’
    ’–with-db-port=5432’ ‘–with-db-rt-user=rt’ ‘–with-db-rt-pass=xxxxxxx’"
    config.status: echo "running /bin/bash ./configure " ‘–with-db-type=Pg’
    ’–with-db-dba=pgsql’ ‘–with-db-port=5432’ ‘–with-db-rt-user=rt’
    ’–with-db-rt-pass=xxxxxx’ " --no-create --no-recursion"
    config.status: exec /bin/bash ./configure ‘–with-db-type=Pg’
    ’–with-db-dba=pgsql’ ‘–with-db-port=5432’ ‘–with-db-rt-user=rt’
    ’–with-db-rt-pass=xxxxxx’ --no-create --no-recursion ;;
    config.status:s,@DB_PORT@,5432,;t t

Did yet another make install, did a dropdb, initialize-database and it still
appears with that 65432 port in the log. Any other odd places I can look?
This is crazy…

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

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

iQCVAwUBPoniOlPEkLgodAWVAQEm6gQAg9F07bJTkv0Ux0DsUegv/kmMkqrlphLT
ArnnLIZI1yUiNmmfxqkmQzU6kaRdeA6RwSY61IgSp+WyU7mxeAxUEahKau7fC+m/
suSYeu51Vx1HKusXtzSjZzF9tqEorrmEfp9Nqt+owVs9X3at0W9p4jrb+qrYKClo
MLocx+l0RnE=
=sOEL
-----END PGP SIGNATURE-----

How are you calling the configure script, exactly? And what port is your
postgres daemon listening on?On Tue, Apr 01, 2003 at 02:02:20PM -0500, Andy Harrison wrote:

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

On 01-Apr-2003, Jesse Vincent wrote message "Re: [rt-users] port problem"

Actually, rather than ever touching the makefile directly, rerun
configure.

I can see that the Makefile is correct.

(309)[aharriso@andy.gwi] [/usr/download/rt/rt-3-0-0] # grep 5432 *
Makefile:DB_PORT = 5432
config.log: $ ./configure --with-db-type=Pg --with-db-dba=pgsql

  • –with-db-port=5432 --with-db-rt-user=rt --with-db-rt-pass=xxxxxx
    config.status: with options "’–with-db-type=Pg’ ‘–with-db-dba=pgsql’
    ’–with-db-port=5432’ ‘–with-db-rt-user=rt’ ‘–with-db-rt-pass=xxxxxxx’"
    config.status: echo "running /bin/bash ./configure " ‘–with-db-type=Pg’
    ’–with-db-dba=pgsql’ ‘–with-db-port=5432’ ‘–with-db-rt-user=rt’
    ’–with-db-rt-pass=xxxxxx’ " --no-create --no-recursion"
    config.status: exec /bin/bash ./configure ‘–with-db-type=Pg’
    ’–with-db-dba=pgsql’ ‘–with-db-port=5432’ ‘–with-db-rt-user=rt’
    ’–with-db-rt-pass=xxxxxx’ --no-create --no-recursion ;;
    config.status:s,@DB_PORT@,5432,;t t

Did yet another make install, did a dropdb, initialize-database and it still
appears with that 65432 port in the log. Any other odd places I can look?
This is crazy…

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

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

iQCVAwUBPoniOlPEkLgodAWVAQEm6gQAg9F07bJTkv0Ux0DsUegv/kmMkqrlphLT
ArnnLIZI1yUiNmmfxqkmQzU6kaRdeA6RwSY61IgSp+WyU7mxeAxUEahKau7fC+m/
suSYeu51Vx1HKusXtzSjZzF9tqEorrmEfp9Nqt+owVs9X3at0W9p4jrb+qrYKClo
MLocx+l0RnE=
=sOEL
-----END PGP SIGNATURE-----

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

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

On 01-Apr-2003, Jesse Vincent wrote message “Re: [rt-users] port problem”

How are you calling the configure script, exactly? And what port is your
postgres daemon listening on?

(274)[aharriso@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=)

(334)[aharriso@andy.gwi] [/usr/download/rt/rt-3-0-0] # sockstat -l | grep -i sql
pgsql postgres 140 3 tcp4 *:5432 :
pgsql postgres 140 4 stream /tmp/.s.PGSQL.5432

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

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

iQCVAwUBPonqylPEkLgodAWVAQFKgAP7BwswflcKcRtJ/6MpZDU10jNypU84UaLe
Um/YLdQT8zlH8CdCFyD+RLgsCNRGtmknjcqyGdENB+VcIY11DZyxdvd7/vMQ15+2
qsr+YJlhdd4hfsGT8O2jNGIN+gDMQq8kFsVTGxME4V0mA5pC4Edx19UVu++Qj/rT
vgj7oLAv8gg=
=RcNe
-----END PGP SIGNATURE-----

Andy Harrison wrote:

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:

In all that excellent transcript, I didn’t see an Apache restart…
�|� http://www.bestpractical.com/rt – Trouble Ticketing. Free.

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

On 01-Apr-2003, Phil Homewood wrote message “Re: [rt-users] port problem”

Andy Harrison wrote:

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:

In all that excellent transcript, I didn’t see an Apache restart…

Wow, that did work… doh! Weird, I wouldn’t think apache would cache
something like that.

Unfortunately, this brings me back to my other problem, even though I’m using
external auth, it’s still bring me to the rt login screen in my web browser,
even after the web server prompts me to authenticate.

http://lists.fsck.com/pipermail/rt-users/2003-March/012732.html

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

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

iQCVAwUBPosKFlPEkLgodAWVAQF4AgP/WS0uFiemBEug9OMvMiH68fYGmeuXnLUd
MExkcMIKx+mUVDVaTbbyxnWoilfLG6RgkhL7xNpdeZz/azi/IrMinys3zyOiRJPX
grfcEKrtn0ly3u1P3KbSn69iICzJJk7CfE8QuVtYU8mnszjhiWaJC7xlJ0WWPnRP
ZdzSOa1iIsw=
=waDe
-----END PGP SIGNATURE-----

Andy Harrison wrote:

Unfortunately, this brings me back to my other problem, even though I’m using
external auth, it’s still bring me to the rt login screen in my web browser,
even after the web server prompts me to authenticate.

http://lists.fsck.com/pipermail/rt-users/2003-March/012732.html

You haven’t defined $WebFallbackToInternalAuth, by any chance?
�|� http://www.bestpractical.com/rt – Trouble Ticketing. Free.

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

On 03-Apr-2003, Phil Homewood wrote message “Re: [rt-users] port problem”

http://lists.fsck.com/pipermail/rt-users/2003-March/012732.html

You haven’t defined $WebFallbackToInternalAuth, by any chance?

Nope, here’s the whole thing:

grep ‘^[^#]’ /opt/rt3/etc/RT_Config.pm

package RT;
=head1 NAME
RT::Config
=for testing
use RT::Config;
=cut
Set($rtname , “example.com”);
Set($Organization , “example.com”);
Set($MinimumPasswordLength , “5”);
Set($Timezone , ‘US/Eastern’);
Set($DatabaseType , ‘Pg’);
Set($DatabaseHost , ‘localhost’);
Set($DatabaseRTHost , ‘localhost’);
Set($DatabasePort , ‘5432’);
Set($DatabaseUser , ‘rt’);
Set($DatabasePassword , ‘xxxxxxxxx’);
Set($DatabaseName , ‘rt3’);
Set($DatabaseRequireSSL , undef);
Set($OwnerEmail , ‘root’);
Set($LoopsToRTOwner , 1);
Set($StoreLoops , undef);
Set($MaxAttachmentSize , 10000000);
Set($TruncateLongAttachments , undef);
Set($DropLongAttachments , undef);
Set($ParseNewMessageForTicketCcs , undef);
Set($RTAddressRegexp , ‘^rt@example.com$’);
Set($CanonicalizeEmailAddressMatch , ‘subdomain.example.com$’);
Set($CanonicalizeEmailAddressReplace , ‘example.com’);
Set($SenderMustExistInExternalDatabase , undef);
Set($CorrespondAddress , ‘RT::CorrespondAddress.not.set’);
Set($CommentAddress , ‘RT::CommentAddress.not.set’);
Set($MailCommand , ‘sendmailpipe’);
Set($SendmailArguments , “-oi -t”);
Set($SendmailPath , “/usr/sbin/sendmail”);
Set($UseFriendlyToLine , 0);
Set($NotifyActor, 0);
Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘error’);
Set($LogToFile , undef);
Set($LogToFileNamed , “$LogDir/rt.log”); #log to rt.log..
Set($WebPath , “”);
Set($WebBaseURL , “http://RT::WebBaseURL.not.configured:80”);
Set($WebURL , $WebBaseURL . $WebPath . “/”);
Set($WebImagesURL , $WebURL . “NoAuth/images/”);
Set($LogoURL , $WebImagesURL . “rt.jpg”);
Set($TrustHTMLAttachments , undef);
Set($WebExternalAuth , “true”);
Set($WebFallbackToInternalAuth , undef);
Set($WebExternalGecos , undef);
Set($WebExternalAuto , “true”);
@EmailInputEncodings = qw(utf-8 iso-8859-1 us-ascii) unless (@EmailEncodings);
Set($EmailOutputEncoding , ‘utf-8’);
Set($DateDayBeforeMonth , 1);
Set($AmbiguousDayInPast , 1);
1;

I just turned on WebExternalAuto and gave that a whirl, to no avail.

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

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

iQCVAwUBPoujnVPEkLgodAWVAQFFmgP/eqlH+5jRkDccKi6m8dQ5c8tdBpUSnQPD
OEYaUTjWPJwQndPJY4xY45Wh0k3VhoL7AgxZ7QG2N9fzTnxhkxMtTwu4BhmryJx3
22fwgMRISGxuaX/RDPoBcLiszhewTQMd3p2WnZoeWAjXkCGBQ1+GM4S7I5ySceod
gein4ADyKp0=
=HwQh
-----END PGP SIGNATURE-----

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

Is anyone else using external auth? I’m just wondering if it’s really broken
in the new version or if I’m just doing something wrong.

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

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

iQCVAwUBPoxz8VPEkLgodAWVAQGTOgP/Vb65UNX07HjJ0AEQh8FlCAcwK+vhLmu+
KfOZ5NDzzaqiR7Wdyx1AYu2/jmk+3zEq8focV3cio0HXe+qMEWiJ1wg25w0n90ls
6rjbsgaYpfGF6kSqbkJLlZOdygM7vTHPCIwEctOM016Sjg0InT3j/pvDDbbGYN3S
Yh1ERyu/BsE=
=nR/6
-----END PGP SIGNATURE-----

I presume you’ve already created users inside RT for each of the
externally authenticated accounts you want to be able to log in to RT?On Thu, Apr 03, 2003 at 12:48:34PM -0500, Andy Harrison wrote:

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

Is anyone else using external auth? I’m just wondering if it’s really broken
in the new version or if I’m just doing something wrong.

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

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

iQCVAwUBPoxz8VPEkLgodAWVAQGTOgP/Vb65UNX07HjJ0AEQh8FlCAcwK+vhLmu+
KfOZ5NDzzaqiR7Wdyx1AYu2/jmk+3zEq8focV3cio0HXe+qMEWiJ1wg25w0n90ls
6rjbsgaYpfGF6kSqbkJLlZOdygM7vTHPCIwEctOM016Sjg0InT3j/pvDDbbGYN3S
Yh1ERyu/BsE=
=nR/6
-----END PGP SIGNATURE-----


rt-users mailing list
rt-users@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.