Confluence 5.1 HSQLDB access problems

[Dave Donnelly [Sensata]]

I did a massively stupid thing in adding a LDAP authenticated user dir above the internal directory and have now lost all my admin rights.

I need to get into the HSQLDB in order to run a few queries in order to restore admin privileges but I'm running into a problem.

Getting the following error when connecting to the DB as per the instructions here:

10:25:58 [FATAL pool-4-thread-2 ENGINE.logSevereEvent] could not reopen database
org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@e92ea377[file =C:\Program Files\Atlassian\Application Data\Confluence\database\confluencedb.properties.lck, exists=false, locked=false, valid=false, ] method: openRAF reason: java.io.FileNotFoundException: C:\Program Files\Atlassian\Application Data\Confluence\database\confluencedb.properties.lck (Access is denied)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
at org.hsqldb.persist.Logger.openPersistence(Unknown Source)
at org.hsqldb.Database.reopen(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
at org.hsqldb.DatabaseManager.newSession(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
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 com.onseven.dbvis.g.B.D.?(Z:1413)
at com.onseven.dbvis.g.B.F$A.call(Z:1474)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Anyone have any ideas? I am not experienced in accessing or manipulating databases so you may need to draw diagrams for me using crayons... ;)

Thanks a million,

Dave

[Dave Donnelly [Sensata] · Accepted solution]

Got it. I needed to run the Datavisualizer as admin. Sorted now.

[BernardoA]

Hi Dave,

You can use Dbvisualizer tool to access you database, here explains how:

https://confluence.atlassian.com/display/DOC/Connecting+to+HSQLDB+using+DBVisualizer