RT and Netscape 4.x

Amit,

Save yourself some heartache, grab a nice hot cup of tea or coffee and
sit back, safe in the knowledge that it isn’t RT that is broken, but the
css implementation of netscape 4.7x and 4.8.

After several weeks of “Why doesn’t this work properly or look right in
netscape 4.79, when it does in mozilla or IE?” we gave up and simply
told users to use a decent, modern browser.

Given that Netscape 4 accounts for less than 0.01% of the total browser
market, your energies would be better served elsewhere.

RikOn Wed, 2004-04-21 at 05:57, rt-users-request@lists.bestpractical.com wrote:

Send RT-Users mailing list submissions to
rt-users@lists.bestpractical.com

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
or, via email, send a message with subject or body ‘help’ to
rt-users-request@lists.bestpractical.com

You can reach the person managing the list at
rt-users-owner@lists.bestpractical.com

When replying, please edit your Subject line so it is more specific
than “Re: Contents of RT-Users digest…”

Today’s Topics:

  1. Re: some performance improvements when caching transactions
    in ShowHistory (Jesse Vincent)
  2. Re: database migration (David Cecchino)
  3. Re: some performance improvements when caching transactions
    in ShowHistory (Ralf Hack)
  4. session management in RT+ oracle (amit poddar)
  5. Ticket DB space usage (kranga)
  6. Resolving ticket via email (kranga)
  7. Re: Statistics 3 - text/html. (Brian Scanlan)
  8. Change .po files (Dimitry Faynerman)
  9. Re: Change .po files (Jesse Vincent)
  10. Re: RT::LoadConfig - httpd configtest fails (Phil Homewood)
  11. RE: Insecure dependency running setgid in Guts.pm (Parish, Brent)

Message: 1
Date: Tue, 20 Apr 2004 16:09:11 -0400
From: Jesse Vincent jesse@bestpractical.com
Subject: Re: [rt-users] some performance improvements when caching
transactions in ShowHistory
To: Ralf Hack ralf.hack@pipex.net
Cc: rt-users@lists.fsck.com
Message-ID: 20040420200911.GB25274@pallas.eruditorum.org
Content-Type: text/plain; charset=us-ascii

On Tue, Apr 20, 2004 at 09:04:45PM +0100, Ralf Hack wrote:

See attachments, simple reload of the page “with” my improvements and
"without", apache restarted in between. As an ‘aside’, /var is reiserfs.

Huh. This looks like it calls for deeper profiling runs. I do wonder
whether it’s the database-calls (pulling data out of the DB) or the
html-wrapping and colorization.


Message: 2
Date: Tue, 20 Apr 2004 16:27:07 -0400 (EDT)
From: David Cecchino cecchind@qwestip.net
Subject: Re: [rt-users] database migration
To: Les Mikesell les@futuresource.com
Cc: rt-users@lists.bestpractical.com
Message-ID: Pine.GSO.4.58L0.0404201626500.7620@qmail
Content-Type: TEXT/PLAIN; charset=US-ASCII

thats just for mysql to mysql, i need mysql -> oracle , thanks for the
reply.

dave

On Tue, 20 Apr 2004, Les Mikesell wrote:

On Tue, 2004-04-20 at 09:08, David Cecchino wrote:

Had a quick question I have a webrt system running 3.0.9 with mysql, I
have a dev box running webrt 3.0.10 with oracle 9i. I have the mysql
dumped , just need a nice way of importing the data, I was wondering if
anyone out there has a way or maybe can share some information.

“man mysqldump” for details. It suggests:

mysqldump --opt database | mysql --host=remote-host -C database
as one way to move a database - or redirect to a file on the
dump and from the file on the restore.


Les Mikesell
les@futuresource.com


Message: 3
Date: Tue, 20 Apr 2004 21:32:14 +0100
From: Ralf Hack ralf.hack@pipex.net
Subject: Re: [rt-users] some performance improvements when caching
transactions in ShowHistory
To: rt-users@lists.fsck.com
Message-ID: 408588CE.3020706@pipex.net
Content-Type: text/plain; charset=us-ascii; format=flowed

Jesse Vincent wrote:

It’s worth looking at using mason’s internal caching, rather than going
to a disk cache. Also, I’d bet that doubling or quadrupling the memory
will result in a pretty wild performance improvement with much less
developer-pain.

You are scraping the bottom of my mason know-how here. It’s been only a
couple of weeks. But yes, web server and memory go hand in hand.

I was impressed with the performance increase I could squeeze out of the
old book stand ;-), so I thought I’d share this with the audience here.
Perhaps it helps as a data point of observation.

Ralf.


