Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Can't login to web client

  1. #1
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default Can't login to web client

    I have Zimbra server running on SLES 9. I created a user, and when I tried to log in to the web client, I received the following error. I also tried creating another user, and receive the same error when trying to log in. Restarting the services also results in the same error.


    msg - system failure: dropMailboxDatabase(2)
    com.zimbra.cs.service.ServiceException: system failure: dropMailboxDatabase(2)
    at com.zimbra.cs.service.ServiceException.FAILURE(Ser viceException.java:131)
    at com.zimbra.cs.db.DbMailbox.dropMailboxDatabase(DbM ailbox.java:169)
    at com.zimbra.cs.mailbox.Mailbox.createMailbox(Mailbo x.java:1221)
    at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountI d(Mailbox.java:988)
    at com.zimbra.cs.mailbox.Mailbox.getMailboxByAccountI d(Mailbox.java:947)
    at com.zimbra.soap.DocumentHandler.getRequestedMailbo x(DocumentHandler.java:85)
    at com.zimbra.cs.service.mail.Search.handle(Search.ja va:72)
    at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:252)
    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:228)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:709)
    at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:154)
    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: Unknown table 'appointment'

    Query being executed when exception was thrown:

    DROP DATABASE IF EXISTS mailbox2
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2928)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2994)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:936)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:773)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.execute(DelegatingPreparedStatement.java:256)
    at com.zimbra.cs.db.DbMailbox.dropMailboxDatabase(DbM ailbox.java:164)
    ... 27 more

    code - service.FAILURE
    method - ZmCsfeCommand.prototype.invoke
    detail - soap:Receiver

  2. #2
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    How did you create the users? Might try restarting tomcat just to make sure you don't have some bad data in the caches. Odd that *both* user's would be tied to the exact same database, unless the LDAP entries for those user's was not created via one of our tools.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #3
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    I created the users as described in the Quick Install guide. In the Zimbra Admin console, I went to Accounts, then clicked New. I put in an Account Name, Password, First name, and Last name, then clicked Finish.

    I rebooted the machine, and still get the same error as in my first post for both users. I did a diff on the error message, and it is exactly the same for both.

  4. #4
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    Can you attach more of the log file. Just zip up the last 1000 lines or something before/after a test.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  5. #5
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    I attached a zip file with the last 1000 lines of the zimbra.log file.
    Attached Files Attached Files

  6. #6
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    Well this is the account it's having trouble with:
    mhiles2@zimbra.notify.net

    Can you remove it via the Admin UI?


    I also see:

    java.io.FileNotFoundException: /opt/zimbra/redolog/redo.log (Permission denied)

    So might be a permissions problem. We've seen this on certain SuSE builds before. You should search the forums and see what else you find on that if the first idea doesn't work.

    Make sure to restart tomcat after you remove that bad account.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  7. #7
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    I am not able to remove that account from the ui. It gives the error:

    Code:
    Failed to delete account mhiles2@zimbra.notify.net
    This is in the zimbra.log:

    Code:
    2006-04-06 15:43:01,621 INFO  [Thread-162] [] im - Executing IMEvent: IMPresenceUpdateEvent: From: admin@zimbra.notify.net  Presence: ONLINE pri=1 st=null
    2006-04-06 15:43:02,818 INFO  [http-7071-Processor49] [ip=192.168.1.254;name=admin@zimbra.notify.net;] SoapEngine - handler exception
    com.zimbra.cs.service.ServiceException: system failure: getting database logger connection
    	at com.zimbra.cs.service.ServiceException.FAILURE(ServiceException.java:131)
    	at com.zimbra.cs.db.DbPool.getLoggerConnection(DbPool.java:364)
    	at com.zimbra.cs.service.admin.GetServiceStatus.handle(GetServiceStatus.java:67)
    	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: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 
    
    ** BEGIN NESTED EXCEPTION ** 
    
    java.net.SocketException
    MESSAGE: java.net.ConnectException: Connection refused
    
    STACKTRACE:
    
    java.net.SocketException: java.net.ConnectException: Connection refused
    	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
    	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
    	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
    	at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    	at java.sql.DriverManager.getConnection(DriverManager.java:525)
    	at java.sql.DriverManager.getConnection(DriverManager.java:193)
    	at com.zimbra.cs.db.DbPool.getLoggerConnection(DbPool.java:361)
    	at com.zimbra.cs.service.admin.GetServiceStatus.handle(GetServiceStatus.java:67)
    	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)
    
    
    ** END NESTED EXCEPTION **
    
    
    
    Last packet sent to the server was 2 ms ago.
    	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2621)
    	at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    	at java.sql.DriverManager.getConnection(DriverManager.java:525)
    	at java.sql.DriverManager.getConnection(DriverManager.java:193)
    	at com.zimbra.cs.db.DbPool.getLoggerConnection(DbPool.java:361)
    	... 23 more
    2006-04-06 15:43:54,471 INFO  [http-7071-Processor48] [ip=192.168.1.254;name=admin@zimbra.notify.net;] mailbox - Creating database mailbox2
    2006-04-06 15:43:54,628 INFO  [http-7071-Processor48] [ip=192.168.1.254;name=admin@zimbra.notify.net;] mailbox - Dropping database mailbox2
    2006-04-06 15:43:54,638 INFO  [http-7071-Processor48] [ip=192.168.1.254;name=admin@zimbra.notify.net;] SoapEngine - handler exception
    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.cs.mailbox.Mailbox.getMailboxByAccount(Mailbox.java:932)
    	at com.zimbra.cs.service.admin.DeleteAccount.handle(DeleteAccount.java:81)
    	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
    2006-04-06 15:44:20,912 INFO  [ImapServer-131] [] imap - [192.168.1.254] connected
    2006-04-06 15:44:21,505 INFO  [ImapServer-131] [] ProtocolHandler - Handler exiting normally
    2006-04-06 15:45:50,652 INFO  [ImapServer-132] [] imap - [192.168.1.254] connected
    2006-04-06 15:45:51,065 INFO  [ImapServer-132] [] ProtocolHandler - Handler exiting normally
    2006-04-06 15:47:20,387 INFO  [ImapServer-133] [] imap - [192.168.1.254] connected
    2006-04-06 15:47:21,002 INFO  [ImapServer-133] [] ProtocolHandler - Handler exiting normally
    I was getting the permission denied error when I tried to restart the services. I changed the permissions on the redo.log file to the zimbra user, and was then able to start them back up.

  8. #8
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    What if you try to delete that account with zmprov and the command line? Then restart tomcat. Can you also verify that MySQL is running?
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  9. #9
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    9

    Default

    I was able to delete the account with the zmprov command. I restarted Tomcat, and MySQL is running. I tried logging in again, and got the same error as before. I also tried creating a user with the zmprov command, and get the same error when trying to log in.

    I found that I am able to log in to the client with the postmaster account. Not sure how this user is created differently than the ones I tried creating.

  10. #10
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    What version of Zimbra are you trying to run?

    postmaster? Did you create that? Or do you mean the admin account?

    After you deleted the bad account can you create a new account with zmprov and try to login with that?
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

Similar Threads

  1. Replies: 12
    Last Post: 08-25-2010, 03:37 AM
  2. Need Help Troubleshooting Web Client Issues
    By soxfan in forum Administrators
    Replies: 2
    Last Post: 03-23-2007, 06: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
  •