Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: upgrading 6.02 > 6.10 and enable hosting feature

  1. #1

    upgrading 6.02 > 6.10 and enable hosting feature

    hi together,

    wat will happen if I make an upgrade from 10238 to 10683 and enable "multi company" ? what will take effect with the existing database? the existing company in the db should be one of the new companies.
    because if hosted is enabled, I have to create a new public store and a new company container for each company.

    thx for hints!


    regards
    sportsone

  2. #2
    Senior Member
    Join Date
    Nov 2007
    Posts
    298

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    When you upgrade from non-hosted to hosted all users and groups will remain present in the database, but will not be visible (because they are not in a company).
    If you want to move all users into a database you should do the following:

    * First create a new company where all users should be member of.

    * For safety create backup of your database!

    * Execute the following command to find your company:
    this should return a single line where 'externid' matches your companyname. Remember the value from the 'id' column

    * Open mysql and run the following command to move all users/groups to the new company (replace $COMPANY with the value from the 'id' column from last command):
    * Move all stores to the company:
    Now all user and groups are located in the new company, if you want you can even try to migrate the public store to the company.

    * Perform the following command to find the public store:
    this should return a single line, the 'id' column is the identifier for your public store.

    * To move the store to the company you should change the ownership of this store ($COMPANY is the same as before, $COMPANYNAME is the externid mentioned above):
    And that is it, you should now be able to see all users in the new company and that company should have the original public store.

  3. #3

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    thank you for your help!
    I'll try this.

    regards
    sportsone

  4. #4
    Senior Member Michael's Avatar
    Join Date
    Dec 2006
    Location
    Lelystad
    Posts
    249

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    Maybe it is not logical for anyone, but when you messing arround with the database. Make sure the zarafaserver isn't running

  5. #5
    Senior Member
    Join Date
    Nov 2007
    Posts
    298

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    Ehh, yes that is definitely true.

  6. #6
    Senior Member Michael's Avatar
    Join Date
    Dec 2006
    Location
    Lelystad
    Posts
    249

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    I am at the moment also busy to migrate a 6.02 into a hosted enviroment.

    The given solution by ivo isn't complete. First of all, when you are using the db-plugin you need to insert for every user an entry into the 'objectproperty' table which specifies the company:

    replace {COMPANYNAME} with the company name.

    When doing this, the users will appear in "zarafa-admin -l", but a new store for these users are created and the original stores are deleted.

    So, we miss a step here, but with my knowledge of the zarafa database I can't figure out what I have to do.

  7. #7
    Senior Member Michael's Avatar
    Join Date
    Dec 2006
    Location
    Lelystad
    Posts
    249

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    Could someone help me with this one?

  8. #8
    Senior Member
    Join Date
    Nov 2007
    Posts
    298

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    Did you correctly update the 'users' table before changing the objectproperty table?
    It is is important that all changes were made while the zarafa-server was down, because it must under no circumstance start syncing in the middle of your changes.

    If you updated the objectproperty table manually, did you also made sure the company exist in that table as well?

  9. #9
    Senior Member Michael's Avatar
    Join Date
    Dec 2006
    Location
    Lelystad
    Posts
    249

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    Should I create the company with SQL or with zarafa-admin (for that the server must be running _and_ the hosting features must be turned on)?

    As far as I remembered I have tried it by first shutdown the server, change the hosting_enabled flag, started the server, added a company, shutdown, do the SQL updates and start the server again, all the users where in their company, however the stores where empty.

    I will try it again tonight and note all the steps I do, maybe we can than figure out what I did wrong.

  10. #10
    Senior Member
    Join Date
    Nov 2007
    Posts
    298

    Re: upgrading 6.02 > 6.10 and enable hosting feature

    The company can/should be created using zarafa-admin.

    The correct order would be:

    Upgrade Zarafa
    Update configuration to enable hosted
    /etc/init.d/zarafa-server start
    zarafa-admin --create-company <companyname>
    zarafa-admin --list-companies
    /etc/init.d/zarafa-server stop
    make changes to database

    Note that requesting the companies is important to make sure the company was created and detected in zarafa.

    The changes in the database are as mentioned earlier:
    - objectproperty
    - users
    - stores

    that should be enough, I must admit I only have done this upgrade once, but it worked for me at that time.

    Could you check /var/log/zarafa/server.cfg to see if there is anything odd in there that might explain the removal and recreation of the users?

Page 1 of 2 12 LastLast

Similar Threads

  1. --enable-feature i get "Speicherzugriffsfehler"
    By shcshc in forum Installation, Configuration and Maintenance
    Replies: 0
    Last Post: 31-12-2011, 02:07 PM
  2. Zarafa + CPanel hosting?
    By albatroz in forum Administration and Integration Archives
    Replies: 1
    Last Post: 02-04-2010, 05:05 PM
  3. configure z-push in shared hosting to connect gmail
    By wuyinzhi in forum Mobile devices Archives
    Replies: 9
    Last Post: 17-05-2009, 05:38 PM
  4. how to enable "sent as" feature on Webaccess
    By Montesuma in forum Installation and Configuration Archives
    Replies: 9
    Last Post: 17-11-2008, 08:46 PM
  5. Hosting on xen
    By robert02 in forum Installation and Configuration Archives
    Replies: 1
    Last Post: 01-02-2007, 03:37 PM

Bookmarks

Posting Permissions

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