powered by Jive Software

Monitoring plugin does not work with OpenFire 3.8.2 embedded database

I attempted to install the monitoring plugin with OpenFire 3.8.2 using the embedded database, but I was unable to execute the script.

Steps to reproduce:

  1. Install OpenFire 3.8.2 and complete the inital configuration

  2. Stop the OpenFire server

  3. Copy monitoring.jar to the plugins directory

  4. Start the OpenFire server

  5. Wait for the plugin to finish installing

  6. Stop the OpenFire server

  7. Run the embedded-db-viewer.bat file from C:\Program Files (x86)\OpenFire\bin\extra directory

  8. Open the script file “monitoring_hsqldb.sql” from C:\Program Files (x86)\Openfire\plugins\monitoring\database\ directory

  9. Execute the script

  10. The script will not execute, it generates the following error: “java.sql.SQLException: Unique constraint violation: SYS_IDX_60”

If you attempt to use the script from C:\Program Files (x86)\OpenFire\plugins\monitoring\database\extras\import.hsqldb.sql, you’ll get this error:

java.sql.SQLException: Unexpected token: TRUNCATE in statement [TRUNCATE]

Any ideas?

You shouldnt have to run a script if you are using the embedded database?