Migrate from PhpBB

Our provider does not support PHP any longer.
Are the (mysql)-Database Files useable? I mean, can I use the old database (crated from phpBB) with the new JForum :?:
If not, is there a converter to convert old PhpBB-Databases to JForum-Databases?

Thanks
[originally posted on jforum.net by Anonymous]

Sure . Take a look in this doc:

http://www.jforum.net/confluence/display/migration/phpbb

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

Thanks,
I have taken a look at the mentioned document.

Do I have to install JForum first, or do I have to start the migration script first?

(In any case. I tried to install the forum, but the mentioned link:
http://localhost:8080/jforum/install/install.page?module=install&action=welcome
does not work. First, because I adminstrate the Forum on a different server (not on localhost) and second (i tried the correct url) I get the message "connection refued")



[originally posted on jforum.net by Anonymous]

Its me again

>now as registered user :-)

Anyone has installed JForum on an apache/tomcat configuration?
What is special? What do I have to insert into /etc/apache/virtuals.conf?
What is the correct jforum.xml content?

thanks
[originally posted on jforum.net by phi]

I suggest you to install jforum first, since the automated installation will try to remove the tables / clean them.

If you use manual installation, then you can do in any order. Just don't forget that at least jforum's tables should be already created.

jforum.net runs under an Apache server, but I just configure an entry in a file named "workers2.properties".

You will need to redirect all *.page and *.jsp extensions to Tomcat.

My jforum.xml looks like

<Context path="/jforum" docBase="/path/to/jforum/root" reloadable="true/> <br /> <br /> Rafael <br /> [originally posted on jforum.net by Rafael Steil]">

The thread actually should be renamed ;-)

I am still triing to "install" jForum.

I am now at this point, where the following call gets a result from the JForum Servlet:
---
http://myserver.net/jforum/install/install.page?module=install&action=welcome

The Result is not the expected Install-Page, but the following error:
---
(ForumException.java:85) at net.jforum.JForum.service(JForum.java:285) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperV...
...

Any Idea? Anyone Installed the JForum on a remote server using Apache/Tomcat?


[originally posted on jforum.net by phi]

Try manual installation: http://www.jforum.net/install_no_wizard.htm

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

I started the "manual installation". A funny hack ;-), but it seams to work...

The whole database is now installed. And I removed and changed the lines in the property files as mentioned.

Now, going to
/http://<myserver>/jforum
I am forwarded to
/http://<myserver>/jforum/install/install.page?module=install&action=welcome
And I Have to do the installation again (?)

Doing so (another installation with the jforum-install-web-application) I get the following error:

Syntax error or access violation message from server: "You have an error in your SQL syntax near '; ' at line 1"
INSERT INTO jforum_groups ( group_name, group_description ) VALUES ('General', 'General Users');


What went wrong?
[originally posted on jforum.net by phi]

Heck. Edit index.htm and set "document.location" to this:

document.location = "forums/list.page";

it should work for you. Also, don't forget to remove the "install" key from WEB-INF/config/modulesMapping.properties.

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

Thank, great, the new document.location seams to work

So step1 (install jForum) is done.
Now I have to configure it and to migrate from PHP.

But irst I have a good sleep and try it tomorow morning.

Good night.
[originally posted on jforum.net by phi]

Now, the title of the Forum makes sense again!

I had to change the
phpbb2jforum.bat
to a
phpbb2jforum.sh with the following content:

/usr/java/bin/java -cp bin:lib\mysql-connector-java-3.1.2-alpha-bin.jar net.jforum.tools.phpbb2jforum.Main $1 $2 $3 $4
Now, when I start the batch, I get the following error message:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:199) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at net.jforum.tools.phpbb2jforum.Main.openConnection(Main.java:41) at net.jforum.tools.phpbb2jforum.Main.main(Main.java:273)
It seams, that the com.mysql.jdbc.Driver could not be found.
I am missing a Jar-File in the classpath (-cp) But where do I find it?

