Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Users
Reload this Page Can't login to web client

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
Page 1 of 2 1 2
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-05-2006, 01:37 PM
Member
  
Posts: 10
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
  #2 (permalink)  
Old 04-05-2006, 03:16 PM
Zimbra Employee
  
Posts: 4,792
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
  #3 (permalink)  
Old 04-06-2006, 06:15 AM
Member
  
Posts: 10
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
  #4 (permalink)  
Old 04-06-2006, 08:38 AM
Zimbra Employee
  
Posts: 4,792
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
  #5 (permalink)  
Old 04-06-2006, 09:59 AM
Member
  
Posts: 10
Default
I attached a zip file with the last 1000 lines of the zimbra.log file.
Attached Files
File Type: zip zimbra.zip (7.0 KB, 95 views)
Reply With Quote
  #6 (permalink)  
Old 04-06-2006, 12:33 PM
Zimbra Employee
  
Posts: 4,792
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
  #7 (permalink)  
Old 04-06-2006, 12:53 PM
Member
  
Posts: 10
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
  #8 (permalink)  
Old 04-06-2006, 01:03 PM
Zimbra Employee
  
Posts: 4,792
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
  #9 (permalink)  
Old 04-06-2006, 01:27 PM
Member
  
Posts: 10
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
  #10 (permalink)  
Old 04-06-2006, 01:57 PM
Zimbra Employee
  
Posts: 4,792
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
Page 1 of 2 1 2

« Previous Thread | Today's Posts or Week's Posts | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode


Similar Threads

Product Information

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com


Home - Blog - Contact Us - Archive - Top


 

SEO by vBSEO ©2011, Crawlability, Inc.