I have inherited a TeamCity installation on version 3.0 and can no longer access the database on startup:
I get a 404: error in the browser. This just started happening. There were no changes made to the system other than adding some new users
In the stdout log I see the error that it can not create the bean with name 'buildserver'
I feel that there is an issue with the HSQLDB and I wanted to migrate it to MySQL (this is the only other supported DB i believe on this version)
I have tried to use the migrateToMySQL.bat utility but then I receive the error
Wed Jan 18 19:29:14 EST 2012 .BuildServer path: C:\Utils\.BuildServer
Wed Jan 18 19:29:14 EST 2012 Connecting to the source database jdbc:hsqldb:file:
Exception in thread "main" java.sql.SQLException: User not found: SA
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
An error has occured during migration. Could not proceed.
Any thoughts why it can't access the HSQLDB? Why SA is not found?
I did notice the buildserver.data file was exactly 64MB (65,536 KB). That did seem odd almost as if the DB max'd out at 64MB and it was Full. I don't much about HSQLDB....
Thanks for any tips