By the way: the jsp-Forum-Code uses the same driver in the mysql.properties and it works.

So, where do I find this driver? Which jar-File do I have to import :?:
[originally posted on jforum.net by phi]

This file should be in the "lib" directory. I included it in the zip file.

I'll add the .sh file .. I forgot that

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

Sorry, my fault
I was not cautios changing the *.bat to the *.sh script.
I should have transformed the \ to / as well.
Now, the script runs fine.

New Problem:
--------------------
Going to the "Forum Index" I see the correct status line:
22 registered users, 277 messages, I even see my old avatar I have used in the old forum :!:

but I do not see the Forums.
I see them using select * from jforum_forums.
But not in the jsp-website going to "Forum-Index". The Index is empty.
What is to do?
---------------------------
A second question arises. How do I give 2 people the administrator possibility? Using "Admin" and password "admin" did not work.
------------------------
Third question:
What about all these wrong special characters like "üÄ ..."?

[originally posted on jforum.net by Anonymous]

You should set the permissions.. In fact, I should had mentioned that in Confluence.. sorry.. I'll updatet the page to include this information.

Let's suppose your user_id is "3".. Run the following query in the mysql console:

INSERT INTO jforum_roles ( name, user_id, role_type ) VALUES ('perm_administration', 3, 1);

This will enable make your user an Admin. Now, log off / login ( or restart the context ), go to the Admin Control Panel and set all other roles for the groups.

The migration utility does not import phpbb's roles, since I didn't understand it yet.

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

A second question arises. How do I give 2 people the administrator possibility? Using "Admin" and password "admin" did not work.

Well, after you did the steps mentioned in the previous post, just go to the user management and give the "Admin" permission to the users you want to administrate the forum. ( or put them in some "admin group" ).

When using the migration program, the "Admin / admin" user is not created.

Third question:
What about all these wrong special characters like "üÄ ..."?

hhmm.. what special chars? I appears to be specifc of your system, no?! .. If you can't solve, send the mysql dump to my email and I take a look.

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

Hi

This worked. I am now a big step ahead. Thanks.

If I log in as administrator now, I can administrate the Forums, Users, Permissions, .....

The "umlaut"-Problem äÜß is solved. I changed form UTF8 to iso-8859-1.

Remaining Problems:
As a user which is not "loged in", I do not see any Categories (Forum-Index).
As "loged in"-User, I see the 4 Categories (Forum-Index), but any Forums.
I just see the forums in the "administration" panel.

The recent topics leads to the followin message in the "Forum Name" Column:
Expression forums.get(topic_index).getName() is undefined on line 64, column 199 in default/recent_thread.htm. The problematic instruction: ---------- ==> ${forums.get(topic_index).getName()} [on line 64, column 197 in default/recent_thread.htm] in include moduleAction [on line 71, column 21 in default/forum_base.htm] ---------- Java backtrace for programmers: ----- ...
[originally posted on jforum.net by Anonymous]

Rafael Steil wrote:Sure . Take a look in this doc:

http://www.jforum.net/confluence/display/migration/phpbb

Rafael

I am trying to access this script, but i see this message:

HTTP Status 404 - /confluence/display/migration/phpbb type Status report message /confluence/display/migration/phpbb description The requested resource (/confluence/display/migration/phpbb) is not available. Apache Tomcat/5.0.28

What is wrong?
[originally posted on jforum.net by Murata]

Confluence and Jira are down. The ISP changed Tomcat and didn't migrate all contexts. I'm working on that.

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

I had some problems, using the migration tool:
Some things get mixed up, if the JForum servlet is running while using the migration tool. That should of course be expected but I did not ops:
Later only one migrated forum showed up although all forums were migrated (saw them in the database). When I tried to access one of the other forums directly, it told me that I am not authorized to use the forum. Solution: Creating as many forums as I wanted to migrate, before I used the migration tool fixed it.
[originally posted on jforum.net by Robert]