[rt-users] Shredder User plugin not working

[Steven Saner]

I am running RT 4.4 and it seems that the User plugin for the shredder
isn't working quit right. That, or I just don't know how to use it.

I'm trying to get rid of Users for which there are no tickets. I've
tried to set both the "no_tickets" argument and the
"no_ticket_transactions" argument to true and in either case it returns
no results at all.

To sort of prove that that there should be results, I found a spam
ticket that was created just the other day by a new user that was
created at the same time the ticket was created. The ticket was
"deleted" and I shredded said ticket. Yet I still can't get the User
plugin of the shredder to find that user. Even if I search by the name
or email address.

I note that the "no_ticket_transactions" argument is new with version
4.4. Are there some known bugs associated with it?

Steve

-- 
--
Steven Saner   Voice:  316-858-3000
Director of Network Operations  Fax:  316-858-3001
Hubris Communicationshttp://www.hubris.net
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016

Re: [rt-users] shredder on specific user

[Kevin Falcone]

On Mon, Aug 04, 2014 at 12:22:52AM +, Hal Douglas wrote:
 Thomas Sibley trs at bestpractical.com writes:
  On 05/16/2013 05:14 PM, Philip Brown wrote:
   After doing a few searches, it seems that using the rt-shredder tool
   is the one true way to delete a user.
   
   Unfortunately... i find the documentation on it, inscruitable :(
   
   Could someone please give me a simple, straightforward commandline to
   delete user X?
   
   I was hoping it would be as simple as
   
   
   rt-shredder --plugin User name=doomeduser
   
   but that does not seem to be adequate.
  
  The format is incorrect.  --plugin takes a single argument, but you've
  space separated it and hence it's two.  See
  http://bestpractical.com/rt/docs/latest/rt-shredder.html for the proper
  format; you're close.
  
  Alternatively, use the admin web interface instead of the command line.
   Select Users from the object type and then enter doomeduser in the
  Name field.  If the user isn't disabled, either disable them first or
  enter enabled in the status field (which defaults to disabled if
  empty, for safety).
 
 Okay, so I was trying to do the same thing myself and struggling just as
 much with the documentation as the original poster was.
 
 After banging my head against the keyboard for a while I worked it out, so I
 recorded in this blog post:
 
 http://sysadministrivia.blogspot.com.au/2014/08/deleting-user-from-rt-using-shredder.html
 
 I thought I'd post back with the answer in the hope it might help the next

The more durable and lasting thing would probably be a documentation
patch.

-kevin


pgpeHlnmC5BCA.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] shredder on specific user

[Hal Douglas]

