Question about errors seen on install

Implementing
1

Hi Everybody,

I’m new to OpenMRS and I’m trying to set up an instance using the war file downloads from Download – OpenMRS.org. I’ve tried both the 2.5.0 and the 2.12 war files and I’m getting the same error:

Caused by: com.mysql.cj.exceptions.CJException: Access denied for user ‘openmrs_user’@‘localhost’ (using password: YES)

This is also in the stack trace: WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2145) |2023-07-17T20:39:01,558| Unable to find a runtime properties file at D:_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64_OPEN_MRS\apache-tomcat-8.5.85\bin\openmrs-runtime.properties

Any help on how to resolve this issue would be greatly appreciated.

Thanks, John

Full stack trace: 17-Jul-2023 20:38:22.694 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 22229 ms WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2145) |2023-07-17T20:39:01,558| Unable to find a runtime properties file at D:_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64_OPEN_MRS\apache-tomcat-8.5.85\bin\openmrs-runtime.properties WARN - InitializationFilter.executeStatement(1185) |2023-07-17T20:39:44,462| error executing sql: create database if not exists ? default character set utf8 java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.21.jar:8.0.21] at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_261] at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_261] at org.openmrs.web.filter.initialization.InitializationFilter.executeStatement(InitializationFilter.java:1169) [openmrs-web-2.4.3.jar:?] at org.openmrs.web.filter.initialization.InitializationFilter.access$300(InitializationFilter.java:80) [openmrs-web-2.4.3.jar:?] at org.openmrs.web.filter.initialization.InitializationFilter$InitializationCompletion$1.run(InitializationFilter.java:1399) [openmrs-web-2.4.3.jar:?] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_261] Caused by: com.mysql.cj.exceptions.CJException: Access denied for user ‘openmrs_user’@‘localhost’ (using password: YES) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_261] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_261] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_261] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_261] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:786) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:711) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:679) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:128) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:466) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:171) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1342) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:850) ~[mysql-connector-java-8.0.21.jar:8.0.21] … 10 more WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2145) |2023-07-17T20:40:06,609| Unable to find a runtime properties file at D:_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64_OPEN_MRS\apache-tomcat-8.5.85\bin\openmrs-runtime.properties WARN - InitializationFilter.executeStatement(1185) |2023-07-17T20:40:36,767| error executing sql: create database if not exists ? default character set utf8 java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.21.jar:8.0.21] at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_261] at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_261] at org.openmrs.web.filter.initialization.InitializationFilter.executeStatement(InitializationFilter.java:1169) [openmrs-web-2.4.3.jar:?] at org.openmrs.web.filter.initialization.InitializationFilter.access$300(InitializationFilter.java:80) [openmrs-web-2.4.3.jar:?] at org.openmrs.web.filter.initialization.InitializationFilter$InitializationCompletion$1.run(InitializationFilter.java:1399) [openmrs-web-2.4.3.jar:?] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_261] Caused by: com.mysql.cj.exceptions.CJException: Access denied for user ‘openmrs_user’@‘localhost’ (using password: YES) at sun.reflect.GeneratedConstructorAccessor56.newInstance(Unknown Source) ~[?:?] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_261] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_261] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:786) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:711) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:679) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:128) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:466) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:171) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1342) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:850) ~[mysql-connector-java-8.0.21.jar:8.0.21] … 10 more WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2145) |2023-07-17T20:49:50,940| Unable to find a runtime properties file at D:_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64_OPEN_MRS\apache-tomcat-8.5.85\bin\openmrs-runtime.properties

2

It looks like the root cause of this was due to files in C:\Users<my-user-name>\Application Data\OpenMRS left behind from an earlier installation attempt. I deleted these files and the installation completed.

However, now when I launch localhost:8080/openmrs/ it navigates to /openmrs/owa/addonmanager/index.html#/ and gives me an error “You cannot view or manage the Add Ons since you don’t have the privileges and you are not an admin.” How do I give my admin account admin privileges?

Also, I’m not familiar with the owa and omod architecture. How do I deploy the omod and owa modules in the zip file downloaded using the “Download Reference Application” link () on Download – OpenMRS.org?

3

I was able to get the downloads for “Reference Application 2.12 - Advanced Installation” at Download – OpenMRS.org to fully install by renaming the openmrs.war file to openmrs.zip, unzipinng, and then adding the omod files to ./openmrs/WEB-INF/bundledModules and the sysadmin.owa file to the ./openmrs/WEB-INF/bundledOwas folder and then putting the openmrs folder in the Tomcat webapps folder.

4

I found the documentation I was looking for in the OpenMRS wiki: https://wiki.openmrs.org/display/docs/Developer+Guide