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?
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.
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");
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...
>
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
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...
>
>
>
>
Attachment(s):
changepass.zip
That worked very nicely. Thank you, Pavel.
Donald
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
Please take a look at this document: http://www.jetbrains.net/confluence/display/TCD3/Changinguserpasswordwithdefaultauthenticationscheme
--
Pavel Sher
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