Unsubscribe

unsubscribe

w.ritchie.vcf (400 Bytes)

unsubscribe

unsubscribe

unsubscribe

smime.p7s (2.8 KB)

Send rt-users mailing list submissions to
rt-users@lists.fsck.com

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

You can reach the person managing the list at
rt-users-admin@lists.fsck.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: RT2 Speed/performance problems. (Florian Weimer)
  2. Re: RT2 Speed/performance problems. (Bruce Campbell)
  3. RT Statistics Package Installation Help (Rajesh Menon)
  4. Re: RT2 Speed/performance problems. (Maren S. Leizaola)
  5. Mysql db creation hassles with tools/initdb (Jake Skinner)
  6. Re: Mysql db creation hassles with tools/initdb (Darrin Walton)
  7. Re: Mysql db creation hassles with tools/initdb (Jake Skinner)
  8. installation problem (Kazu Kimura)
  9. Deleting dead tickets (especially attachments) (Scott A. McIntyre)
  10. RE: RT2 Speed/performance problems. (=?iso-8859-2?Q?Ale=B9_Mustar?=)
  11. Re: Deleting dead tickets (especially attachments) (Simon Cozens)
  12. Odd performance problem - returning from submissions. (Scott A.
    McIntyre)
  13. RE: RT2 Speed/performance problems. (Michael K. Brown)

Message: 1
To: “Maren S. Leizaola” maren@leizaola.com
Cc: Rich Lafferty rich+rt@lafferty.ca,
“Rt-Users (E-mail)” rt-users@lists.fsck.com
Subject: Re: [rt-users] RT2 Speed/performance problems.
From: Florian Weimer Weimer@CERT.Uni-Stuttgart.DE
Date: Tue, 20 Aug 2002 22:01:50 +0200

“Maren S. Leizaola” maren@leizaola.com writes:

The board is an ASUS P2BF-D (old but great board), with two PII 450Mhz,
the machine has 512MB of RAM, the disks are running on a promise raid
TX2-100. The disks are idle, the HTTP deamons eat CPU like there is no
tomorow, and they inflate themselves like zepplins, even with only one
user.

Use mod_fastcgi instead. Then you’ll have to cope just with one
growing process. :slight_smile:

If you use mod_perl and the httpd children die too quickly (after too
few process requests), then you incur the horrendous RT loading
overhead on every second ticket or so. This can kill your performance
much more thoroughly than any other way (with the notable exception of
an un-VACUUM-ed PostgreSQL database, of course).


Florian Weimer Weimer@CERT.Uni-Stuttgart.DE
University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT fax +49-711-685-5898

Message: 2
Date: Tue, 20 Aug 2002 22:36:13 +0200 (CEST)
From: Bruce Campbell bruce_campbell@ripe.net
To: “Rt-Users (E-mail)” rt-users@lists.fsck.com
Subject: Re: [rt-users] RT2 Speed/performance problems.

Maybe I am picky our just a lazy admin, but I believe that decent
system sould be maintainable, should be able install them in a snap,
reconfigure them, see what it is doing. You should be able to rebuild
in

under one hour or less from nothing to live.

It sounds like you’re lazy. Despite what Larry Wall says, it isn’t
always a virtue.

Now now children, you’re starting to sound like the qmail list. Thats
the unfortunate aspect, not that someone has found RT2 not to their
liking.

Maren, its unfortunate that you’ve found RT2 to be unusable. Should you
wish to return to RT, the rt-users list can assist you provided that you
ask for assistance and provide details of the problem.

For rather lightweight ticket/problem managers, theres gnats or
{w,www}req. For medium weight, bugzilla or RT1 with a bit of spit and
polish to add the requested features (there are hints on how to do this in
rt-users about a year or more ago).

Kind regards,


Bruce Campbell
RIPE
Systems/Network Engineer
NCC
www.ripe.net - PGP562C8B1B
Operations/Security

