Unable to create new users

[fizi]

I am attempting to create new user accounts in Zimbra. I have it set to use internal authentication.

When I go through the create a new account wizard I can fill in the fields and create the account. Then if I attempt to edit the user or delete it I get the following error:

Message:  system failure: createMailboxDatabase(13)
Error code:  service.FAILURE
Method:  ZmCsfeCommand.prototype.invoke
Details:soap:Receiver

If I try to login as the user through the webmail client I get the exact same error:

msg - system failure: createMailboxDatabase(13)
code - service.FAILURE
method - ZmCsfeCommand.prototype.invoke
detail - soap:Receiver

I am running Zimbra 4.5.5 and CentOS 4.4. I have recently run zmfixperms as root. According to the service monitor all services are running just fine. Any existing accounts continue to work.

[jholder]

Ofcourse you immediately made a backup for safety reasons, eh?

Please post your /opt/zimbra/log/mailbox.log from when you tried to create the user.

Thanks!
jh

[fizi]

Here it is:

2007-05-25 15:56:49,555 INFO  [http-443-Processor99] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] mailbox - Creating database mboxgroup13
2007-05-25 15:56:49,631 ERROR [http-443-Processor99] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] mailbox - Error during mailbox creation
com.zimbra.common.service.ServiceException: system failure: createMailboxDatabase(13)
    at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
    at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:197)
    at com.zimbra.cs.mailbox.MailboxManager.createMailbox(MailboxManager.java:538)
    at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:216)
    at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:175)
    at com.zimbra.cs.session.Session.(Session.java:72)
    at com.zimbra.cs.session.SoapSession.(SoapSession.java:76)
    at com.zimbra.cs.session.SessionCache.getNewSession(SessionCache.java:86)
    at com.zimbra.soap.ZimbraSoapContext.getSession(ZimbraSoapContext.java:449)
    at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:195)
    at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:178)
    at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:264)
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:168)
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:90)
    at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:223)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:162)
    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:213)
    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:541)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    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: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'open_conversation,pop3_message,tombstone,appointment,mail_item'

[jholder]

oh wow.
I'm gonna have to ping the engineers.

Do you have a backup?

also, can you

su - zimbra
mysql mysql
>show tables;

and post the output?

[jholder]

Was this a failed upgrade?

[fizi]

Nope my upgrade to Zimbra 4.5.5 went smoothly as far as I could tell. No errors and everything worked. All existing accounts work just fine. Kinda funny about the backups. My backup drive died 7 days ago. I've got the last 4 nights backups and I'm pretty sure I have a backup from before upgrading to 4.5.5 but I'd lose a bunch of e-mail then.


MySQL Output:

mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| func                      |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| proc                      |
| procs_priv                |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
17 rows in set (0.00 sec)

[jholder]

Okay, something foobared here, and I'm not the mysql expert.

Can I get your installation logs along with /opt/zimbra/.install_history ?

[fizi]

Here is my /opt/zimbra/.install_history.

Where am I going to find my install logs?

[jholder]

It's gonna be in /tmp
Hopefully you haven't flushed it.
Do a
cd /tmp
ls -l
and grab the one with the latest date
Filename install.log.####

[fizi]

The logs are gone.