[rt-users] port problem
Jesse Vincent
jesse at bestpractical.com
Tue Apr 1 11:29:58 EST 2003
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 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."
>
> _______________________________________________
> 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
--
http://www.bestpractical.com/rt -- Trouble Ticketing. Free.
More information about the rt-users
mailing list