[Play 1.2.x] SSL mysql jdbc connection

[James]

Hi all,

Just wondering if anyone can point me to the right direction for setting up a SSL connection from the Play deployment to MySql database server. I am currently on Play 1.2.7.

My application.conf setting is as below:

db.url=jdbc:mysql://url/databasename?characterEncoding=UTF-8&useSSL=true&requireSSL=true

db.driver=com.mysql.jdbc.Driver

db.user=mydbusername

db.pass=mydbpassword

jpa.dialect=org.hibernate.dialect.MySQL5Dialect

Currently I am getting this error:

Database error

A database error occured : Cannot connected to the database, SSL Connection required, but not supported by server.

play.exceptions.DatabaseException: Cannot connected to the database, SSL Connection required, but not supported by server.

at play.db.DBPlugin.onApplicationStart(DBPlugin.java:161)

at play.plugins.PluginCollection.onApplicationStart(PluginCollection.java:525)

at play.Play.start(Play.java:533)

at play.Play.detectChanges(Play.java:637)

at play.Invoker$Invocation.init(Invoker.java:198)

at Invocation.HTTP Request(Play!)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: SSL Connection required, but not supported by server.

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1246)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2395)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2428)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2213)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at play.db.DBPlugin.onApplicationStart(DBPlugin.java:109)

... 5 more

Thank you :)

Cheers,

James

[Andrew Lira]

I experienced the same error connecting to my database using Python.

[hans]

James,

I don't know, but the message is very clear in saying that the problem has to do with server configuration, maybe key generation in server side or my.cnf parameters.
Try using mysql command line with --ssl flag  to test if ssl is working outside play framework.

I guess that you tested connections without ssl...

Bye,
Hans