Thomas Sibley trs at bestpractical.com writes:

 
 On 05/16/2013 05:14 PM, Philip Brown wrote:
  After doing a few searches, it seems that using the rt-shredder tool
  is the one true way to delete a user.
  
  Unfortunately... i find the documentation on it, inscruitable :(
  
  Could someone please give me a simple, straightforward commandline to
  delete user X?
  
  I was hoping it would be as simple as
  
  
  rt-shredder --plugin User name=doomeduser
  
  but that does not seem to be adequate.
 
 The format is incorrect.  --plugin takes a single argument, but you've
 space separated it and hence it's two.  See
 http://bestpractical.com/rt/docs/latest/rt-shredder.html for the proper
 format; you're close.
 
 Alternatively, use the admin web interface instead of the command line.
  Select Users from the object type and then enter doomeduser in the
 Name field.  If the user isn't disabled, either disable them first or
 enter enabled in the status field (which defaults to disabled if
 empty, for safety).
 


Okay, so I was trying to do the same thing myself and struggling just as
much with the documentation as the original poster was.

After banging my head against the keyboard for a while I worked it out, so I
recorded in this blog post:

http://sysadministrivia.blogspot.com.au/2014/08/deleting-user-from-rt-using-shredder.html

I thought I'd post back with the answer in the hope it might help the next
person.

Thanks.

Hal.


-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Shredder location

[Keith Macpherson]

mmahoney wrote, On 14/11/2013 17:23:
 Please excuse my ignorance... how do you make the file writable to the web
 server?

Like Andrew said, you need to chown the RT-Shredder folder to the web
server user; the user Apache/Nginx/whatever, is running as. Once you
have that information use chown (man chown for more info) on the folder,
for example 'chown webuser:webgroup /opt/rt3/var/data/RT-Shredder'. You
may have to check permissions too.

- Keith

Re: [rt-users] Shredder location

[mmahoney]

Please excuse my ignorance... how do you make the file writable to the web
server?



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Shredder-location-tp45462p55823.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

[rt-users] shredder on specific user

[Philip Brown]

After doing a few searches, it seems that using the rt-shredder tool 
is the one true way to delete a user.


Unfortunately... i find the documentation on it, inscruitable :(

Could someone please give me a simple, straightforward commandline to 
delete user X?


I was hoping it would be as simple as


rt-shredder --plugin User name=doomeduser


but that does not seem to be adequate.





--
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] shredder on specific user

[Thomas Sibley]

On 05/16/2013 05:14 PM, Philip Brown wrote:
 After doing a few searches, it seems that using the rt-shredder tool
 is the one true way to delete a user.
 
 Unfortunately... i find the documentation on it, inscruitable :(
 
 Could someone please give me a simple, straightforward commandline to
 delete user X?
 
 I was hoping it would be as simple as
 
 
 rt-shredder --plugin User name=doomeduser
 
 but that does not seem to be adequate.

The format is incorrect.  --plugin takes a single argument, but you've
space separated it and hence it's two.  See
http://bestpractical.com/rt/docs/latest/rt-shredder.html for the proper
format; you're close.

Alternatively, use the admin web interface instead of the command line.
 Select Users from the object type and then enter doomeduser in the
Name field.  If the user isn't disabled, either disable them first or
enter enabled in the status field (which defaults to disabled if
empty, for safety).



-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[rt-users] Shredder - remove class - name of argument

[Alexander Kucheryuk]

Hi!
I am using shredder - objects plugin to remove a class (the one that is 
assigned to article). What is the name of the argument for that ? I have 
tried class and classes but it didn't work.

Re: [rt-users] Shredder - remove class - name of argument

[Ruslan Zakirov]

On Mon, Apr 15, 2013 at 3:20 PM, Alexander Kucheryuk 
alex.kucher...@eltoma-offshore.com wrote:

 Hi!
 I am using shredder - objects plugin to remove a class (the one that is
 assigned to article). What is the name of the argument for that ? I have
 tried class and classes but it didn't work.


RT::Class

-- 
Best regards, Ruslan.

[rt-users] Shredder - remove dashboard and classes

[Alexander Kucheryuk]

Hi!

Which fields do I need to use for shredder to remove :

 * Dashboard
 * Classes (used in Articles)

Re: [rt-users] Shredder - remove dashboard and classes

[Kevin Falcone]

On Fri, Apr 12, 2013 at 01:06:46PM +0300, Alexander Kucheryuk wrote:
Which fields do I need to use for shredder to remove :

Are you trying to delete a lot of these, because the Delete button on
Dashboards does actually delete from the database.

  * Dashboard
  * Classes (used in Articles)

In both cases you need to use the Object plugin and point at
Attributes for Dashboard and Classes along with the specific id.  Keep
in mind that Shredder has no special logic for either of these, so
you'll want to be sure you clean up articles before cleaning up
Classes, otherwise you'll have a bunch of orphaned objects.

-kevin


pgpim2aMx2WD5.pgp
Description: PGP signature

Re: [rt-users] Shredder - remove dashboard and classes

[Alexander Kucheryuk]

This seems like a silly question but where is delete button to remove 
dashboards ? Where is it physically located ?


In regards to classes, which field do I use in shredder - objects ?

On 12/4/2013 5:24 PM, Kevin Falcone wrote:

On Fri, Apr 12, 2013 at 01:06:46PM +0300, Alexander Kucheryuk wrote:

Which fields do I need to use for shredder to remove :

Are you trying to delete a lot of these, because the Delete button on
Dashboards does actually delete from the database.


  * Dashboard
  * Classes (used in Articles)

In both cases you need to use the Object plugin and point at
Attributes for Dashboard and Classes along with the specific id.  Keep
in mind that Shredder has no special logic for either of these, so
you'll want to be sure you clean up articles before cleaning up
Classes, otherwise you'll have a bunch of orphaned objects.

-kevin

Re: [rt-users] Shredder - remove dashboard and classes

[Alexander Kucheryuk]

I can't find the name of the argument for classes. I tried Class and 
Classes but it says invalid argument.


On 12/4/2013 5:40 PM, Kevin Falcone wrote:

On Fri, Apr 12, 2013 at 05:29:40PM +0300, Alexander Kucheryuk wrote:

This seems like a silly question but where is delete button to
remove dashboards ? Where is it physically located ?

On the Basics page.  This assumes your user has the appropriate
Delete*Dashboard right.


In regards to classes, which field do I use in shredder - objects ?

http://bestpractical.com/rt/docs/latest/RT/Shredder/Plugin/Objects.html

-kevin

[rt-users] Shredder object plugin not working

[Alexander Kucheryuk]

Hi!
Running Centos 6.3 32bit with RT 4.1.0.
When I am trying to use Shredder Objects extension from web GUI I get 
the following error:
Shredder couldn't load object. Most probably it's not fatal error. May 
be you've used Objects plugin and asked to delete object that doesn't 
exist in the system. If you think that your request was correct and 
it's problem of the Shredder then you can get full error message from 
RT log files and send bug report.

When running this extension from CLI I get the following error:
[root@centos www]# /usr/local/rt/sbin/rt-shredder --plugin 
'Objects=Queue,General'

SQL dump file is '/var/www/20130405T092111-0001.sql'
[Fri Apr  5 09:21:11 2013] [critical]: Loaded object has different id 
at /usr/local/rt/sbin/../lib/RT/Shredder.pm line 366. 
(/usr/local/rt/sbin/../lib/RT.pm:356)
Loaded object has different id at 
/usr/local/rt/sbin/../lib/RT/Shredder.pm line 366.

Output of RT log
[Fri Apr  5 09:22:29 2013] [critical]: Loaded object has different id 
at /usr/local/rt/sbin/../lib/RT/Shredder.pm line 366. 
(/usr/local/rt/sbin/../lib/RT.pm:356)

I am trying to remove a queue using it.
What could be causing it / where should I be digging  ?

Re: [rt-users] Shredder object plugin not working

[Kevin Falcone]

On Fri, Apr 05, 2013 at 12:23:06PM +0300, Alexander Kucheryuk wrote:
Running Centos 6.3 32bit with RT 4.1.0.

I assume you mean 4.0.1

When I am trying to use Shredder Objects extension from web GUI I get the 
 following error:
 
  Shredder couldn't load object. Most probably it's not fatal error. May 
 be you've used
  Objects plugin and asked to delete object that doesn't exist in the 
 system. If you think
  that your request was correct and it's problem of the Shredder then you 
 can get full error
  message from RT log files and send bug report.
 
When running this extension from CLI I get the following error:
 
  [root@centos www]# /usr/local/rt/sbin/rt-shredder --plugin 
 'Objects=Queue,General'
  SQL dump file is '/var/www/20130405T092111-0001.sql'
  [Fri Apr  5 09:21:11 2013] [critical]: Loaded object has different id at
  /usr/local/rt/sbin/../lib/RT/Shredder.pm line 366. 
 (/usr/local/rt/sbin/../lib/RT.pm:356)
  Loaded object has different id at 
 /usr/local/rt/sbin/../lib/RT/Shredder.pm line 366.

The Object plugin wants an id, not a name.
rt-shredder --plugin 'Objects=Queue,1'
would delete the first Queue.  You can find the id on the Admin Queues
page.

It's throwing an error for you because it tries to compare the 'id'
you fed it (General) to the id it found in the database, and of course
General != 1.  This could be made smarter, but it would be kind of
tricky.

-kevin


pgpZkyNtOS3b5.pgp
Description: PGP signature

[rt-users] Shredder not shredding attachments?

[Arnon Clark]

So I'm running validator and getting the following error for a few tickets :

example :

Record #600816 in Attachments references not existent record in Attachments
Parent = '600813' = id
Attachment #600816 - Txn #1567423, Transaction #1567423 - object 
RT::Ticket #187697


I attempted to fix this using shredder for ticket ID 187697 
(succesfully), but am still getting the error. How do I shred the 
attachment itself? I'm afraid I'm not sure what the query would be.


Many thanks for any assistance

Arnon






We're hiring! http://bestpractical.com/jobs

Re: [rt-users] Shredder location

[Rabin Yasharzadehe]

If you about to shred a lot of data use the CLI and not the web-interface

*---
Rabin Yasharzadehe*



On Fri, Jun 29, 2012 at 9:19 PM, Chris Preston ch...@thetrafalgartravel.com
 wrote:

  Hello all,

 I am trying to shred some tickets data and when I click on the shredder
 icon, I get a message

 ** **

 Shredder needs a directory to write dumps to. Please check that you have
 span class=file-path/opt/rt3/var/data/RT-Shredder/span and it is
 writable by your web server. 

 ** **

 I created a folder opt/rt3/var/data/RT-Shredder but when I re run I still
 get the message.  What else do I need to do

 ** **

 Regards

 ** **

[rt-users] Shredder location

[Chris Preston]

Hello all,

I am trying to shred some tickets data and when I click on the shredder
icon, I get a message

 

Shredder needs a directory to write dumps to. Please check that you have
span class=file-path/opt/rt3/var/data/RT-Shredder/span and it is
writable by your web server. 

 

I created a folder opt/rt3/var/data/RT-Shredder but when I re run I still
get the message.  What else do I need to do

 

Regards

 

Re: [rt-users] Shredder location

[Andrew Marosi]

Make sure you have chown that folder by the web server user
-Andy

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Chris Preston
Sent: Friday, June 29, 2012 11:19 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Shredder location

Hello all,
I am trying to shred some tickets data and when I click on the shredder icon, I 
get a message

Shredder needs a directory to write dumps to. Please check that you have span 
class=file-path/opt/rt3/var/data/RT-Shredder/span and it is writable by 
your web server.

I created a folder opt/rt3/var/data/RT-Shredder but when I re run I still get 
the message.  What else do I need to do

Regards

[rt-users] Shredder - some tips

[Mike Johnson]

Hi everyone,

I'm looking at shredding a ton of old data from our system and I want to
make sure I am understanding the steps involved to ensure everything is
cleaned up properly.

I have shredder setup and have shredded some tickest through the WebUI to
test things out. All is working in that aspect.

My RT instance has had a fairly long lifecycle where queues have come and
gone. I want to clean up the mess. I want to shred all the stuff that isn't
related to anything recent.

I'm thinking I have to do the following:
- shred all the tickets that aren't in the active queues
- shred all users that aren't attached to anything

On the Shredder page of the Wiki it talks about running rt-validator.

Do I have to run this at all after I've done the shredding?


This is going to shred about 30,000 tickets, and a huge number of Users.
Does the shredding have to be done on a quiet system? I've shred a few
tickets while we were live without issue... I'm just worried that I kick
off a process to shred a large volume and it chokes my server out.

Any experience/input is appreciated.

Thanks!
Mike.

-- 
Mike Johnson
Datatel Programmer/Analyst
Northern Ontario School of Medicine
955 Oliver Road
Thunder Bay, ON   P7B 5E1
Phone: (807) 766-7331
Email: mike.john...@nosm.ca

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5  6, 2012

Re: [rt-users] Shredder - some tips

[Brent Wiese]

snip


This is going to shred about 30,000 tickets, and a huge number of Users. Does 
the shredding have to be done on a quiet system? I've shred a few tickets while 
we were live without issue... I'm just worried that I kick off a process to 
shred a large volume and it chokes my server out.

Any experience/input is appreciated.

You can limit the number of tickets it shreds with the ; limit, x in the 
plugins line. Ie:
--plugin Tickets=query,Status='deleted';limit,0

Limit of 0 means everything. But you could set that to 100 or 1000 and see how 
it affects your system and then make the call on how many to shred at a time.

Brent


RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5  6, 2012

Re: [rt-users] Shredder not deleting some transactions

[Ruslan Zakirov]

On Wed, Aug 10, 2011 at 2:22 AM, Kenneth Crocker kfcroc...@lbl.gov wrote:
 Ruslan,

 Well, to be honest, I can't blame Shredder. Some years ago a person here
 deleted some users, etc manually. I'm using Shredder to clean it all up. So
 I'm sure there were some disconnects left in there.

Then for sure you should start from rt-validator tool. It as well can
--resolve some
problems by deleting records, in a few cases it can create records to
resolve problem.

 Thanks.

-- 
Best regards, Ruslan.

RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA  September 26  27, 2011
*  San Francisco, CA, USA  October 18  19, 2011
*  Washington DC, USA  October 31  November 1, 2011
*  Melbourne VIC, Australia  November 28  29, 2011
*  Barcelona, Spain  November 28  29, 2011

Re: [rt-users] Shredder not deleting some transactions

[Kenneth Crocker]

Ruslan,

Yep. I thought of that. IT stopped before it started. Now that I've run
shredder, perhaps I can do that again. Between the two apps, I should be
able to pound this out.

Thanks.

Kenn

On Wed, Aug 10, 2011 at 4:34 AM, Ruslan Zakirov r...@bestpractical.comwrote:

 On Wed, Aug 10, 2011 at 2:22 AM, Kenneth Crocker kfcroc...@lbl.gov
 wrote:
  Ruslan,
 
  Well, to be honest, I can't blame Shredder. Some years ago a person here
  deleted some users, etc manually. I'm using Shredder to clean it all up.
 So
  I'm sure there were some disconnects left in there.

 Then for sure you should start from rt-validator tool. It as well can
 --resolve some
 problems by deleting records, in a few cases it can create records to
 resolve problem.

  Thanks.

 --
 Best regards, Ruslan.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA — September 26  27, 2011
*  San Francisco, CA, USA — October 18  19, 2011
*  Washington DC, USA — October 31  November 1, 2011
*  Melbourne VIC, Australia — November 28  29, 2011
*  Barcelona, Spain — November 28  29, 2011

[rt-users] Shredder not deleting some transactions

[Kenneth Crocker]

To list,

I've been shredding a whole bunch of tickets and that seems to be working
fine. I can't see them in the WebUI or the DataBase. However, some of the
transaction records are NOT being deleted, like the ones setting a new value
for a ticket CF and in some cases a Create and some setting ticket values
as well.

What I want to know is if I go into the DataBase and just delete these
transaction records, will anything nefarious happen? I mean there are no
ticket records for them to relate for history purposes?

Also, can I do the same for any Attachments for these transactions?

Thanks.

Kenn
LBNL

RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA — September 26  27, 2011
*  San Francisco, CA, USA — October 18  19, 2011
*  Washington DC, USA — October 31  November 1, 2011
*  Melbourne VIC, Australia — November 28  29, 2011
*  Barcelona, Spain — November 28  29, 2011

Re: [rt-users] Shredder not deleting some transactions

[Ruslan Zakirov]

Hello,

On Tue, Aug 9, 2011 at 11:37 PM, Kenneth Crocker kfcroc...@lbl.gov wrote:
 To list,

 I've been shredding a whole bunch of tickets and that seems to be working
 fine. I can't see them in the WebUI or the DataBase. However, some of the
 transaction records are NOT being deleted, like the ones setting a new value
 for a ticket CF and in some cases a Create and some setting ticket values
 as well.

If shredder doesn't delete some transactions then you should report a bug with
additional details about reproducing it.

 What I want to know is if I go into the DataBase and just delete these
 transaction records, will anything nefarious happen? I mean there are no
 ticket records for them to relate for history purposes?

 Also, can I do the same for any Attachments for these transactions?

Before you start deleting things manually check database with rt-validator tool.
RT 3.8+ only, old shredder's validator is useless.

 Thanks.

 Kenn
 LBNL

-- 
Best regards, Ruslan.

RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA  September 26  27, 2011
*  San Francisco, CA, USA  October 18  19, 2011
*  Washington DC, USA  October 31  November 1, 2011
*  Melbourne VIC, Australia  November 28  29, 2011
*  Barcelona, Spain  November 28  29, 2011

Re: [rt-users] Shredder not deleting some transactions

[Kenneth Crocker]

Ruslan,

Well, to be honest, I can't blame Shredder. Some years ago a person here
deleted some users, etc manually. I'm using Shredder to clean it all up. So
I'm sure there were some disconnects left in there.

Thanks.

Kenn
LBNL

On Tue, Aug 9, 2011 at 3:07 PM, Ruslan Zakirov r...@bestpractical.comwrote:

 Hello,

 On Tue, Aug 9, 2011 at 11:37 PM, Kenneth Crocker kfcroc...@lbl.gov
 wrote:
  To list,
 
  I've been shredding a whole bunch of tickets and that seems to be working
  fine. I can't see them in the WebUI or the DataBase. However, some of the
  transaction records are NOT being deleted, like the ones setting a new
 value
  for a ticket CF and in some cases a Create and some setting ticket
 values
  as well.

 If shredder doesn't delete some transactions then you should report a bug
 with
 additional details about reproducing it.

  What I want to know is if I go into the DataBase and just delete these
  transaction records, will anything nefarious happen? I mean there are no
  ticket records for them to relate for history purposes?
 
  Also, can I do the same for any Attachments for these transactions?

 Before you start deleting things manually check database with rt-validator
 tool.
 RT 3.8+ only, old shredder's validator is useless.

  Thanks.
 
  Kenn
  LBNL

 --
 Best regards, Ruslan.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA — September 26  27, 2011
*  San Francisco, CA, USA — October 18  19, 2011
*  Washington DC, USA — October 31  November 1, 2011
*  Melbourne VIC, Australia — November 28  29, 2011
*  Barcelona, Spain — November 28  29, 2011

[rt-users] Shredder limit?

[Kenneth Crocker]

To list,

Also, is there a way to raise the limit on how many tickets I can shred on
one pass?

Kenn


2011 Training: http://bestpractical.com/services/training.html

[rt-users] Shredder limits

[Kenneth Crocker]

To list,

Never mind. DUH! I found it.

Kenn
LBNL


2011 Training: http://bestpractical.com/services/training.html

[rt-users] Shredder SQL dump file without execution of shredder.

[Jonah Hirsch]

Is there any relatively simple way to generate the SQL dump file Shredder
generates without actually shredding anything?
Or would the best way to do it be shredding something, getting the SQL dump,
and just running the queries in the dump to put it back?
Jonah Hirsch
---

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

[rt-users] shredder access

[ronald higgins]

Good Morning Fellow RT Users.

I'm very much new to the RT scene so apologies if this has come up before.
1 of our RT queues has +-300k false tickets (autoresponders, spam etc etc).
The queue administrator would like access to remove those tickets via
Shredder (built into RT).

Now logged in as root i have the shredder option but not when logged
in as a normal
user. Is there a permission that I can set somewhere that will allow
me to grant a specific
user access to the Shredder function ?

Regards

Ronald

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

Re: [rt-users] shredder access

[Jerrad Pierce]

On Mon, May 10, 2010 at 02:28, ronald higgins ronald.higg...@gmail.com wrote:
 Good Morning Fellow RT Users.

 I'm very much new to the RT scene so apologies if this has come up before.
 1 of our RT queues has +-300k false tickets (autoresponders, spam etc etc).
 The queue administrator would like access to remove those tickets via
 Shredder (built into RT).

 Now logged in as root i have the shredder option but not when logged
 in as a normal
 user. Is there a permission that I can set somewhere that will allow
 me to grant a specific
 user access to the Shredder function ?
SuperUser, but that gives them access to everything.

Shredding is not something that's really condoned, but is often a
necessary evil, so it is reserved for root; particularly given the way
shredding handles users separately :-/

You should setup filters to eliminate such things before they get to
RT, and create another queue for those that make it through to be
moved to. Root can then periodically process the backlog.

-- 
Cambridge Energy Alliance: Save money. Save the planet.

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

Re: [rt-users] Shredder

[Torsten Brumm]

Hi Jens,

 I need to shred old tickets, tickets that have been closed for more than a
 year or two.

 Why? Our RT database is now just over 115GB in size and mysql is not
 coping.


OK, thats not so big ;-)


 I don't want to remove the tickets, I want to remove the transactions and
 attachments.

 We have a RT Addon from BPS which is not removing/deleting the Attachements
but stores them on disk instead of DB, this could work for you.
@BPS: When will the AttachmentOnDisk Addon available at Github?


 As I understand it, this will allow someone to still search for a ticket
 and find some metadata about the ticket - helping the user to find more
 information elsewhere about the issue.

 I couldn't work out how to do this. How do I use more than 1 plugin at a
 time?

 Under RT 3.8? just add the second besides the first at the RT_SiteConfig.pm
Plugin Entry...?!?


 Does anyone know how?

 I look forward to your responses.

 Thanks  Regards
 Jens


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

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

 2010 RT Training Sessions!
 San Francisco, CA, USA - Feb 22  23
 Dublin, Ireland - Mar 15  16
 Boston, MA, USA - April 5  6
 Washington DC, USA - Oct 25  26

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




-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22  23
Dublin, Ireland - Mar 15  16
Boston, MA, USA - April 5  6
Washington DC, USA - Oct 25  26

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

[rt-users] Shredder

[Jens von Bülow]

Hi There,

It has been a while since I have worked with RT but I still love it.

I need to shred old tickets, tickets that have been closed for more than a year 
or two.

Why? Our RT database is now just over 115GB in size and mysql is not coping.

I don't want to remove the tickets, I want to remove the transactions and 
attachments. 

As I understand it, this will allow someone to still search for a ticket and 
find some metadata about the ticket - helping the user to find more information 
elsewhere about the issue.

I couldn't work out how to do this. How do I use more than 1 plugin at a time?

Does anyone know how?

I look forward to your responses.

Thanks  Regards
Jens


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

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

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22  23
Dublin, Ireland - Mar 15  16
Boston, MA, USA - April 5  6
Washington DC, USA - Oct 25  26

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

Re: [rt-users] shredder error

[David Hobley]

I thought this was the case; in which case I am still no closer to working out 
why it is crashing for me. 

Does anyone have any suggestions as to how I can get to the bottom of this? 

Couldn't wipeout object: Can't call method new on an undefined value at 
/opt/httpd/rt3/sbin/../lib/RT/Transaction_Overlay.pm line 1031, STDIN line 1. 

Cheers, 
David 
- Original Message - 
From: Ken Crocker kfcroc...@lbl.gov 
To: Howard Jones ho...@thingy.com 
Cc: rt-users@lists.bestpractical.com 
Sent: Friday, 16 October, 2009 3:14:26 AM GMT +10:00 Brisbane 
Subject: Re: [rt-users] shredder error 

Howard, 

I thought the replace-relations was for links to other tickets. If it offers 
an opportunity to enter a replacement User ID, then I'm sure it's OK. 

Kenn 
LBNL 

On 10/15/2009 9:01 AM, Howard Jones wrote: 

On 15/10/2009 16:41, Ken Crocker wrote: 

Some users may be referred to by transaction history of a ticket
because they sent in corresponance or were the original requestor or
owner. Those kind of relationships shouldn't be deleted because it
will cause an error in yoiur history display. Isn't that what replace_relations 
is supposed to fix?

Regards,

Howard
___ 
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community 
help: http://wiki.bestpractical.com Commercial support: sa...@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: sa...@bestpractical.com 
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy 
at http://rtbook.bestpractical.com 

-- 



Cheers, 
David Hobley 

IT Manager 
Creators of Miessence, MiVitality and MiEnviron 

Phone: +61 (7) 5582 7020 
Fax: +61 (7) 5539 6719 
USA Fax 1800 840 0827 
Email : david.hob...@mionegroup.com 
Website: www.mionegroup.com 


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

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


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

Re: [rt-users] shredder error

[Ken Crocker]

David,

Some users may be referred to by transaction history of a ticket because 
they sent in corresponance or were the original requestor or owner. 
Those kind of relationships shouldn't be deleted because it will cause 
an error in yoiur history display.


Kenn
LBNL

On 10/14/2009 4:57 PM, David Hobley wrote:

All,

Having finally purged my db of deleted tickets, I am now trying to 
delete the users who now have no tickets assigned to them.  However 
shredder is failing with rt 3.8.2:


[r...@samba sbin]# ./rt-shredder --plugin 
Users=no_tickets,1;status,any;replace_relations,Nobody;limit,5

SQL dump file is '/opt/httpd/rt3/sbin/20091014T232306-0001.sql'
Next objects would be deleted:
RT::User-110031 object
RT::User-1080297 object
RT::User-911624 object
RT::User-352 object
RT::User-430 object
Do you want to proceed? [y/N] y
Couldn't wipeout object: Can't call method new on an undefined value 
at /opt/httpd/rt3/sbin/../lib/RT/Transaction_Overlay.pm line 1031, 
STDIN line 1.


Anyone any ideas?

--
Cheers,
David


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@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: sa...@bestpractical.com


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

Re: [rt-users] shredder error

[Howard Jones]

On 15/10/2009 16:41, Ken Crocker wrote:
 Some users may be referred to by transaction history of a ticket
 because they sent in corresponance or were the original requestor or
 owner. Those kind of relationships shouldn't be deleted because it
 will cause an error in yoiur history display.
Isn't that what replace_relations is supposed to fix?

Regards,

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

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


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

Re: [rt-users] shredder error

[Ken Crocker]

Howard,

I thought the replace-relations was for links to other tickets. If it 
offers an opportunity to enter a replacement User ID, then I'm sure it's OK.


Kenn
LBNL

On 10/15/2009 9:01 AM, Howard Jones wrote:

On 15/10/2009 16:41, Ken Crocker wrote:
  

Some users may be referred to by transaction history of a ticket
because they sent in corresponance or were the original requestor or
owner. Those kind of relationships shouldn't be deleted because it
will cause an error in yoiur history display.


Isn't that what replace_relations is supposed to fix?

Regards,

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@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: sa...@bestpractical.com


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

Re: [rt-users] shredder stuck!

[David Hobley]

OK, I finally worked this out myself. Note to self. --force stops error 
messages appearing as well as other output. 

The issue was in the dependency setting for the shredder, we had some tickets 
with more than 1,000 dependencies (due to a couple of mail loops in the past) 
and it just stops when it hits that number. I upped ours to 10,000 in the 
RT_SiteConfig.pm file: 

Set( $DependenciesLimit, 1 ); 

Cheers, 
David 
- Original Message - 
From: David Hobley david.hob...@mionegroup.com 
To: rt-users rt-users@lists.bestpractical.com 
Sent: Monday, 21 September, 2009 3:57:21 PM GMT +10:00 Brisbane 
Subject: [rt-users] shredder stuck! 


Hello, 

I am running the shredder over our database and it has been dutifully deleting 
the deleted tickets as requested. It has processed around 20,000 so far but is 
now stuck with the following output in the SQL dump files: 

INSERT INTO 
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`)
 VALUES('0','912264','3107639','912264','10','3107639'); 
INSERT INTO 
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`)
 VALUES('0','912264','3107640','912264','10','3107635'); 
INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`) 
VALUES('912264','1168372','10'); 
INSERT INTO 
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`)
 VALUES('0','912264','3107635','912264','912264','3107635'); 
INSERT INTO 
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype
 
`,`timetaken`,`type`) VALUES('2008-09-26 
23:23:48','228052',NULL,NULL,'2001691',NULL,NULL,'912264','RT::Group',NULL,NULL,NULL,'0','Create');
 
INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) 
VALUES(NULL,'RT::Ticket-Role','912264','192693',NULL,'Owner'); 
INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) 
VALUES('0','912264','912264','Group'); 

No other errors or warnings that I can see. Would anyone have any ideas why it 
is stuck? 

-- 
Cheers, 
David 

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

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


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

Re: [rt-users] Shredder question

[Ruslan Zakirov]

Hello Ken,

Delete them as there is no record to reference anymore after shredding a ticket.

On Tue, Sep 22, 2009 at 8:08 PM, Ken Crocker kfcroc...@lbl.gov wrote:
 To list,

 I haven't used Shredder before so I have a question: when it removes a
 deleted ticket, will it also remove the OBJECTCUSTOMFIELDVALUES records
 as well or just disable them?

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

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


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




-- 
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

Re: [rt-users] Shredder question

[Ken Crocker]

Ruslan,

Thanks. That's what I would have thought. Makes sense.

Kenn
LBNL

On 9/23/2009 1:10 AM, Ruslan Zakirov wrote:

Hello Ken,

Delete them as there is no record to reference anymore after shredding a ticket.

On Tue, Sep 22, 2009 at 8:08 PM, Ken Crocker kfcroc...@lbl.gov wrote:
  

To list,

I haven't used Shredder before so I have a question: when it removes a
deleted ticket, will it also remove the OBJECTCUSTOMFIELDVALUES records
as well or just disable them?

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@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: sa...@bestpractical.com


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

[rt-users] Shredder question

[Ken Crocker]

To list,

I haven't used Shredder before so I have a question: when it removes a 
deleted ticket, will it also remove the OBJECTCUSTOMFIELDVALUES records 
as well or just disable them?

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

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


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

[rt-users] shredder stuck!

[David Hobley]

Hello, 

I am running the shredder over our database and it has been dutifully deleting 
the deleted tickets as requested. It has processed around 20,000 so far but is 
now stuck with the following output in the SQL dump files: 

INSERT INTO 
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`)
 VALUES('0','912264','3107639','912264','10','3107639'); 
INSERT INTO 
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`)
 VALUES('0','912264','3107640','912264','10','3107635'); 
INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`) 
VALUES('912264','1168372','10'); 
INSERT INTO 
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`)
 VALUES('0','912264','3107635','912264','912264','3107635'); 
INSERT INTO 
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype
 
`,`timetaken`,`type`) VALUES('2008-09-26 
23:23:48','228052',NULL,NULL,'2001691',NULL,NULL,'912264','RT::Group',NULL,NULL,NULL,'0','Create');
 
INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) 
VALUES(NULL,'RT::Ticket-Role','912264','192693',NULL,'Owner'); 
INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) 
VALUES('0','912264','912264','Group'); 

No other errors or warnings that I can see. Would anyone have any ideas why it 
is stuck? 

-- 
Cheers, 
David 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] Shredder question

[Ken Crocker]

To list,

I haven't used Shredder before so I have a question: when it removes a 
deleted ticket, will it also remove the OBJECTCUSTOMFIELDVALUES records 
as well?

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

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


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

[rt-users] Shredder notickets finds users who have valid contributions

[Jo Rhett]

Okay, so this is something I'm not sure how to resolve.

I open a ticket for jo.rh...@company.com.

Jo receives his e-mail, and sends replies to me from j...@company.com.

Obviously a second user is created for jo@ but it's also picked up to  
be deleted by Scrubber.  I'm not sure this is the right approach.   Is  
there any way to modify the query done to pick up any valid contributor?

All we really want to do is delete users whose tickets have been  
deleted (ie spam)

-- 
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source  
and other randomness



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

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


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

Re: [rt-users] Shredder in 3.8.2

[Jim Tambling]

Hi Richard,

I applied the permissions recursively and that appears to have fixed it.



Many thanx, Jim

-Original Message-
From: Richard Foley [mailto:richard.fo...@rfi.net] 
Sent: 09 March 2009 07:59
To: rt-users@lists.bestpractical.com
Cc: Jim Tambling; rt-us...@bestpractical.com
Subject: Re: [rt-users] Shredder in 3.8.2


Hi Jim,

Shredder needs a directory to write dumps to. Please check that
you
have span
class=file-path/usr/local/rt/var/data/RT-Shredder/span
and it is writable by your web server.

Looks to me as though that should work:

# ps -ef | grep apache
...
www-data 22739  3889  0 16:19 ?00:00:03
/usr/sbin/apache2 -k

# ls -lR /usr/local/rt/var/data:
...
drwxrwsrwx 2 www-data staff 4096 2009-02-19 10:52 RT_Shredder 

1. Have you restarted your apache?

2. Have you tried being pedantic and checking each and every directory
above 
there too?

ls -d /usr

ls -d /usr/local

ls -d /usr/local/rt

ls -d /usr/local/rt/var

ls -d /usr/local/rt/var/data

ls -d /usr/local/rt/var/data/RT_Shredder

-- 
Richard Foley
Ciao - shorter than aufwiedersehen

http://www.rfi.net/

On Sunday 08 March 2009 18:54:52 Jim Tambling wrote:
 Hi again,
 
 
 greyarea jim # ls -lR /usr/local/rt/var/data
 /usr/local/rt/var/data:
 total 4
 drwxrwsrwx 2 www-data staff 4096 2009-02-19 10:52 RT_Shredder
 
 /usr/local/rt/var/data/RT_Shredder:
 total 0
 
 
 Thanks, Jim
 
 -Original Message-
 From: Richard Foley [mailto:richard.fo...@rfi.net]
 Sent: 07 March 2009 08:44
 To: rt-us...@bestpractical.com
 Cc: Jim Tambling; rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Shredder in 3.8.2
 
 
 It might help to use a couple of different commands, please try these
 two:
 
   groups www-data
 
   ls -lR /usr/local/rt/var/data
 
 --
 Richard Foley
 Ciao - shorter than aufwiedersehen
 
 http://www.rfi.net/
 
 On Friday 06 March 2009 17:46:50 Jim Tambling wrote:
  Hi,
  
  greyarea jim # ls -l /usr/local/rt/var/data/RT_Shredder/
  total 0
  greyarea jim # ps -ef | grep apache2
  root  3889 1  0 13:57 ?00:00:06 /usr/sbin/apache2 -k
  start
  root  3898 11198  0 13:57 pts/700:00:00 tail -f
  /var/log/apache2/error.log
  root  5862 32163  0 12:36 pts/100:00:00 tail -f
  /var/log/apache2/error.log
  root 18192   935  0 14:33 pts/400:00:00 tail -F
  /var/log/apache2/error.log
  www-data 22739  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
  start
  www-data 22740  3889  0 16:19 ?00:00:05 /usr/sbin/apache2 -k
  start
  www-data 22741  3889  0 16:19 ?00:00:04 /usr/sbin/apache2 -k
  start
  www-data 22742  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
  start
  www-data 22743  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
  start
  www-data 22765  3889  0 16:19 ?00:00:02 /usr/sbin/apache2 -k
  start
  www-data 25089  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
  start
  www-data 25090  3889  0 16:26 ?00:00:01 /usr/sbin/apache2 -k
  start
  www-data 25091  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
  start
  root 31666   984  0 16:42 pts/200:00:00 grep apache2
  
  -Original Message-
  From: Richard Foley [mailto:richard.fo...@rfi.net]
  Sent: 06 March 2009 13:24
  To: Jim Tambling
  Cc: rt-users@lists.bestpractical.com; rt-us...@bestpractical.com
  Subject: Re: [rt-users] Shredder in 3.8.2
  
  
  On Friday 06 March 2009 14:04:17 Jim Tambling wrote:
   Hi

   I am trying to get shredder working, I have created the directory
   and
   made it writable by www-data but I still get an error;

   Shredder needs a directory to write dumps to. Please check that 
   you have span
 class=file-path/usr/local/rt/var/data/RT-Shredder/span
   and it is writable by your web server.

   Am I missing something?

  Maybe www-data is the wrong user/group - please post the result of:
  
  ls -l /usr/local/rt/var/data/RT-Shredder
  
  and (for apache or httpd):
  
  ps -ef | grep httpd
  
  and the results of running the groups command against the RT 
  user, something _like_ this might do it:
  
  groups rtuser
  
  --
  Richard Foley
  Ciao - shorter than aufwiedersehen
  
  http://www.rfi.net/
  
  No virus found in this incoming message.
  Checked by AVG - www.avg.com
  Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date: 
  03/06/09 07:20:00
  
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@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

Re: [rt-users] Shredder in 3.8.2

[Richard Foley]

Hi Jim,

Shredder needs a directory to write dumps to. Please check that you
have span class=file-path/usr/local/rt/var/data/RT-Shredder/span
and it is writable by your web server.

Looks to me as though that should work:

# ps -ef | grep apache
...
www-data 22739  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k

# ls -lR /usr/local/rt/var/data:
...
drwxrwsrwx 2 www-data staff 4096 2009-02-19 10:52 RT_Shredder 

1. Have you restarted your apache?

2. Have you tried being pedantic and checking each and every directory above 
there too?

ls -d /usr

ls -d /usr/local

ls -d /usr/local/rt

ls -d /usr/local/rt/var

ls -d /usr/local/rt/var/data

ls -d /usr/local/rt/var/data/RT_Shredder

-- 
Richard Foley
Ciao - shorter than aufwiedersehen

http://www.rfi.net/

On Sunday 08 March 2009 18:54:52 Jim Tambling wrote:
 Hi again,
 
 
 greyarea jim # ls -lR /usr/local/rt/var/data
 /usr/local/rt/var/data:
 total 4
 drwxrwsrwx 2 www-data staff 4096 2009-02-19 10:52 RT_Shredder
 
 /usr/local/rt/var/data/RT_Shredder:
 total 0
 
 
 Thanks, Jim
 
 -Original Message-
 From: Richard Foley [mailto:richard.fo...@rfi.net] 
 Sent: 07 March 2009 08:44
 To: rt-us...@bestpractical.com
 Cc: Jim Tambling; rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Shredder in 3.8.2
 
 
 It might help to use a couple of different commands, please try these
 two:
 
   groups www-data
 
   ls -lR /usr/local/rt/var/data
 
 -- 
 Richard Foley
 Ciao - shorter than aufwiedersehen
 
 http://www.rfi.net/
 
 On Friday 06 March 2009 17:46:50 Jim Tambling wrote:
  Hi,
  
  greyarea jim # ls -l /usr/local/rt/var/data/RT_Shredder/
  total 0
  greyarea jim # ps -ef | grep apache2
  root  3889 1  0 13:57 ?00:00:06 /usr/sbin/apache2 -k
  start
  root  3898 11198  0 13:57 pts/700:00:00 tail -f
  /var/log/apache2/error.log
  root  5862 32163  0 12:36 pts/100:00:00 tail -f
  /var/log/apache2/error.log
  root 18192   935  0 14:33 pts/400:00:00 tail -F
  /var/log/apache2/error.log
  www-data 22739  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
  start
  www-data 22740  3889  0 16:19 ?00:00:05 /usr/sbin/apache2 -k
  start
  www-data 22741  3889  0 16:19 ?00:00:04 /usr/sbin/apache2 -k
  start
  www-data 22742  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
  start
  www-data 22743  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
  start
  www-data 22765  3889  0 16:19 ?00:00:02 /usr/sbin/apache2 -k
  start
  www-data 25089  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
  start
  www-data 25090  3889  0 16:26 ?00:00:01 /usr/sbin/apache2 -k
  start
  www-data 25091  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
  start
  root 31666   984  0 16:42 pts/200:00:00 grep apache2
  
  -Original Message-
  From: Richard Foley [mailto:richard.fo...@rfi.net]
  Sent: 06 March 2009 13:24
  To: Jim Tambling
  Cc: rt-users@lists.bestpractical.com; rt-us...@bestpractical.com
  Subject: Re: [rt-users] Shredder in 3.8.2
  
  
  On Friday 06 March 2009 14:04:17 Jim Tambling wrote:
   Hi

   I am trying to get shredder working, I have created the directory 
   and
   made it writable by www-data but I still get an error;

   Shredder needs a directory to write dumps to. Please check that you
   have span
 class=file-path/usr/local/rt/var/data/RT-Shredder/span
   and it is writable by your web server.

   Am I missing something?

  Maybe www-data is the wrong user/group - please post the result of:
  
  ls -l /usr/local/rt/var/data/RT-Shredder
  
  and (for apache or httpd):
  
  ps -ef | grep httpd
  
  and the results of running the groups command against the RT user,
  something _like_ this might do it:
  
  groups rtuser
  
  --
  Richard Foley
  Ciao - shorter than aufwiedersehen
  
  http://www.rfi.net/
  
  No virus found in this incoming message.
  Checked by AVG - www.avg.com
  Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date:
  03/06/09 07:20:00
  
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@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: sa...@bestpractical.com


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

Re: [rt-users] Shredder in 3.8.2

[Jim Tambling]

Hi again,


greyarea jim # ls -lR /usr/local/rt/var/data
/usr/local/rt/var/data:
total 4
drwxrwsrwx 2 www-data staff 4096 2009-02-19 10:52 RT_Shredder

/usr/local/rt/var/data/RT_Shredder:
total 0


Thanks, Jim

-Original Message-
From: Richard Foley [mailto:richard.fo...@rfi.net] 
Sent: 07 March 2009 08:44
To: rt-us...@bestpractical.com
Cc: Jim Tambling; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Shredder in 3.8.2


It might help to use a couple of different commands, please try these
two:

groups www-data

ls -lR /usr/local/rt/var/data

-- 
Richard Foley
Ciao - shorter than aufwiedersehen

http://www.rfi.net/

On Friday 06 March 2009 17:46:50 Jim Tambling wrote:
 Hi,
 
 greyarea jim # ls -l /usr/local/rt/var/data/RT_Shredder/
 total 0
 greyarea jim # ps -ef | grep apache2
 root  3889 1  0 13:57 ?00:00:06 /usr/sbin/apache2 -k
 start
 root  3898 11198  0 13:57 pts/700:00:00 tail -f
 /var/log/apache2/error.log
 root  5862 32163  0 12:36 pts/100:00:00 tail -f
 /var/log/apache2/error.log
 root 18192   935  0 14:33 pts/400:00:00 tail -F
 /var/log/apache2/error.log
 www-data 22739  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
 start
 www-data 22740  3889  0 16:19 ?00:00:05 /usr/sbin/apache2 -k
 start
 www-data 22741  3889  0 16:19 ?00:00:04 /usr/sbin/apache2 -k
 start
 www-data 22742  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
 start
 www-data 22743  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
 start
 www-data 22765  3889  0 16:19 ?00:00:02 /usr/sbin/apache2 -k
 start
 www-data 25089  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
 start
 www-data 25090  3889  0 16:26 ?00:00:01 /usr/sbin/apache2 -k
 start
 www-data 25091  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
 start
 root 31666   984  0 16:42 pts/200:00:00 grep apache2
 
 -Original Message-
 From: Richard Foley [mailto:richard.fo...@rfi.net]
 Sent: 06 March 2009 13:24
 To: Jim Tambling
 Cc: rt-users@lists.bestpractical.com; rt-us...@bestpractical.com
 Subject: Re: [rt-users] Shredder in 3.8.2
 
 
 On Friday 06 March 2009 14:04:17 Jim Tambling wrote:
  Hi
   
  I am trying to get shredder working, I have created the directory 
  and
  made it writable by www-data but I still get an error;
   
  Shredder needs a directory to write dumps to. Please check that you
  have span
class=file-path/usr/local/rt/var/data/RT-Shredder/span
  and it is writable by your web server.
   
  Am I missing something?
   
 Maybe www-data is the wrong user/group - please post the result of:
 
   ls -l /usr/local/rt/var/data/RT-Shredder
 
 and (for apache or httpd):
 
   ps -ef | grep httpd
 
 and the results of running the groups command against the RT user,
 something _like_ this might do it:
 
   groups rtuser
 
 --
 Richard Foley
 Ciao - shorter than aufwiedersehen
 
 http://www.rfi.net/
 
 No virus found in this incoming message.
 Checked by AVG - www.avg.com
 Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date:
 03/06/09 07:20:00
 


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

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


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

Re: [rt-users] Shredder in 3.8.2

[Richard Foley]

It might help to use a couple of different commands, please try these two:

groups www-data

ls -lR /usr/local/rt/var/data

-- 
Richard Foley
Ciao - shorter than aufwiedersehen

http://www.rfi.net/

On Friday 06 March 2009 17:46:50 Jim Tambling wrote:
 Hi,
 
 greyarea jim # ls -l /usr/local/rt/var/data/RT_Shredder/
 total 0
 greyarea jim # ps -ef | grep apache2
 root  3889 1  0 13:57 ?00:00:06 /usr/sbin/apache2 -k
 start
 root  3898 11198  0 13:57 pts/700:00:00 tail -f
 /var/log/apache2/error.log
 root  5862 32163  0 12:36 pts/100:00:00 tail -f
 /var/log/apache2/error.log
 root 18192   935  0 14:33 pts/400:00:00 tail -F
 /var/log/apache2/error.log
 www-data 22739  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
 start
 www-data 22740  3889  0 16:19 ?00:00:05 /usr/sbin/apache2 -k
 start
 www-data 22741  3889  0 16:19 ?00:00:04 /usr/sbin/apache2 -k
 start
 www-data 22742  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
 start
 www-data 22743  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
 start
 www-data 22765  3889  0 16:19 ?00:00:02 /usr/sbin/apache2 -k
 start
 www-data 25089  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
 start
 www-data 25090  3889  0 16:26 ?00:00:01 /usr/sbin/apache2 -k
 start
 www-data 25091  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
 start
 root 31666   984  0 16:42 pts/200:00:00 grep apache2
 
 -Original Message-
 From: Richard Foley [mailto:richard.fo...@rfi.net] 
 Sent: 06 March 2009 13:24
 To: Jim Tambling
 Cc: rt-users@lists.bestpractical.com; rt-us...@bestpractical.com
 Subject: Re: [rt-users] Shredder in 3.8.2
 
 
 On Friday 06 March 2009 14:04:17 Jim Tambling wrote:
  Hi
   
  I am trying to get shredder working, I have created the directory and 
  made it writable by www-data but I still get an error;
   
  Shredder needs a directory to write dumps to. Please check that you 
  have span class=file-path/usr/local/rt/var/data/RT-Shredder/span
  and it is writable by your web server.
   
  Am I missing something?
   
 Maybe www-data is the wrong user/group - please post the result of:
 
   ls -l /usr/local/rt/var/data/RT-Shredder
 
 and (for apache or httpd):
 
   ps -ef | grep httpd
 
 and the results of running the groups command against the RT user, 
 something _like_ this might do it:
 
   groups rtuser
 
 -- 
 Richard Foley
 Ciao - shorter than aufwiedersehen
 
 http://www.rfi.net/
 
 No virus found in this incoming message.
 Checked by AVG - www.avg.com 
 Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date:
 03/06/09 07:20:00
 


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

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


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

[rt-users] Shredder in 3.8.2

[Jim Tambling]

Hi
 
I am trying to get shredder working, I have created the directory and
made it writable by www-data but I still get an error;
 
Shredder needs a directory to write dumps to. Please check that you
have span class=file-path/usr/local/rt/var/data/RT-Shredder/span
and it is writable by your web server. 
 
Am I missing something?
 
 
Regards, Jim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

Re: [rt-users] Shredder in 3.8.2

[Richard Foley]

On Friday 06 March 2009 14:04:17 Jim Tambling wrote:
 Hi
  
 I am trying to get shredder working, I have created the directory and
 made it writable by www-data but I still get an error;
  
 Shredder needs a directory to write dumps to. Please check that you
 have span class=file-path/usr/local/rt/var/data/RT-Shredder/span
 and it is writable by your web server. 
  
 Am I missing something?
  
Maybe www-data is the wrong user/group - please post the result of:

ls -l /usr/local/rt/var/data/RT-Shredder

and (for apache or httpd):

ps -ef | grep httpd

and the results of running the groups command against the RT user, 
something _like_ this might do it:

groups rtuser

-- 
Richard Foley
Ciao - shorter than aufwiedersehen

http://www.rfi.net/
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

Re: [rt-users] Shredder in 3.8.2

[Jim Tambling]

Hi,



greyarea jim # ls -l /usr/local/rt/var/data/RT_Shredder/
total 0
greyarea jim # ps -ef | grep apache2
root  3889 1  0 13:57 ?00:00:06 /usr/sbin/apache2 -k
start
root  3898 11198  0 13:57 pts/700:00:00 tail -f
/var/log/apache2/error.log
root  5862 32163  0 12:36 pts/100:00:00 tail -f
/var/log/apache2/error.log
root 18192   935  0 14:33 pts/400:00:00 tail -F
/var/log/apache2/error.log
www-data 22739  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
start
www-data 22740  3889  0 16:19 ?00:00:05 /usr/sbin/apache2 -k
start
www-data 22741  3889  0 16:19 ?00:00:04 /usr/sbin/apache2 -k
start
www-data 22742  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
start
www-data 22743  3889  0 16:19 ?00:00:03 /usr/sbin/apache2 -k
start
www-data 22765  3889  0 16:19 ?00:00:02 /usr/sbin/apache2 -k
start
www-data 25089  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
start
www-data 25090  3889  0 16:26 ?00:00:01 /usr/sbin/apache2 -k
start
www-data 25091  3889  0 16:26 ?00:00:02 /usr/sbin/apache2 -k
start
root 31666   984  0 16:42 pts/200:00:00 grep apache2

-Original Message-
From: Richard Foley [mailto:richard.fo...@rfi.net] 
Sent: 06 March 2009 13:24
To: Jim Tambling
Cc: rt-users@lists.bestpractical.com; rt-us...@bestpractical.com
Subject: Re: [rt-users] Shredder in 3.8.2


On Friday 06 March 2009 14:04:17 Jim Tambling wrote:
 Hi
  
 I am trying to get shredder working, I have created the directory and 
 made it writable by www-data but I still get an error;
  
 Shredder needs a directory to write dumps to. Please check that you 
 have span class=file-path/usr/local/rt/var/data/RT-Shredder/span
 and it is writable by your web server.
  
 Am I missing something?
  
Maybe www-data is the wrong user/group - please post the result of:

ls -l /usr/local/rt/var/data/RT-Shredder

and (for apache or httpd):

ps -ef | grep httpd

and the results of running the groups command against the RT user, 
something _like_ this might do it:

groups rtuser

-- 
Richard Foley
Ciao - shorter than aufwiedersehen

http://www.rfi.net/

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date:
03/06/09 07:20:00
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] Shredder seems to hang

[Mathew]

It has recently become clear that a script which calls rtx-shredder never 
finishes.  It seems that shredder is actually hanging on something but I can't 
figure out what.  Script follows.

#!/usr/bin/perl

#
# File: delete_spam.pl
# Version:  2.1.2
# Author:   Mathew Snyder
# Date: August 5, 2007
# Comments: A script to gather up the spam
#   sent to the Security queue and
#   eliminate the users that
#   created it.  It then marks those
#   tickets as deleted for the purpose
#   of further housecleaning by the
#   rtx-shredder cronjob.
#

#Set up our environment
use warnings;
use strict;
use lib '/usr/local/rt3/lib';
use lib '/usr/local/rt3/local/lib';
use lib '/usr/local/lib';
use RT;
use RT::Users;
use RT::Tickets;
use MIME::Lite;
use Reports::Emails;

RT::LoadConfig();
RT::Init();

my @usrID;
my %userID;
my @emails;
my %spammers;

my $users = new RT::Users(RT::SystemUser);
$users-LimitToPrivileged;

while ( my $user = $users-Next ) {
next if $user-Name eq 'root';
$skipEmails{$user-EmailAddress} = undef;
}

my $tix = new RT::Tickets(RT::SystemUser);
$tix-FromSQL('Queue = zSPAM');

while (my $ticket = $tix-Next) {
if ($ticket-RequestorAddresses =~ /^msnyd...@xx.com$/ || 
$ticket-RequestorAddresses =~ /^securi...@xx.com$/) {
$ticket-DeleteWatcher (
Type  = 'Requestor',
Email = $ticket-RequestorAddresses
);
#   $ticket-AddWatcher (
#   Type  = 'Requestor',
#   Email = 'spam...@spammer.com'
#   );
}
next if (exists($skipEmails{$ticket-RequestorAddresses}));
$spammers{$ticket-RequestorAddresses} = undef;
#   push @emails, $ticket-RequestorAddresses;
$ticket-SetStatus(deleted);
}

my $count = 0;
#foreach my $email (@emails) {
foreach my $email (keys %spammers) {

system(/usr/local/rt3/local/sbin/rtx-shredder,--force,--plugin,Users=status,any;email,$email;replace_relations,zbeeblebrox;no_tickets,true);
$count++;
}

system(/usr/local/rt3/local/sbin/rtx-shredder --force --plugin 
'Tickets=status,deleted;queue,zSPAM;limit,1000'  rm -f /root/*.sql);

my $emailTo  = 'msny...@xxx.com';
my $emailFrom= RT;
my $emailSubj= RT Spam Removal;
my $emailMsg = The spam removal script has completed and has removed 
$count spam created users;

my $fullEmail= new MIME::Lite(From= $emailFrom,
  To  = $emailTo,
  Subject = $emailSubj,
  Data= $emailMsg,
);

$fullEmail-send(sendmail, /usr/sbin/sendmail -t);

unlink glob *.sql;

exit;


There are likely some changes which I won't be able to explain since they were 
made after I left the company.  Admittedly, this is a poorly documented script 
which has left me scratching my own head wondering why I did things.  Hopefully 
that won't stop anyone from helping.

One thing that has been noticed is that there are two calls to rtx-shredder for 
each instance of the script.  You'll see that one is a system call (sh -c) and 
the other is a via perl (I'm guessing from the script itself)
Here is the ps output:
10013 pts/1 S 0:00 /usr/bin/perl /usr/local/sbin/delete_spam.pl
10014 pts/1 S 0:00 sh -c /usr/local/rt3/local/sbin/rtx-shredder
--force --plugin 'Tickets=status,deleted;queue,zSPAM;limit,500'  rm -f
/root/*.sql
10015 pts/1 S 0:31 /usr/bin/perl
/usr/local/rt3/local/sbin/rtx-shredder --force --plugin
Tickets=status,deleted;queue,zSPAM;limit,500

In this output, I found that by killing process 10015 the other two terminated 
instantly.  I'm guessing that when the system call is made perl is invoked 
again by way of rtx-shredder and 10015 reflect all the arguments passed.  
However, it never exits giving control back to the system call which would 
then, in turn, terminate giving control back to the script.

I haven't seen any particular errors but then, I don't know what they would 
look like.  Anyone else run into a similar problem?

-Mathew
-- 
Keep up with my goings on at http://feeds.feedburner.com/theillien_atom
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] Shredder cannot shred ticket with many attachments

[Ian Rowland]

Hi everyone, first time post to the list but I have been following it for 2 
years now - thanks for all the great advice.

I had a mail loop on my system during December. Someone emailed a corrupt 
attachment in, rt would send a response to watchers and my exchange server on 
the LAN NDR'd the message back to RT (corrupt attachment), RT in turn then sent 
out a mail to the watchers and this caused an eternal NDR/Response loop. I 
think I have in excess of 100,000 responses in the ticket

We were on 3.8.1 and now running 3.8.2rc1

In firefox I get the following timeout after a few hours:

Couldn't wipeout object: no connection to syslog available - /dev/log is not a 
socket at /usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Syslog.pm line 71 
Stack: [/usr/lib/perl5/5.10.0/Carp.pm:44] 
[/usr/lib/perl5/5.10.0/i386-linux-thread-multi/Sys/Syslog.pm:510] 
[/usr/lib/perl5/5.10.0/i386-linux-thread-multi/Sys/Syslog.pm:389] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Syslog.pm:71] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Output.pm:39] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:147] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:95] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:70] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:22] 
[/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:595] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:551] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:540] 
[/opt/rt3/share/html/Admin/Tools/Shredder/index.html:158] 
[/opt/rt3/share/html/Admin/Tools/Shredder/autohandler:59] 
[/opt/rt3/share/html/Admin/autohandler:49] [/opt/rt3/share/html/autohandler:311]

Tail -f /var/log/messages:

Jan  7 11:00:35 rt kernel: imklog 3.20.2, log source = /proc/kmsg started.
Jan  7 11:00:35 rt rsyslogd: [origin software=rsyslogd swVersion=3.20.2 
x-pid=1622 x-info=http://www.rsyslog.com;] restart
Jan  7 12:00:20 rt kernel: Kernel logging (proc) stopped.
Jan  7 12:00:21 rt kernel: imklog 3.20.2, log source = /proc/kmsg started.
Jan  7 12:00:21 rt rsyslogd: [origin software=rsyslogd swVersion=3.20.2 
x-pid=1622 x-info=http://www.rsyslog.com;] restart

I am also running Nagios on the box, will stop the service and try the shred 
again.

Any pointers will be appreciated

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

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


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

Re: [rt-users] Shredder cannot shred ticket with many attachments

[Ian Rowland]

I ran it with nagios disabled and same error:

Couldn't wipeout object: no connection to syslog available - /dev/log is not a 
socket at /usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Syslog.pm line 71 
Stack: [/usr/lib/perl5/5.10.0/Carp.pm:44] 
[/usr/lib/perl5/5.10.0/i386-linux-thread-multi/Sys/Syslog.pm:510] 
[/usr/lib/perl5/5.10.0/i386-linux-thread-multi/Sys/Syslog.pm:389] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Syslog.pm:71] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Output.pm:39] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:147] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:95] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:70] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:22] 
[/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:595] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:551] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:540] 
[/opt/rt3/share/html/Admin/Tools/Shredder/index.html:158] 
[/opt/rt3/share/html/Admin/Tools/Shredder/autohandler:59] 
[/opt/rt3/share/html/Admin/autohandler:49] [/opt/rt3/share/html/autohandler:311]

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Ian Rowland
Sent: 07 January 2009 11:57 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Shredder cannot shred ticket with many attachments

Hi everyone, first time post to the list but I have been following it for 2 
years now - thanks for all the great advice.

I had a mail loop on my system during December. Someone emailed a corrupt 
attachment in, rt would send a response to watchers and my exchange server on 
the LAN NDR'd the message back to RT (corrupt attachment), RT in turn then sent 
out a mail to the watchers and this caused an eternal NDR/Response loop. I 
think I have in excess of 100,000 responses in the ticket

We were on 3.8.1 and now running 3.8.2rc1

In firefox I get the following timeout after a few hours:

Couldn't wipeout object: no connection to syslog available - /dev/log is not a 
socket at /usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Syslog.pm line 71 
Stack: [/usr/lib/perl5/5.10.0/Carp.pm:44] 
[/usr/lib/perl5/5.10.0/i386-linux-thread-multi/Sys/Syslog.pm:510] 
[/usr/lib/perl5/5.10.0/i386-linux-thread-multi/Sys/Syslog.pm:389] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Syslog.pm:71] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch/Output.pm:39] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:147] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:95] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:70] 
[/usr/local/lib/perl5/site_perl/5.10.0/Log/Dispatch.pm:22] 
[/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:595] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:591] 
[/opt/rt3/bin/../lib/RT/Shredder/Dependencies.pm:146] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:592] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:551] 
[/opt/rt3/bin/../lib/RT/Shredder.pm:540] 
[/opt/rt3/share/html/Admin/Tools/Shredder/index.html:158] 
[/opt/rt3/share/html/Admin/Tools/Shredder/autohandler:59] 
[/opt/rt3/share/html/Admin/autohandler:49] [/opt/rt3/share/html/autohandler:311]

Tail -f /var/log/messages:

Jan  7 11:00:35 rt kernel: imklog 3.20.2, log source = /proc/kmsg started.
Jan  7 11:00:35 rt rsyslogd: [origin software=rsyslogd swVersion=3.20.2 
x-pid=1622 x-info=http://www.rsyslog.com;] restart
Jan  7 12:00:20 rt kernel: Kernel logging (proc) stopped.
Jan  7 12:00:21 rt kernel: imklog 3.20.2, log source = /proc/kmsg started.
Jan  7 12:00:21 rt rsyslogd: [origin software=rsyslogd swVersion=3.20.2 
x-pid=1622 x-info=http://www.rsyslog.com;] restart

I am also running Nagios on the box

[rt-users] Shredder Indexes

[Curtis Bruneau]

I'm just curious if the Indexes recommended by the old RTx-Shredder-0.07 
documentation are still recommended, I would assume yes unless the 
queries have changed. I know a few were added to the default schema, but 
there's a couple others. I'm just wondering since the indexes can be 
rather large and take up quite a bit of memory if you want to cache them 
in the memory buffer. I'm guessing some may be redundant with MySQL 
5.x's index_merge.. 
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html

CREATE INDEX SHREDDER_TXN1 ON Transactions(ReferenceType, OldReference);
CREATE INDEX SHREDDER_TXN2 ON Transactions(ReferenceType, NewReference);
CREATE INDEX SHREDDER_TXN3 ON Transactions(Type, OldValue);
CREATE INDEX SHREDDER_TXN4 ON Transactions(Type, NewValue);



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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder no_tickets

[Krieg, Alexander]

Hi,

what does the parameter no_tickets looks for and how to use it ?
i set status to 'any' and 'no_tickets' = 1 to show me all users who do 
not have any relation to a ticket (watcher(Requestor, Owner, Cc or 
AdminCc)). So i guess 'no_tickets' = 0 means show me users that have a 
relation to at least one ticket.
The strange effect in my case is that i have several users who get 
listed in both terms, how can that be ?
i also tried with true and false but makes no different.

A second question i have is the relation between an user and an 
attachment. Does the shredder script also looks for this relation, or is 
there only a direct relation between an attachment and a ticket and than 
between a ticket and a user (what about TransactionId) ?

If i understand well, the shredder script checks all dependencies an 
user can have to a ticket (watcher(Requestor, Owner, Cc or AdminCc)).


Best regards

-- 
---
Alexander 

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder bug? (was: Shredder web gui, bad path to tickets)

[Gene LeDuc]

I found the problem with displaying objects returned by the Shredder search 
and I think it might be a bug.  The files in
   rtroot/share/html/Admin/Tools/Shredder/Elements/Object
return a path using $RT::WebBaseURL instead of $RT::WebURL; this leaves off 
$RT::WebPath.  So on my system, links point to 
https://mysystem:443/Ticket/Display.html?id=498
instead of https://mysystem/rt/Ticket/Display.html?id=498

The files I had to modify are
   RT--Attachment
   RT--Ticket
   RT--User

Disclaimer:
Since Shredder has been around awhile and no one else has reported this, 
it's possible that this could be due to settings in my RT_Siteconfig that I 
made to get RT to work using https, but it was a while ago and I don't 
recall how I changed the settings from their default.

Regards,
Gene

At 11:56 AM 2/18/2008, I wrote:
I've just installed the latest Shredder extension via CPAN and it seems to
do its job nicely wiping out deleted tickets via the web gui.  When I click
on a ticket from the search results, though, the path to the ticket is
missing the root rt/ component.  Everything else has been working fine
for a year or more.

The path should be: https://rt.company.com/rt/Ticket/Display.html?id=7
But this is what Shredder search is showing (which returns a 404
error):  https://rt.company.com/Ticket/Display.html?id=7

Is this something that needs to be set in RT_Siteconfig or do I need to
modify the shredder html?

My RT is installed in a non-standard location, but I gave the installer the
path to my RT.pm and everything seemed to install fine.


-- 
Gene LeDuc, GSEC
Security Analyst
San Diego State University 

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder no_tickets Users option behaviour

[Mathew Snyder]

I've set the arguments for the RTx-Shredder Users plugin to
limit: 100
status: any
name:
email:
replace_relations: Nobody
no_tickets: true

This pulled up a list of users that consist of both valid users and those
created from incoming spam.  I then set the no_tickets to false and got the same
list.  Why is there no difference?

-- 
Keep up with me and what I'm up to: http://theillien.blogspot.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder no_tickets Users option behaviour

[Mathew Snyder]

And to clarify, I know that the status of any will pull up any user regardless
of privileges but the users that come up which are enabled do have tickets with
which they are associated.

Keep up with me and what I'm up to: http://theillien.blogspot.com


Mathew Snyder wrote:
 I've set the arguments for the RTx-Shredder Users plugin to
 limit: 100
 status: any
 name:
 email:
 replace_relations: Nobody
 no_tickets: true
 
 This pulled up a list of users that consist of both valid users and those
 created from incoming spam.  I then set the no_tickets to false and got the 
 same
 list.  Why is there no difference?
 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder error and solution

[Stephen Turner]

Hello Ruslan,

I'm getting an error with Shredder 0.07 when trying to shred users:

rtx-shredder --force --plugin Users=limit,100

[Fri Oct 12 15:40:44 2007] [crit]: Can't locate object method 
caught via package RTx::Shredder::Exception::Info at 
./rtx-shredder line 109.

 (/usr/local/rt3/lib/RT.pm:285)

This error has been reported a few times on rt-users, but I didn't 
see a solution.


I believe it's caused by having an old version of Exception::Class 
installed. The latest version is 1.23 - we have 1.20 installed, which 
does not include the caught method.


Anyway, no reply necessary - I just thought I would post this in case 
someone else ran into the problem.


Steve


Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IST)


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder Users plugin and RT_System

[Mathew Snyder]

I was using the Shredder Users plugin for users that don't own tickets and saw
that RT_System was listed as one of those users.  I've got a cron job which
eliminates these users as a vast majority of them are created by spam.  As a
matter of reassurance, RT_System won't be removed will it?

-- 
Keep up with me and what I'm up to: http://theillien.blogspot.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder Error

[Ruslan Zakirov]

See below, note that some lines are commented.

On 6/30/07, Mathew Snyder [EMAIL PROTECTED] wrote:

I'm trying to remove users using the methods within Shredder.  After gathering
all the email addresses I need to remove I call Shredder like such:

RTx::Shredder::Init( force = 1 );
my $shredder = new RTx::Shredder(RT::SystemUser);
# my $resolver = new RTx::Shredder::Plugin::Users(RT::SystemUser);
# $resolver-SetResolver(Shredder = 10);

   my $resolver = sub {
   my %args = (@_);
   my $t =$args{'TargetObject'};
   foreach my $method ( qw(Creator LastUpdatedBy) ) {
   next unless $t-_Accessible( $method = 'read' );
   $t-__Set( Field = $method, Value = 10 );
   }
   };
   $shredder-PutResolver( BaseClass = 'RT::User', Code = $resolver );


# $shredder-PutResolver($resolver);
if ($ans =~ m/^(y|yes)$/i){
my ($fname, $fh) = $shredder-SetFile( FromStorage = 0, FileName =
'/usr/local/rt-3.6.1/var/data/RTx-Shredder/Shredder-Users_.sql' );
foreach my $email (@emails){
my $user = new RT::User(RT::SystemUser);
$user-LoadByEmail($email);
next unless $user-id;
$shredder-PutObject(Object = $user);
}
$shredder-WipeoutAll;
}else{
exit;
}

Using this gives me
Odd number of elements in anonymous hash at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder/Plugin/Base.pm line 23.

I looked at the perldocs and verified that Objects = $user is a valid value.
However, I am wondering if it should be something like $user-EmailAddress or
something.

Can someone shed some light on this for me?

Thanks
Mathew
--
Keep up with me and what I'm up to: http://theillien.blogspot.com

--
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder API questions

[Mathew Snyder]

Maybe I'm just not getting it then.

my $shredder; = new RTx::Shredder(RT::SystemUser);
if ($ans =~ m/^(y|yes)$/i){
my $email;
foreach $email (@emails) {
$shredder-PutObject( Object = $email );
}
$shredder-WipeoutAll;
}

Yields

Odd number of elements in anonymous hash at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Use of uninitialized value in anonymous hash ({}) at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Unsupported type '[EMAIL PROTECTED]'

Trace begun at /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 290
RTx::Shredder::PutObject('RTx::Shredder=HASH(0xa5e40e4)', 'Object',
'[EMAIL PROTECTED]') called at delete_spam_users.pl line 65



 I thought it's clear enough from POD that interface is PutObject(
 Object = $user_obj );

On 1/7/07, Mathew Snyder theillien[at]yahoo.com wrote:
 Ruslan Zakirov wrote:
  On 12/30/06, Mathew Snyder theillien[at]yahoo.com wrote:
  I'm rewriting a script that will eliminate all spam users accrued over
  the
  course of a day. Presently, it is using the least efficient way of
  executing
  the wipeout by performing a system call to rtx-shredder. I would
  prefer to run
  the wipeout by way of the Shredder API. I'm guessing along the lines
  of this:
 
  # load plugin by preformatted string
  my $pluginString =
  'Users=status,any;email,$email;replace_relations,Nobody';
  my $plugin = new RTx::Shredder::Plugin;
  my( $status, $msg ) = $plugin-LoadByString( $pluginString );
  unless( $status ) {
  print STDERR Couldn't load plugin: $msg\n;
  exit(1);
  }
  }
 
  Another question is in regards to the sql dump. I've looked at
  rtx-shredder and
  have seen referrence to the SetFile method but haven't seen anything
  about the
  DumpSQl method that is mentioned in Shredder.pm. Is this automatically
  accounted for when if I use my ($fname, $fh) = $shredder-SetFile;?
 
  The portion of my script this relates to is below.
 
  snip
  foreach my $email (sort(@emails)){
  print $email . \n;
  }
 
  print \nDelete the email addresses from the RT database [y/N]: ;
  chomp($ans = STDIN);
 
  if ($ans =~ m/^(y|yes)$/i){
  my $email;
  foreach $email (@emails){
  # system /usr/local/rt-3.6.1/local/sbin/rtx-shredder --force
  --plugin \
  'Users=status,any;email,$email;replace_relations,Nobody';
  # load plugin by preformatted string
  my $pluginString = \
  'Users=status,any;email,$email;replace_relations,Nobody';
  my $plugin = new RTx::Shredder::Plugin;
  my( $status, $msg ) = $plugin-LoadByString(
  $pluginString );
  unless( $status ) {
  print STDERR Couldn't load plugin: $msg\n;
  exit(1);
  }
  }
  }
  else{
  exit;
  }
  /snip
 
  One problem I can already see with the above snippet is that Shredder
  is called
  seperately for each email address. How do I set this up to run as one
  continuous execution for the entire array of addresses?
  You can use $shredder-PutObject and put sever users' objects into
  shredder and then $shredder-WipeoutAll.
 
 I've tried
 foreach my $email (@emails) {
 $shredder-PutObject (User = $email);
 }

 $shredder-PutObject (User::LoadByEmail = $email);
 $shredder-PutObject (RT::User::LoadByEmail = $email);
 and
 $shredder-PutObject ($email);

 I'm getting
 Odd number of elements in anonymous hash at
 /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
 Use of uninitialized value in anonymous hash ({}) at
 /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
 Odd number of elements in hash assignment at
 /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 287, STDIN line 1.
 Unsupported type '(undef)'

 Trace begun at /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 290
 RTx::Shredder::PutObject('RTx::Shredder=HASH(0xa283e64)',
 'kusare.com[at]focalsecurity.com') called at delete_spam_users.pl line 65

 I looked at line 177 in Shredder and couldn't figure out what I was looking 
 at.
 I also looked at the perldoc for Shredder.pm, User.pm, Users.pm and 
 Record.pm.

 I don't know what I'm missing.

 Mathew




 --
 Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder API questions

[Ruslan Zakirov]

On 1/10/07, Mathew Snyder [EMAIL PROTECTED] wrote:

Maybe I'm just not getting it then.

my $shredder; = new RTx::Shredder;
if ($ans =~ m/^(y|yes)$/i){
my $email;
foreach $email (@emails) {

  my $user = RT::User-new( $RT::SystemUser );
  $user-LoadByEmail( $email );
  next unless $user-id;

$shredder-PutObject( Object = $user );
}
$shredder-WipeoutAll;
}

Yields

Odd number of elements in anonymous hash at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Use of uninitialized value in anonymous hash ({}) at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Unsupported type '[EMAIL PROTECTED]'

Trace begun at /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 290
RTx::Shredder::PutObject('RTx::Shredder=HASH(0xa5e40e4)', 'Object',
'[EMAIL PROTECTED]') called at delete_spam_users.pl line 65



 I thought it's clear enough from POD that interface is PutObject(
 Object = $user_obj );

On 1/7/07, Mathew Snyder theillien[at]yahoo.com wrote:
 Ruslan Zakirov wrote:
  On 12/30/06, Mathew Snyder theillien[at]yahoo.com wrote:
  I'm rewriting a script that will eliminate all spam users accrued over
  the
  course of a day. Presently, it is using the least efficient way of
  executing
  the wipeout by performing a system call to rtx-shredder. I would
  prefer to run
  the wipeout by way of the Shredder API. I'm guessing along the lines
  of this:
 
  # load plugin by preformatted string
  my $pluginString =
  'Users=status,any;email,$email;replace_relations,Nobody';
  my $plugin = new RTx::Shredder::Plugin;
  my( $status, $msg ) = $plugin-LoadByString( $pluginString );
  unless( $status ) {
  print STDERR Couldn't load plugin: $msg\n;
  exit(1);
  }
  }
 
  Another question is in regards to the sql dump. I've looked at
  rtx-shredder and
  have seen referrence to the SetFile method but haven't seen anything
  about the
  DumpSQl method that is mentioned in Shredder.pm. Is this automatically
  accounted for when if I use my ($fname, $fh) = $shredder-SetFile;?
 
  The portion of my script this relates to is below.
 
  snip
  foreach my $email (sort(@emails)){
  print $email . \n;
  }
 
  print \nDelete the email addresses from the RT database [y/N]: ;
  chomp($ans = STDIN);
 
  if ($ans =~ m/^(y|yes)$/i){
  my $email;
  foreach $email (@emails){
  # system /usr/local/rt-3.6.1/local/sbin/rtx-shredder --force
  --plugin \
  'Users=status,any;email,$email;replace_relations,Nobody';
  # load plugin by preformatted string
  my $pluginString = \
  'Users=status,any;email,$email;replace_relations,Nobody';
  my $plugin = new RTx::Shredder::Plugin;
  my( $status, $msg ) = $plugin-LoadByString(
  $pluginString );
  unless( $status ) {
  print STDERR Couldn't load plugin: $msg\n;
  exit(1);
  }
  }
  }
  else{
  exit;
  }
  /snip
 
  One problem I can already see with the above snippet is that Shredder
  is called
  seperately for each email address. How do I set this up to run as one
  continuous execution for the entire array of addresses?
  You can use $shredder-PutObject and put sever users' objects into
  shredder and then $shredder-WipeoutAll.
 
 I've tried
 foreach my $email (@emails) {
 $shredder-PutObject (User = $email);
 }

 $shredder-PutObject (User::LoadByEmail = $email);
 $shredder-PutObject (RT::User::LoadByEmail = $email);
 and
 $shredder-PutObject ($email);

 I'm getting
 Odd number of elements in anonymous hash at
 /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
 Use of uninitialized value in anonymous hash ({}) at
 /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
 Odd number of elements in hash assignment at
 /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 287, STDIN line 1.
 Unsupported type '(undef)'

 Trace begun at /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 290
 RTx::Shredder::PutObject('RTx::Shredder=HASH(0xa283e64)',
 'kusare.com[at]focalsecurity.com') called at delete_spam_users.pl line 65

 I looked at line 177 in Shredder and couldn't figure out what I was looking 
at.
 I also looked at the perldoc for Shredder.pm, User.pm, Users.pm and 
Record.pm.

 I don't know what I'm missing.

 Mathew




 --
 Best regards, Ruslan.




--
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder API questions

[Mathew Snyder]

Ruslan Zakirov wrote:
 On 12/30/06, Mathew Snyder [EMAIL PROTECTED] wrote:
 I'm rewriting a script that will eliminate all spam users accrued over
 the
 course of a day.  Presently, it is using the least efficient way of
 executing
 the wipeout by performing a system call to rtx-shredder.  I would
 prefer to run
 the wipeout by way of the Shredder API.  I'm guessing along the lines
 of this:

 # load plugin by preformatted string
 my $pluginString =
 'Users=status,any;email,$email;replace_relations,Nobody';
 my $plugin = new RTx::Shredder::Plugin;
 my( $status, $msg ) = $plugin-LoadByString( $pluginString );
 unless( $status ) {
 print STDERR Couldn't load plugin: $msg\n;
 exit(1);
 }
 }

 Another question is in regards to the sql dump.  I've looked at
 rtx-shredder and
 have seen referrence to the SetFile method but haven't seen anything
 about the
 DumpSQl method that is mentioned in Shredder.pm.  Is this automatically
 accounted for when if I use my ($fname, $fh) = $shredder-SetFile;?

 The portion of my script this relates to is below.

 snip
 foreach my $email (sort(@emails)){
 print $email . \n;
 }

 print \nDelete the email addresses from the RT database [y/N]: ;
 chomp($ans = STDIN);

 if ($ans =~ m/^(y|yes)$/i){
 my $email;
 foreach $email (@emails){
 #   system /usr/local/rt-3.6.1/local/sbin/rtx-shredder --force
 --plugin \
 'Users=status,any;email,$email;replace_relations,Nobody';
 # load plugin by preformatted string
 my $pluginString = \
 'Users=status,any;email,$email;replace_relations,Nobody';
 my $plugin = new RTx::Shredder::Plugin;
 my( $status, $msg ) = $plugin-LoadByString(
 $pluginString );
 unless( $status ) {
 print STDERR Couldn't load plugin: $msg\n;
 exit(1);
 }
 }
 }
 else{
 exit;
 }
 /snip

 One problem I can already see with the above snippet is that Shredder
 is called
 seperately for each email address.  How do I set this up to run as one
 continuous execution for the entire array of addresses?
 You can use $shredder-PutObject and put sever users' objects into
 shredder and then $shredder-WipeoutAll.
 
I've tried
foreach my $email (@emails) {
$shredder-PutObject (User = $email);
}

$shredder-PutObject (User::LoadByEmail = $email);
$shredder-PutObject (RT::User::LoadByEmail = $email);
and
$shredder-PutObject ($email);

I'm getting
Odd number of elements in anonymous hash at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Use of uninitialized value in anonymous hash ({}) at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Odd number of elements in hash assignment at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 287, STDIN line 1.
Unsupported type '(undef)'

Trace begun at /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 290
RTx::Shredder::PutObject('RTx::Shredder=HASH(0xa283e64)',
'[EMAIL PROTECTED]') called at delete_spam_users.pl line 65

I looked at line 177 in Shredder and couldn't figure out what I was looking at.
 I also looked at the perldoc for Shredder.pm, User.pm, Users.pm and Record.pm.

I don't know what I'm missing.

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder API questions

[Mathew Snyder]

Ruslan Zakirov wrote:
 On 12/30/06, Mathew Snyder [EMAIL PROTECTED] wrote:
 I'm rewriting a script that will eliminate all spam users accrued over
 the
 course of a day.  Presently, it is using the least efficient way of
 executing
 the wipeout by performing a system call to rtx-shredder.  I would
 prefer to run
 the wipeout by way of the Shredder API.  I'm guessing along the lines
 of this:

 # load plugin by preformatted string
 my $pluginString =
 'Users=status,any;email,$email;replace_relations,Nobody';
 my $plugin = new RTx::Shredder::Plugin;
 my( $status, $msg ) = $plugin-LoadByString( $pluginString );
 unless( $status ) {
 print STDERR Couldn't load plugin: $msg\n;
 exit(1);
 }
 }

 Another question is in regards to the sql dump.  I've looked at
 rtx-shredder and
 have seen referrence to the SetFile method but haven't seen anything
 about the
 DumpSQl method that is mentioned in Shredder.pm.  Is this automatically
 accounted for when if I use my ($fname, $fh) = $shredder-SetFile;?

 The portion of my script this relates to is below.

 snip
 foreach my $email (sort(@emails)){
 print $email . \n;
 }

 print \nDelete the email addresses from the RT database [y/N]: ;
 chomp($ans = STDIN);

 if ($ans =~ m/^(y|yes)$/i){
 my $email;
 foreach $email (@emails){
 #   system /usr/local/rt-3.6.1/local/sbin/rtx-shredder --force
 --plugin \
 'Users=status,any;email,$email;replace_relations,Nobody';
 # load plugin by preformatted string
 my $pluginString = \
 'Users=status,any;email,$email;replace_relations,Nobody';
 my $plugin = new RTx::Shredder::Plugin;
 my( $status, $msg ) = $plugin-LoadByString(
 $pluginString );
 unless( $status ) {
 print STDERR Couldn't load plugin: $msg\n;
 exit(1);
 }
 }
 }
 else{
 exit;
 }
 /snip

 One problem I can already see with the above snippet is that Shredder
 is called
 seperately for each email address.  How do I set this up to run as one
 continuous execution for the entire array of addresses?
 You can use $shredder-PutObject and put sever users' objects into
 shredder and then $shredder-WipeoutAll.
 
I've tried
foreach my $email (@emails) {
$shredder-PutObject (User = $email);
}

$shredder-PutObject (User::LoadByEmail = $email);
$shredder-PutObject (RT::User::LoadByEmail = $email);
and
$shredder-PutObject ($email);

I'm getting
Odd number of elements in anonymous hash at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Use of uninitialized value in anonymous hash ({}) at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 177, STDIN line 1.
Odd number of elements in hash assignment at
/usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 287, STDIN line 1.
Unsupported type '(undef)'

Trace begun at /usr/local/rt-3.6.1/local/lib/RTx/Shredder.pm line 290
RTx::Shredder::PutObject('RTx::Shredder=HASH(0xa283e64)',
'[EMAIL PROTECTED]') called at delete_spam_users.pl line 65

I looked at line 177 in Shredder and couldn't figure out what I was looking at.
 I also looked at the perldoc for Shredder.pm, User.pm, Users.pm and Record.pm.

I don't know what I'm missing.

Mathew

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder API questions

[Mathew Snyder]

Mathew Snyder wrote:
 I'm rewriting a script that will eliminate all spam users accrued over the
 course of a day.  Presently, it is using the least efficient way of executing
 the wipeout by performing a system call to rtx-shredder.  I would prefer to 
 run
 the wipeout by way of the Shredder API.  I'm guessing along the lines of this:
 
 # load plugin by preformatted string
 my $pluginString = 'Users=status,any;email,$email;replace_relations,Nobody';
 my $plugin = new RTx::Shredder::Plugin;
 my( $status, $msg ) = $plugin-LoadByString( $pluginString );
 unless( $status ) {
 print STDERR Couldn’t load plugin: $msg\n;
 exit(1);
 }
 }
 
 Another question is in regards to the sql dump.  I've looked at rtx-shredder 
 and
 have seen referrence to the SetFile method but haven't seen anything about the
 DumpSQl method that is mentioned in Shredder.pm.  Is this automatically
 accounted for when if I use my ($fname, $fh) = $shredder-SetFile;?
 
 The portion of my script this relates to is below.
 
 snip
 foreach my $email (sort(@emails)){
 print $email . \n;
 }
 
 print \nDelete the email addresses from the RT database [y/N]: ;
 chomp($ans = STDIN);
 
 if ($ans =~ m/^(y|yes)$/i){
 my $email;
 foreach $email (@emails){
 #   system /usr/local/rt-3.6.1/local/sbin/rtx-shredder --force --plugin \
 'Users=status,any;email,$email;replace_relations,Nobody';
 # load plugin by preformatted string
 my $pluginString = \
 'Users=status,any;email,$email;replace_relations,Nobody';
 my $plugin = new RTx::Shredder::Plugin;
 my( $status, $msg ) = $plugin-LoadByString( $pluginString );
 unless( $status ) {
 print STDERR Couldn’t load plugin: $msg\n;
 exit(1);
 }
 }
 }
 else{
 exit;
 }
 /snip
 
 One problem I can already see with the above snippet is that Shredder is 
 called
 seperately for each email address.  How do I set this up to run as one
 continuous execution for the entire array of addresses?
 
 Any and all help will be greatly appreciated.
 
 Mathew

Can no one help with this?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder API questions

[Mathew Snyder]

I'm rewriting a script that will eliminate all spam users accrued over the
course of a day.  Presently, it is using the least efficient way of executing
the wipeout by performing a system call to rtx-shredder.  I would prefer to run
the wipeout by way of the Shredder API.  I'm guessing along the lines of this:

# load plugin by preformatted string
my $pluginString = 'Users=status,any;email,$email;replace_relations,Nobody';
my $plugin = new RTx::Shredder::Plugin;
my( $status, $msg ) = $plugin-LoadByString( $pluginString );
unless( $status ) {
print STDERR Couldn’t load plugin: $msg\n;
exit(1);
}
}

Another question is in regards to the sql dump.  I've looked at rtx-shredder and
have seen referrence to the SetFile method but haven't seen anything about the
DumpSQl method that is mentioned in Shredder.pm.  Is this automatically
accounted for when if I use my ($fname, $fh) = $shredder-SetFile;?

The portion of my script this relates to is below.

snip
foreach my $email (sort(@emails)){
print $email . \n;
}

print \nDelete the email addresses from the RT database [y/N]: ;
chomp($ans = STDIN);

if ($ans =~ m/^(y|yes)$/i){
my $email;
foreach $email (@emails){
#   system /usr/local/rt-3.6.1/local/sbin/rtx-shredder --force --plugin \
'Users=status,any;email,$email;replace_relations,Nobody';
# load plugin by preformatted string
my $pluginString = \
'Users=status,any;email,$email;replace_relations,Nobody';
my $plugin = new RTx::Shredder::Plugin;
my( $status, $msg ) = $plugin-LoadByString( $pluginString );
unless( $status ) {
print STDERR Couldn’t load plugin: $msg\n;
exit(1);
}
}
}
else{
exit;
}
/snip

One problem I can already see with the above snippet is that Shredder is called
seperately for each email address.  How do I set this up to run as one
continuous execution for the entire array of addresses?

Any and all help will be greatly appreciated.

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder problems objects list os empty

[Pete Phillips]

I'm trying to delete spam addresses from RT 3.4.2, vanilla install, with
the latest shredder from CPAN.

If I run this command:

 /opt/rt3/local/sbin/rtx-shredder  --plugin
Users=status,any;email,[EMAIL PROTECTED]

I get this:

SQL dump file is '/tmp/20061215T134640-0001.sql'
Objects list is empty, try refine search options

The address I use is definitely in the database.


Any help appreciated.
Regards,
Pete
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User Plugin - Email Regex

[Mathew]

Very nice to hear.  Thank you so much

Mathew

Ruslan Zakirov wrote:
 I've dropped that validation part and uploaded shredder 0.04_01 to the
 CPAN.
 Also, it has new option 'no_tickets' in Users plugin.
 
 On 12/13/06, Mathew [EMAIL PROTECTED] wrote:
 I've been running a script that calls rtx-shredder directly passing an
 email from an array.  However, I get a lot of emails that I need to get
 rid of which contain hyphens.  What do I add those to the Users plugin
 email regex in order to allow hyphens?

 Mathew

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

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


 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: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User Plugin - Email Regex

[Mathew]

One other quick question though.  How do I prevent the message that I
ran it without a CurrentUser?

Mathew

Ruslan Zakirov wrote:
 I've dropped that validation part and uploaded shredder 0.04_01 to the
 CPAN.
 Also, it has new option 'no_tickets' in Users plugin.
 
 On 12/13/06, Mathew [EMAIL PROTECTED] wrote:
 I've been running a script that calls rtx-shredder directly passing an
 email from an array.  However, I get a lot of emails that I need to get
 rid of which contain hyphens.  What do I add those to the Users plugin
 email regex in order to allow hyphens?

 Mathew

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

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


 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: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User Plugin - Email Regex

[Ruslan Zakirov]

On 12/15/06, Mathew [EMAIL PROTECTED] wrote:

One other quick question though.  How do I prevent the message that I
ran it without a CurrentUser?

I need more info, I don't see such message.



Mathew

Ruslan Zakirov wrote:
 I've dropped that validation part and uploaded shredder 0.04_01 to the
 CPAN.
 Also, it has new option 'no_tickets' in Users plugin.

 On 12/13/06, Mathew [EMAIL PROTECTED] wrote:
 I've been running a script that calls rtx-shredder directly passing an
 email from an array.  However, I get a lot of emails that I need to get
 rid of which contain hyphens.  What do I add those to the Users plugin
 email regex in order to allow hyphens?

 Mathew

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

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


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








--
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User Plugin - Email Regex

[Mathew Snyder]

When running from the command line and executing this command:
./rtx-shredder --plugin
'Users=email,[EMAIL PROTECTED];status,any;replace_relations,Nobody'

I get this output:
SQL dump file is '/usr/local/rt-3.6.1/local/sbin/20061216T032436-0001.sql'
[Sat Dec 16 03:24:36 2006] [err]: RT::User=HASH(0x98668f8) was created without a
CurrentUser
1 (/usr/local/rt-3.6.1/lib/RT/Base.pm:92)

Mathew

Ruslan Zakirov wrote:
 On 12/15/06, Mathew [EMAIL PROTECTED] wrote:
 One other quick question though.  How do I prevent the message that I
 ran it without a CurrentUser?
 I need more info, I don't see such message.
 

 Mathew

 Ruslan Zakirov wrote:
  I've dropped that validation part and uploaded shredder 0.04_01 to the
  CPAN.
  Also, it has new option 'no_tickets' in Users plugin.
 
  On 12/13/06, Mathew [EMAIL PROTECTED] wrote:
  I've been running a script that calls rtx-shredder directly passing an
  email from an array.  However, I get a lot of emails that I need to
 get
  rid of which contain hyphens.  What do I add those to the Users plugin
  email regex in order to allow hyphens?
 
  Mathew
 
  ___
  http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
  Community help: http://wiki.bestpractical.com
  Commercial support: [EMAIL PROTECTED]
 
 
  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: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User Plugin - Email Regex

[Ruslan Zakirov]

I've dropped that validation part and uploaded shredder 0.04_01 to the CPAN.
Also, it has new option 'no_tickets' in Users plugin.

On 12/13/06, Mathew [EMAIL PROTECTED] wrote:

I've been running a script that calls rtx-shredder directly passing an
email from an array.  However, I get a lot of emails that I need to get
rid of which contain hyphens.  What do I add those to the Users plugin
email regex in order to allow hyphens?

Mathew

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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




--
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder User Plugin - Email Regex

[Mathew]

I've been running a script that calls rtx-shredder directly passing an
email from an array.  However, I get a lot of emails that I need to get
rid of which contain hyphens.  What do I add those to the Users plugin
email regex in order to allow hyphens?

Mathew

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder Users plugin error about invalid characters

[Mathew Snyder]

I have a script that gathers up all the newest spam users created over the
course of a day and iterates over each one calling rtx-shredder with the Users
plugin.

It occassionaly spits out an error thusly:
Couldn't load plugin
Error: Invalid characters in email '[EMAIL PROTECTED]'

The email address that cause the error are pretty much the same format as that
above with the hyphen in the domain part.  I'm guessing that is the error's
cause.  The strange thing though is that I've never received this error when
running the plugin from the UI.

Also, how do I call Shredder as RT::SystemUser so I don't get the
RT::User=HASH(0xb01b258) was created without a CurrentUser error?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User plugin mangling tickets?

[Mathew Snyder]

This is the raw error:

Can't call method Name on an undefined value at
/usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line 690.


Trace begun at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Exceptions.pm line 
129
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method Name on an
undefined value at /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line
690.^J') called at /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line 690
RT::Transaction::__ANON__('RT::Transaction=HASH(0xa45b39c)') called at
/usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line 602
RT::Transaction::BriefDescription('RT::Transaction=HASH(0xa45b39c)') called at
/usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowTransaction line 54
HTML::Mason::Commands::__ANON__('Attachments',
'RT::Attachments=HASH(0xa4bc418)', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'AttachmentContent', 'RT::Attachments=HASH(0xa42ebd8)', 'ShowHeaders', undef,
'Collapsed', undef, 'Tickets', undef, 'AttachPath', '/Ticket/Attachment',
'UpdatePath', '/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'Transaction', 'RT::Transaction=HASH(0xa45b39c)', 'ShowHeaders', undef,
'Collapsed', undef, 'RowNum', 12, 'ShowTitleBarCommands', 1, 'Attachments',
'ARRAY(0xa40c70c)', 'AttachmentContent', 'HASH(0xa4a0288)', 'LastTransaction',
0) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa308b10)',
'Attachments', 'RT::Attachments=HASH(0xa4bc418)', 'Ticket',
'RT::Ticket=HASH(0xa4625ac)', 'AttachmentContent',
'RT::Attachments=HASH(0xa42ebd8)', 'ShowHeaders', undef, 'Collapsed', undef,
'Tickets', undef, 'AttachPath', '/Ticket/Attachment', 'UpdatePath',
'/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)', 'Transaction',
'RT::Transaction=HASH(0xa45b39c)', 'ShowHeaders', undef, 'Collapsed', undef,
'RowNum', 12, 'ShowTitleBarCommands', 1, 'Attachments', 'ARRAY(0xa40c70c)',
'AttachmentContent', 'HASH(0xa4a0288)', 'LastTransaction', 0) called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, 'Attachments',
'RT::Attachments=HASH(0xa4bc418)', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'AttachmentContent', 'RT::Attachments=HASH(0xa42ebd8)', 'ShowHeaders', undef,
'Collapsed', undef, 'Tickets', undef, 'AttachPath', '/Ticket/Attachment',
'UpdatePath', '/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'Transaction', 'RT::Transaction=HASH(0xa45b39c)', 'ShowHeaders', undef,
'Collapsed', undef, 'RowNum', 12, 'ShowTitleBarCommands', 1, 'Attachments',
'ARRAY(0xa40c70c)', 'AttachmentContent', 'HASH(0xa4a0288)', 'LastTransaction',
0) called at /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowHistory line 102
HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef, 'Attachments',
'RT::Attachments=HASH(0xa4bc418)', 'AttachmentContent',
'RT::Attachments=HASH(0xa42ebd8)') called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa2ff7f0)',
'Ticket', 'RT::Ticket=HASH(0xa4625ac)', 'Tickets', undef, 'Collapsed', undef,
'ShowHeaders', undef, 'Attachments', 'RT::Attachments=HASH(0xa4bc418)',
'AttachmentContent', 'RT::Attachments=HASH(0xa42ebd8)') called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef, 'Attachments',
'RT::Attachments=HASH(0xa4bc418)', 'AttachmentContent',
'RT::Attachments=HASH(0xa42ebd8)') called at
/usr/local/rt-3.6.1/share/html/Ticket/Display.html line 63
HTML::Mason::Commands::__ANON__('id', 39852, 'id', 39852) called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa207760)',
'id', 39852, 'id', 39852) called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, 'id', 39852, 'id', 39852) called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 914
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xa4e966c)',
'id', 39852) called at /usr/local/rt-3.6.1/share/html/autohandler line 279
HTML::Mason::Commands::__ANON__('id', 39852) called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9e1cf98)',
'id', 39852) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
line 1246
eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245

[rt-users] Shredder User plugin mangling tickets?

[Mathew Snyder]

We have roughly 9500 illegitimate users that were created by incoming spam.
I've been doing my best to eliminate these users by way of the Shredder Users
plugin.  For the most part, this has been a successful operation.  However, due
to the number of legitimate users, picking out the spam users is not a perfect
science and I've inadvertently removed legitimate users.

This has resulted in a ticket getting mangled...I think.  I'm not sure why it
would cause the transactions to get messed up or even if it has.  But this is
the output generated on the latest ticket to suffer the problem:

error:
Can't call method Name on an undefined value at
/usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line 690.

context:
... 
686:AddWatcher = sub {
687:my $self = shift;
688:my $principal = RT::Principal-new($self-CurrentUser);
689:$principal-Load($self-NewValue);
690:return $self-loc( [_1] [_2] added, $self-Field,
$principal-Object-Name);
691:},
692:DelWatcher = sub {
693:my $self = shift;
694:my $principal = RT::Principal-new($self-CurrentUser);
... 

code stack:
/usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm:690
/usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm:602
/usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowTransaction:54
/usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowHistory:102
/usr/local/rt-3.6.1/share/html/Ticket/Display.html:63
/usr/local/rt-3.6.1/share/html/autohandler:279

The ticket displays a few of the transactions on the ticket then the above 
error.

Is this a result of the Requestor being removed as a suspected spam created user
or the indication of something else?  I've removed roughly 8500 users already
and have only seen this happen once before.  If there is no cure for it I'm not
too concerned as the nature of the method of removing these users is error prone
and I've made that clear to my superiors.  However, if there is a way to avoid
this, I would love to know.

Thanks,
Mathew
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User plugin mangling tickets?

[Jesse Vincent]

 plugin.  For the most part, this has been a successful operation.  However, 
 due
 to the number of legitimate users, picking out the spam users is not a perfect
 science and I've inadvertently removed legitimate users.
 
 This has resulted in a ticket getting mangled...I think.  I'm not sure why it
 would cause the transactions to get messed up or even if it has.  But this is
 the output generated on the latest ticket to suffer the problem:

You've removed the user a transaction referred to. RT can't find
something that's...well, never supposed to be removed. So it's
exploding.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder User plugin mangling tickets?

[Mathew Snyder]

Jesse Vincent wrote:
 
 plugin.  For the most part, this has been a successful operation.  However, 
 due
 to the number of legitimate users, picking out the spam users is not a 
 perfect
 science and I've inadvertently removed legitimate users.

 This has resulted in a ticket getting mangled...I think.  I'm not sure why it
 would cause the transactions to get messed up or even if it has.  But this is
 the output generated on the latest ticket to suffer the problem:
 
 You've removed the user a transaction referred to. RT can't find
 something that's...well, never supposed to be removed. So it's
 exploding.
 

Besides, if I set the replace_relations field to nobody, shouldn't it assign all
those transactions to the Nobody user?  Or would I have to use the id for
Nobody?  Or is using nobody with lowercase 'n' not the same as Nobody with
uppercase 'N'?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder Search.html not found

[David Smithson]

Is this expected or is my install wrong?:

/Admin/Tools/Shredder/Search.html was not found on this server

RT 3.6.1rc2

David Smithson

ActivSupport, Inc.
Your Flexible IT Partner
Microsoft Gold Partner -- Small Business Specialist
http://www.activsupport.com
Director of Technical Services
Direct: (415) 869 2991 

Technical Support Hotline: (415) 979 9285 
CLICK HERE FOR ONLINE SUPPORT 

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

RE: [rt-users] Shredder Search.html not found

[David Smithson]

I suppose you've updated the repository and I can just download and
install again?  I'm getting the source from
http://search.cpan.org/dist/RTx-Shredder.

David Smithson


CLICK HERE FOR ONLINE SUPPORT

-Original Message-
From: Ruslan Zakirov [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 08, 2006 11:46 PM
To: David Smithson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Shredder Search.html not found

Expected, I forgot to write that file :)

On 8/9/06, David Smithson [EMAIL PROTECTED] wrote:
 Is this expected or is my install wrong?:

 /Admin/Tools/Shredder/Search.html was not found on this server

 RT 3.6.1rc2

 David Smithson
 
 ActivSupport, Inc.
 Your Flexible IT Partner
 Microsoft Gold Partner -- Small Business Specialist
 http://www.activsupport.com
 Director of Technical Services
 Direct: (415) 869 2991
 
 Technical Support Hotline: (415) 979 9285
 CLICK HERE FOR ONLINE SUPPORT

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

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


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



-- 
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] Shredder error

[Mathew Snyder]

I've eliminated several thousand tickets that were deemed spam.  Now I'm
trying to eliminate all the users that were created as each of the spam
tickets were.  However, when I run the Users plugin I get the following
error on some of the tickets:

Couldn't wipeout object: Couldn't find resolver for dependency
'RT::User-14767 (depends on,resolvable dependency) RT::Attachment-11334'
at /usr/local/rt-3.6.0/local/lib/RTx/Shredder.pm line 394

Have I messed up by removing the tickets first?  Is there a way to
remove the users by ignoring the dependency?

Thanks,
Mathew Snyder
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder error

[Ruslan Zakirov]

search in archives, this error is documented and means next thing:
RT::Attachment-11334 was created by RT::User-14767, read help for users plugin.

On 8/3/06, Mathew Snyder [EMAIL PROTECTED] wrote:

I've eliminated several thousand tickets that were deemed spam.  Now I'm
trying to eliminate all the users that were created as each of the spam
tickets were.  However, when I run the Users plugin I get the following
error on some of the tickets:

Couldn't wipeout object: Couldn't find resolver for dependency
'RT::User-14767 (depends on,resolvable dependency) RT::Attachment-11334'
at /usr/local/rt-3.6.0/local/lib/RTx/Shredder.pm line 394

Have I messed up by removing the tickets first?  Is there a way to
remove the users by ignoring the dependency?

Thanks,
Mathew Snyder
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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




--
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Shredder installation problem

[Mathew]

I'm actually installing to an rt directory in /usr/local/.  I hadn't 
done a recursive chown but had found that the Callbacks directory under 
share/html is not getting the proper mode when rt is initially 
installed.  Since Shredder places files in this directory, they were not 
accessible.  Chmod'ing the directory to 755 (installs as 700) allows 
Shredder to perform properly.  Chmod'ing other directories is also 
needed, such as local/sbin.


I haven't checked the umask so I'll do that when I get in to work 
tomorrow night.  Thanks for that advice.


Mathew Snyder

Ole Craig wrote:

On Sun, 2006-07-30 at 02:14 -0400, Mathew Snyder wrote:

Again, I'm testing a new installation of RT v3.6.0 with RTx::Shredder.
However, when I install Shredder I get this

The requested URL /Admin/Tools/Shredder/ was not found on this server.

I'm finding that the directories created and used during installation
are being chmod'ed to 700 making them not readable by the rt group/user.
 Why is this happening?  I'm installing as root and have also installed
using sudo.  I get the same results everytime.  Shredder is not showing up?

Please...help me.  I need this to be working.



Matthew -
What's root's umask? What are the permissions on each directory in the
hierarchy? (i.e. if you're using the defaults, what are the permissions
on /, /opt, and /opt/rt3?)

Is the problem not solved by a simple recursive chown on the install
directory?


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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



We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] Shredder installation problem

[Mathew Snyder]

Again, I'm testing a new installation of RT v3.6.0 with RTx::Shredder.
However, when I install Shredder I get this

The requested URL /Admin/Tools/Shredder/ was not found on this server.

I'm finding that the directories created and used during installation
are being chmod'ed to 700 making them not readable by the rt group/user.
 Why is this happening?  I'm installing as root and have also installed
using sudo.  I get the same results everytime.  Shredder is not showing up?

Please...help me.  I need this to be working.

Thank You,
Mathew Snyder
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [rt-users] Shredder CLI Question

[Mathew Snyder]

Sorry, v04.

Mathew Snyder
Systems Administrator
Network+
ServerVault TechOps



Ruslan Zakirov wrote:
 RT/Shredder versions?
 
 On 6/23/06, Mathew Snyder [EMAIL PROTECTED] wrote:
 I'm trying to test out the removal of deleted tickets using the
 rtx-shredder CLI method.  I've been entering it nearly verbatim from the
 RTx::Shredder page on CPAN (ie, rtx-shredder --force --plugin
 'Tickets=queue,CustomerCare;status,deleted').  However, nothing is being
 done.  I don't know where the log file for mysql is aside from
 /var/log/mysqld.log.  But that doesn't provide any useful information.

 I'm wondering if Im supposed to provide the password for the rt3
 database somewhere.

 Any help would be appreciated.


 -- 
 Mathew Snyder
 Systems Administrator
 Network+
 ServerVault TechOps

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

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


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


 We're hiring! Come hack Perl for Best Practical:
 http://bestpractical.com/about/jobs.html

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [rt-users] Shredder error - 404 FnF

[Ruslan Zakirov]

Shredder-0.04 should fix 404 error.

On 1/30/06, Stewart Tranter [EMAIL PROTECTED] wrote:

Stephen Turner wrote:
 What are the permissions on the
 /opt/rt3/share/html/Admin/Tools/Shredder  directory?

 And what options did you use in the installation for 'perl Makefile.PL' ?


Hi Steve,

The permissions for the /opt/rt3/share/html/Admin/Tools/Shredder
directory are:

drwxr-xr-x  3 root bin 4096 Jan 27 12:03 Shredder

and I used no options on running 'perl Makefile.PL'.

Thanks,

Stewart

Stewart Tranter
Computing Services
Loughborough University

E:  [EMAIL PROTECTED]
W:  http://www.lboro.ac.uk/computing/
T:  +44 (0) 1509 223719
F:  +44 (0) 1509 223989

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

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O'Reilly Media at 
http://rtbook.bestpractical.com

WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at http://bestpractical.com/services/training.html




--
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html