Category Archives: Jabber

Updating Openfire 3.4.4 to 3.6.3 via RPM

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.

Openfire and transports

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.