Message: 4
Date: Tue, 20 Apr 2004 16:39:03 -0400
From: amit poddar amit.poddar@yale.edu
Subject: [rt-users] session management in RT+ oracle
To: rt-users@lists.bestpractical.com
Message-ID: 5.1.0.14.2.20040420163717.01d86f38@ap349.mail.yale.edu
Content-Type: text/plain; charset=“us-ascii”; format=flowed

Hi,

I was wondering whether RT 3 uses database tables for session management.

Since I don’t see any records being inserted into table sessions.

I have one more installation of RT 3 on mysql. I see records being inserted
into sessions table.

Could anyone please clarify my confusion

thanks
amit


Message: 5
Date: Tue, 20 Apr 2004 17:31:55 -0400
From: “kranga” kranga@k2d2.org
Subject: [rt-users] Ticket DB space usage
To: rt-users@lists.bestpractical.com
Message-ID: 00ba01c4271e$e79acac0$1ab4fea9@eschaton
Content-Type: text/plain; charset=“iso-8859-1”

Does anyone know how much space one single new ticket takes up and how much
a ticket on average takes (assuming no attachments)? Are there guidelines
for tuning the mysql tablespaces?


Message: 6
Date: Tue, 20 Apr 2004 17:33:05 -0400
From: “kranga” kranga@k2d2.org
Subject: [rt-users] Resolving ticket via email
To: rt-users@lists.bestpractical.com
Message-ID: 00cc01c4271f$11231dc0$1ab4fea9@eschaton
Content-Type: text/plain; charset=“iso-8859-1”

Is it possible to resolve a ticket via email? If it takes scrips to do so,
does anyone have a sample?


Message: 7
Date: Tue, 20 Apr 2004 22:39:25 +0100
From: Brian Scanlan brian.scanlan@redbrick.dcu.ie
Subject: Re: [rt-users] Statistics 3 - text/html.
To: rt-users@lists.bestpractical.com
Message-ID: 20040420213925.GB23104@carbon.redbrick.dcu.ie
Content-Type: text/plain; charset=us-ascii

Hi all,

On Mon, Apr 19, 2004 at 02:55:09PM +0100, Brian Scanlan wrote:

I think all of these problems are related to this Debian bug.
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=238494

It looks like I’ve found a workaround to this problem. I’ve seen a few
people post to the list without much success.

Problem description:

  • Search breaks, returning some HTTP headers and a…

OK

The document has moved here

…page appears, which is really annoying.

  • Attachments are sent with a wrong mime type - Everything gets given
    Content-Type: text/html

  • The images produced by Statistics 3 are also broken by this.

I had migrated from a 3.0.6 install to 3.0.8 (and subsequently to
3.0.10, the problem lingered). However, on the 3.0.6 install I was
simply modifying the system html/ directory, and not using the overlay
functionality of Mason. So, when I upgraded to 3.0.8, I thought it would
be ok to copy the 3.0.6 html/ directory to
/usr/local/share/request-tracker3/html - Removing this directory removed
the problem, and I had only made a few changes to the templates anyway,
so these were made against the 3.0.10 html/ tree and only modified files
were installed into the /usr/local/share/request-tracker3/html
directory.

I wonder is the problem Debian specific - Perhaps it’s just because
Debian makes it easy to upgrade RT thanks to the wonderful job done by
the packagers that this seems to have hit Debian users more so than
others.

Brian.

“Verbing weirds language”


Message: 8
Date: Tue, 20 Apr 2004 14:44:13 -0700
From: “Dimitry Faynerman” dimitry.faynerman@hypermediasystems.com
Subject: [rt-users] Change .po files
To: rt-users@lists.bestpractical.com
Message-ID: 000001c42720$a2a0f230$2801140a@DimitryFaynerman
Content-Type: text/plain; charset=“us-ascii”

Hello,

I want to add some lines to ja.po file.
Should I change the original file from /lib/RT/I18N or I’m supposed to make
changes in some local directory?

Thanks
Dimitry Faynerman


Message: 9
Date: Tue, 20 Apr 2004 19:34:04 -0400
From: Jesse Vincent jesse@bestpractical.com
Subject: Re: [rt-users] Change .po files
To: Dimitry Faynerman dimitry.faynerman@hypermediasystems.com
Cc: rt-users@lists.bestpractical.com
Message-ID: 20040420233404.GD25274@pallas.eruditorum.org
Content-Type: text/plain; charset=us-ascii

On Tue, Apr 20, 2004 at 02:44:13PM -0700, Dimitry Faynerman wrote:

Hello,

I want to add some lines to ja.po file.
Should I change the original file from /lib/RT/I18N or I’m supposed to make
changes in some local directory?

If they’re corrections to the core japanese translation, please send
them to rt-bugs@fsck.com and we’ll get them included in the next release
of RT.

Thanks
Dimitry Faynerman


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
http://bestpractical.com/services/training.html

Sign up early, as class space is limited.


