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:
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:
More information can be found hidden somewhere on the Openfire site.
PS: Jabberd 1.4 to Openfire export tool coming here soon.