All,
I’m getting an error running SDK that was noted above as being resolved.
Here’s the commands/results.
Any help is much appreciated!
Thanks much,
Barry
mvn openmrs-sdk:setup -DserverId=test1
-Dversion=2.3 -DdbDriver=mysql -DdbUser=root -DdbUri=jdbc:mysql://localhost:3306/openmrs
-DdbPassword=123
export MAVEN_OPTS="-Xmx1024m -Xms1024m -XX:PermSize=256m -XX:MaxPermSize=512m"
mvn openmrs-sdk:run
[INFO] Scanning for
projects…
INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Maven Stub
Project (No POM) 1
[INFO]
[INFO]
[INFO] —
openmrs-sdk-maven-plugin:2.1.2:run (default-cli) @ standalone-pom —
Define value for property’serverId’: (default: ‘test1’) (possible: test1, Openmrs2.3, openmrsMaster,
Openmrs2.2, SDK): test1
[INFO] Configuring Jetty forproject: Maven Stub Project (No POM)
[INFO] Context path =/openmrs
[INFO] Tmp directory =/Users/levine/OpenMRS/test1/tmp
[INFO] Web defaults =org/eclipse/jetty/webapp/webdefault.xml
[INFO] Web overrides = none
[INFO] jetty-9.0.4.v20130625
[INFO] No Transaction manager found - if your webapp requires one, please configure one.
[INFO] No Spring WebApplicationInitializer types detected on classpath
[INFO] Set web app root system property: ‘webapp.root’ = [/Users/levine/OpenMRS/test1/tmp/webapp]
[INFO] Initializing log4j from [classpath:log4j.xml]
WARN -
OpenmrsUtil.getRuntimePropertiesFilePathName(2669) |2016-05-26 12:51:46,102|
Unable to find a runtime properties file at /Users/levine/openmrs-runtime.properties
WARN -
OpenmrsUtil.getRuntimePropertiesFilePathName(2697) |2016-05-26 12:51:46,110|
Unable to find properties file: /Users/levine/openmrs/test1/openmrs-runtime.properties
WARN -
OpenmrsUtil.getRuntimeProperties(2630) |2016-05-26 12:51:46,112| Unable to find
a runtime properties file. Initial setup is needed. View the webapp to run thesetup wizard.
WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2669)
|2016-05-26 12:51:46,299| Unable to find a runtime properties file at
/Users/levine/openmrs-runtime.properties
WARN -
OpenmrsUtil.getRuntimePropertiesFilePathName(2697) |2016-05-26 12:51:46,300|
Unable to find properties file:
/Users/levine/openmrs/test1/openmrs-runtime.properties
WARN -
OpenmrsUtil.getRuntimeProperties(2630) |2016-05-26 12:51:46,300| Unable to find
a runtime properties file. Initial setup is needed. View the webapp to run the
setup wizard.
ERROR - UpdateFilterModel.updateChanges(77) |2016-05-26 12:51:50,472|
Unable to get the database changes
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:637)
…………………………………
Caused by: java.lang.Exception: 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
………………………………………………………………………
Caused by: java.sql.SQLException: Access denied for user ‘test’@‘localhost’
(using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1750)
………………………………………………………………………
[INFO] Started
o.e.j.m.p.JettyWebAppContext@6b9a7cb8{/openmrs,file:/Users/levine/OpenMRS/test1/tmp/webapp/,AVAILABLE}{/Users/levine/OpenMRS/test1/openmrs-1.11.4.war}
[INFO] Started
ServerConnector@48b68d98{HTTP/1.1}{0.0.0.0:8080}
[INFO] Started Jetty Server
I browsed to localhost:8080/openmrs
It redirected to http://localhost:8080/openmrs/initialsetup
The openmrs db was createdwith no tables
The browser hung at this point
** I stopped the jetty process and it generated the following:**
StoppedServerConnector@48b68d98{HTTP/1.1}{0.0.0.0:8080}
[INFO] Stopped
o.e.j.m.p.JettyWebAppContext@6b9a7cb8{/openmrs,file:/Users/levine/OpenMRS/test1/tmp/webapp/,UNAVAILABLE}{/Users/levine/OpenMRS/test1/openmrs-1.11.4.war}
[WARNING] FAILED
o.e.j.m.p.JettyWebAppContext@6b9a7cb8{/openmrs,file:/Users/levine/OpenMRS/test1/tmp/webapp/,UNAVAILABLE}{/Users/levine/OpenMRS/test1/openmrs-1.11.4.war}:
org.openmrs.api.APIException: contextDAO is null
org.openmrs.api.APIException: contextDAO is null
at org.openmrs.api.context.Context.getContextDAO(Context.java:170)
The installation properties file follows:
openmrs.platform.version=2.3
create_database_user=false
connection.username=root
connection.url=jdbc:mysql://localhost:3306/openmrs?autoReconnect=true&sessionVariables=storage_engine%3DInnoDB&useUnicode=true&characterEncoding=UTF-8
server.id=test1
connection.driver_class=com.mysql.jdbc.Driver
admin_user_password=Admin123
connection.password=123
install_method=auto
module_web_admin=true
add_demo_data=false
create_tables=true
has_current_openmrs_database=true
openmrs.version=1.11.4
database_name=openmrs
auto_update_database=false