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.