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
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
