Using RTx::shredder (v0.06)

RT Users
1

How can I use RTx shredder (v0.06) to do the following:

Permanently remove users and tickets? The tickets have been deleted, but do I
need to remove it from the database?

rtx-shredder - Script which wipe out tickets from RT DB - metacpan.org has some syntax,
but I’m not 100% certain on how to proceed.

Does the below example permanently remove tickets from the queue “General” even
though the tickets have been deleted? (ie. status,deleted) Additionally, does
this reset the ticket numbering? (ie. remove #11-20, next new ticket is #11,
12, and so on)

rtx-shredder --plugin ‘Tickets=status,deleted;queue,general’

And does rtx-shredder --plugin ‘Users=’ remove the user?

I like to be certain of the syntax before touching the database, thank you for
your help.

Regards,

Mike

Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.

2

How can I use RTx shredder (v0.06) to do the following:

Permanently remove users and tickets? The tickets have been deleted, but do I
need to remove it from the database?
No need in general case, as I know most users of a shredder cleanup
spam using it or tickets with big mail loops.

rtx-shredder - Script which wipe out tickets from RT DB - metacpan.org has some syntax,
but I’m not 100% certain on how to proceed.

Does the below example permanently remove tickets from the queue “General” even
though the tickets have been deleted? (ie. status,deleted) Additionally, does
It’s exactly shredder’s task to delete records from the DB, however
shredder writes dumps so you can restore things.

this reset the ticket numbering? (ie. remove #11-20, next new ticket is #11,
12, and so on)
no, it doesn’t. You can do it using DB’s features, but I don’t
recommend it as it wouldn’t allow you to restore tickets from dumps.

rtx-shredder --plugin ‘Tickets=status,deleted;queue,general’
this call delete 10 (see option limit) tickets in general queue with
status equal to deleted.

And does rtx-shredder --plugin ‘Users=’ remove the user?
yes, however it deletes only disabled users.

I like to be certain of the syntax before touching the database, thank you for
your help.
I recommend people to be accurate, but I did tried to write this tool
as safe as possible, it had bugs, in all cases that were bugs related
to leaving some info in the DB, but not deleting more than you ask.

Regards,

Mike

Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
Turbify.com | Buy a Domain | Websites & Domains | Purchase a URL - Turbify

Best regards, Ruslan.

3

rtx-shredder --plugin ‘Tickets=status,deleted;queue,general’
this call delete 10 (see option limit) tickets in general queue with
status equal to deleted.

Excellent, the above command works, and it writes an SQL timestamped file.

And does rtx-shredder --plugin ‘Users=’ remove the user?
yes, however it deletes only disabled users.

I searched for disabled users and the user “Mike” does shows up in RT.
However, I cannot removed the disabled user. The below command returns as
follow, and the SQL file is empty

rtx-shredder --plugin ‘Users=Mike’
SQL dump file is ‘/opt/rt3/local/sbin/20070802T214537-0001.sql’
Couldn’t load plugin
Error: Plugin doesn’t support argument(s): Mike

Regards,

Mike

Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz

4

rtx-shredder --plugin ‘Tickets=status,deleted;queue,general’
this call delete 10 (see option limit) tickets in general queue with
status equal to deleted.

Excellent, the above command works, and it writes an SQL timestamped file.

And does rtx-shredder --plugin ‘Users=’ remove the user?
yes, however it deletes only disabled users.

I searched for disabled users and the user “Mike” does shows up in RT.
However, I cannot removed the disabled user. The below command returns as
follow, and the SQL file is empty

rtx-shredder --plugin ‘Users=Mike’
SQL dump file is ‘/opt/rt3/local/sbin/20070802T214537-0001.sql’
Couldn’t load plugin
Error: Plugin doesn’t support argument(s): Mike
rtx-shredder --plugin ‘Users=name,Mike’

syntax is --plugin
‘PluginName=ArgumentName,ArgumentValue;ArgumentName,ArgumentValue’
may be it’s crappy, but I didn’t come up with a better one and nobody
suggested something better.

Regards,

Mike

  ____________________________________________________________________________________

Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
graduation gifts - Yahoo Search Results

Best regards, Ruslan.

5

rtx-shredder --plugin ‘Users=name,Mike’

syntax is --plugin
‘PluginName=ArgumentName,ArgumentValue;ArgumentName,ArgumentValue’
may be it’s crappy, but I didn’t come up with a better one and nobody
suggested something better.

Doh! on my part. The syntax is good, I need to be a bit more familiar with it.
Thanks for the help and the application.

Regards,

Mike

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more.
http://mobile.yahoo.com/go?refer=1GNXIC