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

Thread: Can't login to web client

  1. 04-05-2006, 01:37 PM #1
    mhiles
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    8

    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
    Reply With Quote Reply With Quote
  2. 04-05-2006, 03:16 PM #2
    KevinH
    KevinH is offline Zimbra Employee
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,792
    Rep Power
    17

    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.
    Bugzilla - Wiki - Downloads - Offline Client
    Reply With Quote Reply With Quote
  3. 04-06-2006, 06:15 AM #3
    mhiles
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    8

    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.
    Reply With Quote Reply With Quote
  4. 04-06-2006, 08:38 AM #4
    KevinH
    KevinH is offline Zimbra Employee
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,792
    Rep Power
    17

    Default

    Can you attach more of the log file. Just zip up the last 1000 lines or something before/after a test.
    Bugzilla - Wiki - Downloads - Offline Client
    Reply With Quote Reply With Quote
  5. 04-06-2006, 09:59 AM #5
    mhiles
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    8

    Default

    I attached a zip file with the last 1000 lines of the zimbra.log file.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  6. 04-06-2006, 12:33 PM #6
    KevinH
    KevinH is offline Zimbra Employee
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,792
    Rep Power
    17

    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.
    Bugzilla - Wiki - Downloads - Offline Client
    Reply With Quote Reply With Quote
  7. 04-06-2006, 12:53 PM #7
    mhiles
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    8

    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.
    Reply With Quote Reply With Quote
  8. 04-06-2006, 01:03 PM #8
    KevinH
    KevinH is offline Zimbra Employee
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,792
    Rep Power
    17

    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?
    Bugzilla - Wiki - Downloads - Offline Client
    Reply With Quote Reply With Quote
  9. 04-06-2006, 01:27 PM #9
    mhiles
    mhiles is offline Member
    Join Date
    Mar 2006
    Posts
    10
    Rep Power
    8

    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.
    Reply With Quote Reply With Quote
  10. 04-06-2006, 01:57 PM #10
    KevinH
    KevinH is offline Zimbra Employee
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,792
    Rep Power
    17

    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?
    Bugzilla - Wiki - Downloads - Offline Client
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Issues with Microsoft Outlook RTF and Web Client
    By soxfan in forum Users
    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, 01:47 AM
  4. Web Client Fails to login
    By maestro in forum Installation
    Replies: 14
    Last Post: 12-21-2006, 11:31 AM

Posting Permissions

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

Forum Rules