Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Can't login to web client

  1. #11
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    I have the open source edition, version 3.0.1_GA_160.SuSEES9.

    Actually, yes, the postmaster account is an alias for the admin account.

    I tried creating a new user with the zmprov, restarted Tomcat, and get the same error when trying to log in with that one.

  2. #12
    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 mhiles
    I have the open source edition, version 3.0.1_GA_160.SuSEES9.

    Actually, yes, the postmaster account is an alias for the admin account.

    I tried creating a new user with the zmprov, restarted Tomcat, and get the same error when trying to log in with that one.
    The exact same error? It's hard to believe that we'll look for the same database each time. Can you post the error you get from the new user?
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #13
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    Here is the error returned by the new user. The username is 'testuser':

    Code:
    msg - system failure: dropMailboxDatabase(2)
    com.zimbra.cs.service.ServiceException: system failure: dropMailboxDatabase(2)
    	at com.zimbra.cs.service.ServiceException.FAILURE(ServiceException.java:131)
    	at com.zimbra.cs.db.DbMailbox.dropMailboxDatabase(DbMailbox.java:169)
    	at com.zimbra.cs.mailbox.Mailbox.createMailbox(Mailbox.java:1221)
    	at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountId(Mailbox.java:988)
    	at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountId(Mailbox.java:947)
    	at com.zimbra.soap.DocumentHandler.getRequestedMailbox(DocumentHandler.java:85)
    	at com.zimbra.cs.service.mail.Search.handle(Search.java:72)
    	at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:252)
    	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:228)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    	at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:154)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    	at 
    
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.jav
    
    a: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(Http11Pro
    
    tocol.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: Unknown table 'appointment'
    
    Query being executed when exception was thrown:
    
    DROP DATABASE IF EXISTS mailbox2
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    	at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
    	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
    	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)
    	at 
    
    org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.jav
    
    a:256)
    	at com.zimbra.cs.db.DbMailbox.dropMailboxDatabase(DbMailbox.java:164)
    	... 27 more
    
    code - service.FAILURE
    method - ZmCsfeCommand.prototype.invoke
    detail - soap:Receiver

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

    Default

    Our guess here is that the MySQL db didn't get the grants setup right so your MySQL user doesn't have permission to create a table. One cause for this is an inconsistent /etc/hosts file or changing the hostname after install. What is in your /etc/hosts file?

    Also can you dump you MySQL grant tables?

    su - zimbra
    mysql
    > use mysql;
    > select * from users;
    [Paste the result]
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  5. #15
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    Here is the /etc/hosts file:

    Code:
    127.0.0.1       localhost
    
    # special IPv6 addresses
    ::1             localhost ipv6-localhost ipv6-loopback
    
    fe00::0         ipv6-localnet
    
    ff00::0         ipv6-mcastprefix
    ff02::1         ipv6-allnodes
    ff02::2         ipv6-allrouters
    ff02::3         ipv6-allhosts
    192.168.1.93    zimbra.notify.net zimbra
    Here is the MySQL output:

    Code:
    mysql> select * from user;
    +-----------------------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
    | Host                  | User   | Password                                  | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections |
    +-----------------------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
    | localhost             | root   | *9719F7D2AC77AD8265C7EC98E74280E1D4003E37 | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                |          |            |             |              |             0 |           0 |               0 |
    | zimbra                | root   |                                           | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                |          |            |             |              |             0 |           0 |               0 |
    | zimbra                |        |                                           | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          | N            | N          | N                     | N                | N            | N               | N                |          |            |             |              |             0 |           0 |               0 |
    | localhost             |        |                                           | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          | N            | N          | N                     | N                | N            | N               | N                |          |            |             |              |             0 |           0 |               0 |
    | %                     | zimbra | *F54E5778FC88B20BBF289F1065FDFE2051DFF2B3 | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                |          |            |             |              |             0 |           0 |               0 |
    | localhost             | zimbra | *F54E5778FC88B20BBF289F1065FDFE2051DFF2B3 | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                |          |            |             |              |             0 |           0 |               0 |
    | localhost.localdomain | zimbra | *F54E5778FC88B20BBF289F1065FDFE2051DFF2B3 | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                |          |            |             |              |             0 |           0 |               0 |
    | localhost.localdomain | root   | *6E6F7B4008B7AD56CE235EE6AB66BC6B8207C6FF | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                |          |            |             |              |             0 |           0 |               0 |
    +-----------------------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
    8 rows in set (0.00 sec)

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

    Default

    Try changing the 127.0.0.1 line in /etc/hosts to this:

    127.0.0.1 localhost localhost.localdomain
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  7. #17
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    I changed the /etc/hosts file to what you mentioned, and rebooted the machine. I then added a user with the zmprov command, and restarted tomcat. I still receive the same error when I try to log in.

    Code:
    msg - system failure: dropMailboxDatabase(2)
    com.zimbra.cs.service.ServiceException: system failure: dropMailboxDatabase(2)
    	at com.zimbra.cs.service.ServiceException.FAILURE(ServiceException.java:131)
    	at com.zimbra.cs.db.DbMailbox.dropMailboxDatabase(DbMailbox.java:169)
    	at com.zimbra.cs.mailbox.Mailbox.createMailbox(Mailbox.java:1221)
    	at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountId(Mailbox.java:988)
    	at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountId(Mailbox.java:947)
    	at com.zimbra.soap.DocumentHandler.getRequestedMailbox(DocumentHandler.java:85)
    	at com.zimbra.cs.service.mail.Search.handle(Search.java:72)
    	at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:252)
    	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:228)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    	at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:154)
    	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: Unknown table 'appointment'
    
    Query being executed when exception was thrown:
    
    DROP DATABASE IF EXISTS mailbox2
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    	at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
    	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
    	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:256)
    	at com.zimbra.cs.db.DbMailbox.dropMailboxDatabase(DbMailbox.java:164)
    	... 27 more
    
    code - service.FAILURE
    method - ZmCsfeCommand.prototype.invoke
    detail - soap:Receiver

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

    Default

    Well there must be something else going on. Do you have your install logs from /tmp? Maybe something failed at install since the system seems pretty crippled.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 12
    Last Post: 08-25-2010, 02:37 AM
  2. Need Help Troubleshooting Web Client Issues
    By soxfan in forum Administrators
    Replies: 2
    Last Post: 03-23-2007, 05:27 AM
  3. Moving Zimbra Web Client from one port to another.
    By oopstu in forum Administrators
    Replies: 2
    Last Post: 01-20-2007, 02:47 AM
  4. Web Client Fails to login
    By maestro in forum Installation
    Replies: 14
    Last Post: 12-21-2006, 12:31 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
  •