[rt-users] port problem

Tue Apr 1 11:07:19 EST 2003

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 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-----
> _______________________________________________
> rt-users mailing list
> rt-users at 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."