Hi Hewage, I think on your first attempt, everything was fine, admin is the system_id of the super user and not username, this is why your sql statement above returned no row. When logging in, you have to use the password you entered when installing OpenMRS and not 'test'. Can you check your catalina/tomcat home directory to see if you '.OpenMRS' directory, if it exists, delete it.
Wyclif On Mon, Mar 19, 2012 at 2:54 AM, 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 _________________________________________ 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]
