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

[rrudolf]

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.

[justdave]

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.

[jrv]

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

[justdave]

[quote user="jrv"]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).[/QUOTE]
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.

[jrv]

[quote user="justdave"]

The script is listed in the release notes.

[/QUOTE]

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:


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.

[justdave]

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.

[jrv]

I don't know how to run mysql_upgrade


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