[rt-users] how to change email address for all existing users of domain foo.com from userA at foo.com to userA at bar.com?

[Asif Iqbal]

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:
John.Doe at bar.com, 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
'John.Doe at bar.com'.giving up
(/opt/rt3/bin/../lib/RT/Interface/Email.pm:806)
[Thu Aug  2 17:44:28 2012] [crit]: User  'John.Doe at bar.com' 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 (John.Doe at bar.com).

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 ktm at rice.edu 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?