Resetting Continuum passwords

26 01 2007

The only place I could find info on resetting a Continuum password, was as a patch in Codehaus JIRA.

http://jira.codehaus.org/secure/attachment/23421/CONTINUUM-956.patch

In short, Passwords are stored as SHA-1 hashes in the SA.CONTINUUMUSER table.

So

1. Shutdown continuum. 2. create a new SHA-1 password eg echo ‘mypassword’ | openssl dgst -sha1 3. Download a copy of Apache Derby 4. DERBY_HOME to this location eg export DERBY_HOME=/Users/ieb/db-derby-10.2.2.0-bin 5. Execute the Embedded Classpath setup eg db-derby-10.2.2.0-bin/bin/setEmbeddedCP 6. Start up ij eg db-derby-10.2.2.0-bin/bin/ij 7. At the ij prompt connect to your continnum databse eg connect ‘jdbc:derby:/Users/ieb/continuum/apps/continuum/database’; 8. select * from SA.CONTINUUMUSER; 9. UPDATE SA.CONTINUUMUSER set HASH_PASSWORD = ‘the sha1 from step 2’ where ACCOUNT_ID = 6;

You will need to check the steps in 8 and 9 for syntax and schema names. ACCOUNT_ID = 6 represents the account where the password is being reset.

10. commit; 11. exit;

Then restart continuum and login with ‘mypassword’ or whatever you used in step 2.

If that fails… you may have to drop the DB and restart.

To avoid this…. always have 2 admin users… then if one fails you can always use the other one to reset things.

Advertisements

Actions

Information




%d bloggers like this: