Never mind - I figured this out. Here are the steps I needed to follow:
1. Install Derby db from http://db.apache.org/derby/derby_downloads.html 2. Set DERBY_HOME like: export DERBY_HOME=~/derby/db- derby-10.2.2.0-bin/ 3. set classpath like this: export CLASSPATH=$DERBY_HOME/lib/derby.jar:$DERBY_HOME/lib/derbytools.jar 4. Then run ij to start the derby database, like this: ~/derby/db- derby-10.2.2.0-bin/bin/ij 5. I got the ij> prompt. 6. Ensure that continuum is shut down. I use kill <pid of continuum.> 7. At the ij> prompt, start the db, like this: connect 'jdbc:derby:/usr/local/continuum-1.0.3/apps/continuum/database'; 8. ij> connect 'jdbc:derby:/usr/local/continuum-1.0.3 /apps/continuum/database'; ij> select * from sa.continuumuser; 9. Next modify the data using a simple sql, like this: ij> describe sa.continuumuser; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ ACCOUNT_ID |INTEGER |0 |10 |10 |NULL |NULL |NO EMAIL |VARCHAR |NULL|NULL|255 |NULL |510 |YES FULL_NAME |VARCHAR |NULL|NULL|255 |NULL |510 |YES GROUP_ID_OID |INTEGER |0 |10 |10 |NULL |NULL |YES GUEST |CHAR |NULL|NULL|1 |NULL |2 |NO HASHED_PASSWORD |VARCHAR |NULL|NULL|255 |NULL |510 |YES MODEL_ENCODING |VARCHAR |NULL|NULL|255 |NULL |510 |YES USERNAME |VARCHAR |NULL|NULL|255 |NULL |510 |YES 8 rows selected ij> UPDATE SA.CONTINUUMUSER set GROUP_ID_OID=1 where ACCOUNT_ID = 6; 1 row inserted/updated/deleted ij> commit; ij> exit; Thanks, Anoop On 1/29/07, Anoop kumar V <[EMAIL PROTECTED]> wrote:
I have lost the password to the only continuum admin. But I do have a lot of other users. Instead of going through sha1 password hashing etc, I think I can just change one of the existing users role to build admin and use that to reset the admin's password. How do I do that? I know I can log into the derby db as sa.. but dont know how to log in to derby. Thanks. -- Thanks and best regards, Anoop
-- Thanks and best regards, Anoop