Message: 3
Reply-To: rajmen@olemiss.edu
From: “Rajesh Menon” rajmen@olemiss.edu
To: rt-users@lists.fsck.com
Date: Tue, 20 Aug 2002 16:14:41 -0500
Subject: [rt-users] RT Statistics Package Installation Help

Hello,

I am trying to setup RT Statistics (Simon Cozen’s) package on RT 2.0.14,
running on a Red Hat 7.2 box. Is there a way someone can help me with some
installation guidelines. Looks like i installed all the required modules,
including Apache::GD::Graph and made the modifications in the httpd.conf
file.

How do i get to the initial page?

I can get to my RT page and i have the stats folder under /WebRT
folder and i have the folder chart under /html folder.

If i try to open http:///chart it gives me and error in the
apache
log “Undefined subroutine &Apache::GD::Graph::handler called”

Where do i go from here? Any help / comments in this regard would be
highly
appreciated.

Thanks,

Raj

Message: 4
Date: Wed, 21 Aug 2002 02:53:24 +0800 (HKT)
From: “Maren S. Leizaola” maren@leizaola.com
To: Bruce Campbell bruce_campbell@ripe.net
Cc: “Rt-Users (E-mail)” rt-users@lists.fsck.com
Subject: Re: [rt-users] RT2 Speed/performance problems.

Maybe I am picky our just a lazy admin, but I believe that decent
system sould be maintainable, should be able install them in a snap,
reconfigure them, see what it is doing. You should be able to
rebuild in

under one hour or less from nothing to live.

It sounds like you’re lazy. Despite what Larry Wall says, it isn’t
always a virtue.

Now now children, you’re starting to sound like the qmail list. Thats
the unfortunate aspect, not that someone has found RT2 not to their
liking.

Maren, its unfortunate that you’ve found RT2 to be unusable. Should you
wish to return to RT, the rt-users list can assist you provided that you
ask for assistance and provide details of the problem.

Right now I am thinking of engaging Jesse, the man himself, to prove me
wrong…

Let see.

For rather lightweight ticket/problem managers, theres gnats or
{w,www}req. For medium weight, bugzilla or RT1 with a bit of spit and
polish to add the requested features (there are hints on how to do this
in

rt-users about a year or more ago).

I will have a quick peak.

Maren.

Kind regards,


Bruce Campbell
RIPE

               Systems/Network Engineer

NCC

             www.ripe.net - PGP562C8B1B

Operations/Security


rt-users mailing list
rt-users@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

Message: 5
From: “Jake Skinner” Jake.Skinner@gribbles.com.au
To: “RT Users” rt-users@lists.fsck.com
Date: Wed, 21 Aug 2002 13:12:30 +0930
Subject: [rt-users] Mysql db creation hassles with tools/initdb

It is failing when trying to create indexs - complaining that fields being
used to index on aren’t set to ‘NOT NULL’

RH7.2, mysql 3.22.32, rt 2.0.14

Any help would be fantastic! :slight_smile:

jake

Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
delete the material from any system and destroy any copies.

Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of The Gribbles Group.

Thank You.

Whilst every effort has been made to ensure that this e-mail message and
any attachments are free from viruses, you should scan this message and any
attachments.
Under no circumstances do we accept liability for any loss or damage which
may result from your receipt of this message or any attachment.

Message: 6
Date: Tue, 20 Aug 2002 23:37:54 -0400
From: Darrin Walton darrinw@nixc.net
To: Jake Skinner Jake.Skinner@gribbles.com.au
Cc: RT Users rt-users@lists.fsck.com
Subject: Re: [rt-users] Mysql db creation hassles with tools/initdb
Organization: NIXC, Inc.

|+ It is failing when trying to create indexs - complaining that fields
being
|+ used to index on aren’t set to ‘NOT NULL’
|+
|+ RH7.2, mysql 3.22.32, rt 2.0.14

Did you read the README file?

REQUIRED PACKAGES:
[snip]

