Openmrs-SDK failed to setup server

mikejg · April 3, 2017, 3:04pm

Failed again

mikejg · April 3, 2017, 3:09pm

Heres proof though the DB one was set up

mikejg · April 3, 2017, 3:26pm

@raff thank you so much for your time.

mikejg · April 3, 2017, 9:59pm

Any further suggestions to help me get connected are most welcome

tansentim · April 4, 2017, 1:57am

@mikejg Could you try connecting to your MySQL server using the TCP port and not the unix socket.

mysql -h 127.0.0.1

If that does not work, then it may be that the mysqld config file is not allowing TCP connections. This was the default on some versions of mysql installer for Mac OS X.

mikejg · April 4, 2017, 2:01am

@tansentim thanks for your thoughts. If the following means I’m connected, then yes. ~ default$ mysql -h 127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 44 Server version: 5.6.35 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

mikejg · April 4, 2017, 2:03am

I’m looking into setting up through Whale docker, yet another learning curve!

raff · April 4, 2017, 8:57am

One last clue… It says you used the “default” user and not “root” to connect. Could you please try to connect as “root” same as when running openmrs-sdk:setup? Run:

mysql -u root -p

mikejg · April 4, 2017, 9:32am

@raff thanks again for your thoughts . I seem to have made a breakthrough by choosing the H2 database. But then I ran into another problem when I mvn openmrs-sdk:create-project. I’m not sure what the H@ database is, but at least it connects. I’m getting to my wits end!

/ default$ mvn openmrs-sdk:setup [INFO] Scanning for projects… [INFO]
[INFO] ------------------------------------------------------------------------ [INFO] Building Maven Stub Project (No POM) 1 [INFO] ------------------------------------------------------------------------ [INFO] [INFO] — openmrs-sdk-maven-plugin:3.8.2:setup (default-cli) @ standalone-pom —

Setting up a new server…

Specify server id (-DserverId) (default: ‘server’):

You can setup the following servers:

Distribution
Platform

Which one do you choose? [1/2]: 2

You can deploy the following versions of a platform:

2.1.0-SNAPSHOT
2.0.4.1
2.0.4
1.12.0
1.11.7
1.10.4
Other…

Which one do you choose? [1/2/3/4/5/6/7]: 1 [INFO] Configured Artifact: org.openmrs.distro:platform:2.1.0-SNAPSHOT:jar [INFO] Copying platform-2.1.0-SNAPSHOT.jar to /Users/default/openmrs/server/openmrs-distro.jar [INFO] Configured Artifact: org.openmrs.web:openmrs-webapp:2.1.0-SNAPSHOT:war [INFO] Copying openmrs-webapp-2.1.0-SNAPSHOT.war to /Users/default/openmrs/server/openmrs-2.1.0-SNAPSHOT.war [INFO] Configured Artifact: org.openmrs.module:fhir-omod:1.7.0-SNAPSHOT:jar [INFO] Configured Artifact: org.openmrs.module:webservices.rest-omod:2.17:jar [INFO] Configured Artifact: org.openmrs.module:owa-omod:1.6.3:jar [INFO] Copying fhir-omod-1.7.0-SNAPSHOT.jar to /Users/default/openmrs/server/modules/fhir-1.7.0-SNAPSHOT.omod [INFO] Copying webservices.rest-omod-2.17.jar to /Users/default/openmrs/server/modules/webservices.rest-2.17.omod [INFO] Copying owa-omod-1.6.3.jar to /Users/default/openmrs/server/modules/owa-1.6.3.omod

If you want to enable remote debugging by default when running the server, specify the port number here (e.g. 1044). Leave blank to disable debugging. (Do not do this on a production server) (default: ‘no debugging’): 1044

Which database would you like to use?:

H2
MySQL 5.6 (requires pre-installed MySQL 5.6)
MySQL 5.6 in SDK docker container (requires pre-installed Docker)
Existing docker container (requires pre-installed Docker)

Which one do you choose? [1/2/3/4]: 1 [INFO] Configured Artifact: com.h2database:h2:1.4.190:jar [INFO] Copying h2-1.4.190.jar to /Users/default/openmrs/server/h2-1.4.190.jar

The specified database openmrs-server does not exist and it will be created for you.

Note: JDK 1.8 is needed for platform version 2.1.0-SNAPSHOT.

Which JDK would you like to use to run this server?:

JAVA_HOME (currently: /Library/Java/JavaVirtualMachines/jdk1.8.0_121.jdk/Contents/Home/jre)
Other…

