Locked out of TeamCity
So I had two TeamCity logins and oddly enough I find myself locked out of both accounts.
I googled and found this approach .. http://confluence.jetbrains.net/display/TCD5/Changing+user+password+with+default+authentication+scheme
..which I followed precisely, but it returns an error about the table not existing.
C:\TeamCity\webapps\ROOT\WEB-INF\lib>..\..\..\..\jre\bin\java.exe -cp server.jar;common-api.jar;commons-codec-1.3.jar;util.jar;hsqldb.jar ChangePassword jason Passw0rd1 C:\Users\bruno\.BuildServer
Using TeamCity configuration directory path: C:/Users/bruno/.BuildServer
Exception in thread "main" java.sql.SQLException: Table not found in statement [
UPDATE users SET PASSWORD = ? WHERE USERNAME = ? AND REALM IS NULL]
at org.hsqldb.jdbc.Util.throwError(Util.java:58)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(jdbcPreparedStatement.java:1833)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(jdbcConnection.java:580)
at ChangePassword.main(ChangePassword.java:17)
So what is that all about? Very frustrating !.!
Please sign in to leave a comment.