Thx! -----Ursprüngliche Nachricht----- Von: Patrick Kimber [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 27. Juni 2006 11:23 An: [email protected] Betreff: Re: AW: Continuum admin password problem
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 > > > > > > > > > > >
