OpenMRS 2.0.6 Enterprise Installation Challenge - Need Help!

ggomez · May 15, 2019, 11:59am

The given database driver class was not found. Please ensure that the database driver jar file is on the class path (like in the webapps lib folder)

How do I resolve this challenge?

OpenMRS 2.0.6 | MySQL 5.7 | OS Ubuntu 18.04 LTS

.Thanks in advance

mozzy · May 15, 2019, 12:11pm

@ggomez Do you have MySQL 5.7 installed and running??

can you also share deatiled server logs here ??

ggomez · May 15, 2019, 12:17pm

See server logs https://pastebin.com/L4a4yE4Y

mozzy · May 15, 2019, 12:20pm

seeing this error Access denied for user 'root'@'localhost'

do you have A password set for your MySQL root user in your MySQL database??

ggomez · May 15, 2019, 12:34pm

Yes i have a password but it works via terminal. See logs again here https://pastebin.com/JtcFbDLn

ssmusoke · May 15, 2019, 5:56pm

Create a different user e.g., openmrs with a password and use that instead of root

ggomez · May 17, 2019, 9:51pm

Thank you @ssmusoke I create a different user with a password and grant privileges, but the message still persists

(The given database driver class was not found. Please ensure that the database driver jar file is on the class path (like in the webapps lib folder)

dkayiwa · May 18, 2019, 6:09pm

Can you paste the current server side log at pastebin.com?

ggomez · May 21, 2019, 11:58pm

RESOLVED!

Thank you @mozzy @ssmusoke @dkayiwa for your support. I finally purged the MySQL server 5.7 and reinstall same 5.7, then ran the entire setup process all over again. Also, create the db and grant permission to the openmrs_user manually and it worked. Surprisingly, the server was finding it difficult to store the root password.