JForum database structure compatible with PHPBB?

[Migrated From Jforum.net]

Hi,

I have a phpbb-based website that I'm eager to move to Java. I wonder if it's possible to port it to JForum?

Thanks
JG
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Yes, it is possible to migrate your phpbb database to jforum. I have done a little program to make this task. You can take a look at http://jforum-tools.dev.java.net. If you know how to access a CVS repository, the files are there.

I"ll make a little Swing program to make easier to use the convertion program.

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

[Migrated From Jforum.net]

Hello Rafael,

I love jforum, and love the idea of the phpbb2 to jforum export tool. However, when I downloaded the phpbb2jforum-1.0.zip tool, I did not find any of the Unix/Linux shell script files (ie phpbb2jforum.sh) Is there an updated version of the tool that includes these? I have tried to execute the script manually but to no avail.

Thanks,
Arthur.
[originally posted on jforum.net by aenright]

[Migrated From Jforum.net]

Here is what I get when I try to execute it manualy (using what I found in the .bat file)

java -cp bin;lib/mysql-connector-java-3.1.2-alpha-bin.jar net.jforum.tools.phpbb2jforum.Main xxx_jforum xxx_jforum_xxx ******** localhost
Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)

where options include:
    -client       to select the "client" VM
    -server       to select the "server" VM
    -hotspot      is a synonym for the "client" VM  [deprecated]
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A : separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose[:class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -jre-no-restrict-search
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
-bash: lib/mysql-connector-java-3.1.2-alpha-bin.jar: Permission denied
[root@catcher phpbb2jforum]#

I have tried running it form my workstation as well (that has the latest Sun JRE) and I get the same error...

Thanks,
Art.
[originally posted on jforum.net by aenright]

[Migrated From Jforum.net]

It appears to be a class path problem, but as I am not versed in the way java works, I am at a loss. When I run

java -jar mysql-connector-java-3.1.2-alpha-bin.jar

I get Failed to load Main-Class manifest attribute from mysql-connector-java-3.1.2-alpha-bin.jar. When I run java with the -cp option, it just pukes all over my console :P

Any help would be greatly appreciated.

Thanks,
Art
[originally posted on jforum.net by aenright]

[Migrated From Jforum.net]

There is no Main class in mysql-connector-java-3.1.2-alpha-bin.jar, That's all

and from your previous post

-bash: lib/mysql-connector-java-3.1.2-alpha-bin.jar: Permission denied

you have to check permissions or just do an chmod 777 mysql-connector-java-3.1.2-alpha-bin.jar
[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

I tried chmoding mysql-connector-java-3.1.2-alpha-bin.jar, but I still get an error... Does anyone have the bash script for executing it? I am on CentOS4 w/ Java 1.4.2

Thx,
Art
[originally posted on jforum.net by aenright]

[Migrated From Jforum.net]

Have you chmoded the lib directory too ?
[originally posted on jforum.net by redhand]

[Migrated From Jforum.net]

Ok, I chmoded the entire directory tree to 777. This is what I get:

[root@catcher phpbb2jforum]# java lib/mysql-connector-java-3.1.2-alpha-bin.jar net.jforum.tools.phpbb2jforum.Main xxxx_jforum xxxx_jforum_adm **** localhost
Exception in thread "main" java.lang.NoClassDefFoundError: lib/mysql-connector-java-3/1/2-alpha-bin/jar
[root@catcher phpbb2jforum]#


[root@catcher phpbb2jforum]# java -cp bin;lib/mysql-connector-java-3.1.2-alpha-bin.jar net.jforum.tools.phpbb2jforum.Main xxxx_jforum xxxx_jforum_adm ******** localhost
Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)

where options include:
    -client       to select the "client" VM
    -server       to select the "server" VM
    -hotspot      is a synonym for the "client" VM  [deprecated]
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A : separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose[:class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -jre-no-restrict-search
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
-bash: lib/mysql-connector-java-3.1.2-alpha-bin.jar: cannot execute binary file
[root@catcher phpbb2jforum]#

Any suggestions?
[originally posted on jforum.net by aenright]

[Migrated From Jforum.net]

I still havent had any luck with this tool. I cannot get it to execute. Is there a manual set of SQL queries that can be run on the DB? I would love to get the posts imported (and I wish I had gone with JForum in the first place...)

Thanks,
Art.
[originally posted on jforum.net by aenright]

[Migrated From Jforum.net]

Ok, so I have ran most of the SQL queries that are in:

phpbb2jforum/bin/phpbb2jforum/mysql_queries.sql

But I am still missing some things (like the queris that need input from the java program.

Thanks in advance to anybody who can shed some light.

Thanks,
Art.
[originally posted on jforum.net by aenright]

[Migrated From Jforum.net]

Maybe a conflict between 'bin' command and bin set in 'java -cp bin;....."
Try to set full pathname for bin and lib in your classpath .e.g :

java -cp /jforum/src/bin;/jforum/src/lib/........

or rename bin directory and change it accordingly in your command line
[originally posted on jforum.net by redhand]