Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-10 Thread Mariangela Hills
Created a JIRA to track this task. https://wso2.org/jira/browse/DOCUMENTATION-6396 Regards, Mariangela *Mariangela Hills* Associate Lead Technical Writer - WSO2, Inc. http://wso2.com Committer and PMC member - Apache Stratos email:mariang...@wso2.com | mobile: +94 773 500185

Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-08 Thread Damith Wickramasinghe
As Harsha mentioned it should be some where common to all places. Regards, Damith On Tue, Nov 7, 2017 at 3:35 PM, Harsha Kumara wrote: > > > On Tue, Nov 7, 2017 at 3:18 PM, Chamalee De Silva > wrote: > >> Hi Damith, >> >> mysql5.7.sql script has been added for MySQL 5.7 and later versions of >

Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-08 Thread Sanjeewa Malalgoda
MySQL script on default product pack do not work as expected with mysql 5.7.19 . Please find updated one here. Thanks sanjeewa. On Tue, Nov 7, 2017 at 3:39 PM, Mariangela Hills wrote: > - Removing dev@wso2.org > > Ack for docs! > > Regards, > Mariangela > > > *Mariangela Hills* > Associate Lead

Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-07 Thread Damith Wickramasinghe
Hi Chamalee, Then there should be a link to that from where ever we mention to run mysql scripts. Because person only checks/ run what's mentioned then and there. WDYT ? Regards, Damith On Tue, Nov 7, 2017 at 3:18 PM, Chamalee De Silva wrote: > Hi Damith, > > mysql5.7.sql script has been add

Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-07 Thread Mariangela Hills
- Removing dev@wso2.org Ack for docs! Regards, Mariangela *Mariangela Hills* Associate Lead Technical Writer - WSO2, Inc. http://wso2.com Committer and PMC member - Apache Stratos email:mariang...@wso2.com | mobile: +94 773 500185 On Tue, Nov 7, 2017 at 3:37 PM, Da

Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-07 Thread Harsha Kumara
On Tue, Nov 7, 2017 at 3:18 PM, Chamalee De Silva wrote: > Hi Damith, > > mysql5.7.sql script has been added for MySQL 5.7 and later versions of > databases. > This is clearly described in the documentation on setting up MySQL > documentation in [1]. > > If we are going to add this special note,

Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-07 Thread Chamalee De Silva
Hi Damith, mysql5.7.sql script has been added for MySQL 5.7 and later versions of databases. This is clearly described in the documentation on setting up MySQL documentation in [1]. If we are going to add this special note, we may have to add this everywhere where mysql is used. @team, What is t

Re: [Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-07 Thread Harsha Kumara
On Tue, Nov 7, 2017 at 2:20 PM, Damith Wickramasinghe wrote: > Hi all, > > I'm using mysql version 5.7.20. In order to populate userdb and regdb i > need to run mysql scripts and i have used the scripts in APIM analytics > pack(mysql.sql). When run below issue arises, > > ERROR 1067 (42000): Inva

[Dev] Issue when running mysql db script - APIM analytics HA setup

2017-11-07 Thread Damith Wickramasinghe
Hi all, I'm using mysql version 5.7.20. In order to populate userdb and regdb i need to run mysql scripts and i have used the scripts in APIM analytics pack(mysql.sql). When run below issue arises, ERROR 1067 (42000): Invalid default value for 'REG_CREATED_TIME' ERROR 1146 (42S02): Table 'regdb.R