PunBB to Vanilla 1 or 2

yann

I am planning to move our punBB forums to Vanilla and was wondering about a few things.

1- Has someone done a script to migrate a punBB database to Vanilla? If not, does anyone know how hard it would be?

2- I need to do this in the next few months. What would you recommend, vanilla 1 and update when 2 is officially released or go straight to 2 now. The forum is in production and we'd rather do one move instead of two. It would save time on doing two theme to get the a similar look and feel as well.

3- We would like gravatar and OpenID support as well, is there already plugins for 2 for those or not yet.

4- Before we fully move to OpenID, we would need a single sign on. I saw that it was planned for Vanilla 2 but not released yet. Any idea of ETA on that?

Finally, thanks for making a superb set of forums.

Mark

1. There aren't any migration scripts for Vanilla 2 yet, but there is one from Vanilla 1 to Vanilla 2. So if you managed to get a Vanilla 1 migration working, you could get it ported to Vanilla 2. We're planning on working on Vanilla 2 importers after it is released (end of October-ish).

2. I'd recommend going Vanilla 2 if you've got months of time available. You could get a theme working now and go live when V2 is officially released.

3. @Todd has been working on authentication methods, and I think he's got openid support built in. We'll have to refer to him on that one. There isn't any gravatar support out of the box, and I don't know how Gravatar works, so I don't know how difficult/easy it would be.

4. The first SSO integration for Vanilla 2 will be released in a day or so.

Glad you like Vanilla!

Linc

@Mark, Gravatar integration is usually super easy; I hacked it into vBulletin in under an hour. And by "super easy" I mean "you could probably leave it to us" not "well why don't you hurry up"

yann

Okay, I have a version of an importer from punBB to vanilla 1.

What would be the best way to get this download here? Should I get commit writes to git or should I just email @Mark with a .zip file?

It is tested in the sense that it does work for me (TM). It is written in activewarehouse-etl which is based on ruby. It should be easy enough to expend.

Mark

Upload it to the addons site!

yann

@Mark, that would be smart now, would it not? .............

Will upload sometimes today

yann

Link http://vanillaforums.org/addon/474/PunBB-to-Vanilla-migration-tool

Mark

Sweet!

yann

@Mark No problems.

tsabat

Hi guys, I just completed the migration from Wufoo's punBB installation to vanilla 2 and I thought I'd post my notes here to help the next guy who comes along.

I used http://vanillaforums.org/addon/474/PunBB-to-Vanilla-migration-tool which got me 99% of the way.

The README file provided with the tool was pretty thorough, but if you're working on a Mac with Snow Leapord, you'll be faced with a few stumbling blocks, so the following resources were very helpful in getting me off the ground.

* Migration Path

We had to go from punBB to Vanilla 1 using the tool listed here, then use the Data Import Tool to get the DB upgraded to Vanilla 2. The Data Import Tool instructions may be found here: http://vanillaforums.com/blog/help-topics/importing-data

* Ruby Issues

You'll need to install various gems. This will differ from system to system. Just pay attention to the errors you get and you'll be able to figure out which those are.

* Missing Requirements

mysql.rb
Error: The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql
The solution mentioned here did the trick:
http://stackoverflow.com/questions/991708/rails-mysql-and-snow-leopard/1349567#1349567

So, after reinstalling MySQL, I used this command:
sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql-5.1.49-osx10.6-x86_64/bin/mysql_config

which got the mysql gem compiled correctly.

* MAMP Issues

Because MAMP lives in an unexpected location, getting the Ruby mysql_adapter to work resulted in an error, "Can't connect to local MySQL server through socket '/tmp/mysql.sock (2)'"

I fixed this with the help of this post: http://www.fischerlaender.net/web-20/mac-os-x-trouble-with-mamp-mysql, which advised creating a symlink to the sql socket, like so:

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

* SQL Issues

Don't name your databases with dashes. These will break the sql

* Permissions

When you switch to Vanilla 2, you'll have to add permissions for unauthenticated and authenticated users before you're able to mess with the