2.1.7 HSQLDB install fails

[Migrated From Jforum.net]

The first install I've done installed 2.1.7 on my Windows box with MySQL was no problem (with the "redirect" fix).

Then I tried a fresh installation with HSQLDB , including "redirect" fix plus the HSQLDB jars. Unfortunately it ends up with an
"java.sql.SQLException: User not found: " error.

The tomcat log has an exception

java.io.FileNotFoundException: C:\javagroups.properties (The system cannot find the file specified) ...

more here:

21:47:08,250  INFO [InstallAction       ] Updating key database.connection.dbname with value tluk
21:47:08,250  INFO [InstallAction       ] Updating key database.support.autokeys with value false
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.host with value localhost
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.pool.min with value 1
21:47:08,250  INFO [InstallAction       ] Updating key database.support.subqueries with value true
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.pool.timeout with value 2000
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.port with value 
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.username with value sa
21:47:08,250  INFO [InstallAction       ] Updating key dbencoding with value utf-8
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.string with value jdbc:hsqldb:${config.dir}/database/hsqldb/${database.connection.dbname}
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.pool.max with value 5
21:47:08,250  INFO [InstallAction       ] Updating key dao.driver with value net.jforum.dao.hsqldb.HsqldbDataAccessDriver
21:47:08,250  INFO [InstallAction       ] Updating key database.connection.driver with value org.hsqldb.jdbcDriver
21:47:08,265  INFO [FileMonitor         ] Watching C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\jforumderby/WEB-INF/config/jforum-custom.conf
21:47:08,265  INFO [FileMonitor         ] Watching C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\jforumderby/WEB-INF/config/jforum-custom.conf
Trace.init() java.io.FileNotFoundException: C:\javagroups.properties (The system cannot find the file specified)[Database(): group="null"
props="null"
java.sql.SQLException: User not found: 
	at org.hsqldb.Trace.getError(Unknown Source)
	at org.hsqldb.Trace.error(Unknown Source)
	at org.hsqldb.UserManager.get(Unknown Source)
	at org.hsqldb.UserManager.getUser(Unknown Source)
	at org.hsqldb.Database.connect(Database.java:522)
	at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
	at org.hsqldb.jdbcConnection.<init>(Unknown Source)
	at org.hsqldb.jdbcDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at net.jforum.SimpleConnection.getConnection(SimpleConnection.java:93)
	at net.jforum.SimpleConnection.init(SimpleConnection.java:74)
	at net.jforum.view.install.InstallAction.configureDatabase(InstallAction.java:590)
	at net.jforum.view.install.InstallAction.doInstall(InstallAction.java:153)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at net.jforum.Command.process(Command.java:117)
	at net.jforum.view.install.InstallAction.process(InstallAction.java:764)
	at net.jforum.InstallServlet.service(InstallServlet.java:140)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
21:47:08,453  WARN [InstallAction       ] Error while trying to get a connection: net.jforum.exceptions.DatabaseException: java.sql.SQLException: User not found: 

Does anyone know what I missed? I dont have to create the HSQLDB beforehand, do I?

Thanks, Lukas
[originally posted on jforum.net by lukas]