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
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev