You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@continuum.apache.org by Bernhard Wellhöfer <Be...@gaia-group.com> on 2006/06/26 11:28:09 UTC
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
AW: AW: Continuum admin password problem
Posted by Bernhard Wellhöfer <Be...@gaia-group.com>.
Thx!
-----Ursprüngliche Nachricht-----
Von: Patrick Kimber [mailto:mailing.patrick.kimber@gmail.com]
Gesendet: Dienstag, 27. Juni 2006 11:23
An: continuum-users@maven.apache.org
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 <Be...@gaia-group.com> 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:emmanuel@venisse.net]
> Gesendet: Dienstag, 27. Juni 2006 11:12
> An: continuum-users@maven.apache.org
> 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:Bernhard.Wellhoefer@gaia-group.com]
> > Gesendet: Montag, 26. Juni 2006 11:28
> > An: continuum-users@maven.apache.org
> > 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
> >
> >
> >
>
>
>
>
>
Re: AW: Continuum admin password problem
Posted by Patrick Kimber <ma...@gmail.com>.
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 <Be...@gaia-group.com> 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:emmanuel@venisse.net]
> Gesendet: Dienstag, 27. Juni 2006 11:12
> An: continuum-users@maven.apache.org
> 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:Bernhard.Wellhoefer@gaia-group.com]
> > Gesendet: Montag, 26. Juni 2006 11:28
> > An: continuum-users@maven.apache.org
> > 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
> >
> >
> >
>
>
>
>
>
AW: AW: Continuum admin password problem
Posted by Bernhard Wellhöfer <Be...@gaia-group.com>.
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:emmanuel@venisse.net]
Gesendet: Dienstag, 27. Juni 2006 11:12
An: continuum-users@maven.apache.org
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:Bernhard.Wellhoefer@gaia-group.com]
> Gesendet: Montag, 26. Juni 2006 11:28
> An: continuum-users@maven.apache.org
> 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
>
>
>
Re: AW: Continuum admin password problem
Posted by Emmanuel Venisse <em...@venisse.net>.
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:Bernhard.Wellhoefer@gaia-group.com]
> Gesendet: Montag, 26. Juni 2006 11:28
> An: continuum-users@maven.apache.org
> 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
>
>
>
AW: Continuum admin password problem
Posted by Bernhard Wellhöfer <Be...@gaia-group.com>.
Hello,
I filed http://jira.codehaus.org/browse/CONTINUUM-736 for this issue.
Cheers,
Bernd
-----Ursprüngliche Nachricht-----
Von: Bernhard Wellhöfer [mailto:Bernhard.Wellhoefer@gaia-group.com]
Gesendet: Montag, 26. Juni 2006 11:28
An: continuum-users@maven.apache.org
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