continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anoop kumar V" <anoopkum...@gmail.com>
Subject Re: Change a user role to build admin
Date Mon, 29 Jan 2007 17:43:52 GMT
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 <anoopkumarv@gmail.com> 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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message