Help

I recently had some clown send over 2000 tracker messages to the server we used for our RT tracker.
This of course clogged the system up, and I needed to know how to remove just these tracker issues
from the system without having to dump the database files as a friend recommended.

I am really new to the system and need if possible the SQL command to get rid of
this access tracker issues. I also would like to know how to backup and remove
older years of tracker issues.

HELP…

First; this should go to rt-users, not rt-devel.

|+ I recently had some clown send over 2000 tracker messages to the server we used for our RT tracker.
|+ This of course clogged the system up, and I needed to know how to remove just these tracker issues
|+ from the system without having to dump the database files as a friend recommended.

Why not go to the search menu, search for the tickets in question (I am
assuming they have a common element, like subject, or email address, or
something), select ‘Update all these tickets at once’, if there are some
tickets you don’t want to update, unselect the ‘Update’ box, then change
the status to ‘Dead’.

|+ I am really new to the system and need if possible the SQL command to get rid of
|+ this access tracker issues. I also would like to know how to backup and remove
|+ older years of tracker issues.

Its not really adviced to delete older tickets. Thats one of the
features of a database, store all your information, have it available to
you at anytime via a search. Would suck if you needed a ticket from 3
years ago, and you had deleted it from teh system. You’d have to then
put the old information up somewhere where its accessable.

-darrin (cc’ing rt-users. questions asking for help should go there)

“TJG” == Ted J Green bishop@totalaccess.net writes:

TJG> I recently had some clown send over 2000 tracker messages to the
TJG> server we used for our RT tracker. This of course clogged the
TJG> system up, and I needed to know how to remove just these tracker
TJG> issues from the system without having to dump the database files
TJG> as a friend recommended.

We had a mailer loop caused by a misconfiguration that once created
500 or so tickets. What I did was do a search on the some matching
criteria, clicked on “update all these tickets at once” and marked
them dead. Repeat until all are done.

If RT’s database had referential integrity with cascade on delete, one
could probably issue a single delete query to the database to clear
out those tickets and all associated records. Alas, it does not have
the references (since MySQL doesn’t support them).

First; this should go to rt-users, not rt-devel.

|+ I recently had some clown send over 2000 tracker messages to the server we used for our RT tracker.
|+ This of course clogged the system up, and I needed to know how to remove just these tracker issues
|+ from the system without having to dump the database files as a friend recommended.

Why not go to the search menu, search for the tickets in question (I am
assuming they have a common element, like subject, or email address, or
something), select ‘Update all these tickets at once’, if there are some
tickets you don’t want to update, unselect the ‘Update’ box, then change
the status to ‘Dead’.

Hello rt-users,

I once was desparate when some junkie sent us 50 e-mails on the same subject and I though
the best thing was to delete them. I tried the --help opt of the rt binary but no reference
was there to delete. So I just wanted to ask what the effect of “Dead” is? Is it the best
option we have instead of deleting. If that is the case, I also want to mention that when
I am in a queue’s listing, under search criteria there appears:

Search Criteria
New search
Bookmarkable URL for this search

Queue = cs [delete]
Status = open [delete]
Status = new [delete]

What does the [delete] do? It doesn’t seem to do anything in my case. Of course I could be
dumb on this, having missed some part of TFM :wink:

-Wash

Odhiambo Washington wash@wananchi.com “The box said ‘Requires
Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,’
Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD.”
GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :slight_smile:
She missed an invaluable opportunity to give him a look that you could
have poured on a waffle …

Odhiambo Washington wrote:

First; this should go to rt-users, not rt-devel.

|+ I recently had some clown send over 2000 tracker messages to the server we used for our RT tracker.
|+ This of course clogged the system up, and I needed to know how to remove just these tracker issues
|+ from the system without having to dump the database files as a friend recommended.

Why not go to the search menu, search for the tickets in question (I am
assuming they have a common element, like subject, or email address, or
something), select ‘Update all these tickets at once’, if there are some
tickets you don’t want to update, unselect the ‘Update’ box, then change
the status to ‘Dead’.

Hello rt-users,

I once was desparate when some junkie sent us 50 e-mails on the same subject and I though
the best thing was to delete them. I tried the --help opt of the rt binary but no reference
was there to delete.

For referential inegrity reasons, there is no advertized way to delete tickets
from an existing RT database. You would need to use a special add on for that
(in the contribution area, in the CensorWare folder) if You really want to do
it (and risk screwing up Your database).

So I just wanted to ask what the effect of “Dead” is? Is it the best
option we have instead of deleting. If that is the case, I also want to mention that when
I am in a queue’s listing, under search criteria there appears:

Dead is used by the above mentioned Censorware script. It might be, that dead
tickets are not auto-opened by replies or such, and it might be they are not
shown in searches matching otherwise unless the dead status is explicitly in
Your search expression, but I don’t know actually.

[snip]

Queue = cs [delete]
Status = open [delete]
Status = new [delete]

What does the [delete] do? It doesn’t seem to do anything in my case. Of course I could be
dumb on this, having missed some part of TFM :wink:

The delete deletes that token from Your search expression. The above would
look into queue cs where the status is open or new. Would You delete the Queue
qualifier, it would show all tickets that are open or new, regardless of Queue.

Regards,
Harald

PS: By the way: Your sig is not McQ, or I don’t know what the ++ means

Harald WagenerAn der Alster 4220099 Hamburg*http://www.fcb-wilkens.com