OpenMRS Standalone not working

Ask OpenMRS
1

Application Name: Reference Application Version Number: referenceapplication-standalone-2.11.0

Question:

I’m trying to run the standalone openMRS application but I’m getting the following error in the screenshot. I’ve seen multiple people run into the same issue and I’ve read through the forums but I haven’t been able to get it to work.

I was initially trying to get the SDK to work, but I was running into the exact same issue. I then decided to try running the standalone application to try further isolate the issue, and the problem still persists… even though the standalone version uses its’ own mysql and tomcat built into the application.

Any ideas what I can do to fix this?

image
image1702×1027 99 KB

2

Oh sorry! kindly ensure you are using java 8 since Reference Application 2.11 is build on OpenMRS Platform version 2.3.2 which runs on java 8.

3

Hi Juliet!

I am using v8.54 and I have attached a screenshot for confirmation.

image

4

kindly ensure

  • You can connect to you DB with your Credentials ?
  • Also ensure MySQL instance is started at the time of running your server ?

just a reminder the Mysql you are supposed to run is 5.6

5

For the standalone application, doesn’t it come with its own mysql packaged with it?

6

Kindly ensure MySQL 5.6 or 5.7 is running locally.

7

I installed MySQL 5.7 when I was initially trying to get the SDK working, and that is currently running locally on port 3306.

Is it supposed to use that connection? I see that it’s configured to connect to port 3316 for the standalone application.

8

Juliet and I had a debugging session but I’m still getting errors. We focused on trying to get the SDK to work instead of the standalone application.

We found out that my maven was using the wrong java version, so I fixed it so that it points to version 8.x but I still have the problem. I’ve attached a pastebin of the terminal output as well as a screenshot from the output details:

  1. at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4901) at com.my - Pastebin.com

image
image1433×363 33.6 KB

I’ve also confirmed that the openmrs-runtime.properties file exists within the openmrs folder and that it contains the correct DB information

9

Take a look at this:

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html

10

Oh yes following the instructions from the stack overflow got it working!

Thank you! :slight_smile:

1 Like