Hi Bernd Theses are my notes from when I fixed my password:
Continuum - Database The password for my user on Continuum was not working. So I need a way to change it! Copied the Continuum database folder: /usr/local/bin/continuum-1.0.3/apps/continuum/database To a temp folder on my Windows workstation: C:\temp\continuum\database\ Downloaded SQuirreL SQL from http://squirrel-sql.sourceforge.net/. Selected Modify Driver for Apache Derby Embedded and added the Derby jar files, derby.jar and derbyclient.jar to the Extra Class Path tab. Created a new continuum entry in the Aliases window. These are the properties: Name: continuum Driver: Apache Derby Embedded URL: jdbc:derby:c:/temp/continuum/database UserName: sa In Linux the URL is: jdbc:derby:/usr/local/bin/continuum-1.0.3/apps/continuum/database I can now connect to the database... Change Password I used HashCalc from http://www.slavasoft.com/hashcalc/overview.htm to hash a new password. Use the following SQL statements to display all the users then update the selected user with a new password: SELECT ACCOUNT_ID,EMAIL,FULL_NAME,GROUP_ID_OID,GUEST,HASHED_PASSWORD,MODEL_ENCODING,USERNAME FROM CONTINUUMUSER; UPDATE CONTINUUMUSER SET HASHED_PASSWORD = 'f10dd37094e36e1093b16de1ae7b5d51ed6a7d33' WHERE USERNAME = 'patrick'; Make sure you shut down all connections to this database before re-starting Continuum. Pat On 27/06/06, Bernhard Wellhöfer <[EMAIL PROTECTED]> wrote:
Hello, do you have a hint how I can fix my continuum installation? Right now my admin user is "dead"... Cheers, Bernd -----Ursprüngliche Nachricht----- Von: Emmanuel Venisse [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 27. Juni 2006 11:12 An: [email protected] Betreff: Re: AW: Continuum admin password problem Thanks. Emmanuel Bernhard Wellhöfer a écrit : > Hello, > > I filed http://jira.codehaus.org/browse/CONTINUUM-736 for this issue. > > Cheers, > > Bernd > > -----Ursprüngliche Nachricht----- > Von: Bernhard Wellhöfer [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 26. Juni 2006 11:28 > An: [email protected] > Betreff: Continuum admin password problem > > Hello, > > I changed in the user management section the real name for the continuum admin user. The form where I added the real name also presented the password field. Here the password field was empty - nevertheless the admin user had a password. After entering the new real name for admin and after hitting "submit" the real named changed - but the password also changed. I did not enter anything in the password text field ... > > So is the new password now blank? If yes I have a serious problem, > since the login page does not allow an empty password. So how do I > reset the admin password to a known value? [This is the first time I > work with derby. So how do I e.g. open the database with a SQL editor > to change the password directly in the DB?] > > Do you agree that this should be filed as a bug? > > Cheers, > > Bernd > > >
