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
