Upgrade

Upgrading is very simple. Opinio will automatically detect the database version, and make the necessary upgrades:

  1. Stop the application server. If you are running in clustering mode (multiple instances of Opinio), remember to stop all cluster members.
  2. Move the opinio folder out of the webapps folder of your application server (Tomcat or other). Keep this as backup for now.
  3. Place the Opinio.war file in the webapps folder, and restart your application server.
  4. Edit the opinio/WEB-INF/opinio.properties file, if this file was edited after the original installation (if you are using another database than the built-in HSQLDB database, for example).
  5. If you are using another database than the built-in HSQLDB database copy the JDBC driver to the new installation (Opinio/WEB-INF/lib folder).
  6. Copy the upload folder of your old Opinio installation to your new installation. Make sure it is located under the Opinio top folder.
  7. For HSQLDB users: If you are using the built-in database, HSQLDB, then you must also copy the database files from the old installation, to the newly installed version. Copy the folder opinio/WEB-INF/data/ to the new installation (overwrite the files).
  8. Make sure the database user (specified in opinio.properties file) has permissions to perform ALTER TABLE operations on the Opinio database. This does not apply if you are using HSQLDB.
  9. Restart the application server. If you are running multiple instances of Opinio in clustering mode, remember to start one server first, then wait 3 minutes (so that it can perform automatic database upgrades), then start the remaining cluster members. Your new version is now installed, and the database is updated for the new version.