upgrading from 2.1.6 to cvs head

[Migrated From Jforum.net]

Hi,

yeah that's what I understood from the stack trace but following it
down doesnt help me much getting into the code to see what's wrong.

Would it ne possible to have a description of the steps one has to get
through to upgrade its forum from cvs (head) ?
I am not claiming (yet) that the upgrade is not working, i may have
missed something.

thanks a lot for your help,
seb
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Hello,

I am a new jforum user. I installed v2.1.6 ran with a tomcat on fedora core 5:

Server version: Apache Tomcat/5.5.15
Server built: Mar 6 2006 06:17:44
Server number: 5.5.15.0
OS Name: Linux
OS Version: 2.6.16-1.2122_FC5
Architecture: i386
JVM Version: 1.5.0_04-b05
JVM Vendor: Sun Microsystems Inc.

I encountered an error already pointed by other users. The fix is said to
get the cvs head version.
Built succesfully, but now i am a bit stuck with file replacements w.r.t version
2.1.6; following the advices from the upgrading web page didn't help (i guess
they are especially available for migrating from 2.0X to 2.1X)

I am using a hsqldb and am wondering through wich steps i have to go
to get my forum up again.
What i tried up-to-know is:
- replace jforum 2.1.6 directory with the cvs head one.
- checked the SystemGlobalProperties file
- copied the jforum_custom.conf in WEB-INF/config
(removed the database.contact.string line)
- copied the directory database in (including all files)

when i try to get to the page:
http://localhost:8080/jforum/forums/list.page

I get this message:

HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Servlet.init() for servlet jforum threw exception
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)

root cause
net.jforum.exceptions.DatabaseException: Error while trying to start the database: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectException: Connection refused'.

** 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:2680)
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 net.jforum.SimpleConnection.getConnection(SimpleConnection.java:93)
at net.jforum.SimpleConnection.init(SimpleConnection.java:74)
at net.jforum.ForumStartup.startDatabase(ForumStartup.java:75)
at net.jforum.JForum.init(JForum.java:93)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:757)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:130)
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.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
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 **


Attempted reconnect 3 times. Giving up.
com.mysql.jdbc.Connection.createNewIO(Connection.java:2749)
com.mysql.jdbc.Connection.<init>(Connection.java:1485)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:193)
net.jforum.SimpleConnection.getConnection(SimpleConnection.java:93)
net.jforum.SimpleConnection.init(SimpleConnection.java:74)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:75)
net.jforum.JForum.init(JForum.java:93)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.
Apache Tomcat/5.5.15


any help would be appreciated.

cheers,
seb




[originally posted on jforum.net by sgreder]

[Migrated From Jforum.net]

Looks like the database isn't starting and JForum can't make a connection to it.

[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

Remove your jforum-custom.conf for a while, and check the database settings at web-inf/config/database/mysql/mysql.properties

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Hello Rafael,

thanks for you quick reply but i have to say that i am a bit confused.

"keep your jforum_custom.conf away for a while" ... what does this mean ?
and why should i play with mysql.properties since i am using hsqldb ?

Sorry for annoying you, but i cannot get the proper information i would like
from you web pages (upgrading, ...).
So, my point is still the same: what should I *exactly* do to rebuild and redeploy jforum 2.1.6 into the cvs head version ? ( i am not a java guru )

Could you please, write down which files have to be checked, replaced, moved ? If i have to follow some instructions from another link that I may
have missed ?
Installing stuf from cvs might happen again so it would be nice to have
a minimal set of instructions.

cheers,
seb



[originally posted on jforum.net by sgreder]

[Migrated From Jforum.net]

If you are using hsqldb, then edit hsqldb.properties

Remove your jforum-custom.conf from the config directory - that's what I meant.

Rafael
[originally posted on jforum.net by Rafael Steil]