SDK: ???Unable to connect to database???

[ndacyayisenga (TAYEBWA NOAH)]

am currently running ubuntu 20.4, Server version: 5.7.34 MySQL, I have selected to run a Distribution having **Reference application 2.11.0, mysql server is up running but i would like to know why am really landing into this error of my database not connecting… the error log can be found ndacyayisenga@ndacyayisenga-OptiPlex-3010:~$ mvn openmrs-sdk:run[INFO] Scannin - Pastebin.com

cc @jwnasambu @reagan @dkayiwa @sharif @mozzy

[piumal1999 (Piumal Rathnayake)]

Hi @ndacyayisenga , I hope this thread will help you:

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

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-pl…

[herbert24 (Herbert Yiga)]

are you able to login to your database via terminal? @ndacyayisenga

[ndacyayisenga (TAYEBWA NOAH)]

yes @herbert24 but all in vain

[jwnasambu (Juliet Wamalwa)]

Kindly you can also share the error logs on the terminals using pastebin.

[ibacher (Ian Bacher)]

What is the output of mvn -v?

[ndacyayisenga (TAYEBWA NOAH)]

@ibacher

What is the output of mvn -v ?

Apache Maven 3.6.3 Maven home: /usr/share/maven Java version: 1.8.0_292, vendor: Private Build, runtime: /usr/lib/jvm/java-8-openjdk-amd64/jre Default locale: en_US, platform encoding: UTF-8 OS name: “linux”, version: “5.4.0-26-generic”, arch: “amd64”, family: "unix @ibacher

[ndacyayisenga (TAYEBWA NOAH)]

@jwnasambu

Kindly you can also share the error logs on the terminals using pastebin.

@jwnasambu

ndacyayisenga@ndacyayisenga-OptiPlex-3010:~$ mvn openmrs-sdk:run[INFO] Scannin - Pastebin.com

[ibacher (Ian Bacher)]

The issue you are having seems to be the same as the one in this StackOverflow post and the fix is probably the same, i.e., add &enabledTLSProtocols=TLSv1.2 to the end of your JDBC connection string.

To change the JDBC connection string, go to ~/openmrs/myserver, open the file openmrs-runtime.properties in a text editor. Find the line that starts connection.url= and add &enabledTLSProtocols\=TLSv1.2 to the end of the connection string.

[ndacyayisenga (TAYEBWA NOAH)]

@ibacher

The issue you are having seems to be the same as the one in this StackOverflow post and the fix is probably the same, i.e., add &enabledTLSProtocols=TLSv1.2 to the end of your JDBC connection string.

To change the JDBC connection string, go to ~/openmrs/myserver , open the file openmrs-runtime.properties in a text editor. Find the line that starts connection.url= and add &enabledTLSProtocols\=TLSv1.2 to the end of the connection string.

Thanks @ibacher this works fine… Thankyou

[atiq (Mohd Atique)]

Hi @ibacher followed the steps but not able to connect with database .

[ndacyayisenga (TAYEBWA NOAH)]

Hey @atiq what are the logs saying?

[atiq (Mohd Atique)]

Thanks @ndacyayisenga for response. Its giving me java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)

[jwnasambu (Juliet Wamalwa)]

@atiq

‘root’@‘localhost’ (using password: YES)

Is YES your mysql root password?

[atiq (Mohd Atique)]

Yes its set to root

[ndacyayisenga (TAYEBWA NOAH)]

@atiq

Thanks @ndacyayisenga for response. Its giving me java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)

Are you able to access you mysql in the terminal. I mean something like this

ndacyayisenga@ndacyayisenga-OptiPlex-3010:~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 156
Server version: 5.7.34 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[atiq (Mohd Atique)]

Yes I can access my sql through terminal as well.

[ndacyayisenga (TAYEBWA NOAH)]

@atiq

I am using 5.7.32

At what exact point does this fail… When you input password for mysql or it fails in the browser?

[atiq (Mohd Atique)]

I am using 5.7.32

[ndacyayisenga (TAYEBWA NOAH)]

@ibacher

To change the JDBC connection string, go to ~/openmrs/myserver , open the file openmrs-runtime.properties in a text editor. Find the line that starts connection.url= and add &enabledTLSProtocols\=TLSv1.2 to the end of the connection string.

@atiq did you take a look at that