o A DB backend; MySQL is recommended ( http://www.mysql.com )
Currently supported: Mysql 3.23.38 or newer.
(Some older releases had crippling SQL
bugs)
Postgres 7.1
Partially supported: Oracle 8i

Upgrade MySQL.

Message: 7
From: “Jake Skinner” Jake.Skinner@gribbles.com.au
To: “RT Users” rt-users@lists.fsck.com
Subject: Re: [rt-users] Mysql db creation hassles with tools/initdb
Date: Wed, 21 Aug 2002 13:23:25 +0930

Did you read the README file?

Ummm… I thought I did :wink:

thanx

(hiding and going red from embarressment) jake

Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
delete the material from any system and destroy any copies.

Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of The Gribbles Group.

Thank You.

Whilst every effort has been made to ensure that this e-mail message and
any attachments are free from viruses, you should scan this message and any
attachments.
Under no circumstances do we accept liability for any loss or damage which
may result from your receipt of this message or any attachment.

Message: 8
From: “Kazu Kimura” kazu@kmn.co.jp
To: rt-users@lists.fsck.com
Date: Wed, 21 Aug 2002 13:59:53 +0900
Organization: KMN
Subject: [rt-users] installation problem

All,

I am still having problem with rt2 installation as follows.

Congratulations. RT has been upgraded. You should now check-over /opt/rt2/etc/config.pm for any necessary site customization. Additionally, you should update RT's system database objects by running /opt/rt2/etc/insertdata where is the version of RT you're upgrading from. /usr/bin/perl -I//opt/rt2/etc -I//opt/rt2/lib //opt/rt2/etc/insertdata Can't locate object method "new" via package "RT::Handle" at //opt/rt2/etc/inser tdata line 26. *** Error code 255

Stop in /usr/home/kazu/rt-2-0-14.
localhost#

Do you have any suggestion on this?

Regards,
Kazu,

Message: 9
Date: Wed, 21 Aug 2002 08:52:17 +0200
From: “Scott A. McIntyre” scott@xs4all.nl
To: RT-Users rt-users@lists.fsck.com
Subject: [rt-users] Deleting dead tickets (especially attachments)

Hi,

About a year ago there was a reference on the list to a perl script for
removing data from the database for dead tickets – unfortunately, it
looks like the web site where that was hosted, and perhaps the company
itself, no longer exist.

Does anyone have a copy? Or, does anyone have a good reference to the
location of a script/tool for pruning garbage out of a somewhat bloaty
feeling MySQL database?

As of last night to this morning I’ve noticed that adding new data to
the database takes an unreasonable amount of time – seconds to minutes,
through the command line tool, so not an Apache/mod_perl problem this
time. My hunch is that the thousands of copies of viruses we’re storing
in our 604112148 byte Attachments.MYD may have something to do with
this.

I’m not entirely comfortable in SQL yet, so any help would be
appreciated on doing this right; ideally I’d like to completely delete
dead tickets older than X days, or something convenient like that…

Thanks,

Scott A. McIntyre

Message: 10

To: rt-users@lists.fsck.com
Subject: RE: [rt-users] RT2 Speed/performance problems.
Date: Wed, 21 Aug 2002 10:06:10 +0200
Organization: Opensource-Technologies

Sorry to say this (don’t want to start any flame war), but yer one hell
of a lazy admin. What the hell do they pay you for?

If you want to pull out the best of PHP, mysql, etc… There is more to
it then just simple ./configure ; make ; make install.

I admit that first i thought RT was a nightmare to set up, now I don’t
anymore…

A.

-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com] On Behalf Of Maren S. Leizaola
Sent: Tuesday, August 20, 2002 10:14 AM
To: Dave Rolsky
Cc: David C. Troy; Rt-Users (E-mail)
Subject: Re: [rt-users] RT2 Speed/performance problems.

Well I’ve optimized the tables when stuff has been deleted but other

than that I am using mysql default installation. A totally dedicated

machine.

The default mysql config uses very little memory and doesn’t take
advantage of multiple processors as well as it could. Actually tuning

MySQL can have a big impact.

