How do I install the MySql connector driver jar?

Permanently deleted user

Created December 19, 2011 19:03

I am very new to TC.Java isn't a strong suit either.

I am migrating from the distribution to MySql database. The instructions say to download the jar archive (no problem) and then, quote:

Install MySQL connector driver jar (mysql-connector-java-*-bin.jar from the downloaded archive).

The install link does nothing. How and where do I install this driver?

Thanks,

Len

2 comments

Yegor Yarko

Created December 19, 2011 20:57

Install is a link to the section in the same page:

Due to licensing terms, TeamCity does not bundle driver jars for external databases. You will need to download the Java driver and put the appropriate jars from it (see specific databases instructions below) into<TeamCity Data Directory>/lib/jdbc directory (create it if necessary).

Permanently deleted user

Created December 19, 2011 21:10

Thank you! I was able to do that.

Now I have another issue. I ran the maintainDB.cmd file and it appears it worked like a champ with new tables being created, even moving the properties.dist file to the database properties file:

        index build_subst_root_index
Finishing
Restoring finished successfully
Changing default database connection in TeamCity configuration:
Copying target database properties file
        from:   C:\Users\sys_buildmml\.BuildServer\config\database.mysql.propert
ies.dist
        to:     c:\Users\sys_buildmml\.BuildServer\config\database.properties
Done.

However when I restart the server I get this error:

An error was encountered during TeamCity server startup

Unexpected exception SQLException: SQL error when doing: Connecting to MySQL SQL exception: Access denied for user 'sys_buildmml'@'buildmml.amr.corp.intel.com' (using password: NO)

UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Connecting to MySQL
SQL exception: Access denied for user 'sys_buildmml'@'buildmml.amr.corp.intel.com' (using password: NO)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)
   at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)
UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Connecting to MySQL
.

But the same configuration file is being used! I don't get it.

Thanks again,

Len

Please sign in to leave a comment.