User edit issues

[cmglobal]

Somehow everytime I pull up the account 'mjames' I get an error and cannot edit anything. It appears multiple addresses are associated with the mailbox which is causing confusion? Anyone have any ideas how I can fix this mailbox so I can edit settings for it in the admin?

Error I get:
2009-11-09 23:08:02,530 INFO [btpool0-7] [name=admin@domain.com;mid=7;ip=192.168.0.23;ua=Zim braWebClient - IE7 (Win);] soap - GetAccountRequest
2009-11-09 23:08:02,624 INFO [btpool0-7] [name=admin@domain.com;mid=7;ip=192.168.0.23;ua=Zim braWebClient - IE7 (Win);] SoapEngine - handler exception
com.zimbra.cs.account.AccountServiceException: lookup returned multiple accounts: getAccountByQuery: (&(zimbraId=3f77aa1a-d377-41c7-a11f-530285520787)(objectclass=zimbraAccount)) returned multiple entries at [uid=mjames,ou=people,dc=mydomain,dc=com] [uid=mjames,ou=people,dc=mydomain2,dc=com]
ExceptionId:btpool0-7:1257829682624:d3934cf22f8b1ace
Code:account.MULTIPLE_ACCOUNTS_MATCHED
at com.zimbra.cs.account.AccountServiceException.MULT IPLE_ACCOUNTS_MATCHED(AccountServiceException.java :147)
at com.zimbra.cs.account.ldap.LdapProvisioning.getAcc ountByQuery(LdapProvisioning.java:532)
at com.zimbra.cs.account.ldap.LdapProvisioning.getAcc ountById(LdapProvisioning.java:558)
at com.zimbra.cs.account.ldap.LdapProvisioning.get(Ld apProvisioning.java:582)
at com.zimbra.cs.account.Provisioning.get(Provisionin g.java:1917)
at com.zimbra.cs.service.admin.AdminDocumentHandler.g etAccount(AdminDocumentHandler.java:101)
at com.zimbra.cs.service.admin.AdminDocumentHandler.p roxyIfNecessary(AdminDocumentHandler.java:141)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:421)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)

[veronica]

From the logs I can see :-

2009-11-09 23:08:02,624 INFO [btpool0-7] [name=admin@domain.com.com;mid=7;ip=192.168.0.23;ua =ZimbraWebClient - IE7 (Win);] SoapEngine - handler exception

Can you try deleting admin@domain.com.com ?

[cmglobal]

From the logs I can see :-

2009-11-09 23:08:02,624 INFO [btpool0-7] [name=admin@domain.com.com;mid=7;ip=192.168.0.23;ua =ZimbraWebClient - IE7 (Win);] SoapEngine - handler exception

Can you try deleting admin@domain.com.com ?

That was a typo which I have corrected just now when trying to conceal some information. There is only a .com

It seems that there are 2 addresses associated with the mailbox, and I need to change it in the LDAP somehow or somewhere to change it so only one address maps/OWNs the account

[veronica]

zmprov gaa | grep -i admin

what this returns ?

[cmglobal]

zmprov gaa | grep -i admin

what this returns ?

Actually it's not the admin@mydomain.com that has the problem.

It's the mjames@mydomain.com that seems to have two accounts associated with the mailbox which is returning that Error code of Multiple Accounts, which has this mailbox all wacked out.

When I run zmprov gaa | grep -i mjames

It shows just mjames@mydomain2.com (which is right)

But somehow in the system somewhere mjames@mydomain.com is also associated/link to it.....

Any other ideads?

[veronica]

Thats odd : -

So as per log:-

[uid=mjames,ou=people,dc=mydomain,dc=com] [uid=mjames,ou=people,dc=mydomain2,dc=com]

are users in 2 different domains returned for same zimbraId=3f77aa1a-d377-41c7-a11f-530285520787

Can you run ldapsearch -x -h `zmhostname` -D cn=config -w ldap_password uid=mjames ? what zimbraId does it return ?

Also when you connect to mysql : -

mysql zimbra

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5071
Server version: 5.0.85-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from mailbox where account_id='3f77aa1a-d377-41c7-a11f-530285520787';


How many entries does it return ?

[cmglobal]