Which one do you choose? [1/2]: 1 [INFO] Server configured successfully, path: /Users/default/openmrs/server [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESS [INFO] ------------------------------------------------------------------------ [INFO] Total time: 47.067 s [INFO] Finished at: 2017-04-04T18:40:59+09:30 [INFO] Final Memory: 19M/180M

/ default$ mvn openmrs-sdk:create-project [INFO] Scanning for projects… [INFO]
[INFO] ------------------------------------------------------------------------ [INFO] Building Maven Stub Project (No POM) 1 [INFO] ------------------------------------------------------------------------ [INFO] [INFO] — openmrs-sdk-maven-plugin:3.8.2:create-project (default-cli) @ standalone-pom —

What kind of project would you like to create?:

Platform module
Reference Application module
Open Web App

Which one do you choose? [1/2/3]: 1

Module id uniquely identifies your module in the OpenMRS world.

It is advised to consult your module id on https://talk.openmrs.org to eliminate possible collisions.

Module id must consists of lowercase letters, must start from a letter, can contain alphanumerics and dots, e.g. webservices.rest, metadatasharing, reporting, htmlformentry.

Please specify module id (default: ‘basicexample’):

Module name is a user friendly name displayed to the user instead of the module id.

By convention it is a module id with spaces between words.

Please specify module name (default: ‘Basicexample’):

Describe your module in a few sentences (default: ‘no description’):

GroupId, artifactId and version combined together identify your module in the maven repository.

By convention OpenMRS modules use ‘org.openmrs.module’ as a groupId (must follow convention for naming java packages) and the module id as an artifactId. The version should follow maven versioning convention, which in short is: major.minor.maintenance(-SNAPSHOT).

Please specify groupId (default: ‘org.openmrs.module’):

Please specify initial version (default: ‘1.0.0-SNAPSHOT’):

What is the lowest version of the platform (-Dplatform) you want to support? (default: ‘1.11.6’): [INFO] Archetype: openmrs-sdk-archetype-module-platform [INFO] Generating project in Batch mode [INFO] Archetype defined by properties [INFO] ---------------------------------------------------------------------------- [INFO] Using following parameters for creating project from Archetype: openmrs-sdk-archetype-module-platform:3.8.2 [INFO] ---------------------------------------------------------------------------- [INFO] Parameter: groupId, Value: org.openmrs.module [INFO] Parameter: artifactId, Value: basicexample [INFO] Parameter: version, Value: 1.0.0-SNAPSHOT [INFO] Parameter: package, Value: org.openmrs.module.basicexample [INFO] Parameter: packageInPathFormat, Value: org/openmrs/module/basicexample [INFO] Parameter: moduleClassnamePrefix, Value: Basicexample [INFO] Parameter: moduleName, Value: Basicexample [INFO] Parameter: moduleAuthor, Value: default [INFO] Parameter: moduleDescription, Value: no description [INFO] Parameter: groupId, Value: org.openmrs.module [INFO] Parameter: version, Value: 1.0.0-SNAPSHOT [INFO] Parameter: package, Value: org.openmrs.module.basicexample [INFO] Parameter: openmrsPlatformVersion, Value: 1.11.6 [INFO] Parameter: artifactId, Value: basicexample [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 16.155 s [INFO] Finished at: 2017-04-04T18:59:13+09:30 [INFO] Final Memory: 19M/109M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.openmrs.maven.plugins:openmrs-sdk-maven-plugin:3.8.2:create-project (default-cli) on project standalone-pom: org.apache.maven.archetype.exception.ArchetypeGenerationFailure: Error merging velocity templates: /basicexample/pom.xml (No such file or directory) -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException

sunil99k · May 28, 2017, 6:57pm

I used default name “server” without quotation … and it works for me.

sharif · June 24, 2019, 1:00pm

j tried to follow the above instructions but this is the same error, j get Failed to setup server: Failed to connect to the specified database jdbc:mysql://localhost:3306/2?autoReconnect=true&sessionVariables=default_storage_engine%3DInnoDB&useUnicode=true&characterEncoding=UTF-8 . any updated help

jwnasambu · July 8, 2019, 8:08pm

Was your issue sorted out?

sharif · July 9, 2019, 1:30am

yes it was sorted after following the convention on this page https://wiki.openmrs.org/display/docs/OpenMRS+SDK+Step+By+Step+Tutorials j finally figured out the issue

herbert24 · July 9, 2019, 8:46am

kindly explain what you did in solving the error in order to help other people who might face the same error here!!

sharif · July 9, 2019, 9:49am

@herbert24 j guess this might be for @mikejg .but for my case since j had the same issue. after following this thread https://wiki.openmrs.org/display/docs/OpenMRS+SDK+Step+By+Step+Tutorial , all errors were solved, j think we need to hear from @mikejg, how fur he have gone

aman · January 2, 2020, 8:53pm

I am facing the same issue. Did anyone solved this issue for mysql db server?

sharif · January 3, 2020, 12:49am

@aman where did u got stuck from?

jwnasambu · January 3, 2020, 8:40am

@aman Honestly, its hard to figure out the error you are getting.Is it okay you share the error log through pastebin?

aman · January 3, 2020, 12:58pm

Here are the logs: https://pastebin.com/q8A5LXF3

The problem is that it is not able to connect to the local mysql server running even though I am giving the correct credentials.

aman · January 3, 2020, 12:59pm

@jwnasambu @sharif any ideas?

I am thinking of going with the docker option.