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:
-
Install OpenFire 3.8.2 and complete the inital configuration
-
Stop the OpenFire server
-
Copy monitoring.jar to the plugins directory
-
Start the OpenFire server
-
Wait for the plugin to finish installing
-
Stop the OpenFire server
-
Run the embedded-db-viewer.bat file from C:\Program Files (x86)\OpenFire\bin\extra directory
-
Open the script file “monitoring_hsqldb.sql” from C:\Program Files (x86)\Openfire\plugins\monitoring\database\ directory
-
Execute the script
-
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?