Issues with creating platform server with SDK and MySql 5.7

Application Name: I’m to create an instance of a platform server using the SDK instructions at https://wiki.openmrs.org/display/docs/OpenMRS+SDK#OpenMRSSDK-Installation

Version Number: According to the URL above, this is 3.5.0 (released on 2016/11/29)

Question: When I use the mvn command “mvn openmrs-sdk:setup” everything goes well with the database connection. Here’s is a transcript of what I see:


Which database would you like to use?:

  1. H2
  2. MySQL 5.6 (requires pre-installed MySQL 5.6)
  3. MySQL 5.6 in SDK docker container (requires pre-installed Docker)
  4. Existing docker container (requires pre-installed Docker)

Which one do you choose? [1/2/3/4]: 2

The distribution requires MySQL database. Please specify database uri (-DdbUri) (default: ‘jdbc:mysql://localhost:3306/@DBNAME@’):

Please specify database username (-DdbUser) (default: ‘root’): Please specify database password (-DdbPassword) (default: ’ '):

Connected to the database.

Importing an initial database from classpath://openmrs-platform.sql…


But then when I actually start the server with the command

mvn clean install openmrs-sdk:run -DserverId=my_test_server

the error.log shows that the DB connection fails:


WARN - InitializationFilter.verifyConnection(1000) |2016-12-25 16:16:49,983| Error while checking the connection user account com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.


I am using MySql 5.7 instead of 5.6. Will a server created with the SDK mvn task work with MySql 5.7? Or is this problem due to something else?

Thanks Tom Naps

Most versions of OpenMRS do not run on MySQL 5.7. Please see https://issues.openmrs.org/browse/TRUNK-4813.

The issue was fixed for platform 2.0.1 and the master branch.