No suitable driver found for jdbc:hsqldb:file:/var/lib/rundeck/data/grailsdb;shutdown=true

[Rolands Mekšs]

Hi,I'm struggling with installing 1.5RC2. I have installed rundeck 1.5RC2 with rpms on RHEL6 (with openjdk1.6). I'm starting rundeck but all I'm getting is

Caused by: java.sql.SQLException: No suitable driver found for jdbc:hsqldb:file:/var/lib/rundeck/data/grailsdb;shutdown=true
        at java.sql.DriverManager.getConnection(DriverManager.java:640)
        at java.sql.DriverManager.getConnection(DriverManager.java:169)
        at $Proxy7.getMetaData(Unknown Source)

I have downloaded hsqldb.jar and put in every possible location (/var/rundeck/cli/ /var/rundeck/server/lib, /etc/rundeck/server/lib), but no luck.
And if hsqldb is default storage, shouldn't library be already included? Otherwise software doesn't work out of the box...

Do you have a clue what could be wrong?

[Moses Lei]

How are you starting rundeck-- with init script? With what privileges? Can you check if there were any problems with the rpm post inst (e.g. Creating rundeck user etc)?

Best of luck,

Moses Lei

[Greg Schueler]

Hi Rolands,

The default driver changed to h2 for 1.5, but I think the config files used by rpm install were not yet updated.

Can you change the rundeck-config.properties file to use h2 dataSource.url like this, and try it again:

dataSource.url = jdbc:h2:file:/var/lib/rundeck/data/rundeckdb

I will file this as a bug 

[Rolands Mekšs]

Hi, Greg!

Thanks! That did the trick!

[Fares Akram]

Hi Greg,

Thank's, it worked perfectly!