i am trying to setup sdk,but after running mvn openmrs-sdk:run, i get this error https://pastebin.com/6njUDdaf .i have tried to look for some online solutions but they werent of help.Any suggestion?
Not sure as to why this is happening, but it could be with dependency incompatibility.
Don’t you wanna add more info? In the first place, whats the version of yr MYSQL server? And what does this return
mysql> show variables like "%storage%";
This was fixed in platform 2.0 as you can see here: https://issues.openmrs.org/browse/TRUNK-4800
So you can either use a higher openmrs platform version or downgrade your mysql.
as installing the sdk,this is what i have for msql server version(Server version: 5.1.53-community-log MySQL Community Server (GPL)
) and i have tried the follwoing versions of distribution
(1)Reference Application 2.9.0-SNAPSHOT (2) Reference Application 2.8.0 (3) Reference Application 2.7.0 (4) Reference Application 2.6.1 (5) Reference Application 2.5 .
As you had suggested that i use a lower version of the database,i think i am using a lower one,and i have tried using the Reference Application 2.9.0-SNAPSHOT as the higher version of openmrs platform but still it brings out the same error!!! could it stil be version incompability
it returns Variable_name=storage_engine and value=MyISAM
The version of mysql server yr running is incompatible with refApp 2.x.
Upgrade to at least
Lower versions should work fine too. Can you switch to InnoDB?
but still after running mvn openmrs-sdk:setup i ge this error.https://hastebin.com/uzisenaruq.sql I have read a couple of solutions from @dkayiwa and @ssmusoke which include upgrading to the latest sdk,setting a root password for root and all are still failing
i switched to InnoDB,and i got to this error , https://hastebin.com/uzisenaruq.sql showing that still the database still cant connect
@herbert24 do you want to re-run “mvn openmrs-sdk:setup -X” so folks can get a detailed log.
for this i changed the mysql database version to 5.6 and it worked fine.The problem was version conflict.
So you got this fixed? Could explain in details starting from the issue you faced and how it was solved. It always helps others that hit upon the same issue.
i explained it above basing on the flow of the thread,thanks for the support