Results 1 to 2 of 2

Thread: Can I use oracle as a db for the OS edition?

  1. #1
    Join Date
    Mar 2008
    Location
    Mountain View, CA
    Posts
    27
    Rep Power
    7

    Question Can I use oracle as a db for the OS edition?

    Hi,

    Is it possible to replace MySQL with Oracle as the datastore for the OS edition? Has someone tried doing that? How easy or difficult it is to do that? Any help or information would be highly appreciated.

    Thanks

  2. #2
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    Default

    Note: I Am Not An Install/Upgrade Guy or A Tools Guy. (So grain of salt and all that.) But it'd be nontrivial.

    First, you'd have to build your own. That includes your initial install as well as subsequent upgrades. The official packages assume MySQL in a particular location for install, and I believe they assume that you can do DB schema upgrades by calling "mysql ...".

    Second, you'll need to rewrite any DB-related scripts. Other folks can tell you which zm* scripts are invalid with a different DB, but I'll bet that there are several.

    Third, you'd have to actually port the database-related code to work with Oracle. That probably requires editing the DB schema (ZimbraServer/src/db/db.sql and ZimbraServer/src/db/create_database.sql) and writing a new subclass of Db.java. You can use the Desktop's open-source Derby.java as an example of this. You'd then need to tell jetty to use the Db.java sublass of your choice by setting zimbra_class_database in your install's localconfig.xml.

    If you do get things running with Oracle, we'd love it if you shared your work with the community!
    Bugzilla - Wiki - Downloads - Before posting... Search!

Similar Threads

  1. Network edition trial on Leopard (mac os x)
    By Rodi.reich@gmail.com in forum Installation
    Replies: 4
    Last Post: 03-19-2008, 10:07 PM
  2. Symbian OS sync in opensource edition
    By daimer77 in forum Zimbra Mobile
    Replies: 4
    Last Post: 10-15-2007, 01:02 PM
  3. OS edition hot standby server
    By fviero in forum Administrators
    Replies: 10
    Last Post: 06-15-2007, 10:34 AM
  4. [Network Edition Trial] OS X Installation
    By dmg in forum Installation
    Replies: 4
    Last Post: 02-07-2007, 04:25 PM
  5. OS Requirements for Network Edition
    By mrichard in forum Installation
    Replies: 6
    Last Post: 11-22-2006, 01:52 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
  •