Thanks. Shall we include those version details in the documentation? Otherwise it will confuse the end user.
[1] https://docs.wso2.com/display/CLUSTER44x/Clustering+Business+Process+Server+3.5.0+and+3.5.1#ClusteringBusinessProcessServer3.5.0and3.5.1-Settingupthedatabases [2]https://docs.wso2.com/display/BPS351/Setting+up+MySQL Thanks, Gayan On Tue, Jul 12, 2016 at 11:34 AM, Hasitha Aravinda <hasi...@wso2.com> wrote: > Please find my comments inline. > > On Tue, Jul 12, 2016 at 11:27 AM, Vinod Kavinda <vi...@wso2.com> wrote: > >> Hi Gayan, >> There are separate scripts for mysql 5.5 for bpmn. Have you tried with >> those scripts. You need to run following scripts located at >> <BPS_HOME>/dbscripts/bps/bpmn/create folder. >> >> activiti.mysql55.create.engine.sql >> >> activiti.mysql55.create.history.sql >> >> We have not tested for mysql 5.7 AFAIU. >> >> >> Regards, >> >> Vinod >> >> >> >> >> On Tue, Jul 12, 2016 at 11:19 AM, Gayan Gunarathne <gay...@wso2.com> >> wrote: >> >>> Hi, >>> >>> Seems BPS 3.5.1 worked only with mysql 5.6. Got the following >>> incompatibility issues with mysql 5.5 and mysql 5.7. >>> But in the documentation we didn't mention anything about the mysql >>> version[1]. If we are support only mysql 5.6, shall we update the >>> documentation with the compatible mysql version? >>> >>> mysql 5.5 - Syntax incompatibility with BPMN_DB >>> >>> bps_rdbms | /usr/local/bin/docker-entrypoint.sh: running >>> /docker-entrypoint-initdb.d/bpsdb.sql >>> bps_rdbms | ERROR 1064 (42000) at line 2052: You have an error in your >>> SQL syntax; check the manual that corresponds to your MySQL server version >>> for the right syntax to use near '(3), >>> bps_rdbms | primary key (ID_) >>> bps_rdbms | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin' at >>> line 6 >>> bps_rdbms exited with code 1 >>> >> > A > s Vonod mentioned, Activiti has two scripts for MySQL 5.5 and MySQL 5.6. > > >>> >>> mysql 5.7 - Syntax incompatibility with WSO2_USER_DB >>> >>> bps_rdbms | /usr/local/bin/docker-entrypoint.sh: running >>> /docker-entrypoint-initdb.d/bpsdb.sql >>> bps_rdbms | ERROR 1067 (42000) at line 55: Invalid >>> >>> default value for 'REG_CREATED_TIME' >>> bps_rdbms exited with code 1 >>> >> > AFAIK, this is a known issue in kernel db scripts. Kernel registry mysql > script has default timestamp value as 0, which is not supported in MySQL > 5.7. This is fixed in latest kernel release. > > Thanks, > Hasitha. > > > >> >>> [1]https://docs.wso2.com/display/BPS351/Setting+up+MySQL >>> >>> Thanks, >>> Gayan >>> >>> -- >>> >>> Gayan Gunarathne >>> Technical Lead, WSO2 Inc. (http://wso2.com) >>> Committer & PMC Member, Apache Stratos >>> email : gay...@wso2.com | mobile : +94 775030545 <%2B94%20766819985> >>> >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Vinod Kavinda >> Software Engineer >> *WSO2 Inc. - lean . enterprise . middleware <http://www.wso2.com>.* >> Mobile : +94 (0) 712 415544 >> Blog : http://soatechflicks.blogspot.com/ >> >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > -- > Hasitha Aravinda, > Associate Technical Lead, > WSO2 Inc. > Email: hasi...@wso2.com > Mobile : +94 718 210 200 > -- Gayan Gunarathne Technical Lead, WSO2 Inc. (http://wso2.com) Committer & PMC Member, Apache Stratos email : gay...@wso2.com | mobile : +94 775030545 <%2B94%20766819985>
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev