Failing to install Standalone Ref Application [SOLVED]

Development
1

Hello friends, Have encountered an exception while installing Standalone Reference Application 2.9.0. Have recognized the problem may be concerned with database configuration in
openmrs-standalone-runtime.properties but could not understand what to do exactly. Here is a pastebin link https://pastebin.com/7CMiKTLS

2

@kdaud try re-extracting again and run the standalone afresh

3

@gcliff Have tried it several times but the same exception is thrown. Even when I tried standalone ref application 2.2.0, it throws similar error

4

Do u have the mysql instance running on your pc when u start your standalone?

5

@kdaud what is the name of your database?

6

which java are you running apparently?

7

@kdaud There might be two things that could cause the issue you’re facing. 1. Your openmrs-standalone-runtime.properties is missing certain vital parameters that establish a connection to the db. 2. Your Java version installed, i will suggest you paste your openmrs-standalone-runtime.properties via pastebing.com and as well share your java version output.

ggomez

8

Am sorry for reply delay. Had been fixed up with College Exams.
cc: @gcliff, @herbert24, @jwnasambu, @ggomez

9

@herbert24, java -version gives
java version “1.8.0_221” Java™ SE Runtime Environment (build 1.8.0_221-b11) Java HotSpot™ 64-Bit Server VM (build 25.221-b11, mixed mode)
While javac -version gives
javac 1.8.0_221

10

@jwnasambu, I have openmrs though am thinking this database is the one created when installing openmrs sdk

11

@gcliff, I have no mysql instance running apparently during standalone installation.

12

@ggomez, Here is the openmrs-standalone-runtime.properties pastebin link and the Java version link is here

13

If you don’t mind try using the db username as openmrs and password as test then share the output.

14

@jwnasambu As per openmrs-standalone-runtime.properties configuration file, the db connection.username=openmrs and connection.password=test.Here is the link to the file output

15

Is your MySQL instance truly running on port 3316? The default is 3306.

16

@sjmckee Mysql instance is not running

17

I thought of changing the port number of Mysql but it didn’t work out.
cc: @gcliff @jwnasambu @sjmckee @ggomez @herbert24 @samuel34 @sharif @ruhanga @rushikesh @reubenv

18

@kdaud may be lets try re-downloading standalone 2.9.0 and if it generates the same error again then u can also try running standalone 2.8.0

19

Let me do it and see

20

@gcliff On the download page https://openmrs.org/download/, I can only see two version 2.9.0 and 2.2.0. The standalone 2.8.0 am unable to see it.