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.