Hey all-
The admin password on continuum (which was setup way long back by some person who no longer works) is lost and I tried creating a new one using sha1 hash and inserting into derby table. But for some obvious reason it is still not allowing me get in. Unfortunately I have only admin and guest users. I tried changing the guest user's goup id to 1 but this dosent work either. Let me knowif you have any thoughts.. I am clearly missing somthing here.. here are the steps that I followed - 1. Shutdown continuum. 2. create a new SHA-1 password eg echo 'admin' | openssl dgst -sha1 ;;;;; 8e30cefbe06caad8cfc8c5c15a6595d31aadd9fc 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 export DERBY_HOME=/opt/Apache/db-derby-10.3.1.4-bin 5. Execute the Embedded Classpath setup eg db-derby-10.2.2.0-bin/bin/setEmbeddedCP /opt/Apache/db-derby-10.3.1.4-bin/bin/setEmbeddedCP 6. Start up ij eg db-derby-10.2.2.0-bin/bin/ij /opt/Apache/db-derby-10.3.1.4-bin/bin/ij 7. At the ij prompt connect to your continnum databse eg connect 'jdbc:derby:/Users/ieb/continuum/apps/continuum/database'; connect 'jdbc:derby:/insp/continuum-1.0.3/apps/continuum/database'; 8. select * from SA.CONTINUUMUSER; |GROUP_ID_O&|&|HASHED_PASSWORD |MODEL_ENCODING |USERNAME ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 |NULL |Anonymous User |2 |Y|NULL |UTF-8 |guest 2 xxxx |Continuum Administrator |1 |N|da39a3ee5e6b4b0d3255bfef95601890afd80709 |UTF-8 |admin 9. UPDATE SA.CONTINUUMUSER set HASHED_PASSWORD = '4015bc9ee91e437d90df83fb64fbbe312d9c9f05' where ACCOUNT_ID = 1; 10. commit; 11. exit;
