Results 1 to 3 of 3

Thread: Where are user Contacts/Address Books stored?

  1. #1
    Join Date
    May 2009
    Rep Power

    Default Where are user Contacts/Address Books stored?

    Hi everyone,

    I am having a terrible time finding where a users Address Book is stored. I'm pretty sure it's in the MySQL database rather than in LDAP, but I cannot find it.

    I am using 5.0.16 and trying to access the contacts from within MySQL.

    Any help would be appreciated.

    Thank you,

  2. #2
    Join Date
    May 2009
    Bremen, Germany
    Rep Power


    Entries of type 6 in table mail_item from database mboxgroupXX are address books entries. To find your mailbox id, see Account mailbox database structure - Zimbra :: Wiki.

    Sample query for mailbox id 25

    select * from mboxgroup25.mail_item where type = '6' and mailbox_id = '25';
    This is for Zimbra 6.0, but I think it works also for 5.0.

  3. #3
    Join Date
    May 2009
    Rep Power



    Is there a mapping somewhere that tells what the type's are? 6=contact, what others are there?

    Also, any tips on how to decode the metadata for a contact? It's all jumbled together and I don't see any real field-delimiters.

    Are there any zimbra-provided command-line utilities that make accessing the address books any easier?

    Thanks again,

Similar Threads

  1. Replies: 21
    Last Post: 02-04-2010, 09:06 AM
  2. [SOLVED] Zimbra logwatch.
    By nishith in forum Administrators
    Replies: 5
    Last Post: 06-10-2009, 04:42 PM
  3. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 10:38 AM
  4. Services stopped working
    By lilwong in forum Administrators
    Replies: 4
    Last Post: 08-15-2006, 09:19 AM
  5. Fedora Core 3, Clean Install - Not working!
    By pcjackson in forum Installation
    Replies: 17
    Last Post: 03-05-2006, 06:38 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