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@yyyyyyyy.com | NULL |
| 40 | binand@xxxxxxxxxxxx.com | binand@xxxxxxxxxxxx.com | Autocreated on ticket submission |
| 55 | binands@xxxxxxxxxxxx.com | binands@xxxxxxxxxxxx.com | Autocreated on ticket submission |
| 101 | binand@gmx.net | binand@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@xxxxxxxxxxxx.com. Is it ok if I do an UPDATE in the database? 
RT version is 2.0.13.
TIA,
Binand
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 checked and found that my new email address is
already present in RT’s database, as “Autocreated on ticket submission”.
mysql> select id,Name,EmailAddress,Comments from Users where EmailAddress like ‘%binand%’;
±----±-------------------------±-------------------------±---------------------------------+
| id | Name | EmailAddress | Comments |
±----±-------------------------±-------------------------±---------------------------------+
| 4 | binand | binand@yyyyyyyy.com | NULL |
| 40 | binand@xxxxxxxxxxxx.com | binand@xxxxxxxxxxxx.com | Autocreated on ticket submission |
| 55 | binands@xxxxxxxxxxxx.com | binands@xxxxxxxxxxxx.com | Autocreated on ticket submission |
| 101 | binand@gmx.net | binand@gmx.net | Autocreated on ticket submission |
±----±-------------------------±-------------------------±---------------------------------+
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@xxxxxxxxxxxx.com. Is it ok if I do an UPDATE in the database?
You can update the database, but don’t just update the email for id=4.
You also have to go through every record type which points at a user
and change any of the values 40, 55 and 101 to 4. (Presuming that
you really want to merge them). If you really don’t care about merging
the old data, you could try this
update Users set Name=‘binand@old’, EmailAddress=‘binand@old’ where id = 55
update Users set EmailAddress=‘binands@xxxxxxxxx.com’ where id = 4
I’m assuming that it would be very bad to have two User records to have
the same name, and that it would probably be bad for one record to have
an EmailAddress that matches the Name of another record.
-tony aiuto