How to change email address for all existing users of domain foo.com from userA@foo.com to userA@bar.com?

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

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
I had a suggestion from ktm@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?

Should I use RT::Extension::MergeUsers ? I have 4820 enabled users and
another 80 disabled users with
email domain foo.com. I need to move them to bar.com. foo.com is not valid
anymore and causing
issues like this for old accounts like ‘john.doe@foo.com’ when trying to
create new tickets from ‘john.doe@bar.com’

[Wed Apr 10 22:05:02 2013] [info]:
RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments:
Autocreated on ticket submission, Disabled: , EmailAddress:
john.doe@bar.com, Name: jdoe, Password: , Privileged: , RealName: John Doe
(/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:651)
[Wed Apr 10 22:05:02 2013] [crit]: User creation failed in mailgateway:
Name in use (/opt/rt3/bin/…/lib/RT/Interface/Email.pm:244)
[Wed Apr 10 22:05:02 2013] [warning]: Couldn’t load user
‘john.doe@bar.com’.giving
up (/opt/rt3/bin/…/lib/RT/Interface/Email.pm:806)
[Wed Apr 10 22:05:02 2013] [crit]: User ‘john.doe@bar.com’ could not be
loaded in the mail gateway (/opt/rt3/bin/…/lib/RT/Interface/Email.pm:244)
[Wed Apr 10 22:05:02 2013] [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@bar.com).

You might need to grant ‘Everyone’ the right ‘CreateTicket’ for the <==
this is always there for last 10 yrs
queue help. (/opt/rt3/bin/…/lib/RT/Interface/Email.pm:244)
[Wed Apr 10 22:05:02 2013] [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)
[Wed Apr 10 22:05:03 2013] [error]: Could not record email: Could not load
a valid user (/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway:75)

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?