Openmrs is not able to start

22

Oh thnx man, i had forgotten… i re-extracted the reference application files from the Zip folder and re-run the java file

1 Like
23

okie.That java file is called the jar file (java archive)

2 Likes
24

Am facing this challenge on an sdk instance. I have restarted the database several times but no success though its not a new server. When I check my openmrs runtime properties the username to the root is okay. Kindly how can I solve this?

25

A few things to check:

  1. Does the OpenMRS database you are trying to connect to exist? I.e., the url should be something like: jdbc:mysql://localhost:3306/openmrs?.... In this case, do you have a database called openmrs on that MySQL server?

  2. Does the database server you are trying to connect to run on port 3306 (this is the default) or another port? The docker container setup by the SDK defaults to port 3308 iirc. You can verify this by looking at the connection settings for whatever tool you use to connect to the database or by looking at the main my.cnf file for your MySQL server.

  3. Is your MySQL instance configured to accept network connections? Some out-of-the-box MySQL configurations turn off networking by default, only allowing connections via sockets. Unfortunately, the MySQL Java driver only connects via the network. To check this, open your main my.cnf file and look to ensure there isn’t a setting called skip-networking or that it’s commented out and that there is a setting called bind-address that is set to 127.0.0.1.

Sorry for the wall of text, but hopefully that can help you at least identify the issue.

1 Like
26

Thanks for the feedback. Am not setting a new server instead am running a server which has been working pretty for the past 2 years and its my first time to get such an error after starting a ProtocolHandler “http-bio-8080”

27

Do you know how you installed MySQL, i.e., are you running the Docker version or did you install a version of MySQL 5.6 on your local machine?

1 Like
28

I installed the MySQL 5.6 following the steps provided on this link https://wiki.openmrs.org/display/docs/OpenMRS+SDK#OpenMRSSDK-Settingupservers

29

hei,@jwnasambu are you able to run now?