Issues setting up embedded hsql database

Openfire Openfire Support
1

Hi,

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 http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .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)

<connectionProvider>

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

</connectionProvider>

<database>

<defaultProvider>

<driver>org.hsqldb.jdbcDriver</driver>

<serverURL>jdbc:hsqldb:…/data/test</serverURL>

<username>sa</username>

<password>test</password>

<testSQL>select 1</testSQL>

<testBeforeUse>true</testBeforeUse>

<testAfterUse>true</testAfterUse>

<minConnections>5</minConnections>

<maxConnections>15</maxConnections>

<connectionTimeout>1.0</connectionTimeout>

</defaultProvider>

</database>

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.

2

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.