Hi Nadeeshani, If you delete the openmrs-runtime.properties file, when you start the application you should be directed to the configuration page, which allows you to set up a new database etc. Anytime you want to return to the configuration setup, just delete the openmrs-runtime.properites file and restart the app.
Hope that helps, Lara ________________________________________ From: [email protected] [[email protected]] On Behalf Of Nadeeshani Hewage [[email protected]] Sent: Monday, March 19, 2012 4:42 PM To: [email protected] Subject: Re: [OPENMRS-DEV] Error on Startup Hi Harsha, Thanks for the reference :) I tried it. Following is my tomcat/logs/catalina.out Mar 19, 2012 6:13:04 AM org.apache.catalina.startup.HostConfig deployWAR INFO: Deploying web application archive openmrs.war WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2438) |2012-03-19 06:13:07,161| Unable to find a runtime properties file at /usr/share/tomcat6/apache-tomcat-6.0.35/bin/openmrs-runtime.properties ERROR - Listener.contextInitialized(168) |2012-03-19 06:13:11,665| Got exception while starting up: 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:627) at org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:586) at org.openmrs.util.DatabaseUpdater.updatesRequired(DatabaseUpdater.java:257) at org.openmrs.web.Listener.setupNeeded(Listener.java:184) at org.openmrs.web.Listener.contextInitialized(Listener.java:145) So I created a new openmrs-runtime.properties file on the place that the log specifies, with contents as stated. But the point is, to set "connection.url=jdbc:mysql://localhost:3306/openmrs?autoReconnect=true" , I should have a database named openmrs. The mysql query to show databases tell me that there is no such database. How do I create it back? Any opinion to overcome this issue is much appreciated. And thanks Wyclif and Anurudda. But I have deleted all the openmrs folders on tomcat, and even tried a new tomcat installation. No luck. Regards Nadeeshani On Mon, Mar 19, 2012 at 6:47 PM, Harsha Siriwardena <[email protected]<mailto:[email protected]>> wrote: Hi Nadeeshani Akki, Here's the simple solution<http://www.harshadura.net/2012/01/solved-open-mrs-webapp-build-problem.html> to prevent your exact problem which I was faced earlier too. I have blogged the solution for my own reference. :) hope this helps! Regards, Harsha On Mon, Mar 19, 2012 at 12:24 PM, Nadeeshani Hewage <[email protected]<mailto:[email protected]>> wrote: Hi devs, I'm a final year undergraduate from University of Moratuwa, Sri Lanka and a would-be applicant for GSoC this year. I have tried playing around with the web-app and code, but I'm facing some issues in deploying the .war that I built from source. Following are the steps I followed. Environment: Unix (Linux Mint) Steps: 1. Successfully checked out and built the complete trunk, avoiding tests. 2. Deployed the openmrs.war (from webapp/target) on Tomcat6 with Tomcat Manager, and war is on the running state. 3. On the very first time I tried this, it asked for my mysql credentials, created a database, and I selected the option to proceed without using demo data, just to play around hoping I could get the same screen back. Hard luck. Couldn't login with 'admin' and 'test' credentials on login screen. 4. On mysql prompt, i could see openmrs database. And with the commands mysql> USE openmrs mysql> select * from openmrs.users where username="admin"; I got an empty result. 5. Hence hoping to redo the process all-new with demodata, I dropped the database, deleted ~/.OpenMRS, 'rm -r' ed openmrs and the war from Tomcat's webapp folder, and redeployed the war. This time it ends giving following error at start up. Error: 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:627) at org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:586) at org.openmrs.util.DatabaseUpdater.updatesRequired(DatabaseUpdater.java:257) at org.openmrs.web.Listener.setupNeeded(Listener.java:184) at org.openmrs.web.Listener.contextInitialized(Listener.java:145) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3461) at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:943) at org.apache.catalina.manager.HTMLManagerServlet.reload(HTMLManagerServlet.java:557) at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:121) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) .......... I grep-ed for a runtime.properties file but couldn't find any. Any opinion to get the system running would be most appreciated, and what possibly have I missed out 1. To be unable to login at my first trial? 2. To get the stated error message? Thanks in advance :) -- Nadeeshani Hewage Undergraduate Department of Computer Science and Engineering University of Moratuwa nadeeshanihewage.blogspot.com<http://nadeeshanihewage.blogspot.com/> ________________________________ Click here to unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l> from OpenMRS Developers' mailing list ________________________________ Click here to unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l> from OpenMRS Developers' mailing list -- Nadeeshani Hewage Undergraduate Department of Computer Science and Engineering University of Moratuwa nadeeshanihewage.blogspot.com<http://nadeeshanihewage.blogspot.com/> ________________________________ Click here to unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l> from OpenMRS Developers' 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]
