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]
