Hello All,
The error reappeared. Please anyone with the solution.
Thanks,
Rajib
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:578)
at
org.openmrs.util.DatabaseUpdater.updatesRequired(DatabaseUpdater.java:257)
at org.openmrs.web.Listener.setupNeeded(Listener.java:170)
at org.openmrs.web.Listener.contextInitialized(Listener.java:142)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.startup.Embedded.start(Embedded.java:825)
at org.openmrs.standalone.TomcatManager.run(TomcatManager.java:73)
at
org.openmrs.standalone.ApplicationController.startServer(ApplicationController.java:378)
at
org.openmrs.standalone.ApplicationController.access$000(ApplicationController.java:29)
at
org.openmrs.standalone.ApplicationController$1.construct(ApplicationController.java:126)
at org.openmrs.standalone.SwingWorker$2.run(SwingWorker.java:125)
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:337)
at
org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:564)
...
16 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:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)
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:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.openmrs.util.DatabaseUpdater.getConnection(DatabaseUpdater.java:394)
at
org.openmrs.util.DatabaseUpdater.getLiquibase(DatabaseUpdater.java:334)
... 17 more
Caused by: java.util.MissingResourceException: Resource 'kill.exe' not found
at
com.mysql.management.util.Streams.getResourceAsStream(Streams.java:124)
at
com.mysql.management.util.Streams.getResourceAsStream(Streams.java:108)
at com.mysql.management.util.Streams$1.inner(Streams.java:140)
at
com.mysql.management.util.Exceptions$VoidBlock.exec(Exceptions.java:129)
at
com.mysql.management.util.Streams.createFileFromResource(Streams.java:153)
at
com.mysql.management.util.ProcessUtil.getWindowsKillFile(ProcessUtil.java:71)
at com.mysql.management.util.ProcessUtil.(ProcessUtil.java:60)
at
com.mysql.management.MysqldResource.processRunning(MysqldResource.java:421)
at
com.mysql.management.MysqldResource.isRunning(MysqldResource.java:414)
at
com.mysql.management.driverlaunched.ServerLauncherSocketFactory.ensureMysqlStarted(ServerLauncherSocketFactory.java:118)
at
com.mysql.management.driverlaunched.ServerLauncherSocketFactory.connect(ServerLauncherSocketFactory.java:72)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:290)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
... 30 more
See the server log for full output.
________________________________
From: Rajib Sengupta <[email protected]>
To: [email protected]
Sent: Friday, March 23, 2012 12:56 AM
Subject: Re: [OPENMRS-DEV] [OPENMRS-IMPLEMENTERS] Problem starting up the
standalone instance
Hello All,
It seems my standlaone database might have been corrupted due to the kill.exe
problem in windows 7
https://tickets.openmrs.org/browse/STAND-42
https://tickets.openmrs.org/browse/STAND-40
I have deleted my earlier install, unzipped the 1.8.3 standlone again. Now it
is running fine without any error.
But, I am sure, sooner or later the db will get corrupted due to the kill.exe
not found issue. Whenever I am stopping the server I am getting this error of
"cannot stop MySQLResource kill.exe" not found.
I read the following temporary fix in one of the above ticket - "A temporary
fix which does not require you to re-download the standalone would be to put
kill.exe in the c-mxj-utils folder which is already in your unzipped standalone
folder."
But, I haven't been able to find that kill.exe file anywhere in the unzipped
folder. Please let me know what will be the solution of this without doing a
fresh download and install. (I will prefer to stay with 1.8.3 as that is the
same version used in our server)
Due to connectivity with the server, I am planning to build the concepts, forms
in my standalone box and then will later import it to the server.
I don't want to build the concepts, form and then if for any chance it gets
corrupted, I need to start all over again.
Thanks,
Rajib
www.missionarogya.org
________________________________
From: Rajib Sengupta <[email protected]>
To: [email protected]
Sent: Thursday, March 22, 2012 11:29 PM
Subject: [OPENMRS-IMPLEMENTERS] Problem starting up the standalone instance
Hello All,
I have installed the standalone openmrs in my laptop (windows 7, 64bit) by
following the install
https://wiki.openmrs.org/display/docs/OpenMRS+Standalone
When I executed the standalone-1.1.1.jar file , I have been able to get to the
userid/password page of openmrs
But then when I tried it again, I am getting the following error :
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:578)
My runtime.properties file is as following:#Last updated by the OpenMRS
Standalone application.
#Tue Mar 20 23:31:35 EDT 2012
reset_connection_password=false
tomcatport=8081
connection.url=jdbc:mysql:mxj://127.0.0.1:3316/openmrs?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8&server.initialize-user=true&createDatabaseIfNotExist=true&server.basedir=database&server.datadir=database/data&server.collation-server=utf8_general_ci&server.character-set-server=utf8&server.max_allowed_packet=32M
module.allow_web_admin=true
connection.username=openmrs
auto_update_database=false
application_data_directory=appdata
connection.password=test
====================
Log
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:578)
at
org.openmrs.util.DatabaseUpdater.updatesRequired(DatabaseUpdater.java:257)
at org.openmrs.web.Listener.setupNeeded(Listener.java:170)
at org.openmrs.web.Listener.contextInitialized(Listener.java:142)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.startup.Embedded.start(Embedded.java:825)
at org.openmrs.standalone.TomcatManager.run(TomcatManager.java:73)
at
org.openmrs.standalone.ApplicationController.startServer(ApplicationController.java:378)
at
org.openmrs.standalone.ApplicationController.access$000(ApplicationController.java:29)
at
org.openmrs.standalone.ApplicationController$1.construct(ApplicationController.java:126)
at org.openmrs.standalone.SwingWorker$2.run(SwingWorker.java:125)
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:337)
at
org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:564)
...
16 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:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
at com.mysql.jdbc.ConnectionImpl. (ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection. (JDBC4Connection.java:46)
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:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.openmrs.util.DatabaseUpdater.getConnection(DatabaseUpdater.java:394)
at
org.openmrs.util.DatabaseUpdater.getLiquibase(DatabaseUpdater.java:334)
... 17 more
Caused by: java.util.MissingResourceException: Resource 'kill.exe' not found
at
com.mysql.management.util.Streams.getResourceAsStream(Streams.java:124)
at
com.mysql.management.util.Streams.getResourceAsStream(Streams.java:108)
at com.mysql.management.util.Streams$1.inner(Streams.java:140)
at
com.mysql.management.util.Exceptions$VoidBlock.exec(Exceptions.java:129)
at
com.mysql.management.util.Streams.createFileFromResource(Streams.java:153)
at
com.mysql.management.util.ProcessUtil.getWindowsKillFile(ProcessUtil.java:71)
at com.mysql.management.util.ProcessUtil. (ProcessUtil.java:60)
at
com.mysql.management.MysqldResource.processRunning(MysqldResource.java:421)
at
com.mysql.management.MysqldResource.isRunning(MysqldResource.java:414)
at
com.mysql.management.driverlaunched.ServerLauncherSocketFactory.ensureMysqlStarted(ServerLauncherSocketFactory.java:118)
at
com.mysql.management.driverlaunched.ServerLauncherSocketFactory.connect(ServerLauncherSocketFactory.java:72)
at com.mysql.jdbc.MysqlIO. (MysqlIO.java:290)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
... 30 more
See the server log for full output.
________________________________
Click here to unsubscribe from OpenMRS Implementers' mailing list
________________________________
Click here to unsubscribe from OpenMRS Developers' mailing list
_________________________________________
To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to
[email protected] with "SIGNOFF openmrs-devel-l" in the body (not
the subject) of your e-mail.
[mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
