Zimbra Forums

Hi,
i want to access Zimbra Database(Mysql) using external java code, Could you please tell how could i do that?
also please tell me about database details, where it is placed,how can i edit DB etc..

[quote user="jdk"]also please tell me about database details, where it is placed,how can i edit DB etc..[/QUOTE]You should not tamper with the Zimbra MySQL instance, you might break your Zimbra server and any changes you make probably survive after an upgrade.

YOu will find all the stuffs in Soap Provisioning.

Hi jignesh,
could you please tell which table is there in Zimbra DB is used for storing free-busy information.

If you just look for an abstraction on accessing the local mailboxd node database, you can use zcs-lib-vnc-common for that:

This">https://github.com/vnc-biz/zcs-lib-vnc-common
This library is entirely designed for use with zmpkg, so you'll need that:
https://github.com/vnc-biz/zcs-zmpkg
>

By the way: you can easily add new tables to the database (as long as you choose their names wisely, so future updates wont conflict that, eg. by using some separate namespace). zmpkg also provides an easy way for automatically applying sql scripts on deployment.
BUT: you need to be aware that each mailboxd node has it's own mysql database instance, so multiserver-setups can become a bit tricky that way !