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