Supporting MariaDB with OpenMRS 2.3 release?

Software Reference App
21

Sure, please let me know the output of:

docker info

and also which command lines you are using.

1 Like
22

It’s currently running here: https://ci.openmrs.org/browse/TRUNK-MWO-9

I guess the output will be displayed.

docker build -t openmrs-docker:latest . time=“2015-10-06T07:33:42Z” level=info msg=“Unknown instruction: -DDBDRIVER=COM.MYSQL.JDBC.DRIVER-DDBURI=JDBC:MYSQL://LOCALHOST:3306/OPENMRSTEST?AUTORECONNECT=TRUE&SESSIONVARIABLES=STORAGE_ENGINE=INNODB&USEUNICODE=TRUE&CHARACTERENCODING=UTF-8”

            Error response from daemon: no such id: openmrs-9
            time="2015-10-06T07:33:42Z" level=fatal msg="Error: failed to kill one or more containers"
23

I changed

-DuseInMemoryDatabase=false -DdbDriver=com.mysql.jdbc.Driver\

to

-DuseInMemoryDatabase=false
-DdbDriver=com.mysql.jdbc.Driver \

Looking better, now

24

But openmrs docker container is not coming up.

06-Oct-2015 09:43:56 + docker run -d --name openmrs-12 --link mysql-12:mysql -p 8080:8080 openmrs-docker 06-Oct-2015 09:43:58 + DC_ID=d366ebe5879ac6abd0046a3c49254693f241c68cc3ccd04967b54d5e555dacab 06-Oct-2015 09:43:58 + sleep 100 06-Oct-2015 09:45:38 + docker logs d366ebe5879ac6abd0046a3c49254693f241c68cc3ccd04967b54d5e555dacab 06-Oct-2015 09:45:38 /bin/sh: 1: -DdbUser=test: not found

Apparently you didn’t configured mysql to have that user? The one you configured openmrs to run.

1 Like
25

Alright, Thanks @cintiadr. Will fix this ASAP.

26

Hello @cintiadr @dkayiwa,

I have fixed the user issue with docker test. How do I proceed to adding the tests @burke talked of. that’s the Integration tests, Reference App tests etc?

27

@ch3ck can you now run openmrs with the arguments below?

-DuseInMemoryDatabase=false
-DdatabaseUrl=jdbc:mysql://localhost:3306/openmrstest?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8
-DdatabaseUsername=test
-DdatabasePassword=test
-DdatabaseDriver=com.mysql.jdbc.Driver
-DdatabaseDialect=org.hibernate.dialect.MySQLDialect

Remember to replace the values with what you have.

28

@cintiadr @dkayiwa

I used those arguments and they did not work. I’ve modified the arguments accordingly to the way I configure the docker image. I’m still running the Docker container, and will need your assistance in adding the tests to the disposable containers.

Cheers!

29

@cintiadr,

Could you help me out here. I’m still getting the connection refused error with the MySQL docker container. I don’t know what I may be doing wrong here.

Thanks,

30

Hi @dkayiwa @cintiadr, I have fixed the issues with the MySQL build and it works against MySQL and MariaDB. I will like to proceed to the next steps. As @burke stated

Create a CI plan to build openmrs-core against MySQL, failing if build fails. (DONE!) Create a CI plan to build openmrs-core against MariaDB, failing if build fails. (DONE!) Make sure MySQL plan runs integration tests, failing if tests fail (CURRENT) Make sure MariaDB plan runs integration tests, failing if tests fail (CURRENT) Enhance MySQL plan to do first-time setup of reference application, failing if setup fails Enhance MariaDB plan to do first-time setup of reference application, failing if setup fails Enhance MySQL plan to run refapp integration tests Enhance MariaDB plan to run refapp integration tests

I am currently working on adding the integration tests to the tests. I will need your assistance with this.

31

@ch3ck, it’s great to see you making progress on this!

Would you mind giving the URLs to the bamboo plans for the things you have completed?

32

@darius, These are the links are shared last time. Just check them out and give me feedback.

33

@ch3ck, this thread is long (and confusing for those of us who haven’t been following it closely!)

Would you mind posting the URLs again of the 4 thing you said are done or in progress, in one consolidated message?

1 Like
34

Here is MariaDB: https://ci.openmrs.org/browse/TRUNK-OOM As for MySQL: https://ci.openmrs.org/browse/TRUNK-MWO-9

The first part works. Now I have to move on to writing scripts for next steps.

35

Thanks @ch3ck for you help with this. Where do things stand today?

/cc @dkayiwa

36

Hi @burke, I have finished the first part, I’m trying to run the integration tests for both plans and the ref App tests setup. Once I’m done with this. It should be all good.

37

Hi @cintiadr @dkayiwa

I am having an issue running the integration tests. I am constantly getting this error:

>   /bin/sh: 1: -DdatabaseUsername=test: not found

I properly configured the user names and password to test, but I don’t understand the error here.

I also get this error activation the integration tests, https://paste.kde.org/p3dcl56mz

Cheers!

38

Probably it’s missing a \ before the previous line. I assume it’s something which is supposedly one single line, but there’s an endline when it shoudln’t.

Can you give me the link to the build?

39

Hi @cintiadr,

Here are the links:

Here is MariaDB: https://ci.openmrs.org/browse/TRUNK-OOM
As for MySQL: https://ci.openmrs.org/browse/TRUNK-MWO-9

Just let me know how it goes.

Thanks, Nyah

40

In https://ci.openmrs.org/browse/TRUNK-MWO-112/log

“Cannot execute mojo: resources. It requires a project with an existing pom.xml, but the build is not using one.”

I don’t know where you are running maven, but you don’t seem to have a maven project on that folder. I can see the ‘Integration test for OpenMRS’ task trying to run maven, but it absolutely needs somehow a checkout of a maven repository before.

Looking the other one now.