Results 1 to 7 of 7

Thread: Upgrade ZCS 6.0.12 to 8.0 with upgrade ubuntu 8.04 to 12.04.

  1. #1
    Join Date
    Sep 2009
    Posts
    5
    Rep Power
    6

    Lightbulb Upgrade ZCS 6.0.12 to 8.0 with upgrade ubuntu 8.04 to 12.04.

    I have Zimbra ZCS 6.0.12 on ubuntu 08.04 64 bit. I need to fix upgrade to the current version of Zimbra ZCS (version 8) with the current version of ubuntu (12.04 64 bit version) with minimum downtime. I have about 5,000 email accounts. The system consists of 1x mailbox server, 1x ldap master, 1x ldap replica, 3x gateway.
    How will this solve most preferably?
    Thank you for all the answers.

  2. #2
    Join Date
    Nov 2008
    Location
    Grand Rapids, MI
    Posts
    123
    Rep Power
    7

    Default

    ZCS servers of the same version but on different OSes can still talk to each other for the communication between boxes.

    The main information you'll want to follow is here: OS Specific Platform Upgrades - Zimbra :: Wiki

    The short version is you'll need to upgrade the machines a couple times in sequence. In order to safely upgrade the operating system, you need to be running a version of Zimbra that runs on both the before and after versions of the operating system. ZCS 6 doesn't run on anything newer than Ubuntu 10.04. ZCS 8 doesn't run on anything older than 10.04. So you'll need to upgrade the OS to Ubuntu 10.04 first, then reinstall ZCS 6.0.12 with the Ubuntu 10.04 version of it. Once you verify that's all working and you haven't lost or broken anything, then upgrade ZCS to version 8. Once you verify that all works, then upgrade the OS to Ubuntu 12.04 and reinstall ZCS 8 with the Ubuntu 12.04 version of it.

  3. #3
    Join Date
    Nov 2008
    Posts
    28
    Rep Power
    7

    Default

    It is *essential* to clone the setup and test the upgrade offline first, as the upgrade may fail. I've got a 6.0.16 that I've spent several days trying to upgrade and cannot upgrade to any 7.* version (the mysql format changed and nothing in the 7.* installers seems to update it).
    Release 6.0.6_GA_2324.UBUNTU8 UBUNTU8 FOSS edition

  4. #4
    Join Date
    Nov 2008
    Location
    Grand Rapids, MI
    Posts
    123
    Rep Power
    7

    Default

    Quote Originally Posted by jrv View Post
    I've got a 6.0.16 that I've spent several days trying to upgrade and cannot upgrade to any 7.* version (the mysql format changed and nothing in the 7.* installers seems to update it).
    There is actually a script included with the installer that does the database update. It isn't run by default by the installer because it takes a long time to run, and supposedly the system will still work without having run it yet (just with degraded performance until you do). The script is listed in the release notes. The actual schema changes should be done by the installer itself. Make sure it's properly detecting the version of Zimbra you're upgrading from when the script runs (it'll tell you in the output). The standalone script is changing the table formats, not the actual schema.

  5. #5
    Join Date
    Nov 2008
    Posts
    28
    Rep Power
    7

    Default

    Quote Originally Posted by justdave View Post
    The script is listed in the release notes.
    The problem is more basic than that. mysql will not even start once the 7.0.0 packages are installed because conf/my.cnf is wrong (even though the installer says it verified my.cnf, it's not enough to get mysql to start).

    So I did a install elsewhere of a blank 7.0.0 an made a copy of my.cnf, then copied it into the upgrade environment after the install failed. That at least lets mysql start. But install.sh still crashes right after installing the new packages (where it used to hang because of my.cnf) because the mysql data isn't right. Nothing I've tried upgrades the mysql data so that install.sh (the database check at the begging of install.sh succeeds).

    From /opt/zimbra/log/mysql_error.log after fixingmy.cnf:

    Code:
    121025 07:30:55 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
    /opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
    121025  7:30:55 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use GCC atomic builtins
    InnoDB: Compressed tables use zlib 1.2.3.3
    121025  7:30:55  InnoDB: highest supported file format is Barracuda.
    121025  7:30:56 InnoDB Plugin 1.0.13 started; log sequence number 2462851538
    121025  7:30:56 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    121025  7:30:56 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50051, now running 50152. Please use mysql_upgrade to fix this error.
    121025  7:30:56 [ERROR] mysql.user has no `Event_priv` column at position 29
    121025  7:30:56 [ERROR] Cannot open mysql.event
    121025  7:30:56 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    121025  7:30:56 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
    Release 6.0.6_GA_2324.UBUNTU8 UBUNTU8 FOSS edition

  6. #6
    Join Date
    Nov 2008
    Location
    Grand Rapids, MI
    Posts
    123
    Rep Power
    7

    Default

    That sounds like MySQL itself didn't get upgraded, not just Zimbra's schema in it.

    Try running (as root)

    /opt/zimbra/mysql/bin/mysql_upgrade

    NOTE: always a good idea to have a backup first before trying stuff like this, too, just in case.
    Last edited by justdave; 10-25-2012 at 06:50 PM. Reason: add note about having a backup

  7. #7
    Join Date
    Nov 2008
    Posts
    28
    Rep Power
    7

    Default

    I don't know how to run mysql_upgrade

    Code:
    # /opt/zimbra/mysql/bin/mysql_upgrade
    Looking for 'mysql' as: /opt/zimbra/mysql/bin/mysql
    Looking for 'mysqlcheck' as: /opt/zimbra/mysql/bin/mysqlcheck
    Running 'mysqlcheck with default connection arguments
    /opt/zimbra/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
    FATAL ERROR: Upgrade failed
    # /opt/zimbra/mysql/binn/mysql_upgrade  -S /opt/zimbra/db/mysql.sock
    Looking for 'mysql' as: /opt/zimbra/mysql/bin/mysql
    Looking for 'mysqlcheck' as: /opt/zimbra/mysql/bin/mysqlcheck
    Running 'mysqlcheck' with connection arguments: '--socket=/opt/zimbra/db/mysql.sock'
    /opt/zimbra/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
    FATAL ERROR: Upgrade failed
    # /opt/zimbra/mysql/bin/mysql_upgrade  -S /opt/zimbra/db/mysql.sock -p
    Enter password:
    Looking for 'mysql' as: /opt/zimbra/mysql/bin/mysql
    Looking for 'mysqlcheck' as: /opt/zimbra/mysql/bin/mysqlcheck
    Running 'mysqlcheck' with connection arguments: '--socket=/opt/zimbra/db/mysql.sock'
    /opt/zimbra/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
    FATAL ERROR: Upgrade failed
    #
    I'm working on a copy of the mail server.
    Release 6.0.6_GA_2324.UBUNTU8 UBUNTU8 FOSS edition

Similar Threads

  1. Zimbra-Upgrade and Server-Move inkl. Ubuntu-Dist-Upgrade
    By karl.kowald in forum Administrators
    Replies: 5
    Last Post: 10-25-2011, 11:24 AM
  2. Upgrade Ubuntu 6.06LTS to Ubuntu 8.04LTS and Zimbra 6.x
    By ajaylamb in forum Administrators
    Replies: 3
    Last Post: 09-12-2011, 02:45 AM
  3. Replies: 4
    Last Post: 04-07-2011, 03:54 AM
  4. Replies: 0
    Last Post: 04-06-2011, 03:07 AM
  5. Replies: 4
    Last Post: 09-28-2010, 09:50 AM

Posting Permissions

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