Question:
I am having trouble setting up openmrs-sdk 2.13.0 with MySQL installation.
While starting ‘openmrs-sdk-mysql-v3-2’ DB docker container, I am getting this build failure message:
[ERROR] Failed to execute goal org.openmrs.maven.plugins:openmrs-sdk-maven-plugin:5.2.0:setup (default-cli) on project standalone-pom: Failed to setup server: Failed to connect to the specified database jdbc:mysql://localhost:3308/openmrs-dev?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&sessionVariables=default_storage_engine%3DInnoDB: No suitable driver found for jdbc:mysql://localhost:3308/
I am wondering if the port is supposed to be 3308 or 3306 instead!
Oh sorry! The error message you provided indicates that the Maven build process failed to set up an OpenMRS server due to a database connection issue. Specifically, it’s failing to find a suitable driver for the MySQL database connection. You can try out the following to fix the issue:
Check Database URL: Make sure the database URL in your OpenMRS configuration is correct. The URL should be in the format jdbc:mysql://localhost:3308/openmrs-dev .
Port and Connection: Double-check that your MySQL server is running on localhost at port 3308 , and that the openmrs-dev database is present. If not, adjust the URL and port accordingly.
Verify that your database configuration in OpenMRS settings is correct. Check the openmrs-runtime.properties or similar configuration file for the correct database URL, username, and password.
Make sure the MySQL server is up and running on the specified port (3308 in your case). If it’s not, start the MySQL server.
lastly, Ensure that there are no firewall restrictions or security settings preventing the connection to the database.