error with the openmrs installation wizard, can't connection to the database

1

am using manual installation appraoch Setting Up mysql 5.7, tomcat 8, java 8, maven 3 all running yet i have no clue to my issue, here is a paste bin link error installation wizard openmrs - Pastebin.com

Capture
Capture1354×408 29.3 KB

2

Is this able to get in little light of prerequisites:

Unable to find a runtime properties file

1 Like
3

i have edited the question above, it seems what you cited was different approach, if not elaborate

4

@kamajo It seems the issue is with the server database connection. The distribution requires a MySQL database. Please specify database uri (-DdbUri) (default: 'jdbc:mysql://localhost:3306/@DBNAME@'):

Please specify database username (-DdbUser) (default: 'root'):

Hope you didnt specify dbname - You have to just press enter for default values to apply same for username.

5

@suubi7 here is a step by step of how I was installing

  1. git clone GitHub - openmrs/openmrs-core: OpenMRS API and web application code
  2. cd openmrs-core
  3. mvn clean install
  4. cd webapp
  5. mvn jetty:run
  6. http://localhost:8080/openmrs/initialsetup

I didn’t specify any distribution

6

well, from the error log, its db user permissions, so, actually I wanted you to know the root password for the install, because that’s necessary to setup OpenMRS.

maybe more informative would be the wizard options you selected

cc @ibacher @dkayiwa

7

@thembo42 I used a first option, simple installation

8

are you able to login into mysql using the root password?

9

yes, am also using the same password

10

I also faced this problem before and I opted to use the SDK installation as an alternative. cc @dkayiwa @ibacher

Could you try using the SDK instead of jetty server installation. Follow along with this https://openmrs.atlassian.net/wiki/spaces/docs/pages/25476136/OpenMRS+SDK

Run mvn org.openmrs.maven.plugins:openmrs-sdk-maven-plugin:setup-sdk If this installation is successful run mvn openmrs-sdk:setup to setup your distribution.

Then if all goes well run mvn openmrs-sdk:run this should put up your server running.

1 Like
11

okay let me use that approach

12

if you are using a docker container for MySQL, it’s preferable to create the database and database user beforehand(running the OpenMRS installer). You can name them as the default installation would have (database: openmrs, user: openmrs_user). Then grant privileges with a statement like:

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'%' IDENTIFIED BY 'password';

be sure to choose the Advanced option

1 Like
13

cool!

I hope this is a known issue !

14

@thembo42 not sure about that, since the sdk installation worked for I just somehow didnt try Jetty again.

1 Like