Re: [Dev] BPS 3.5.1 compatible mysql version

[Gayan Gunarathne]

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  wrote:

> Please find my comments inline.
>
> On Tue, Jul 12, 2016 at 11:27 AM, Vinod Kavinda  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
>> /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 
>> 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 .*
>> 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

Re: [Dev] BPS 3.5.1 compatible mysql version

[Hasitha Aravinda]

Please find my comments inline.

On Tue, Jul 12, 2016 at 11:27 AM, Vinod Kavinda  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
> /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 
> 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 .*
> 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

Re: [Dev] BPS 3.5.1 compatible mysql version

[Vinod Kavinda]

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
/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  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
>
>
> 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
>
> [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 .*
Mobile : +94 (0) 712 415544
Blog : http://soatechflicks.blogspot.com/
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] BPS 3.5.1 compatible mysql version

[Gayan Gunarathne]

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


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

[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