I’d also recommend to anyone that they either use Mason 1.05 or
1.1201, but not 1.10 or 1.11. 1.12 is also fine except it doesn’t
work with Perl 5.00503. The 1.10 and 1.11 releases have memory leaks
that can suck up some decent memory, so up- or down-grading is
definitely recommended. If you’re not using Mason for other
development, there’s little reason to upgrade from 1.05 for those
currently using . 1.12 does offer a lot of cool new features, but it’s

also slower.

Of course, the chances that Mason was the bottleneck in Maren’s case
are very small, since RT is most likely going to be DBMS-bound once
more than a small number of tickets have been created.

Dave,
Maybe I am picky our just a lazy admin, but I believe that
decent system sould be maintainable, should be able install them in a
snap, reconfigure them, see what it is doing. You should be able to
rebuild in under one hour or less from nothing to live.

This was what I was referring to that RT2 has gone in the wrong
direction. The installation is a nightmare if you compare it to just
about any other Open source system I have had on my machines during the
past 8 years…

Look at what you have above, you have to tune, mysql, mason, the right
version, make sure that mode perl does this, make sure that apache kills
the process after etc…

I don’t doubt that you guys love it and without it you would struggle.
Well maybe it is just me. I like systems software like postfix, Nuke,
that do their job and let me get on with what I should be doing.

Cheers,
Maren.

-dave

/==================
www.urth.org
we await the New Sun
==================
/


rt-users mailing list
rt-users@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

Message: 11
Date: Wed, 21 Aug 2002 10:15:53 +0100
From: Simon Cozens rt@netthink.co.uk
To: “Scott A. McIntyre” scott@xs4all.nl
Cc: RT-Users rt-users@lists.fsck.com
Subject: Re: [rt-users] Deleting dead tickets (especially attachments)

–zYM0uCDKw75PZbzx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Scott A. McIntyre:

About a year ago there was a reference on the list to a perl script for
removing data from the database for dead tickets – unfortunately, it
looks like the web site where that was hosted, and perhaps the company
itself, no longer exist.

Does anyone have a copy?

Yep. It’s attached.


“Irrigation of the land with seawater desalinated by fusion power is
ancient.
It’s called ‘rain’.”
– Michael McClary, in alt.fusion

–zYM0uCDKw75PZbzx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename=cleanup-dead

#!/usr/bin/perl

Steve Poirier - steve@inet-technologies.com

edited by Tim Allwine tallwine@oreilly.com

to use with RT2 and MySQL

use strict;
my $ticketnbr = 0;

BEGIN { push @INC, “/usr/local/share/rt2/lib/”; do
"/usr/local/share/rt2/etc/config.pm"; }
use RT;
(my $x=RT::Handle->new)->Connect;

my $dbh = $x->dbh() or die “Couldn’t connect to RT database”;

my $sql = q{SELECT id FROM Tickets where Status=?};
my $sth = $dbh->prepare($sql);
$sth->execute(‘dead’);

proceed with deletion

my $d_sth = $dbh->prepare(‘SELECT id FROM Transactions where Ticket=?’);
my $stid = $dbh->prepare(‘DELETE FROM Attachments WHERE TransactionId=?’);
my $sttrans = $dbh->prepare( ‘DELETE FROM Transactions WHERE Ticket=?’);
my $stwatch = $dbh->prepare( ‘DELETE FROM Watchers WHERE Value=?’);
my $stobjects =$dbh->prepare( ‘DELETE FROM ObjectKeywords WHERE
ObjectId=?’);
my $stticket = $dbh->prepare( ‘DELETE FROM Tickets WHERE id=?’);

open MAIL, ‘|mail -s “dead tickets” database@rt.oucs.ox.ac.uk’ or die $!;

print MAIL $sth->rows()," dead tickets were removed.\n\n";

