Upgrading Openfire 3.10.2 to 4.0.1 on CentOS using MySQL DB

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 ?

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

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.