The original post above applies to Collaborator v.8003 or earlier, running with our embedded database HSQL v.1.8.
For Collaborator v.8100 or later, running with our embedded database HSQL v.2.0:
1) Shut down the Collaborator server.
2) Open up a command prompt.
3) CD into their Collaborator Server directory.
4) Run: java -cp tomcat/lib/hsqldb.jar org.hsqldb.util.DatabaseManagerSwing
That starts up a utility for viewing/editing the HSQL database.
5) Open the database with these options:
Type: HSQL Database Engine Standalone
Driver: org.hsqldb.jdbcDriver [default]
URL: jdbc:hsqldb:file:tomcat/database
User: SA [default]
Password: [leave this blank, which is the default]
6) Copy/paste the following query into the big text box at the top-right:
UPDATE user SET user_password='d41d8cd98f00b204e9800998ecf8427e' WHERE user_login='admin';
You might want to change "admin" to whatever your username is.
7) Click the "Execute SQL" button.
You should see a result with the column header "update count" and the value "1". (i.e.: 1 record was updated.)
8) Close the HSQL Database Manager.
9) Restart Collaborator and log in.
