hi Nadeeshani, Just create a database named "openmrs" manually by using mysql client. and add the relevant root, root-pass(just in-case if you havent configured a separate mysql user for open mrs already) inside the "openmrs-runtime.properties"
finally do a "mvn clean install jetty:run" again hope this will work! Regards, Harsha On Mon, Mar 19, 2012 at 8:12 PM, Nadeeshani Hewage < [email protected]> wrote: > 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]>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]> 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 >>> >>> >>> ------------------------------ >>> Click here to >>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >>> OpenMRS Developers' mailing list >>> >> >> ------------------------------ >> Click here to >> unsubscribe<[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 > > > ------------------------------ > Click here to > unsubscribe<[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]
