File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes Convert phpbb/mysql to jforum/hsqldb Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Convert phpbb/mysql to jforum/hsqldb" Watch "Convert phpbb/mysql to jforum/hsqldb" New topic
Author

Convert phpbb/mysql to jforum/hsqldb

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
That would be greatly appreciated.
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Convert phpbb/mysql to jforum/hsqldb
 
Similar Threads
phpBB to JForum/PostgreSQL
Replacement of phpbb
Migrate from PhpBB
How to convert phpBB to JForum?
Any good free Messageboards on the internet?