Hi Charles, What database are you using? Is it demo database or database you got from another Openmrs system. Or to be more specific what version of database and openmrs are you using? Because it seems as though there is mismatch between the database version you are using and the openmrs system deployed.
- Willa. > 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]] *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]> >>> <mailto:[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] <mailto:[email protected]> - http://openmrs.org/ >>> >>> ------------------------------------------------------------------------ >>> >>> Click here to unsubscribe >>> <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> >>> from OpenMRS Implementers' mailing list >>> >>> ------------------------------------------------------------------------ >>> Click here to unsubscribe >>> <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> >>> from OpenMRS Implementers' mailing list >> >> ------------------------------------------------------------------------ >> Click here to unsubscribe >> <mailto:[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] > _________________________________________ 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]
