[rt-devel] comments on install rt-3.0beta

[Julian R C Briggs]

Jesse,

Comments on rt-2-1-70 with Apache-2.0.42+mod_fastcgi-2.4.0 on Solaris-9.

Install:

   1. We want to connect to database on localhost at non-default
socket location (/home/mysql/data/mysql.sock) to reduce security
risk of socket in /tmp. Add configure option --with-db-socket=SOCKET
used to configure Makefile (and rt-setup-database) and RT_Config.pm

   2. We want to create the RT database and RT root user manually
then create tables and populate them as RT root user to avoid
security and/or corruption risk of using database server root.

   3. /usr/local/pkg/rt3/bin/mason_handler.fcgi: Can't locate
/dev/fd/webmux.pl

Can't locate /dev/fd/webmux.pl in @INC (@INC contains: /usr/local/lib/perl5/5.8.0/sun4-solaris /usr/local/lib/perl5/5.8.0 /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris /usr/local/lib/perl5/site_perl/5.8.0 /usr/local/lib/perl5/site_perl) at /dev/fd/3 line 29.
[Tue Feb 11 10:46:24 2003] [warn] FastCGI: server "/usr/local/pkg/rt3/bin/mason_handler.fcgi" (pid 27804) terminated by calling exit with status '2'

      Workaround:

#require (dirname(__FILE__) . '/webmux.pl');
require ('/usr/local/pkg/rt3/bin/webmux.pl');

   4. enhanced-mailgate gives errors

holly# date ; date | /usr/local/pkg/rt3/bin/enhanced-mailgate --queue general --action correspond --url http://www.dcs.shef.ac.uk/rt3/
Tue Feb 11 15:32:29 GMT 2003
"CleanEnv" is not exported by the RT::Interface::Email module
 "GetCurrentUser" is not exported by the RT::Interface::Email module
 "ParseMIMEEntityFromSTDIN" is not exported by the RT::Interface::Email module
 "loc" is not exported by the RT::Interface::Email module
Can't continue after import errors at /dev/fd/3 line 68
BEGIN failed--compilation aborted at /dev/fd/3 line 68.
holly# 


   5. /rt-2.0-to-dumpfile only copied 2 of 12 users

holly# /tmp/rt2-to-rt3-v1.4/rt-2.0-to-dumpfile /tmp/rt.dbdump
holly# /tmp/rt2-to-rt3-v1.4/dumpfile-to-rt-3.0 /tmp/rt.dbdump
Creating 12 - andy
Creating 6 - d.abbott at dcs.shef.ac.uk

      Admittedly I had already used the rt3 database so perhaps it
      hit a conflict.

Use:

   1. Hard to read text on buttons and menus against dark blue top
banner

   2. Web interface runs slowly (15s update) on Netscape
Communicator 4.79 (rt-1.0.15 ran fast), runs ok on Netscape6.

Looks promising.

Julian

-- 
Julian Briggs, Director of IT, Department of Computer Science, 
University of Sheffield, Regent Court, 211 Portobello St, Sheffield S1 4DP, UK
Phone +44 (0) 114-222-1851. Fax +44 (0) 114-222-1810
j.briggs at sheffield.ac.uk  http://www.dcs.shef.ac.uk/~julian