???Unable to connect to database??????

1

Hi everyone I am new to openMrs. I have been trying to install openMrs by using OpenMRS SDK for many days because i want to start contributing and i have been facing many issues and I have been reading many answers but no answer has helped me to solve my issue. I have followed the instructions in the SDK development installation and every thing has worked well until the last stage. problem description. First step: I install SDK by using command ‘mvn org.openmrs.maven.plugins:openmrs-sdk-maven-plugin:setup-sdk’. and it worked fine. Second step: I set up the server by using command ‘mvn openmrs-sdk:setup’ and it worked fine

1
1813×392 11.8 KB
Third step: I run the server using command ‘mvn openmrs-sdk:run’ and it worked fine.
2
2931×405 18.1 KB
Fourth step: The problem occurs here when i open http://localhost:8091/openmrs/ in a browser. it is saying ???Unable to connect to database???.
3
31920×1080 148 KB
error details:
4
41896×473 57.6 KB

2

Are you able to connect to your database, with the same account, using any other client?

3

@bahagt on top of @dkayiwa 's question, which MySQL version are you running?

4

@dkayiwa I am very sorry but i don’t fully understand your question because maybe it is my first time to interact with database

5

@herbert24 I am using MySQl 8.0

6

I also had the same issue when reinstalling openmrs sdk. It worked fine with the Reference Application 2.12.0 - SNAPSHOT version of the distribution. But the Unable to connect to database error occurred when running the older versions. (I am using mysql 8.0)

1 Like
7

For MySQL 8 you need to select platform 2.4 and above or reference application 2.12.0-SNAPSHOT

1 Like
9

@bahagt the above comment from @dkayiwa should get you moving :point_up:

1 Like
10

@dkayiwa @piumal1999 @herbert24. I don’t know how to thank you all. Thank you very much. I have spent alot of time on this issue without any progress but you solved it in a day. Thank you very much and i appreciate your time and efforts

11

@dkayiwa Aside from this issue. I wan to start contributing. I know java, object oriented programming, data strucutres and algorithms, and sql. My question is. Should i spent some time learning hibernate and spring and then start contributing or it is better to start now. I want to contribute to the core

12

By the way how you solved this database connectivity issue? @bahagt

13

I have followed Daniel Kayiwa advice which is ( For MySQL 8 you need to select platform 2.4 and above or reference application 2.12.0-SNAPSHOT )