while ( my ($ticketid) = $sth->fetchrow_array() ) {
#print "\nticket $ticketid is dead. Deleting: ";
$d_sth->execute($ticketid);

delete Attachments for this ticket

#print "Attachments. ";
while ( my ($transid) = $d_sth->fetchrow_array() )  {

$stid->execute($transid);
}

delete Ticket in Transactions table

#print "Transactions. ";
$sttrans->execute($ticketid);

delete Ticket in ticket in Watchers table

#print "Watchers. ";
$stwatch->execute($ticketid);

delete Ticket in ObjectKeywords table

#print "ObjectKeywords. ";
$stobjects->execute($ticketid);

delete Ticket from the Tickets table

#print "Ticket. ";
$stticket->execute($ticketid);

$ticketnbr++;

}
#print “\nDone. Deleted $ticketnbr tickets.\n\n”;

exit;

–zYM0uCDKw75PZbzx–

Message: 12
Date: Wed, 21 Aug 2002 14:21:39 +0200
From: “Scott A. McIntyre” scott@xs4all.nl
To: RT-Users rt-users@lists.fsck.com
Subject: [rt-users] Odd performance problem - returning from submissions.

Hi,

Thanks to Simon for that delete tickets script – sadly, whilst it
probably did help get rid of 6500 tickets that didn’t need to be there,
I’m still facing the same odd performance problem as earlier today.

The symptom is simple: Queries and searches are fine, but any
changes/writes to the database seem to happen quickly, but both the
command line rt tool and the web interface “stall” when waiting for the
result.

What’s peculiar is that the changes do seem to happen fast; if I make
a comment on a ticket and click on Submit, it stalls for several moments
without updating the display – however, if I have another rt window
open and put in the ticket number that I just updated, the query returns
quickly with the changes that are still ‘Loading’ in the other window.

This is new behaviour from yesterday evening, which is why I felt it was
some sort of a size issue with the database, poor indexing, etc…as a
test I’ve built a new apache with fastcgi and am running it in parallel
(to rule out mod_perl) and I felt the delay there as well, plus, as I
say, the command line tools do the same.

An rt --create produced this timing:

real 2m1.148s
user 0m0.850s
sys 0m0.100s

Which is obviously a bit drastic. This is with rt 2-0-13, on a 1Ghz
Celeron, with 512mb of RAM. RedHat Linux 7.2, and the system is
otherwise “idle” with a very low load average, enough free memory and no
errors anywhere obvious as to disk errors (IDE, MAXTOR 6L040J2).

Total number of tickets is about 39000 or so at the moment, with the
entire rt2 database taking up about 625 megabytes in /var/lib/mysql…

If anyone has any thoughts as to why just the writing/modifications
would be producing such a noticeable delay, I’d very much like to hear
them…in the mean time, I’ll keep trying to pin this down a bit
further.

Thanks,

Scott

Message: 13
Date: 21 Aug 2002 10:15:30 -0400
From: “Michael K. Brown” michael.k.brown@alcatel.com
To: “Maren S. Leizaola” maren@leizaola.com
Cc: “Rt-Users” rt-users@lists.fsck.com
Subject: RE: [rt-users] RT2 Speed/performance problems.

As a Non-IT person running a webserver with RT and PostNuke, I thought I’d
wade into the discussion:

First: I’m not a programmer, sys-admin, or have EVER had formal IT
training.
I’m an advanced computer USER who happens to be a lab technician with an
interest in computers.

Second: I set up a webserver to support my lab users and environment. I
loaded a Dual Ultra-II (UltraSparc) with 512MB of RAM and a 4GB hard disk
with Solaris 8, manually added the packages for GNU tools, PERL 5.6.1, and
then used ApacheToolbox to help with installing Apache, MySQL, and all the
required packages. It all still required tweaking to get it all running
properly with Solaris. All of my Unix/PERL/PHP/MySQL skills are self
taught, with a lot of help from google.ca and people on mailing lists like
this one.

Third: I installed RT (and I did fight with it to get all the dependancies
working), but I thought it was worth it, because RT2 was the best that I
had
seen out there, and because this list was active and people were very
helpful in doing mods and fixes.

