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 <sher...@wso2.com> 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 <asan...@wso2.com> > 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 <thili...@wso2.com> 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 < >>> madura...@wso2.com> 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 <sewm...@wso2.com> >>>> 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 >>>>> sewm...@wso2.com >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> Dev@wso2.org >>>>> 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 : 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 >>> >>> >> >> >> -- >> 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*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev