Re: [rt-users] Shredding users
G.Booth, Yep, that seems odd. I've done most of my changes to the USERS Table manually in the past. WAY too intense! I'm hoping to move over to shredder with the 3.8.6 version we're about to test. Kenn LBNL On 11/17/2009 9:56 AM, G.Booth wrote: > On Tue, 17 Nov 2009 08:30:49 -0800 > Ken Crocker wrote: >> G.Booth, >> >> You could also use the SQL native to your DataBase and do it >> manually. However, keep in mind that it is a RISKY business. You must >> be sure that whatever UserID you change the info to REALLY exists, or >> your history will break when looking at a ticket. >> >> Kenn >> LBNL > > Hi Kenn > > Im trying to avoid that if I can, for just the reasons you list. > I can't figure out what the "replace_relations" part of the shredder > is for if not this. If you dump the sql as you run the shred and > re-inject it into the database, it seems (at first glance) to have > done exactly what I want and all i need to do is now delete the > original user. It seems very odd that it would let you go to all of > the trouble to rename everything only to then wipe all evidence of it. > > regards > Garry > ___ 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] Shredding users
On Tue, 17 Nov 2009 08:30:49 -0800 Ken Crocker wrote: > G.Booth, > > You could also use the SQL native to your DataBase and >do it manually. However, keep in mind that it is a RISKY >business. You must be sure that whatever UserID you >change the info to REALLY exists, or your history will >break when looking at a ticket. > > Kenn > LBNL Hi Kenn Im trying to avoid that if I can, for just the reasons you list. I can't figure out what the "replace_relations" part of the shredder is for if not this. If you dump the sql as you run the shred and re-inject it into the database, it seems (at first glance) to have done exactly what I want and all i need to do is now delete the original user. It seems very odd that it would let you go to all of the trouble to rename everything only to then wipe all evidence of it. regards Garry ___ 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] Shredding users
G.Booth, You could also use the SQL native to your DataBase and do it manually. However, keep in mind that it is a RISKY business. You must be sure that whatever UserID you change the info to REALLY exists, or your history will break when looking at a ticket. Kenn LBNL On 11/17/2009 8:02 AM, Andy Millar wrote: On Tue, 2009-11-17 at 15:50 +, G.Booth wrote: Id like to change the histroy in the ticket so user becomes user-old throughout, sadly changing the ticket owner doesnt do this :-[ Then I suspect shredder is the wrong tool. Have you considered just renaming all the users using the RT API? (ok, I'm making a little bit of an assumption that you can do this, but I'd guess you can). Andy ___ 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] Shredding users
On Tue, 2009-11-17 at 15:50 +, G.Booth wrote: > Id like to change the histroy in the ticket so user becomes user-old > throughout, sadly changing the ticket owner doesnt do this :-[ > Then I suspect shredder is the wrong tool. Have you considered just renaming all the users using the RT API? (ok, I'm making a little bit of an assumption that you can do this, but I'd guess you can). Andy ___ 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] Shredding users
On Tue, 2009-11-17 at 15:05 +, G.Booth wrote: > This does everything I want except it still shreds the tickets, whereas I > only wanted to get rid of the original user account and preserver the > tickets with another user. Does anybody know if theres a way to do this > through the shredder tool? I guess your best bet would be to change the owner of the tickets first before running the shredder tool? Andy ___ 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] Shredding users
> I guess your best bet would be to change the owner of >the tickets first > before running the shredder tool? > > Andy Hi Andy Id like to change the histroy in the ticket so user becomes user-old throughout, sadly changing the ticket owner doesnt do this :-[ regards Garry ps I tested this on 3.8.1 (shouldve mentioned in the original email - doh!) ___ 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] Shredding users
Hi Got a quick query regarding the shredder. Im trying to move a users cases to a different user and then shred the first user, using: rt-shredder --plugin "Users=name,user;status,any;replace_relations,user-old" This does everything I want except it still shreds the tickets, whereas I only wanted to get rid of the original user account and preserver the tickets with another user. Does anybody know if theres a way to do this through the shredder tool? regards Garry -- Dr Garry Booth IT Services Loughborough University ___ 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] Shredding Users wipes out a Ticket - bug?
I have a script executed by a cron job that is intended to remove unprivileged Users who are not Watchers from the DB. The Shredder command it generates looks like this: /opt/rt3/sbin/rt-shredder --force -sqldump /opt/rt3/var/data/RT-Shredder/Users/2009-10-01-7384.sql --plugin 'Users=status,any;limit,100;no_tickets,1;replace_relations,Nobody;member_of,unprivileged' A recent run removed a Ticket apparently because it had earlier removed a User who had submitted a Reply to that Ticket. The User was otherwise not a Watcher of any Ticket. The user (i.e., the person who owned the shredded User account) also owned the (different) account that was the Requestor for the shredded Ticket. I.e., Person P submits request using email account A(EM) RT creates Ticket T and possibly RT account A(RT) P responds to Reply from RT using email account B(EM) RT creates RT account B(RT) Shredder removes B(RT) because B(RT) is not a Watcher of any Ticket and as part of the same process Shredder removes Ticket T (because it contains content submitted by B(RT)?) Is this a bug? It would seem so to me. Is there a workaround? -- Gary Hall Network Support Group Simon Fraser University ___ 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