Hi !
I installed JForum on a server (Linux) very well protected. It is just port 8088 (the tomcat-port) that is open outside.
I use the HSQLDB database, and my hsqldb.properties looks like this:
<<
<br /> database.connection.password=
<br /> database.connection.dbname=jforum
<br /> database.support.autokeys=false
<br /> database.connection.host=www.myserver.se
<br /> database.connection.pool.min=1
<br /> database.support.subqueries=true
<br /> database.connection.pool.timeout=2000
<br /> database.connection.username=sa
<br /> database.connection.string=jdbc\:hsqldb\:${config.dir}/database/hsqldb/${database.connection.dbname}
<br /> dbencoding=utf-8
<br /> database.connection.pool.max=5
<br /> dao.driver=net.jforum.dao.hsqldb.HsqldbDataAccessDriver
<br /> database.connection.driver=org.hsqldb.jdbcDriver
<br /> >>
When I'm working on the server, JForum works very well.
But when I try to access it remotely via port 8088, I can see everything, but I can't post a message on the forum. When I press "Submit", the page is deseperaly blank.
In the logfile, I see
<<
<br /> 2006-08-21 14:41:35 StandardWrapperValve[jforum]: Servlet.service() for
servlet jforum threw exception
<br /> java.lang.NullPointerException
<br /> at net.jforum.JForumExecutionContext.enableRollback(JForumExecutionContext.java:272)
<br /> at net.jforum.JForum.service(JForum.java:209)
<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
<br />
<br /> >>
The error points to JForum.java, raw 209, which is inside an exception. Something has gone wrong before in service().
My guess is that one port is not open and the database needs it to be open in order to write the new post. Bus as I use hsqldb, I'm quite confused...
I see in jforum-custom.conf:
<<
<br /> ..
<br /> database.connection.port=3306
<br /> ..
<br /> >>
3306 is the port MySQL uses, but it seems useless in my case.
Can I remove this line ?
Is it the port I need to open ?
Is there another port hsqldb uses ?
regards
Olivier
[originally posted on jforum.net by olivierm2]