How do I install the MySql connector driver jar?

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
Comment actions Permalink

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).
0
Comment actions Permalink

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

0

Please sign in to leave a comment.