Results 1 to 2 of 2

Thread: SQL backend details

  1. #1
    Join Date
    May 2007
    Rep Power

    Default SQL backend details

    Good day to all,

    This is my first post to the Zimbra forums, hooray!

    We are in need of a robust internal calendaring/email solution with AJAX GUI, and Zimbra looks to be the solution we've been looking for. Before proceeding, I'd like to inquire on a few things, though.

    I was wondering if I might be able to modify the individual components of Zimbra to use custom SQL queries for authentication (IMAP, POP, SMTP, Webmail, etc). If so, would this break Zimbra? I've modified dovecot IMAP/POP3, exim, and other softwares in the past to use custom queries, which has worked superbly. I do understand if I were to do this with Zimbra, support would be void, and am fully willing to accept that.

    Secondly, if custom internal database queries are not possible, perhaps I can modify the many services we host to use Zimbra's internal database. Does Zimbra store it's users and passwords in a MySQL table with perhaps MD5 hashing of the passwords?

    Any details or insight you can provide will be most helpful. Thank you all for your time and support.

    Have a great day!

  2. #2
    Join Date
    Oct 2005
    USA, Canada and India
    Rep Power


    Hi..welcome the the fourms and to the zimbra community.

    1) All user info is stored in LDAP, password is a HASH
    2) All metadata regarding messages, cal, ..everything is stored in MySQL
    3) Yes if you buy network vesion and you change anything your support is voided (i dont work for zimbra. )
    4) Any "changes" you do the software will most probably be overwitten on next update/upgrade
    5) Any changes you do to MYSQL/LDAP stucture my cause the future UPGRADED to zimbra scripts may not handle your custom changes.

    6) ** Most important point ** is zimbra has SOAP API (ADMIN as well as USER based) if you can do all your stuff thru API then you can ignore all the 1-5 points mentioned above

    and for any kind of cool shuff you can get help in fourms anyway.


Similar Threads

  1. How to sync gal details using zimbra connector
    By menonumesh in forum Administrators
    Replies: 1
    Last Post: 05-09-2007, 03:56 AM
  2. sql query to retrieve mails store path
    By banou in forum Developers
    Replies: 10
    Last Post: 05-02-2007, 06:53 AM
  3. VMWare Virtual Appliance admin details
    By blittle in forum Installation
    Replies: 4
    Last Post: 06-06-2006, 06:17 AM
  4. Choice of auth backend?
    By Nodsu in forum Developers
    Replies: 2
    Last Post: 12-09-2005, 01:27 AM
  5. User List in LDAP Backend
    By rmroadee in forum Installation
    Replies: 5
    Last Post: 09-21-2005, 08:26 AM

Posting Permissions

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