This issue is still open. If we don't fix this before kernel 4.4.6, none of our new products are going to be compatible with MySQL 5.7. Which would be a major limitation in the platform.
Thanks, NuwanD. On Tue, May 10, 2016 at 4:15 PM, Chandana Napagoda <chand...@wso2.com> wrote: > Hi Janaka, > > Please note that, this fix will be available in the next kernel release. > > Regards, > Chandana > On May 10, 2016 3:14 PM, "Thilini Cooray" <thili...@wso2.com> wrote: > >> Hi, >> >> A public JIRA is raised in [1]. >> >> [1] https://wso2.org/jira/browse/REGISTRY-3610 >> >> Thanks. >> >> On Tue, May 10, 2016 at 12:11 PM, Janaka Ranabahu <jan...@wso2.com> >> wrote: >> >>> Hi Thushara >>> >>> On Tue, May 10, 2016 at 12:06 PM, Thushara Ranawaka <thusha...@wso2.com> >>> wrote: >>> >>>> Hi Thilini, >>>> >>>> AFAIU you workaround need to be updated with the current >>>> timestamp[1][2]. Setting default value to zero is not nice. You might have >>>> to figure out the correct syntax for other DB types and test against them. >>>> >>> What Thilini is pointing is an issue in the Registry database creation >>> script. Hence we will create a public JIRA and assign it to you guys. >>> Please fix them. >>> >>> We can not modify the Registry database creation script since API >>> Manager would not capture the complete scenarios of G-Reg. >>> >>> Thanks, >>> Janaka >>> >>> >>>> >>>> >>>> [1] - DEFAULT CURRENT_TIMESTAMP >>>> [2] - >>>> http://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column >>>> >>>> Thanks, >>>> Thushara. >>>> >>>> On Tue, May 10, 2016 at 11:52 AM, Thilini Cooray <thili...@wso2.com> >>>> wrote: >>>> >>>>> Hi GReg team, >>>>> >>>>> We encounter following issue [1] while testing API Manager with MySQL >>>>> 5.7 >>>>> MySQL 5.7 has enabled NO_ZERO_IN_DATE, NO_ZERO_DATE policies by >>>>> default. Therefore it does not allow 0 as a valid default value for >>>>> date/time. >>>>> >>>>> As a workaround we can set MySQL server to accept 0 changing the >>>>> default server settings if the database owner agrees on it. >>>>> [2] contains the related table creation script. >>>>> >>>>> Appreciate your feedback on a fix for this. >>>>> >>>>> [1] https://wso2.org/jira/browse/APIMANAGER-4645 >>>>> >>>>> [2] CREATE TABLE IF NOT EXISTS REG_RESOURCE ( >>>>> REG_PATH_ID INTEGER NOT NULL, >>>>> REG_NAME VARCHAR(256), >>>>> REG_VERSION INTEGER NOT NULL AUTO_INCREMENT, >>>>> REG_MEDIA_TYPE VARCHAR(500), >>>>> REG_CREATOR VARCHAR(31) NOT NULL, >>>>> REG_CREATED_TIME TIMESTAMP NOT NULL *DEFAULT 0*, >>>>> REG_LAST_UPDATOR VARCHAR(31), >>>>> REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL *DEFAULT 0*, >>>>> REG_DESCRIPTION VARCHAR(1000), >>>>> REG_CONTENT_ID INTEGER, >>>>> REG_TENANT_ID INTEGER DEFAULT 0, >>>>> REG_UUID VARCHAR(100) NOT NULL, >>>>> CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, >>>>> REG_TENANT_ID) >>>>> )ENGINE INNODB; >>>>> >>>>> Thanks. >>>>> >>>>> -- >>>>> Best Regards, >>>>> >>>>> *Thilini Cooray* >>>>> Software Engineer >>>>> Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194> >>>>> E-mail : thili...@wso2.com >>>>> >>>>> WSO2 Inc. www.wso2.com >>>>> lean.enterprise.middleware >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> Dev@wso2.org >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> Thanks, >>>> Thushara Kasun Ranawaka >>>> Software Engineer >>>> WSO2 Inc.; <http://www.wso2.com> >>>> lean.enterprise.middleware >>>> Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>* >>>> *thusha...@wso2.com <thusha...@wso2.com>* >>>> >>> >>> >>> >>> -- >>> *Janaka Ranabahu* >>> Associate Technical Lead, WSO2 Inc. >>> http://wso2.com >>> >>> >>> *E-mail: jan...@wso2.com <http://wso2.com>**M: **+94 718370861 >>> <%2B94%20718370861>* >>> >>> Lean . Enterprise . Middleware >>> >> >> >> >> -- >> Best Regards, >> >> *Thilini Cooray* >> Software Engineer >> Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194> >> E-mail : thili...@wso2.com >> >> WSO2 Inc. www.wso2.com >> lean.enterprise.middleware >> > -- Nuwan Dias Technical Lead - WSO2, Inc. http://wso2.com email : nuw...@wso2.com Phone : +94 777 775 729
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev