Issues setting up embedded hsql database


I’m trying to setup the Openfire server on a machine where I don’t have admin rights.

I have extracted the openfire server and followed the instructions as specified in the link .html

However, when I start up the server, i get the error ‘created a new connection but it failed its test’

My openfire.xml settings are as follows (only relevant bits shown)


<className>org.jivesoftware.database.DefaultConnectionProvider</classN ame>








<testSQL>select 1</testSQL>








I have already created the database as a stand alone database and i can verify that all tables exist.

Can anybody suggest any possible reasons why I’m getting this error. Pls. find attached the error log.

It would be beneficial to know what OS you are installing on. That being said I do not believe you can setup Openfire without admin access. The server software will not have the correct permissions on the files and folders to operate.