Page 4 of 6 FirstFirst ... 23456 LastLast
Results 31 to 40 of 58

Thread: M1 -> M2 Upgrade Scripts

  1. #31
    marcmac is offline Expert Member
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    13

    Default Nope - don't hardcode the return version

    Quote Originally Posted by 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-1Armstrong

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

  2. #32
    vaitguy is offline Intermediate Member
    Join Date
    Sep 2005
    Location
    Washington DC
    Posts
    15
    Rep Power
    9

    Default Holy Heck after upgrade...

    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(Ser viceException.java:99)
    at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox .java:95)
    at com.zimbra.cs.mailbox.Mailbox.createMailbox(Mailbo x.java:1202)
    at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountI d(Mailbox.java:980)
    at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountI d(Mailbox.java:939)
    at com.zimbra.soap.DocumentHandler.getRequestedMailbo x(DocumentHandler.java:82)
    at com.zimbra.cs.service.mail.Search.handle(Search.ja va:87)
    at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:249)
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:163)
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:84)
    at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:226)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:709)
    at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:148)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
    at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
    at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:526)
    at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:825)
    at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:738)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:526)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails

    Query being executed when exception was thrown:

    com.mysql.jdbc.ServerPreparedStatement[3] - INSERT INTO mailbox(account_id, id, index_volume_id, item_id_checkpoint, comment) SELECT '85a780ab-5ad2-11da-b5a0-6983575c14d7', next_mailbox_id, index_volume_id, 255, 'michael.wilson@zimbra.rmxtalk.com' FROM current_volumes ORDER BY index_volume_id LIMIT 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2926)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(ServerPreparedStatement.java:1120)
    at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(ServerPreparedStatement.java:675)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1162)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1079)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1064)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
    at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox .java:75)
    ... 27 more

    code - service.FAILURE
    method - ZmCsfeCommand.prototype.invoke
    detail - soap:Receiver
    --------------
    Michael Wilson
    REMAX Allegiance

  3. #33
    vaitguy is offline Intermediate Member
    Join Date
    Sep 2005
    Location
    Washington DC
    Posts
    15
    Rep Power
    9

    Default Crap...

    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?
    --------------
    Michael Wilson
    REMAX Allegiance

  4. #34
    adobrin is offline Special Member
    Join Date
    Sep 2005
    Posts
    135
    Rep Power
    9

    Default armstrong->m2

    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.

  5. #35
    vaitguy is offline Intermediate Member
    Join Date
    Sep 2005
    Location
    Washington DC
    Posts
    15
    Rep Power
    9

    Default sweet...

    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.
    --------------
    Michael Wilson
    REMAX Allegiance

  6. #36
    adobrin is offline Special Member
    Join Date
    Sep 2005
    Posts
    135
    Rep Power
    9

    Default no promises;

    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

  7. #37
    vaitguy is offline Intermediate Member
    Join Date
    Sep 2005
    Location
    Washington DC
    Posts
    15
    Rep Power
    9

    Default

    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).
    --------------
    Michael Wilson
    REMAX Allegiance

  8. #38
    adobrin is offline Special Member
    Join Date
    Sep 2005
    Posts
    135
    Rep Power
    9

    Default zimbra guys?

    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?

  9. #39
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    Quote Originally Posted 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?

    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.

  10. #40
    vaitguy is offline Intermediate Member
    Join Date
    Sep 2005
    Location
    Washington DC
    Posts
    15
    Rep Power
    9

    Default

    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.
    --------------
    Michael Wilson
    REMAX Allegiance

Page 4 of 6 FirstFirst ... 23456 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 4.5.6 -> 5.0 Upgrade Problem :(
    By uxbod in forum Installation
    Replies: 3
    Last Post: 07-21-2007, 08:02 PM
  2. 4.0.3 -> 4.5.1 upgrade
    By Storm16 in forum Installation
    Replies: 1
    Last Post: 02-11-2007, 09:44 PM
  3. fc4 zcs-3.0.1 -> 3.1 upgrade worked great.. almost
    By keyhman in forum Installation
    Replies: 29
    Last Post: 09-29-2006, 11:06 AM
  4. M2 -> M3 upgrade
    By gutzeit in forum Installation
    Replies: 26
    Last Post: 01-12-2006, 10:46 AM
  5. Upgrade M1 -> M2? .... Yes!!
    By jholder in forum Installation
    Replies: 27
    Last Post: 11-20-2005, 04:34 PM

Posting Permissions

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