Hi Charles, I'm not sure how you have set up your environment, but by default the application data directory '.OpenMRS' should be located in the user home directory and not '/user/share/tomcat6', So you need to delete the one in the home directory.
Wyclif On Fri, Feb 17, 2012 at 1:27 PM, Charles C. Chou <[email protected]> wrote: > Hi, > I am now trying to re-install OpenMRS on the same Linux server. After > removing the openmrs database from mysql and removing the .OpenMRS from > /usr/share/tomcat6, undeployed openmrs from the tomcat manager app, I > proceeded with deploying the openmrs.war file again and got the same > runtime properties not found error. I then created one manually as > suggested by James and now I got: > > *The following error occurred at startup:* > Error occurred while trying to get the updates needed for the database. > liquibase.exception.JDBCException: Error executing SQL CREATE TABLE > `liquibasechangeloglock` (`ID` INT NOT NULL, `LOCKED` TINYINT(1) NOT NULL, > `LOCKGRANTED` DATETIME, `LOCKEDBY` VARCHAR(255), CONSTRAINT > `PK_LIQUIBASECHANGELOGLOCK` PRIMARY KEY (`ID`)) > > java.lang.RuntimeException: Error occurred while trying to get the updates > needed for the database. liquibase.exception.JDBCException: Error executing > SQL CREATE TABLE `liquibasechangeloglock` (`ID` INT NOT NULL, `LOCKED` > TINYINT(1) NOT NULL, `LOCKGRANTED` DATETIME, `LOCKEDBY` VARCHAR(255), > CONSTRAINT `PK_LIQUIBASECHANGELOGLOCK` PRIMARY KEY (`ID`)) > at > org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:578) > at > org.openmrs.util.DatabaseUpdater.updatesRequired(DatabaseUpdater.java:257) > at org.openmrs.web.Listener.setupNeeded(Listener.java:170) > at org.openmrs.web.Listener.contextInitialized(Listener.java:142) > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) > at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:563) > at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1397) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:616) > at > org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:297) > at > com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:857) > at > com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:795) > at > org.apache.catalina.manager.ManagerServlet.check(ManagerServlet.java:1500) > at > org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:252) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > at java.lang.Thread.run(Thread.java:679) > Caused by: liquibase.exception.LockException: > liquibase.exception.JDBCException: Error executing SQL CREATE TABLE > `liquibasechangeloglock` (`ID` INT NOT NULL, `LOCKED` TINYINT(1) NOT NULL, > `LOCKGRANTED` DATETIME, `LOCKEDBY` VARCHAR(255), CONSTRAINT > `PK_LIQUIBASECHANGELOGLOCK` PRIMARY KEY (`ID`)) > at liquibase.lock.LockHandler.waitForLock(LockHandler.java:176) > at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:518) > at > org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:566) > ... 35 more > Caused by: liquibase.exception.JDBCException: Error executing SQL CREATE > TABLE `liquibasechangeloglock` (`ID` INT NOT NULL, `LOCKED` TINYINT(1) NOT > NULL, `LOCKGRANTED` DATETIME, `LOCKEDBY` VARCHAR(255), CONSTRAINT > `PK_LIQUIBASECHANGELOGLOCK` PRIMARY KEY (`ID`)) > at > liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) > at > liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) > at > liquibase.database.AbstractDatabase.checkDatabaseChangeLogLockTable(AbstractDatabase.java:755) > at liquibase.lock.LockHandler.waitForLock(LockHandler.java:145) > ... 37 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > '`openmrs`.`liquibasechangeloglock`' already exists > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:532) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at com.mysql.jdbc.Util.getInstance(Util.java:381) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:769) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:612) > at > liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) > at > liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) > ... 40 more > > Any ideas? > > BTW anyway to see the deployment code? It seems kind of sensitive, maybe > limited to just the Linux platform. > > Regards, > Charles Chou > > On 2/8/2012 9:47 AM, Charles C. Chou wrote: > > Thanks James. After creating the openmrs-runtime-properties as suggested I > got the installation to complete successfully. The system is now running. > Thanks again! > > Regards, > Charles Chou > On 2/8/2012 8:49 AM, James Arbaugh wrote: > > Hi again Charles.**** > > ** ** > > It sounds like you ran into a bug. Recent versions of OpenMRS should > create the runtime properties file if it doesn’t exist.**** > > ** ** > > You could try to do it manually with the details on this page.**** > > > https://wiki.openmrs.org/display/docs/Overriding+OpenMRS+Default+Runtime+Properties > **** > > ** ** > > Thanks,**** > > James**** > > ** ** > > *From:* [email protected] > [mailto:[email protected]<[email protected]>] > *On Behalf Of *Charles C. Chou > *Sent:* Wednesday, February 08, 2012 12:42 PM > *To:* [email protected] > *Subject:* Re: [OPENMRS-IMPLEMENTERS] Linux server installation**** > > ** ** > > Hi, > The installation wizard is now stuck at Create database user and will > not continue. The output details is as follows:**** > > Create database user**** > > > Number of actions completed so far: 2 > > Server log file output: **** > > WARN - OpenmrsUtil.getRuntimeProperties(2274) |2012-02-08 07:34:04,225| > Unable to find a runtime properties file at > /usr/share/tomcat6/openmrs-runtime.properties > WARN - OpenmrsUtil.getRuntimeProperties(2304) |2012-02-08 07:34:04,351| > Unable to find properties file: > /usr/share/tomcat6/.OpenMRS/openmrs-runtime.properties > WARN - OpenmrsUtil.getRuntimeProperties(2321) |2012-02-08 07:34:04,352| > Unable to find a runtime properties file. Initial setup is needed. View the > webapp to run the setup wizard. > WARN - InitializationFilter.verifyConnection(455) |2012-02-08 > 07:34:27,881| Error while checking the connection user account > ERROR - Context.getServiceContext(253) |2012-02-08 07:35:13,877| > serviceContext is null. Creating new ServiceContext() **** > > > Any ideas? > > On 2/8/2012 7:05 AM, Charles C. Chou wrote: **** > > Thanks. That was the problem. There were 2 users created, tomcat and > tomcat6, during the installation of tomcat somehow (I guess one is from the > distro package and one is from apache-tomcat-6.0.29) The webapps directory > was owned by tomcat6 where the tomcat6 process was running as user tomcat. > After changing the webapps ownership to tomcat.tomcat the deployment of > openmrs.war was successful. I have removed the confusing user tomcat6. > > Thanks again! > Charles Chou > > On 2/8/2012 6:19 AM, Michael Downey wrote: > > **** > > Hi Charles, > > On Wed, Feb 8, 2012 at 11:00 AM, Charles C. > Chou<[email protected]><[email protected]> > wrote: > > **** > > Feb 7, 2012 10:17:09 AM org.apache.catalina.core.ApplicationContext log > SEVERE: HTMLManager: FAIL - Deploy Upload Failed, Exception: null **** > > A quick Google search suggests this is probably a file permissions > issue. Make sure all of your files are owned by the user that is > running the Tomcat process. > > Hope this helps get you started! > > Best regards, > Michael Downey > OpenMRS Community Infrastructure Team > [email protected] - http://openmrs.org/ **** > > ** ** > > ** ** > ------------------------------ > > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > **** > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list _________________________________________ 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]