Fourth: I modified RT2 and PostNuke to get them to do what I want them to
do. My RT pages load in 2 seconds typically, and my PostNuke pages load
in
3-5. I’m still tweaking both systems as I learn new things from the
people
on this list and on PostNuke.com. What I’ve learned over my years of
being a computer user is that nothing is ever perfect out-of-the-box, and
you only get out of it what you put into it. RT and PostNuke are both
very
extensible, well-designed systems, and I think that you can get a lot from
those systems if you’re willing to put some time into them! My $0.02
worth… (before taxes!)

Lastly, I would like to thank all the RT-User’s Listers for all their
assistance, especially Rich Lafferty, Phil Homewood, Michael Grubb, Mike
Quitero, Smylers, Bruce Campbell and Paul Rossman (and anyone else who’s
helped me out in the past that I might have missed!)

/Mike
Lab Services
Alcatel BND

-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]On Behalf Of Maren S. Leizaola
Sent: Tuesday, August 20, 2002 3:43 AM
To: Rich Lafferty
Cc: Rt-Users (E-mail)
Subject: Re: [rt-users] RT2 Speed/performance problems.

3-10 seconds is the norm, for us it does not cut it.

So yours takes 5-10x as long as mine when I use Mozilla, but runs on
faster hardware. Still think it’s RT?

Well this is what I see…

The board is an ASUS P2BF-D (old but great board), with two PII 450Mhz,
the machine has 512MB of RAM, the disks are running on a promise raid
TX2-100. The disks are idle, the HTTP deamons eat CPU like there is no
tomorow, and they inflate themselves like zepplins, even with only one
user.

I also think that RT UI is designed for large teams and the number of
clicks at the interface are execessive for smaller support teams. Less
clicks more speed more e-mails out. With RT1 we could respond about 10% of
e-mails in under 5 mins, as it was quick and nimble.

Cheers,
Maren.

-Rich


Rich
Lafferty --------------±----------------------------------------------
Ottawa, Ontario, Canada | Save the Pacific Northwest Tree Octopus!
http://www.lafferty.ca/ | http://zapatopi.net/treeoctopus.html

rich@lafferty.ca -----------±----------------------------------------------

unsubscribe

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Samantha Lacy
Computing Technology Services
Washington University in St. Louis
Unix Systems Administrator
lacy@cts.wustl.edu
314.935.5882 - Phone
314.935.7302 - Fax
Office: 406d Lopata Hall

unsubscribeFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Todd
Chapman
Sent: Tuesday, February 03, 2004 1:36 PM
To: Aaron Turner
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Adding additional status option

I’m just sugggesting the the Ticket’s status is Open, but
that for one queue you could have a sub-status that is more
specific.

However the code is there and you can do what you want…

-Todd

Well that would suck for obvious reasons. A tool like RT should
adapt to the user’s needs, not the other way around. I understand
that right now it doesn’t support this, but that doesn’t mean
the custom work around is the “correct solution”.

It sounds like you should be using a custom field for the queue.

-Todd

Hi Tim,

I asked a simular question not long ago, didn’t get an answer,
but I can tell you what I do know.

You’re right that there’s no table. The different status’s are listed
in the Queue_Overlay.pm file. You’ll need to add it to either the
@ACTIVE_STATUS or @INACTIVE_STATUS array’s and add the appropriate
comment line below (not sure why, just seems that way… if it doesn’t
make sense right now, it will when you edit the file.)

The only problem I have is that changes here are global, not specific
to one queue. So if you have a bunch of queues, and only want to
change

one of them… you’re kinda SOL. If you figure out how to limit it to
a single queue, by all means let me know. :slight_smile:

-Aaron

Hi everyone,

I’ve looked through the RT database and it appears that there’s no
table

that contains the list of predetermined ticket status options (e.g.,
new,

open, resolved, etc.) I’d like to add another one, “At repair,” to
indicate

that a particular piece of equipment is in the shop. I haven’t found
any

clues in the list archives either.

If it’s not in the database, where should I add that?


rt-users mailing list
rt-users@lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


