please mail [EMAIL PROTECTED] instead.
Thanks,
Brett
On 22/09/2007, at 10:11 AM, Vamshi Yamsani wrote:
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;
--
Brett Porter - [EMAIL PROTECTED]
Blog: http://www.devzuz.org/blogs/bporter/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
