Zimbra Forums

M1 -> M2 Upgrade Scripts

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 1:59 pm

by marcmac

[quote user="vaitguy"]Get ain immediate failure that the script cannot determine my ZCS version. when I manually run rpm -q zimbra-core, I get version zimbra-core-2005.0.0-39.FC3-1ArmstrongI see that in the script, its looking for zimbra-coor-3.0.xxxxxx. Can I manually edit the script to return M1 as I have not run the M2 install yet?I'm using this personally as my prod email right now (not the company, just myselft/deparment) and would prefer not to mess this up.MW[/QUOTE]The upgrade script (upgradeM1M2.pl) if for upgrades from M1 to M2. You're running the "Armstrong" release, which predates both of those, so the upgrade script won't help you - you'll need a complete reinstall.

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 3:17 pm

by vaitguy

Ok, well I went through the motions, really had few problems. I am able to getin into the admin profile, but all of my past users are now still in db.mailbox. But the system does not recognize the logins at all. There were only a few logins created. I manually created a new me in the admin console, which is now in the ldap directory (no others are), but the mailbox entry is not created. Here is the report.It seems like new accounts are great, its just mine w/ the calendar, and all that is hosed completely. Can I migrate this somehow? Can we anticipate hickups like this on the Network version (As our board is very interested in going that path):msg - system failure: writing new mailbox for account 85a780ab-5ad2-11da-b5a0-6983575c14d7

com.zimbra.cs.service.ServiceException: system failure: writing new mailbox for account 85a780ab-5ad2-11da-b5a0-6983575c14d7

at com.zimbra.cs.service.ServiceException.FAILURE(ServiceException.java:99)

at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox.java:95)

at com.zimbra.cs.mailbox.Mailbox.createMailbox(Mailbox.java:1202)

at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountId(Mailbox.java:980)

at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountId(Mailbox.java:939)

at com.zimbra.soap.DocumentHandler.getRequestedMailbox(DocumentHandler.java:82)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1120)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:675)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1162)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1079)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1064)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)

at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox.java:75)

... 27 morecode - service.FAILURE

method - ZmCsfeCommand.prototype.invoke

detail - soap:Receiver

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 3:26 pm

by vaitguy

I just saw your follow up to my previous post. SO I need to blow it all away and go from there.Is there, please please say yes, a way for me to grab one users Calendar/mailbox from the old 'armstrong' and import into the new, fresh install?

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 3:58 pm

by adobrin

you're best bet is probably going to be using imapsync to transfer to a third party imap server (install one on another box, or another port on that machine), and then back again once you install m2.this won't of course save your calendar information. i'm guessing, and its probably a pretty well educated guess, that you could get the calendar information out of the mysql database and reimport it manually once you've done the upgrade.. probably a matter of ensuring a few key fields are inserted properly. of course, i haven't looked at the schema at all.if you want to post a mysql dump of the armstrong database, i will see if i can get you a transfer insert statement.

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 4:12 pm

by vaitguy

If I haven't said it, thanks for your help.Which armstrong db do you need? Mailbox2 is the db in question. Do you need the appointment table?To uninstall, I assume, I would just blow away the /zimbra dir? and reinstall everything? I have all the mail on our main postfix box, I was sending copies to Zimbra, but using the cal exclusively. Dumb me.

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 4:19 pm

by adobrin

MIke, it looks like the data i will need is the appointment table from Mailbox2 as well as the mail_item table matching item_id from appointment. (the actual appointment data is stored as a mail item)so, dump appointment from Mailbox2 and

select * from mail_item where id in (select item_id from appointment);

No promises on this, the data storage format might be more dificult to decipher than i originally though. i'm happy to give it a try though :)

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 4:24 pm

by vaitguy

Don't worry about it. I think all the other people would rather see you put your time towards making this app the best we've ever seen (so far, I think we are almost there).

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 4:25 pm

by adobrin

Zimbra Guys.Am i right in assuming the mysql database corresponds to Mailbox# where # is id from zimbra.mailbox?do we have to worry about the UID field in appointment.. is that a foreign key?

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 5:01 pm

by 14319KevinH

[quote user="adobrin"]Zimbra Guys.Am i right in assuming the mysql database corresponds to Mailbox# where # is id from zimbra.mailbox?do we have to worry about the UID field in appointment.. is that a foreign key?[/QUOTE]

Your right but to be honest we don't really want to try and support this type of upgrade. Better off just using the supported methods.

M1 -> M2 Upgrade Scripts

Posted: Mon Nov 21, 2005 5:09 pm

by vaitguy

I agree, and I might be the only tech person who keeps one of those franklin covey type planners still. glad I did on this occasion.