Page 1 of 1
Posted: Wed Aug 22, 2012 7:24 am
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..
Posted: Wed Aug 22, 2012 8:54 am
[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.
Posted: Fri Aug 24, 2012 1:42 am
YOu will find all the stuffs in Soap Provisioning.
Posted: Mon Aug 27, 2012 8:49 am
could you please tell which table is there in Zimbra DB is used for storing free-busy information.
Posted: Wed Aug 29, 2012 2:00 pm
If you just look for an abstraction on accessing the local mailboxd node database, you can use zcs-lib-vnc-common for that:
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 !