Page 1 of 1

After Update to 11.4.4 - Mobile Webmail and Webcal problem

Posted: Fri Jun 12, 2009 8:34 am
by joey4712
Hi all,

after Updating to Scalix 11.4.4 the Mobild Webmail and Webcal access stopped working.

Code: Select all

2009-06-12 14:32:52,558  WARN [PlatformDispatcherServlet.service:83] Problem processing request method=GET URI=/api/***@***.***/mailbox/Public%20Folders/Kalender%20***
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.hibernate.exception.GenericJDBCException: Cannot open connection
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
   at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
   at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
   at $Proxy0.createStatement(Unknown Source)
   at com.scalix.api.mailbox.ImapDataCache.getSession(ImapDataCache.java:144)
   at com.scalix.api.mailbox.ImapDataCache.checkForTables(ImapDataCache.java:1013)
   at com.scalix.api.mailbox.ImapDataCache.init(ImapDataCache.java:96)
   at com.scalix.api.mailbox.CacheService.init(CacheService.java:42)
   at com.scalix.api.service.Context.getServiceByName(Context.java:229)
   at com.scalix.api.service.Context.getServiceByName(Context.java:213)
   at com.scalix.api.mailbox.Mailbox.init(Mailbox.java:155)
   at com.scalix.api.service.Context.getServiceByName(Context.java:229)
   at com.scalix.api.service.Context.getMailboxService(Context.java:196)
   at com.scalix.api.rest.MailboxServlet.doGet(MailboxServlet.java:69)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
   at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:174)
   at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
   at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:774)
   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:460)
   at com.scalix.api.PlatformDispatcherServlet.service(PlatformDispatcherServlet.java:76)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   at org.springframework.web.filter.AbstractRequestLoggingFilter.doFilterInternal(AbstractRequestLoggingFilter.java:133)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
   at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
   at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
   at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
   at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
   at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
   at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
   at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
   at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
   at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
   at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
   ... 42 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
   at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
   at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
   at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
   at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
   ... 45 more



I think the apps running in Tomcat cannot connect to Postgres? Postgres seems to be running.

Any hints?


Thanks!

Re: After Update to 11.4.4 - Mobile Webmail and Webcal problem

Posted: Fri Jun 12, 2009 9:01 am
by joey4712
We found the solution for this problem:

During update te installer asked for the Database password. We entered the WRONG password.

We reconfigured Scalix DB (Postgres) now and used the correct password this time. Mobile Webmail and Webcal is now working again.