Hi Lara and Harsha, Thanks I got it done :)
Regards Nadeeshani On Mon, Mar 19, 2012 at 9:17 PM, Lara Kellett <[email protected]> wrote: > 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] > -- Nadeeshani Hewage Undergraduate Department of Computer Science and Engineering University of Moratuwa nadeeshanihewage.blogspot.com _________________________________________ 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]
