[rt-users] Re: RT and Netscape 4.x
Rick Ellis
Richard.Ellis at Sun.COM
Wed Apr 21 03:50:26 EDT 2004
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.
Rik
On Wed, 2004-04-21 at 05:57, rt-users-request at lists.bestpractical.com
wrote:
> Send RT-Users mailing list submissions to
> rt-users at 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 at lists.bestpractical.com
>
> You can reach the person managing the list at
> rt-users-owner at 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 at bestpractical.com>
> Subject: Re: [rt-users] some performance improvements when caching
> transactions in ShowHistory
> To: Ralf Hack <ralf.hack at pipex.net>
> Cc: rt-users at lists.fsck.com
> Message-ID: <20040420200911.GB25274 at 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 at qwestip.net>
> Subject: Re: [rt-users] database migration
> To: Les Mikesell <les at futuresource.com>
> Cc: rt-users at lists.bestpractical.com
> Message-ID: <Pine.GSO.4.58L0.0404201626500.7620 at 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 at futuresource.com
> >
> >
> >
> >
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 20 Apr 2004 21:32:14 +0100
> From: Ralf Hack <ralf.hack at pipex.net>
> Subject: Re: [rt-users] some performance improvements when caching
> transactions in ShowHistory
> To: rt-users at lists.fsck.com
> Message-ID: <408588CE.3020706 at 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 at yale.edu>
> Subject: [rt-users] session management in RT+ oracle
> To: rt-users at lists.bestpractical.com
> Message-ID: <5.1.0.14.2.20040420163717.01d86f38 at 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 at k2d2.org>
> Subject: [rt-users] Ticket DB space usage
> To: <rt-users at lists.bestpractical.com>
> Message-ID: <00ba01c4271e$e79acac0$1ab4fea9 at 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 at k2d2.org>
> Subject: [rt-users] Resolving ticket via email
> To: <rt-users at lists.bestpractical.com>
> Message-ID: <00cc01c4271f$11231dc0$1ab4fea9 at 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 at redbrick.dcu.ie>
> Subject: Re: [rt-users] Statistics 3 - text/html.
> To: rt-users at lists.bestpractical.com
> Message-ID: <20040420213925.GB23104 at 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 at hypermediasystems.com>
> Subject: [rt-users] Change .po files
> To: <rt-users at lists.bestpractical.com>
> Message-ID: <000001c42720$a2a0f230$2801140a at 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 at bestpractical.com>
> Subject: Re: [rt-users] Change .po files
> To: Dimitry Faynerman <dimitry.faynerman at hypermediasystems.com>
> Cc: rt-users at lists.bestpractical.com
> Message-ID: <20040420233404.GD25274 at 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 at 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 at bestpractical.com>
> Subject: Re: [rt-users] RT::LoadConfig - httpd configtest fails
> To: rt-users at lists.fsck.com
> Message-ID: <20040421033905.GB10121 at 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 at workscape.com>
> Subject: RE: [rt-users] Insecure dependency running setgid in Guts.pm
> To: <rt-users at lists.bestpractical.com>
> Message-ID:
> <A4B80826CB8CAF4FB397A9A6836B9E39E9BD8F at 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 at bestpractical.com]
> Sent: Tuesday, April 20, 2004 3:01 PM
> To: Parish, Brent
> Cc: rt-users at 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 at Sun.COM>
More information about the rt-users
mailing list