Issues with 11.4.1 Installation

[mbowesman]

I have been trying to get Scalix up and running, without much succes and I am beginning to think about throwing it out of the Window.

I have a clean install of Fedora 9, on top of which I have installed Scalix communitry edition 11.4.1.

2 issues so far

1). If I attempt to send an email to an external address from within webmail, it never gets sent. All I have is the following entry in maillog

Aug 20 21:21:13 core-svr sendmail[4119]: m7KBLDDn004119: from=<martin@xx.net>, size=1142, class=0, nrcpts=1, msgid=<14952429.41219231272628.JavaMail.root@core-svr.xx.net>, proto=ESMTP, daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Aug 20 21:21:13 core-svr sendmail[4119]: m7KBLDDn004119: to=<xx@internode.on.net>, delay=00:00:00, mailer=esmtp, pri=31142, dsn=4.4.3, stat=queued

This is from a vanilla install with no modifications to any files

2). Attempts to login via the mobile client, result in the following error

An error occurred: Unknown error (A00000)

I admit that I'm still a novice, but I have no idea what to do next.

Suggestions ?

[schmoe90]

1) The message has been handed to sendmail, so it's not a Scalix problem, it's a sendmail problem. Look at:

mailq

to see why it can't be sent.

2) What do the tomcat logs say?

[mbowesman]

mailq

/var/spool/mqueue (2 requests)
-----Q-ID----- --Size-- -----Q-Time----- ------------Sender/Recipient-----------
m7L4IQaj004211 565 Thu Aug 21 14:18 <martin@xx.net>
(host map: lookup (xx.net): deferred)
<xx@abc.com>
m7L2wZn9031328 530 Thu Aug 21 12:58 <martin@xx.net>
(host map: lookup (xx.net): deferred)
<xx@abc.com>
<xx@abc.on.net>

2) What do the tomcat logs say?

2008-08-21 14:23:33,043 WARN [PlatformDispatcherServlet.service:81] Problem processing request method=GET URI=/api/martin@xx.net/mailbox
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:146)
at com.scalix.api.mailbox.ImapDataCache.checkForTables(ImapDataCache.java:843)
at com.scalix.api.mailbox.ImapDataCache.init(ImapDataCache.java:101)
at com.scalix.api.mailbox.CacheService.init(CacheService.java:44)
at com.scalix.api.service.Context.getServiceByName(Context.java:213)
at com.scalix.api.service.Context.getServiceByName(Context.java:197)
at com.scalix.api.mailbox.Mailbox.init(Mailbox.java:133)
at com.scalix.api.service.Context.getServiceByName(Context.java:213)
at com.scalix.api.service.Context.getMailboxService(Context.java:180)
at com.scalix.api.rest.MailboxServlet.doGet(MailboxServlet.java:65)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:74)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:174)
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:151)
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 can successfully connect to this account via webmail, just not the mobile client.

I'm stumped.

[schmoe90]

(host map: lookup (xx.net): deferred)

That looks like it can't look up your server...? I'd make sure that DNS is configured correctly.

org.hibernate.exception.GenericJDBCException: Cannot open connection

That's a (duh) connection problem. The first thing I'd do is check /var/opt/scalix/<xx>/mobile/mobile.properties to make sure the platform.url is correct.

[mbowesman]

That's a (duh) connection problem. The first thing I'd do is check /var/opt/scalix/<xx>/mobile/mobile.properties to make sure the platform.url is correct.

That is what I originally thought, by nslookup / dig returns domains all successfully. If I run sendmail -q all mail gets sent. So why does it get deferred when originating from scalix.

That's a (duh) connection problem. The first thing I'd do is check /var/opt/scalix/<xx>/mobile/mobile.properties to make sure the platform.url is correct.

A connection problem in a vanilla install of scalix. Hmmm, sounds like something is broken with Fedora 9.

Anyway, I have since trashed my Fedoraq 9 installation, and installed Centos 5.2 and had Scalix up and running sccessfully in 20 minutes, including sending email and mobile web access. As such, I can only conclude that something is busted in Scalix when installed on Fedora 9.