Aaron Turner aturner@netscreen.com work: 408-543-4025
Sr. Security Engineer fax: 408-543-4078
NetScreen Technologies, Inc
All emails by me are PGP signed; a bad signature indicates a forgery.

rt-users mailing list
rt-users@lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

how does one go about removing themselves from this list? I seem to be
perplexed and unable to register the proper procedure.

Robert Gorman
ChannelPlus/Open House Tech Services
1.800.999.5225

The info is contained in the message header of each message. I’ve copy and pasted the relevant info:

List-Id: For users of RT: Request Tracker <rt-users.lists.bestpractical.com>
List-Help: mailto:rt-users-request@lists.bestpractical.com?subject=help
List-Post: mailto:rt-users@lists.bestpractical.com
List-Subscribe: http://lists.bestpractical.com/mailman/listinfo/rt-users,
mailto:rt-users-request@lists.bestpractical.com?subject=subscribe
List-Archive: http://lists.fsck.com/pipermail/rt-users
List-Unsubscribe: http://lists.bestpractical.com/mailman/listinfo/rt-users,
mailto:rt-users-request@lists.bestpractical.com?subject=unsubscribe

Hope this helps

-Evan-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Robert Gorman
Sent: March 23, 2004 10:38 AM
To: rt-users@lists.fsck.com
Subject: [rt-users] unsubscribe

how does one go about removing themselves from this list? I seem to be perplexed and unable to register the proper procedure.

Robert Gorman
ChannelPlus/Open House Tech Services
1.800.999.5225

how does one go about removing themselves from this list? I seem to be
perplexed and unable to register the proper procedure.

Please note the footer that is appended to every rt-users message. It
includes a url, which lets you do things like unsubscribe. I realize
it’s very hard to read a footer, and much easier to spam all 1800
people instead, but please refrain.

seph

unsubscribe

Regards,
Bryce Porter
ShellShark Networks
Owner

Bryce Porter wrote:

unsubscribe

Regards,
Bryce Porter
ShellShark Networks
Owner


151 Shadoway Dr.
East Peoria, IL 61611

p. 309.698.5584 x103
f. 425.606.3294
e. bryce@shellshark.net
w. www.shellshark.net



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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Resistance is futile!

Mathew Borger

unsubscribe

Thanks,

Sudhir Damle

Keith A McDermott wrote:

Ignore. Someone showed me how to turn on DBI_Trace (which I’m liking
quite a bit) and, I will admit, I found a subtle password mis-type I’ve
missed for the past few weeks of tinkering. Fix that, revert a few code
changes and voila - RT works.

Thanks for the help,
Keith

Keith A McDermott wrote:

More Info:

I can successfully connect through mysql command line tools, php test
script and through a test perl script with the default apache2 config.
This all leads me to it being something with RT’s setup specifically.
Once I switch back to the RT apache config RT fails to connect to the
db. This is when trying to connect from perl 5.8.8, apache2.2.3. The
local database was 5.0.32 which worked fine whereas the remote database
is 4.0.24 which does meet the minimum required version in the docs.

Any other ideas I can try?

Thanks,
Keith

Raed El-Hames wrote:

Hi Keith;

Most likely the problem is with the @hostname bit not being recognised
correctly …(and cauing permissions problems)
try to login with rt_user from your rt server to the database via
mysql client and tail your sql server log files to determine why
rt_user is being denied.

Regards;
Roy

Keith A McDermott wrote:

Thanks Odhiambo,

Yes - I can connect fine through the standard mysql tools from the same
host without issue however, I was trying “rt_user” previously. It
actually does fail when connecting with “rt_user@hostname”. As I
manually moved the database over, manually create the user and manually
granted the rights (I don’t want to run make initialize-database against
our very stable and department-wide mysql server), I’ll look through and
see what else I need to do.

Keith

Odhiambo Washington wrote:

Hi there,

I'm moving forward with my testing of RT 3.8.2.

Setup:
Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch.  

Web port
is forwarded to the virtual machine through the host but otherwise
there
is no access to the VM. I moved the database onto a production
database
server.

