Results 1 to 9 of 9

Thread: User edit issues

  1. #1
    Join Date
    Nov 2009
    Posts
    6
    Rep Power
    5

    Default User edit issues

    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)
    Last edited by cmglobal; 11-09-2009 at 10:15 PM.

  2. #2
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    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 ?

  3. #3
    Join Date
    Nov 2009
    Posts
    6
    Rep Power
    5

    Default

    Quote Originally Posted by veronica View Post
    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

  4. #4
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    zmprov gaa | grep -i admin

    what this returns ?

  5. #5
    Join Date
    Nov 2009
    Posts
    6
    Rep Power
    5

    Default

    Quote Originally Posted by veronica View Post
    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?

  6. #6
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    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 ?

  7. #7
    Join Date
    Nov 2009
    Posts
    6
    Rep Power
    5

    Default

    # 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.

  8. #8
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    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 )

  9. #9
    Join Date
    Nov 2009
    Posts
    6
    Rep Power
    5

    Default

    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?

Similar Threads

  1. Performance Issues with Single User
    By soxfan in forum Administrators
    Replies: 2
    Last Post: 12-09-2008, 11:33 AM
  2. Replies: 1
    Last Post: 05-28-2008, 04:18 AM
  3. Calendar Sync Issues
    By glassman in forum Zimbra Connector for Outlook
    Replies: 0
    Last Post: 05-14-2008, 10:43 AM
  4. Installation Issues - SLES 10_Zimbra 5.0 Beta 3
    By rhartman in forum Installation
    Replies: 3
    Last Post: 01-14-2008, 06:18 AM
  5. 2 user issues I have..
    By langs in forum Users
    Replies: 1
    Last Post: 10-23-2006, 11:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •