Forum Discussion
bswetman
12 years agoOccasional Contributor
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.
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.
Related Content
- 5 months ago
- 3 years ago
- 3 years ago
- 12 months ago
Recent Discussions
- 2 months ago