How do I can change the foo.com to bar.com for every users email address in RT ?
foo.com is invalid and need to be replaced by bar.com to avoid error like this [Thu Aug 2 17:44:27 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: Autocreated on ticket submission, Disabled: , EmailAddress: [email protected], Name: exmend6, Password: , Privileged: , RealName: John Doe (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:651) [Thu Aug 2 17:44:27 2012] [crit]: User creation failed in mailgateway: Name in use (/opt/rt3/bin/../lib/RT/Interface/Email.pm:244) [Thu Aug 2 17:44:28 2012] [warning]: Couldn't load user '[email protected]'.giving up (/opt/rt3/bin/../lib/RT/Interface/Email.pm:806) [Thu Aug 2 17:44:28 2012] [crit]: User '[email protected]' could not be loaded in the mail gateway (/opt/rt3/bin/../lib/RT/Interface/Email.pm:244) [Thu Aug 2 17:44:28 2012] [error]: RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for this email ([email protected]). You might need to grant 'Everyone' the right 'CreateTicket' for the queue Help. (/opt/rt3/bin/../lib/RT/Interface/Email.pm:244) <== this is already in place! [Thu Aug 2 17:44:28 2012] [error]: RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for your email. (/opt/rt3/bin/../lib/RT/Interface/Email.pm:244) [Thu Aug 2 17:44:28 2012] [error]: Could not record email: Could not load a valid user (/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway:75) I had a suggestion from [email protected] to patch local/lib/RT/User_Local.pm to allow foo.com as well. However since there should not be any foo.com (compnay is bought and moved to bar.com) I think I like to attempt to just change the email address since it works fine when I do it manually for a user. I just want to do it for all foo.com users through script or database? Thanks -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
