aspose file tools*
The moose likes JForum and the fly likes Migrate from PhpBB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Migrate from PhpBB" Watch "Migrate from PhpBB" New topic
Author

Migrate from PhpBB

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Sure . Take a look in this doc:

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

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

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

<br /> <br /> Rafael <br /> [originally posted on jforum.net by Rafael Steil]">
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Try manual installation: http://www.jforum.net/install_no_wizard.htm

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Heck. Edit index.htm and set "document.location" to this:



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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Now, the title of the Forum makes sense again!

I had to change the

to a
with the following content:


Now, when I start the batch, I get the following error message:


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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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 .
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]
Migrated From Jforum.net
Ranch Hand

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



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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424

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]
Migrated From Jforum.net
Ranch Hand

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

[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

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



What is wrong?
[originally posted on jforum.net by Murata]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Migrate from PhpBB