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 _________________________________________ 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]
