Convert phpbb/mysql to jforum/hsqldb

[Migrated From Jforum.net]

Hi all,
Having an apache/mysql/phpbb for a long time, I wanted to migrate in all java with jetty/hsqldb/jforum. The tool phpbb2forum being a good base, I modified it to directly target hsqldb or any other bases
After having installed your jforum, copy your base hsqldb in another directory. It is enough to modify the SystemGlobals.properties file according to your configuration then to carry out following scripts:
- phpbb2JForum.bat
- searchIndexer.bat
then to recopy your base towards the directory of the Web server.
For information, I treated 1500 posts migrated then indexed in 10 seconds on P3 1Gz.

Comments are welcome 8)

http://rapidshare.de/files/18929184/phpbb2jforum-redhand.rar.html
[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

Looks great! I'll take a closer look and add to the cvs!

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

[Migrated From Jforum.net]

Any progress on making this compatible with the latest releases of JForum (e.g. support for polls)?
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Humm, nothing more have been done since my post but maybe I could try adding polls to this converter.
[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

That would be greatly appreciated.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

redhand wrote:Humm, nothing more have been done since my post but maybe I could try adding polls to this converter.

I have the files here.. sorry for not giving any feedback so far.

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

[Migrated From Jforum.net]

Hi there,

I have deployed jforum to jetty but when trying to access http://localhost:8080/jforum/forums/list.page, I have the following error:

java.lang.LinkageError: javax/management/MBeanServer
at com.mchange.v2.c3p0.management.ActiveManagementCoordinator.attemptManageC3P0Registry(ActiveManagementCoordinator.java:52)
at com.mchange.v2.c3p0.C3P0Registry.attemptRegisterRegistryMBean(C3P0Registry.java:183)
at com.mchange.v2.c3p0.C3P0Registry.reregister(C3P0Registry.java:208)
at com.mchange.v2.c3p0.impl.PoolBackedDataSourceBase.(PoolBackedDataSourceBase.java:228)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.(AbstractPoolBackedDataSource.java:59)
at com.mchange.v2.c3p0.ComboPooledDataSource.(ComboPooledDataSource.java:94)
at com.mchange.v2.c3p0.ComboPooledDataSource.(ComboPooledDataSource.java:90)
at net.jforum.C3P0PooledConnection.init(C3P0PooledConnection.java:69)
at net.jforum.ForumStartup.startDatabase(ForumStartup.java:75)
at net.jforum.JForum.checkDatabaseStatus(JForum.java:246)
at net.jforum.JForum.service(JForum.java:143)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1124)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:361)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:757)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:416)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:826)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:523)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:377)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:497)


anyone has similar problem before?

Thanks
Alan
[originally posted on jforum.net by huang_a]