Thanks, Buddhika! Though my problem differed from yours, your answer lead me to the solution. Searching for the openmrs-runtime.properties file revealed that there was still application data left over from a previous installation. Deleting it solved the problem. When installed in Tomcat, the application data is stored in C:\Application Data\OpenMRS\, when installed in Jetty during software development, it is stored in C:\Users\<Username>\Application Data\OpenMRS\.
Von: [email protected] [mailto:[email protected]] Im Auftrag von Buddhika Ariyaratne Gesendet: Donnerstag, 29. Dezember 2011 15:43 An: [email protected] Betreff: Re: [OPENMRS-IMPLEMENTERS] Not able to start. Unable to get connection to database. Please check this link of my problem and the solution given. https://answers.openmrs.org/questions/49/error-at-start-up-unable-to-get-a-connection-to-the-database On 29 December 2011 20:10, Buddhika Ariyaratne <[email protected]<mailto:[email protected]>> wrote: I also had the same problem when I tried to run it on Windows 7. The login details of the mySQL database is stated in the openmrsruntime.properties file. When the details are wrong, the database can not be accessed and that gave me the very same error. I searched for the file and changed the username and the password and saved the file, It worked next time. Again I had the same problem, then I checked the file, the details were correct, still I had the same error. So I check openmrsruntime.properties files else where and there was another one in another location. I change it to the correct username and password of mySQL, and then started working again. The full solution for my problem was answered in this mailing list and I will try to find it and post it here for the details. Now I am not using windows 7 to run the openMRS because this kept on happening. On 29 December 2011 19:32, Marco Eckstein <[email protected]<mailto:[email protected]>> wrote: After installing the WAR file to Tomcat and navigating to /openmrs, I get the following error "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" Followed by a stacktrace that includes the lines "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" "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" "Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up." "Caused by: java.sql.SQLException: Access denied for user 'openmrs_user'@'localhost' (using password: YES)" I have read the information in https://wiki.openmrs.org/display/docs/Troubleshooting+Installation#TroubleshootingInstallation-WarfiledeploysinTomcatbutitwon%27tstartOpenMRS, but the given SQL does not work. The MySQL console keeps prompting for new lines, and the MySQL workbench reports a syntax error. MySQL server 5.5 is running. Reloading OpenMRS does not help. What am I supposed to do? ----- Server Information Tomcat Version JVM Version JVM Vendor OS Name OS Version OS Architecture Apache Tomcat/6.0.29 1.7.0_02-b13 Oracle Corporation Windows 7 6.1 amd64 ________________________________ Click here to unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list -- Dr. M. H. B. Ariyaratne MBBS(Ruhuna) Medical Officer, Ministry of Health. Trainee - MSc(Biomedical Informatics) Postgraduate Institute of Medicine, No 160, Norris Canal Road, Colombo, Sri Lanka. Residence 36/A, Thalgahahena Lane, Galle, Sri Lanka. Mobile : + 94 71 5812399<tel:%2B%2094%2071%205812399> Residence : + 94 91 2241603<tel:%2B%2094%2091%202241603> Email : [email protected]<mailto:[email protected]> [email protected]<mailto:[email protected]> Website : www.lakmedi.com<http://www.lakmedi.com> www.familygene.org<http://www.familygene.org> -- Dr. M. H. B. Ariyaratne MBBS(Ruhuna) Medical Officer, Ministry of Health. Trainee - MSc(Biomedical Informatics) Postgraduate Institute of Medicine, No 160, Norris Canal Road, Colombo, Sri Lanka. Residence 36/A, Thalgahahena Lane, Galle, Sri Lanka. Mobile : + 94 71 5812399 Residence : + 94 91 2241603 Email : [email protected]<mailto:[email protected]> [email protected]<mailto:[email protected]> Website : www.lakmedi.com<http://www.lakmedi.com> www.familygene.org<http://www.familygene.org> ________________________________ Click here to unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