# mjames, people, mydomain.com
dn: uid=mjames,ou=people,dc=mydomain,dc=com
zimbraAccountStatus: active
zimbraMailDeliveryAddress: mjames@mydomain.com
zimbraId: 3f77aa1a-d377-41c7-a11f-530285520787
zimbraMailStatus: enabled
mail: mjames@mydomain.com
mail: mjames@mydomain3.com
mail: mjames@zimbra.mydomain.com
uid: mjames
objectClass: organizationalPerson
objectClass: zimbraAccount
objectClass: amavisAccount
zimbraMailHost: zimbra.mydomain.com
zimbraHideInGal: TRUE
sn: Johnston
givenName: Barry
cn: Barry Johnston
displayName: Barry Johnston
zimbraMailAlias: mjames@mydomain3.com
zimbraMailAlias: mjames@zimbra.mydomain.com
zimbraPasswordModifiedTime: 20090924170739Z
userPassword:: e1NTSEF9RnJ5c3VkT1h0WDVFVHBud0tKSGNRY2FuMlRJTjRtZm U=
zimbraPrefDefaultSignatureId: 0c7fa37b-396f-4fe2-9063-88a405955951
zimbraSignatureName: Standard mydomain
zimbraPrefMailSignature:: QmFycnkgSm9obnN0b24KQ01HIEVuZXJneSBTb2x1dGlvbnMgCk NN
IEdsb2JhbAoKT2ZmaWNlOiAgOTc4LjM3My42OTY1CkNlbGw6IC A5NzguOTk0LjM0MTYKYmpvaG5zd
G9uQGNtZ2xvLmNvbQo=
zimbraSignatureId: 0c7fa37b-396f-4fe2-9063-88a405955951
zimbraMailTransport: lmtp:zimbra:7025
zimbraPrefComposeFormat: html
zimbraPrefGroupMailBy: message
zimbraLastLogonTimestamp: 20091109100810Z
zimbraPrefTagTreeOpen: TRUE
zimbraPrefFolderTreeOpen: TRUE
zimbraPrefZimletTreeOpen: FALSE
zimbraPrefSearchTreeOpen: TRUE
zimbraPrefReadingPaneEnabled: TRUE

# mjames, people, mydomain3.com
dn: uid=mjames,ou=people,dc=mydomain2,dc=com
zimbraId: f1a5a701-281e-48a6-9d37-9e02c3c3bf13
uid: mjames
zimbraAliasTargetId: 3f77aa1a-d377-41c7-a11f-530285520787
objectClass: zimbraAlias

# mjames, people, zimbra.mydomain.com
dn: uid=mjames,ou=people,dc=zimbra,dc=mydomain,dc=com
zimbraId: 73df8be9-2dd6-4baa-aa40-2a7d1e8f01ea
uid: mjames
zimbraAliasTargetId: 3f77aa1a-d377-41c7-a11f-530285520787
objectClass: zimbraAlias

# mjames, people, mydomain2.com
dn: uid=mjames,ou=people,dc=mydomain2,dc=com
displayName: Barry Johnston
zimbraSignatureId: 0c7fa37b-396f-4fe2-9063-88a405955951
givenName: Barry
objectClass: organizationalPerson
objectClass: zimbraAccount
objectClass: amavisAccount
zimbraHideInGal: TRUE
zimbraPrefComposeFormat: html
userPassword:: e1NTSEF9RnJ5c3VkT1h0WDVFVHBud0tKSGNRY2FuMlRJTjRtZm U=
zimbraLastLogonTimestamp: 20091109100810Z
zimbraPrefGroupMailBy: message
zimbraId: 3f77aa1a-d377-41c7-a11f-530285520787
zimbraSignatureName: Standard mydomain
zimbraMailStatus: enabled
zimbraPrefSearchTreeOpen: TRUE
zimbraMailDeliveryAddress: mjames@mydomain2.com
mail: mjames@mydomain2.com
mail: mjames@mydomain3.com
mail: mjames@zimbra.mydomain.com
uid: mjames
zimbraAccountStatus: active
cn: Barry Johnston
zimbraMailTransport: lmtp:zimbra:7025
zimbraMailHost: zimbra.mydomain.com
zimbraPrefZimletTreeOpen: FALSE
zimbraPrefTagTreeOpen: TRUE
zimbraPrefDefaultSignatureId: 0c7fa37b-396f-4fe2-9063-88a405955951
zimbraPasswordModifiedTime: 20090924170739Z
sn: Johnston
zimbraPrefMailSignature:: QmFycnkgSm9obnN0b24KQ01HIEVuZXJneSBTb2x1dGlvbnMgCk NN
IEdsb2JhbAoKT2ZmaWNlOiAgOTc4LjM3My42OTY1CkNlbGw6IC A5NzguOTk0LjM0MTYKYmpvaG5zd
G9uQGNtZ2xvLmNvbQo=
zimbraPrefReadingPaneEnabled: TRUE
zimbraPrefFolderTreeOpen: TRUE
zimbraMailAlias: mjames@mydomain3.com
zimbraMailAlias: mjames@zimbra.mydomain.com