RT_SiteConfig.pm has been altered to say:
$DatabaseHost is set to dbproductionserver
$DatabaseRTHost is set to the hostname of the vm host machine

Problem:
In the apache error logs, I get:
DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) 

failed:
Access denied for user: ‘rt_user@hostmachineHostname’ (Using
password:
YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 106
[Tue Mar 31 08:58:05 2009] [error] [client
hostmachine.ip.goes.here]
Connect Failed Access denied for user:
‘rt_user@hostmachineHostname’
(Using password: YES)\n at /opt/rt3/bin/…/lib/RT.pm line 204\n

And I get a 500 server error page returned to me.  However, I 

can use
the mysql command line tools from the virtual machine and connect
just fine.

Is there possibly a port that's being expected to be open that i
need to
forward or something else that I'm missing?  This seemed like a 

pretty
straightforward change in the beginning…

It should be straighforward just as you say.
Have you tested manually connecting to the DB like:

mysql -h dbproductionserver -urt_user@hostmachineHostname -pSec3t rt

?? Did it work?

If not, then go to the dbproductionserver and give the necessary
privileges for rt_user to connect:

mysql> GRANT ALL ON rt.* TO rt_user@hostmachineHostname IDENTIFIED BY
"Sec3t";
mysql> flush privileges;


Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223


“The only time a woman really succeeds in changing a man is when he is
a baby.”
- Natalie Wood


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Steven Gott
eCommerce Intelligence
http://www.eComIQ.com
800-930-5908, Ext 7
Google Analytics Authorized Consultan

unsubscribe

Attention:
The contents of this email and any attachments is intended only for the named recipients to which it is addressed. The information contained in this email communication may be confidential or may contain legally privileged information or copyright material. You should only read, disclose, re-transmit, copy or act in reliance on the information if you are authorised to do so. If you are not the intended recipient of this email communication, please notify the sender immediately and then destroy any electronic or paper copy of this message. Aero-Care Pty Ltd, Aero-Care Flight Support Pty Ltd or a related entity, does not represent, warrant or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, spam, malware or interference.

For further information about Aero-Care, please see our website at http://www.aerocare.com.au

Please consider the environment before printing this email

unsubscribe

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. DBD::mysql version 4.002 required--this is only version
   3.0007 at ./upgrade-mysql-schema.pl (Pravinator)
2. Handling a ticket that contains MANY comments.... (Chris Hall)
3. Re: Handling a ticket that contains MANY comments....
   (Kenneth Marshall)
4. Re: Handling a ticket that contains MANY comments....
   (Steve Anderson)
5. Re: Handling a ticket that contains MANY comments.... (Chris Hall)

Message: 1
Date: Fri, 22 Apr 2011 03:13:30 -0700 (PDT)
From: Pravinatorramprem@gmail.com
To: rt-users@lists.bestpractical.com
Subject: [rt-users] DBD::mysql version 4.002 required–this is only
version 3.0007 at ./upgrade-mysql-schema.pl
Message-ID:31455543.post@talk.nabble.com
Content-Type: text/plain; charset=us-ascii

Hi guys,

Just need some help with the above error message (as in subject).

I get that when I try to upgrade the MySQL schema. I tried manually
installing version DBD::MySQL 4.002 (tarball) but ended up with a host of
errors. I can’t find a yum repo even to update perl-DBD-MySQL from version
3.0 to 4.0.

What do I do? I’m just one step away from having my old DB functioning in my
new RT but whats so close seems so far away.

Thanks guys
Pravin

Brian Carpenter
Network& Allscripts Systems Analyst
Homecare& Hospice of WNY
1225 West State St, Olean NY 14760
(716)372-2106
bcarpenter@homecare-hospice.org

CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for the use of the addressee and may contain information that is privileged and confidential. If you are not the intended recipient, any dissemination of this communication is prohibited. If you have received this transmission in error, please notify the sender immediately by email and delete the original message. Thank you.

unsubscribe