Hi Sherene, Yes, that seems sufficient.Please resolve it.
Regards Asanthi On Wed, Sep 14, 2016 at 10:26 AM, Sherene Mahanama <[email protected]> wrote: > Sorry Nilmini, I just realized that page [2] actually explains the file > renaming approach for mysql5.7 which I think should be sufficient. > > *@Asanthi,* > Can I resolve that JIRA since 5.2.0 docs points to [2] and the file > renaming is mentioned there? > > > > On Wed, Sep 14, 2016 at 10:22 AM, Sherene Mahanama <[email protected]> > wrote: > >> Hi Asanthi, >> >> We recently moved admin content that's common for all products to a >> common "product administration guide". Therefore, working with databases >> content is mentioned here [1] in 5.2.0 where it points off to the admin >> docs. >> >> @Nilmini, >> Can we add a note on page [2] stating that the -Dsetup option is not >> supported for IS 5.2.0 and APIM 2.0.0? >> >> [1] https://docs.wso2.com/display/IS520/Product+Administration >> [2] https://docs.wso2.com/display/ADMIN44x/Working+with+Databases >> >> On Tue, Sep 13, 2016 at 10:27 PM, Asanthi Kulasinghe <[email protected]> >> wrote: >> >>> Hi Sherene, >>> >>> I couldn't find [1] for IS 5.2.0. Have we removed this? >>> Also we need to mention that -Dsetup is not supported for mysql 5.7 as >>> mentioned above. [2] >>> >>> [1] https://docs.wso2.com/display/IS510/Working+with+Databases >>> [2] https://wso2.org/jira/browse/DOCUMENTATION-3883 >>> >>> >>> Regards >>> Asanthi >>> >>> On Tue, Aug 9, 2016 at 9:57 PM, Thilini Cooray <[email protected]> >>> wrote: >>> >>>> Hi, >>>> >>>> In API Manager, -Dsetup would not take MySQL 5.7 scripts (for registry, >>>> um and apimgt) to execute by default. >>>> However you can rename those scripts to mysql.sql and then those can be >>>> executed with -Dsetup. >>>> >>>> Since -Dsetup is only a development time option, as Maduranga has >>>> mentioned, kernel 4.4.7 has removed -Dsetup default support for mysql 5.7 >>>> [1]. >>>> >>>> @IS team : shall we modify your "Setting up MySQL" documentation either >>>> by removing -Dsetup option as per APIM doc [2] or explaining the file >>>> renaming approach as per kernel doc [3]? >>>> Also IMO, it is better to rename identity script as *mysql5.7.sql* >>>> instead of mysql-5.7+.sql to comply with kernel's script naming. >>>> >>>> We removed the -Dsetup option from the APIM documentation as file >>>> renaming can be confusing for the users and most of the time this option >>>> does not use in real production deployments. >>>> >>>> [1] [Dev] [MySql5.7] Concern about MySql 5.7 scripts running with >>>> -Dsetup >>>> [2] https://docs.wso2.com/display/AM200/Setting+up+MySQL >>>> [3] https://docs.wso2.com/display/ADMIN447/Setting+up+MySQL >>>> >>>> Thanks. >>>> >>>> >>>> >>>> On Tue, Aug 9, 2016 at 5:22 PM, Maduranga Siriwardena < >>>> [email protected]> wrote: >>>> >>>>> Hi Sewmini, >>>>> >>>>> Kernel 4.4.6 had the feature to execute mysql 5.7 scripts with >>>>> -Dsetup. But it is removed from kernel 4.4.7 release. >>>>> >>>>> This feature was added to identity components based on the fact that >>>>> the kernel had this feature. But as this no longer in kernel, there is no >>>>> point of having it in identity component. So I guess this feature should >>>>> be >>>>> removed from identity components also. >>>>> >>>>> @Thilini, what is the status of this feature in APIM 2.0.0? >>>>> >>>>> Thanks, >>>>> Maduranga. >>>>> >>>>> On Mon, Aug 8, 2016 at 2:24 PM, Sewmini Jayaweera <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi IS team, >>>>>> >>>>>> I pointed carbon, registry and user DBs to MySQL 5.7 and tried >>>>>> starting with -dsetup. What I observed was; >>>>>> >>>>>> - In order to registry and user tables to get created with -Dsetup, >>>>>> 'mysql5.7.sql' script should be renamed to mysql.sql. But in order for >>>>>> identity tables to get created it requires 'mysql-5.7+.sql' script. >>>>>> >>>>>> Reason why I renamed script which creates registry and user tables is >>>>>> Jira [1] and mail thread [2]. According to mail thread [2] Kapila has >>>>>> initially done the fix to work -Dsetup without renaming the script but he >>>>>> has revered it. >>>>>> >>>>>> How are we going to handle above? >>>>>> >>>>>> >>>>>> [1]. https://wso2.org/jira/browse/DOCUMENTATION-3604 >>>>>> [2]. WSO2 Carbon Kernel 4.4.6 throws exceptions when rinning Oracle >>>>>> DB script >>>>>> >>>>>> Thank you. >>>>>> Kind Regards, >>>>>> >>>>>> Sewmini Jayaweera >>>>>> *Software Engineer - QA Team* >>>>>> Mobile: +94 (0) 773 381 250 >>>>>> [email protected] >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> [email protected] >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Maduranga Siriwardena >>>>> Software Engineer >>>>> WSO2 Inc. >>>>> >>>>> mobile: +94718990591 >>>>> >>>> >>>> >>>> >>>> -- >>>> Best Regards, >>>> >>>> *Thilini Cooray* >>>> Software Engineer >>>> Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194> >>>> E-mail : [email protected] >>>> >>>> WSO2 Inc. www.wso2.com >>>> lean.enterprise.middleware >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> Regards >>> >>> *Asanthi Kulasinghe* >>> Senior Software Engineer - QA >>> WSO2 Inc. - http://wso2.com >>> Mobile: +94777355522 >>> >>> >>> >> >> >> -- >> Sherene Mahanama >> Associate Technical Writer >> >> WSO2 (pvt.) Ltd. >> Colombo, Sri Lanka >> (+94) 777 <%28%2B94%29%20773131798>*994805* >> > > > > -- > Sherene Mahanama > Associate Technical Writer > > WSO2 (pvt.) Ltd. > Colombo, Sri Lanka > (+94) 777 <%28%2B94%29%20773131798>*994805* > -- Regards *Asanthi Kulasinghe* Senior Software Engineer - QA WSO2 Inc. - http://wso2.com Mobile: +94777355522
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
