Oh thnx man, i had forgotten… i re-extracted the reference application files from the Zip folder and re-run the java file
okie.That java file is called the jar file (java archive)
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?
A few things to check:
-
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 calledopenmrs
on that MySQL server? -
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. -
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 calledskip-networking
or that it’s commented out and that there is a setting calledbind-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.
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”
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?
I installed the MySQL 5.6 following the steps provided on this link https://wiki.openmrs.org/display/docs/OpenMRS+SDK#OpenMRSSDK-Settingupservers
hei,@jwnasambu are you able to run now?