Thank you so much! This was the solution to my handshake error, and I now have OpenMRS deployed and configured with a properly launched database! @herbert24 thank you for your help as well!
2 Likes
Much like Tara, i had similar issues while deploying test modules. I followed the same steps you outlined and was successfully able to connect to the database. However, when i open http://localhost:8081/openmrs/, i get the following error. https://pasteboard.co/JAPRc9T.png Not sure how to proceed.
Sorry! your error cannot be reflected. Kindly use pastebin.com/ to share the error logs.
https://pastebin.com/mEDyYi2x Here is the log of warnings and errors i get in the terminal when i go to http://localhost:8081/openmrs/ My MySQL version is: 14.14 Distrib 5.6.49, for Linux (x86_64) My OpenMRS Core version is: 2.3.2 My Java JDK is: 1.8.0_275
I downgraded the mysql to mysql 5.7 but still getting the error says " WARN - InitializationFilter.executeStatement(1179) |2023-02-16T07:50:51,036| 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.30.jar:8.0.30]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_202]
at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_202]
at org.openmrs.web.filter.initialization.InitializationFilter.executeStatement(InitializationFilter.java:1163) ~[classes/:?]
at org.openmrs.web.filter.initialization.InitializationFilter.access$300(InitializationFilter.java:80) ~[classes/:?]
at org.openmrs.web.filter.initialization.InitializationFilter$InitializationCompletion$1.run(InitializationFilter.java:1393) ~[classes/:?]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_202]
Caused by: com.mysql.cj.exceptions.CJException: Access denied for user ârootâ@âlocalhostâ (using password: NO)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_202]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_202]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_202]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_202]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:848) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:770) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:738) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:155) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:472) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:212) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1433) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.30.jar:8.0.30]
⊠10 more
The error youâre getting is:
That probably means that you need to fill in the password for the MySQL root user (determined when you set MySQL up) in the appropriate step.
PS Recent versions of OpenMRS support MySQL 8, so you shouldnât need to downgrade.
Itâs worked for me on windows by deleting the directory C:\Users\user-name\AppData\Roaming\OpenMRS and then start installaton
1 Like
There was an error while updating the database to the latest. file: liquibase-demo-data.xml. Error: liquibase.exception.LiquibaseException: Unable to execute change set: liquibase-schema-only.xml::1226412230538-11::ben (generated) See the error log for more details
please, can someone help here ?
It helps to share the server side log. You can share it via a paste site like pastebin.com
I have just committed the fix. Update your code by pulling the latest upstream changes, compile and then run again.
Hey @ibacher, I am getting this error while setting up openmrs-core repository.
.
I am having
Ubuntu - 22.04
MySQL - 8.0.35
Java - 11.0.21
Please guide me on how to solve this.
Can you share the server side log via pastebin.com?