Message: 10
Date: Wed, 21 Apr 2004 13:39:05 +1000
From: Phil Homewood pdh@bestpractical.com
Subject: Re: [rt-users] RT::LoadConfig - httpd configtest fails
To: rt-users@lists.fsck.com
Message-ID: 20040421033905.GB10121@bne.snapgear.com
Content-Type: text/plain; charset=unknown-8bit

amit poddar wrote:

Coule anyone please explain to me why can’t we run two RT instances from
same apache/mod_perl instance

Namespace collisions. It just won’t work. Use FastCGI, or use
multiple apache instances with mod_perl.

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


Message: 11
Date: Wed, 21 Apr 2004 00:57:48 -0400
From: “Parish, Brent” bparish@workscape.com
Subject: RE: [rt-users] Insecure dependency running setgid in Guts.pm
To: rt-users@lists.bestpractical.com
Message-ID:
A4B80826CB8CAF4FB397A9A6836B9E39E9BD8F@mailrelay.workscape.net
Content-Type: text/plain; charset=“utf-8”

Sorry, Jesse, don’t mean to be thick, but I can’t find much on this.
I have enabled suexec and the logs show it starting successfully with Apache, along with fastcgi and all that. However, I wasn’t convinced I was doing the right thing, since the files were still set as setgid.
I was guessing that I needed to strip the setgid permission from the mason_handler.fcgi file, but doing so caused a fastcgi error on Apache startup:

[Wed Apr 21 00:16:03 2004] [notice] suEXEC mechanism enabled (wrapper: /usr/local/apache/bin/suexec)
[Wed Apr 21 00:16:18 2004] [notice] FastCGI: process manager initialized (pid 9974)
[Wed Apr 21 00:16:18 2004] [warn] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” started (pid 9975)
[Wed Apr 21 00:16:19 2004] [notice] Apache configured – resuming normal operations
"/opt/rt3/bin/mason_handler.fcgi" started (pid 9983)
Can’t locate /opt/rt3/etc/RT_SiteConfig.pm in @INC (@INC contains: /opt/rt3/local/lib /opt/rt3/lib /usr/local/lib/perl5/5.8.3/sun4-solaris-thread-multi /usr/local/lib/perl5/5.8.3 /usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris-thread-multi /usr/local/lib/perl5/site_perl/5.8.3 /usr/local/lib/perl5/site_perl .) at /opt/rt3/lib/RT.pm line 105.
Compilation failed in require at /opt/rt3/bin/mason_handler.fcgi line 28.
[Wed Apr 21 00:16:28 2004] [warn] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” (pid 9975) terminated by calling exit with status ‘13’

Thanks a million!

  • Brent

-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Tuesday, April 20, 2004 3:01 PM
To: Parish, Brent
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Insecure dependency running setgid in Guts.pm

Ok. Another workaround is to use apache’s suexec functionality, rather
than setgid perl. The author of Locale::Maketext hasn’t been able to
track this issue yet.

On Tue, Apr 20, 2004 at 02:55:35PM -0400, Parish, Brent wrote:

Hi.

I saw this error on the list Thu 4/15/2004, reported on RH9. I am seeing this on Solaris 9, Perl 5.8.3, RT 3.0.10.
I have seen this in several places, but this particular one (below) was while modifying a ticket and dropping a requestor from it.
I upgraded Locale::Maketext to 1.09, but got the error again. I have a number of users (about 20) hitting the RT servers (there are 3, load balanced with persistent sessions behind a VIP) fairly regularly through the day. I see this error probably about three times an hour or more. Anyone have any ideas? Also, I only saw this error after upgrading to 3.0.10 (from 3.0.9 for performance).

Thanks!
Brent

=========== ERROR =================

error: Insecure dependency in eval while running setgid at /usr/local/lib/perl5/5.8.3/Locale/Maketext/Guts.pm line 247.

context: …
243: unshift @code, “use strict; sub {\n”;
244: push @code, “}\n”;
245:
246: print @code if DEBUG;
247: my $sub = eval(join ‘’, @code);
248: die “$@ while evalling” . join(’’, @code) if $@; # Should be impossible.
249: return $sub;
250: }
251:

code stack: /usr/local/lib/perl5/5.8.3/Locale/Maketext/Guts.pm:247
/usr/local/lib/perl5/5.8.3/Locale/Maketext.pm:195
/opt/rt3/lib/RT/CurrentUser.pm:360
/opt/rt3/lib/RT/Base.pm:97
/opt/rt3/lib/RT/Ticket_Overlay.pm:1601
/opt/rt3/lib/RT/Interface/Web.pm:1265
/opt/rt3/share/html/Ticket/ModifyPeople.html:49
/opt/rt3/share/html/autohandler:195

=========== END ERROR =================

Rick Ellis Richard.Ellis@Sun.COM