Hello friends, I am having trouble running my first project that I created as directed from the openmrs docs. I have the runtime properties files pesent with the right configurations but somehow when i run the sdk it gives me back the message of unable to find a runtime properties file. My problem is similar to this Database connection problems with SDK however the discussion was suddenly cut short and i cant find a solution there in.my errors are posted here https://pastebin.com/wbBnCRsg Any help rendered would be so great…
Can you confirm that MySQL is running with a database named server3?
take a look at your run time properties file.
#Auto generated by OpenMRS initialization wizard
#Tue Mar 05 15:01:15 EAT 2019
encryption.vector=4EjE8q/78ntmOJzwEdyGpA\=\=
connection.url=jdbc\:mysql\://localhost\:3306/**db-name**?autoReconnect\=true&sessionVariables\=default_storage_engine%3DInnoDB&useUnicode\=true&characterEncoding\=UTF-8
module.allow_web_admin=true
connection.username=**user**
auto_update_database=false
encryption.key=KijkSt2Apx1nDJHpJ3nw/A\=\=
connection.driver_class=com.mysql.jdbc.Driver
connection.password= **password**
- Ensure your MySQL is installed and running.
- By default the SDK created a DB as your server name, in your case its server3
- Ensure in your run time properties file you have the right user (root by default) and coresponding password coresponding to what you set in MySQL
1 Like
How do i confirm this?
check your mySQL database either via UI or commandline depending on how you installed it.
i dont have such a db in my system…
with in the server setting I have the runtime properties file as shown below.
#Auto generated by OpenMRS initialization wizard
#Thu May 02 04:53:58 EAT 2019
encryption.vector=AP4t3ZHMn4B7STIdfSI6BQ\=\=
connection.url=jdbc\:mysql\://localhost\:3306/server3?autoReconnect\=true&sessionVariables\=default_storage_engine%3DInnoDB&useUnicode\=true&characterEncoding\=UTF-8
module.allow_web_admin=true
connection.username=root
auto_update_database=false
encryption.key=hM+g/Tabab9wY2/q3llmgQ\=\=
connection.driver_class=com.mysql.jdbc.Driver
connection.password=hassh
``whic db name is set in your runtime properites file? inside your sdk server3 folder??
According to my runtime properties I think its server3…I seem to get it(I dont have the db in the system)…Should I manually create it then?
how were you able to generate that file? That file is Auto generated by the sdk.
This line mean the SDK created a database with name server3.
you seem to have made a change in your MySQL or probably you just copiedand psted that file.
ok try changing
connection.url=jdbc:mysql://localhost:3306/server3
to
connection.url=jdbc:mysql://localhost:3306/openmrs
and see if it works. because thats the only openmrs database i see in your MySQL. and put in the right credentails ie user and password as what you set in your MySQL
I used the sdk to create the database…during this time…Failed to connect to specified database while setting up sever
ok . but then your MySQL cant reflect it? . probably you have different Mysql databases installed, if thats possible anyway.
1 Like
Let me try to set a new server all over again…This mix up might be because am using different directories for the servers and also my project…When i copy the runtime properties file into the project folder…it is able to connect however now the issue is the database…ill keep you posted on the success if i record any…otherwise thanks…
3 Likes
i have been succeful with a new set up of the server…Thanks everyone. the db has been set up
1 Like
Hello, My db is running. Openmrs also running. But I couldn’t find runtime properties. Also, where I put modules( . omod ) files? I searched appdata folder. But nothing found.
Could you please give me the steps you took to solve this problem. I have the same issue but I have the correct DB in the runtime properties file.
