Zimbra Database

Have a great idea for extending Zimbra? Share ideas, ask questions, contribute, and get feedback.
jdk
Posts: 15
Joined: Sat Sep 13, 2014 2:35 am

Zimbra Database

Postby jdk » Wed Aug 22, 2012 7:24 am

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


phoenix
Ambassador
Ambassador
Posts: 26347
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

Zimbra Database

Postby phoenix » 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.
Regards

Bill

Rspamd: A high performance spamassassin replacement

If you'd like to see this implemented in a future version of ZCS then please vote on Bugzilla entries 97706 & 108168
10142Jignesh
Advanced member
Advanced member
Posts: 64
Joined: Sat Sep 13, 2014 2:17 am

Zimbra Database

Postby 10142Jignesh » Fri Aug 24, 2012 1:42 am

YOu will find all the stuffs in Soap Provisioning.
jdk
Posts: 15
Joined: Sat Sep 13, 2014 2:35 am

Zimbra Database

Postby jdk » Mon Aug 27, 2012 8:49 am

Hi jignesh,
could you please tell which table is there in Zimbra DB is used for storing free-busy information.
10119metux
Advanced member
Advanced member
Posts: 75
Joined: Sat Sep 13, 2014 2:29 am

Zimbra Database

Postby 10119metux » 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:

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 !

Return to “Developers”

Who is online

Users browsing this forum: No registered users and 1 guest