[rt-users] Deleting/Merging users

[Binand Raj S.]

Hi,

My employer has moved to a new domain, and hence we all have new email
addresses.

I tried changing my email address from the Configuration menu, but it said
"Permission Denied".

I tried doing this as rt root, but got "Illegal value in EmailAddress".

I checked and found that my new email address is already present in RT's
database, as "Autocreated on ticket submission".

How do I merge these accounts?

mysql> select id,Name,EmailAddress,Comments from Users where EmailAddress like '%binand%';
+-----+--------------------------+--------------------------+----------------------------------+
| id  | Name                     | EmailAddress             | Comments                         |
+-----+--------------------------+--------------------------+----------------------------------+
|   4 | binand                   | binand at yyyyyyyy.com      | NULL                             |
|  40 | binand at xxxxxxxxxxxx.com  | binand at xxxxxxxxxxxx.com  | Autocreated on ticket submission |
|  55 | binands at xxxxxxxxxxxx.com | binands at xxxxxxxxxxxx.com | Autocreated on ticket submission |
| 101 | binand at gmx.net           | binand at gmx.net           | Autocreated on ticket submission |
+-----+--------------------------+--------------------------+----------------------------------+
4 rows in set (0.01 sec)

I want to merge all these into one account, with id = 4. Or if
simpler, I just want to change the EmailAddress for id = 4 to
binands at xxxxxxxxxxxx.com. Is it ok if I do an UPDATE in the database? :-)

RT version is 2.0.13.

TIA,

Binand