Hi Rajib, You can download the 1.9 RC standalone. Unzip and copy the standalone-1.1.1.jar file over to your 1.8.3 unzipped folder. That jar file will have the needed kill.exe
On Sat, Mar 24, 2012 at 6:57 AM, Rajib Sengupta <[email protected]> wrote: > 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<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > > > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list -- If we keep uppermost in our minds the unkind and unjust acts of others, we shall find it impossible to love them as Christ has loved us; but if our thoughts dwell upon the wondrous love and pity of Christ for us, the same spirit will flow out to others. _________________________________________ 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]
