Zimbra

billzeta · #1 (**permalink**) 05-27-2008, 09:06 AM

Upgrading from 5.0.5 to 5.0.6 and for some reason the upgrade just stops when it comes to starting mysql...

I also noticed some errors when the install verifies the message store..

Quote:

Do you want to verify message store database integrity? [Y]
Verifying integrity of message store databases. This may take a while.
/opt/zimbra/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Generating report
No errors found
command failed

billzeta · #2 (**permalink**) 05-27-2008, 09:25 AM

Zimbra wont start now, and the mysql.sock file in '/opt/zimbra/db' is empty..

uxbod · #3 (**permalink**) 05-27-2008, 09:27 AM

Please check your Log Files - Zimbra :: Wiki for any error messages. Also, in /tmp will be a zmsetup log so could you post that aswell please.

billzeta · #4 (**permalink**) 05-27-2008, 10:15 AM

OK

I've restored from a backup.. problem is its a few days old so I'm sure there will be missing data.. I've copied the /opt/zimbra directory prior to restoring..

I can't just copy /opt/zimbra over im sure, because its corrupted since the upgrade failed.

Is there a way to just restore the message data and calendars?

billzeta · #5 (**permalink**) 05-27-2008, 10:22 AM

Can I just copy over the following directories -- /opt/zimbra/store, db, index, openldap-data ?

billzeta · #6 (**permalink**) 05-27-2008, 10:46 AM

Murphys law...

the backup file will not restore! lovely.

So now I'm left with a working fresh install of zimbra with no users, mail, calendars.. and a backup of the corrupt /opt/zimbra files.. can anything be salvaged?

I'm doing this all in virtual environments, so I still have the corrupt version where it hangs @ the mysql install.

I created a new "VM" and installed a fresh copy of Zimbra.

On my old VMware server I think i still have a running copy of zimbra which was migrated to the new server ~7days ago.. so the files may be out of date, but the copy on that machine should still be operational...

phoenix · #7 (**permalink**) 05-27-2008, 11:00 AM

How much memory have you got allocated to the VM that Zimbra runs in?

billzeta · #8 (**permalink**) 05-27-2008, 11:12 AM

Quote:

Originally Posted by phoenix

How much memory have you got allocated to the VM that Zimbra runs in?

1-1.5GB.. it should have plenty.

billzeta · #9 (**permalink**) 05-27-2008, 11:19 AM

is it possible to just move the directories -- /opt/zimbra/store, db, index, openldap-data to the working VM?

will that work or am i going to end up with more errors?