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*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
