tomcat server behind a firewall, which port to open ?

[Migrated From Jforum.net]

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]

[Migrated From Jforum.net]

Not sure this could help but if you are using hsqldb without manual modif to config files, db type is "in memory" so you don't have to open any port for use it and database.connection.port=3306 isn't used in this case.

first check your jforum-custom.conf, you should find something like that :
database.driver.name=hsqldb
database.connection.driver=org.hsqldb.jdbcDriver
database.connection.username=sa
database.connection.password=
database.connection.dbname=jforum
dao.driver=net.jforum.dao.hsqldb.HsqldbDataAccessDriver

seconde, if your dbname is jforum then properties are jforum.properties

[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

Port 8080 is the default tomcat port.
Port 80 is the default http port.
So you have to either forward port 8080 to 80 or you have to change the port and forward port 80 to 80
[originally posted on jforum.net by Anime-Otaku]