openmrs installation errors using xampp

Hello, I have this errors when I install openmrs using xampp. This erros occurs with the Tomcat xampp server. Can anyone please help me?

OpenMRS is not able to start.

The following error occurred at startup:

Error occurred while trying to get the updates needed for the database. Unable to get a connection to the database. Please check your openmrs runtime properties file and make sure you have the correct connection.username and connection.password set

java.lang.RuntimeException: Error occurred while trying to get the updates needed for the database. Unable to get a connection to the database. Please check your openmrs runtime properties file and make sure you have the correct connection.username and connection.password set at org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:627) at org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:583) at org.openmrs.util.DatabaseUpdater.updatesRequired(DatabaseUpdater.java:249) at org.openmrs.web.Listener.setupNeeded(Listener.java:222) at org.openmrs.web.Listener.contextInitialized(Listener.java:180) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5197) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5720) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1016) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:992) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:639) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2020) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.Exception: Unable to get a connection to the database. Please check your openmrs runtime properties file and make sure you have the correct connection.username and connection.password set at org.openmrs.util.DatabaseUpdater.getLiquibase(DatabaseUpdater.java:358) at org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:612) … 17 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2395) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2316) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:834) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.openmrs.util.DatabaseUpdater.getConnection(DatabaseUpdater.java:420) at org.openmrs.util.DatabaseUpdater.getLiquibase(DatabaseUpdater.java:355) … 18 more Caused by: java.sql.SQLException: Access denied for user ‘openmrs_user’@‘localhost’ (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1750) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2493) at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2334) … 32 more

See the server log for full output.

Hello @cher , can you please paste your error log in pastebin ??

However , you seem to have pointed your installation to a wrong database connection that is a wrong username/password , or probably your MySQL instance wasnt running

I am redoing it now and make sure mysql is running and connected. However I am still getting this Server Output Details errors:

OpenMRS Core 2.2.0 Installation Wizard Tasks completed so far: Created database openmrs Created user openmrs_user Granted user openmrs_user all privileges to database openmrs Created database tables and added core data

Installation is currently in progress…

Tasks to execute Create database 100% Create database user 100% Create OpenMRS tables 100% Add OpenMRS core data 100% Add OpenMRS demo data 50% Update the database

Hide output details

OpenMRS demo patients, users, and forms (22/46): Author: ben (generated) Comments: null Description: Insert Row (x833)

Number of actions completed so far: 453

Server log file output: WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2080) |2020-01-19 09:53:42,744| Unable to find a runtime properties file at c:\xampp\openmrs-runtime.properties WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2108) |2020-01-19 09:53:42,746| Unable to find properties file: C:\Users\pocc\Application Data\OpenMRS\openmrs-runtime.properties WARN - InitializationFilter.executeStatement(1184) |2020-01-19 09:54:28,067| error executing sql: create database if not exists ? default character set utf8 WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2080) |2020-01-19 10:26:20,403| Unable to find a runtime properties file at c:\xampp\openmrs-runtime.properties WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2108) |2020-01-19 10:26:20,405| Unable to find properties file: C:\Users\pocc\Application Data\OpenMRS\openmrs-runtime.properties

First, thank you for responding @mozzy.

I am redoing it now and make sure mysql is running and connected. However I am still getting this Server Output Details errors:

OpenMRS Core 2.2.0 Installation Wizard Tasks completed so far: Created database openmrs Created user openmrs_user Granted user openmrs_user all privileges to database openmrs Created database tables and added core data

Installation is currently in progress…

Tasks to execute Create database 100% Create database user 100% Create OpenMRS tables 100% Add OpenMRS core data 100% Add OpenMRS demo data 50% Update the database

Hide output details

OpenMRS demo patients, users, and forms (22/46): Author: ben (generated) Comments: null Description: Insert Row (x833)

Number of actions completed so far: 453

Server log file output: WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2080) |2020-01-19 09:53:42,744| Unable to find a runtime properties file at c:\xampp\openmrs-runtime.properties WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2108) |2020-01-19 09:53:42,746| Unable to find properties file: C:\Users\pocc\Application Data\OpenMRS\openmrs-runtime.properties WARN - InitializationFilter.executeStatement(1184) |2020-01-19 09:54:28,067| error executing sql: create database if not exists ? default character set utf8 WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2080) |2020-01-19 10:26:20,403| Unable to find a runtime properties file at c:\xampp\openmrs-runtime.properties WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2108) |2020-01-19 10:26:20,405| Unable to find properties file: C:\Users\pocc\Application Data\OpenMRS\openmrs-runtime.properties