Reset Password

Is there any way to reset a user password if none of the users can remember theirs? Without deleting all of the data and starting from scratch?

Donald

7 comments
Comment actions Permalink

Hello Donald,

What database do you use? HSQL (which is default) or MySQL?

--
Pavel Sher

"Donald McLean" <dmclean@stsci.edu> wrote in message
news:7161593.1170963341265.JavaMail.itn@is.intellij.net...

Is there any way to reset a user password if none of the users can
remember theirs? Without deleting all of the data and starting from
scratch?

>

Donald



0
Comment actions Permalink

Well, if HSQL is the default, then I'm using HSQL since I didn't even know that we had a choice.

We're running 1.1.2, if that makes a difference.

Just out of curiosity, is Derby a choice for the database?

Thank you,

Donald

0
Comment actions Permalink

Hello,

I've attached a zip file to this message. There you will find a simple
utility that can change password of any user. To use it you should first
shutdown TeamCity server. Then unpack zip archive and copy hsqldb.jar file
to the resulting folder (you will find this jar in the webapps/WEB-INF/lib
directory of the server).

After that type the following command (for windows):
java -cp .;hsqldb.jar ChangePassword for unix: java -cp .:hsqldb.jar ChangePassword Note that if you are using non default place for TeamCity configuration files you should provide it as third parameter. If all is done correctly then you should see message: Password changed successfuly As for supported databases: TeamCity currently supports HSQLDB and MySQL only. -- Pavel Sher "Donald McLean" ]]> wrote in message
news:7526972.1171027614731.JavaMail.itn@is.intellij.net...

Well, if HSQL is the default, then I'm using HSQL since I didn't even know
that we had a choice.

>

We're running 1.1.2, if that makes a difference.

>

Just out of curiosity, is Derby a choice for the database?

>

Thank you,

>

Donald






Attachment(s):
changepass.zip
0
Comment actions Permalink

That worked very nicely. Thank you, Pavel.

Donald

0
Comment actions Permalink

It seems I need this same solution for version 3.1.1, I continued using the same user/pass then it just stopped accepting that. I guess I must of changed something. I need to get back in the system as admin. The zip file that was attached in the previous post doesn't work with 3.1.1.

Regards,
Wiley

0
Comment actions Permalink

Please take a look at this document: http://www.jetbrains.net/confluence/display/TCD3/Changinguserpasswordwithdefaultauthenticationscheme

--
Pavel Sher

0
Comment actions Permalink

For TeamCity v. 3.1.1 change
PreparedStatement st = connection.prepareStatement("UPDATE user SET PASSWORD = ? WHERE USERNAME = ? AND REALM IS NULL");
to
PreparedStatement st = connection.prepareStatement("UPDATE users SET PASSWORD = ? WHERE USERNAME = ? AND REALM IS NULL");



Attachment(s):
ChangePassword.java
0

Please sign in to leave a comment.