# search result
search: 2
result: 0 Success

# numResponses: 5
# numEntries: 4


MYSQL QUERY:

mysql> select * from mailbox where account_id='3f77aa1a-d377-41c7-a11f-530285520 787';
+----+----------+--------------------------------------+-----------------+------ --------------+---------------+-----------------+-------------------+----------- ----+---------------+----------------+-------------------------+---------------- --+--------------+--------------------+
| id | group_id | account_id | index_volume_id | item_ id_checkpoint | contact_count | size_checkpoint | change_checkpoint | tracking_s ync | tracking_imap | last_backup_at | comment | last_soap_acces s | new_messages | idx_deferred_count |
+----+----------+--------------------------------------+-----------------+------ --------------+---------------+-----------------+-------------------+----------- ----+---------------+----------------+-------------------------+---------------- --+--------------+--------------------+
| 63 | 63 | 3f77aa1a-d377-41c7-a11f-530285520787 | 2 | 24084 | 111 | 2039925766 | 26205 | 22 932 | 1 | NULL | mjames@mydomain2.com | 125786566 7 | 1 | 20 |
+----+----------+--------------------------------------+-----------------+------ --------------+---------------+-----------------+-------------------+----------- ----+---------------+----------------+-------------------------+---------------- --+--------------+--------------------+
1 row in set (0.00 sec)


It showed account belonging to: mjames@mydomain2.com (which is what I want, and it was orginally set to)



Hey -- I am really appreciating your help- You have no idea how grateful I am. Any more ideas I greatly appreciate in troubleshooting this problem.

[veronica]

So here is the issue : -

mjames, people, mydomain.com
has alias
zimbraMailAlias: mjames@mydomain3.com

and

mjames, people, mydomain2.com
has alias
zimbraMailAlias: mjames@mydomain3.com

How did you end up creating same alias for 2 accounts and that actually happened due to reason below: -

mjames, people, mydomain.com
mjames, people, mydomain2.com

Both have same zimbraId
zimbraId: 3f77aa1a-d377-41c7-a11f-530285520787

I am unsure if you can change the zimbraId easily. Maybe it might mess up other things. So do both users have emails ? If not try deleting any one ( I doubt it will allow to do but give it a shot else we can see other options )

[cmglobal]

mjames@domain.com and mjames@domain2.com are litterally the same Mailbox.


What happened is a couple weeks ago the user was setup like th is:

main email: mjames@domain.com
alias: mjames@domain2.com
alias: mjames@domain3.com

AND THEN I DECIDED TO CHANGE HIS MAIN EMAIL

main email: mjames@domain2.com
alias: mjames@domain.com
alias: mjames@domain3.com


Everything was fine. However I was trying to upgrade recently, and had to restore from a backup, and that is when I encountered my present issue.

In the admin panel, his account shows up only with main email of: mjames@domain.com

I tried to change his main email back to mjames@domain2.com , but encounter the errors you have seen in this post like too many account results.

I cannot delete alias or change main email from the web interface or command line using zmprov.

Is there a way to remove one of the entries (mjames@domain.com) from the LDAP directory, since that is where it seems to be? The right address mjames@domain2.com shows up in the MySQL db as you can see above from the command you told me to run. Maybe removing the wrong address from teh LDAP would help?

If not, is there a way I can delete this user's account entirely (manually) because then I could just download all his email to outlook (PST file), delete the user(s) and aliases, recreate them, and then use PST import utility to restore?