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.zimbra.cs.service.mail.Search.handle(Search.java:87)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:249)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:163)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:84)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:226)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(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.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.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.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
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 more
code - service.FAILURE
method - ZmCsfeCommand.prototype.invoke
detail - soap:Receiver