Markus "guruz" Goetz

In case anyone googles for this, I had problems doing this. Somehow, the DB upgrade scripts were not executed. So it complained because it could not find its tables:

java.lang.IllegalArgumentException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
  Table 'openfiredb.ofID' doesn't exist

What I did was to check in the jiveVersion table which DB version was set for “openfire”. Then I mysql’ed the SQL files in /opt/openfire/resources/database/upgrade manually to the latest version.

Then everything worked fine. Why it didn’t run the SQL scripts automatically? I don’t know. But it once again proves that the quality of Openfire is.. not so high.

You can use guruzJabberd14ToOpenfireExport.jar to convert userfiles from Jabberd 1.4 to the format Openfire understands. Just run it with the directory with the XML-files as parameter. The file for Openfire will be put out on stdout.

Change some lines and be able to merge users instead of having to delete and re-import them.

In case you have migrated to Openfire, you may have some problems with ICQ, AIM etc. users on your roster. It MAY help to set the following properties to true:

 plugin.gateway.tweak.percenthack
 plugin.gateway.tweak.persistentroster

More information can be found hidden somewhere on the Openfire site.

PS: Jabberd 1.4 to Openfire export tool coming here soon.

I’ve written a component for Openfire which enables authentication of users via a crypt() password in a DB.

1. Make sure you have a lot of packages installed: subversion rpm-build rpm-devel ant ant-junit ant-scripts ant-jmf ant-nodeps  ant-antlr junit (this may be way too much, but it worked for me)
2. Checkout the Openfire sources from SVN
3. In build/ run ant installer.rpm
4. Happy compiling and installing