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]> 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 > *<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<[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 Residence : + 94 91 2241603 Email : [email protected] [email protected] Website : www.lakmedi.com www.familygene.org _________________________________________ 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]
