Upgrading Openfire 3.10.2 to 4.0.1 on CentOS using MySQL DB

Openfire Openfire Support
1

What are the procedures in upgrading an existing Openfire installation. Is it just uninstalling the previous one and installing the new one ? then connect to the current DB ? When I start the new version, does Openfire update the DB automatically ?

2

If you used the RPM install, just rpm -Uvh openfire-4.0.1.rpm and when openfire restarts, it will update the database automagically.

3

Hi Daryl,

This was the error in the Openfire application server :

2016.02.24 03:58:27 INFO [pool-3-thread-1]: org.jivesoftware.database.SchemaManager - Found old database version 0 for monitoring. Upgrading to version 3…

2016.02.24 03:58:27 ERROR [pool-3-thread-1]: org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:

ALTER TABLE ofMessageArchive ADD COLUMN fromJIDResource VARCHAR(255) NULL;

2016.02.24 03:58:27 ERROR [pool-3-thread-1]: org.jivesoftware.database.SchemaManager - Duplicate column name ‘fromJIDResource’

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name ‘fromJIDResource’

Upon checking the column is already there but of different size. The application should not be adding a COLUMN.