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.