Hi Isuru, As I've explained earlier. We will not implement -Dsetup support in C5.
Thanks, Sameera. On Fri, May 6, 2016 at 1:11 PM, Isuru Perera <isu...@wso2.com> wrote: > Yes. -Dsetup is easier, but let's avoid setting up database from the > server. In Wiki, we can give instructions on setting up databases for each > vendor. > > Carbon Team, could you please let us know your conclusion on this? > > On Wed, May 4, 2016 at 4:55 PM, Isuru Haththotuwa <isu...@wso2.com> wrote: > >> Hi Sagara, >> >> On Fri, Apr 29, 2016 at 5:31 PM, Sagara Gunathunga <sag...@wso2.com> >> wrote: >> >>> >>> >>> On Fri, Apr 29, 2016 at 4:21 PM, Isuru Perera <isu...@wso2.com> wrote: >>> >>>> Hi Sameera, >>>> >>>> As Thilini mentioned, most of the products need a database to keep >>>> data. With -Dsetup we could execute scripts based on the vendor. We need >>>> some way of setting up the database in C5 as well. >>>> >>>> I'm sorry I couldn't create a JIRA for $subject yet. >>>> >>>> In C5, what is the recommended way to setup a database (by creating >>>> required tables) for a WSO2 product? >>>> >>>> On Fri, Apr 29, 2016 at 3:45 PM, Thilini Cooray <thili...@wso2.com> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> In many of our carbon 4.x.x based products, we use -Dsetup option >>>>> allowing users to create databases on their preferred vendor (instead of >>>>> our inbuilt H2 database). >>>>> Without this option, users will have to run database scripts against >>>>> each of the databases by themselves prior to server startup. >>>>> >>>>> Therefor I think it is a useful option to have in C5. >>>>> >>>> >>> I'm -1 to include this option into C5 products due to following >>> reasons. >>> >>> 1.) This option available with C4 product is just a demoware only, >>> nobody use this option to populate databases in production systems. >>> Recommended practise for production environments is DB admin/team populate >>> databases manually and create user with limited privileges so that >>> applications use this limited-privileged user to access the database >>> server. >>> >> >>> 2.) In production systems, those admin rights are not anyway assign to >>> generic users hence not usable feature even if we include this option it >>> will use for demos only. Also previously we found some lazy practises where >>> developer assumed DB user always got admin rights and try to perform DB >>> admin tasks through our Java codes[1]. >>> >>> 3.) Having this option in production systems increase security risks. >>> >> Fully agreed that this should not be the recommended method for creating >> DB tables in production environments. However IMHO the ease of trying >> out/demonstrating is very important. >> >> As an example scenario, we are focusing more and more on making wso2 >> products container friendly and easy to try out. A user trying out a >> distributed deployment deployment on a containerized environment (docker, >> kubernetes, etc.) will expect to deploy it with minimal steps: start a >> mysql container and start the products pointing to the mysql container. If >> a method similar to -Dsetup is available, it will make the life of the user >> much easier, rather than having to run the DB scripts manually. >> >> >> [1] - "TrustedIdPDBInitializer Class should not create any tables, >> indexes when -Dsetup is not given" >> >> >> Thanks ! >> >>> >>>> Thanks. >>>> >>>> On Fri, Apr 29, 2016 at 3:24 PM, Sameera Jayasoma <same...@wso2.com> >>>> wrote: >>>> >>>>> Hi Isuru, >>>>> >>>>> Can you explain the need to have a -Dsetup option? Can we simply >>>>> remove this in C5? >>>>> >>>>> Thanks, >>>>> Sameera. >>>>> >>>>> >>>>> On Fri, Mar 25, 2016 at 1:45 PM, Isuru Perera <isu...@wso2.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> In Carbon 4.x.x, we extend [1] >>>>>> org.wso2.carbon.utils.dbcreator.DatabaseCreator [2]. How can we do the >>>>>> same >>>>>> in Carbon 5? >>>>>> >>>>>> Thanks! >>>>>> >>>>>> [1] >>>>>> https://github.com/search?l=&q=DatabaseCreator++user%3Awso2&ref=advsearch&type=Code&utf8=%E2%9C%93 >>>>>> [2] >>>>>> https://github.com/wso2/carbon-kernel/blob/4.4.x/core/org.wso2.carbon.utils/src/main/java/org/wso2/carbon/utils/dbcreator/DatabaseCreator.java >>>>>> >>>>>> -- >>>>>> Isuru Perera >>>>>> Associate Technical Lead | WSO2, Inc. | http://wso2.com/ >>>>>> Lean . Enterprise . Middleware >>>>>> >>>>>> about.me/chrishantha >>>>>> Contact: +IsuruPereraWSO2 >>>>>> <https://www.google.com/+IsuruPereraWSO2/about> >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> Dev@wso2.org >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Sameera Jayasoma, >>>>> Software Architect, >>>>> >>>>> WSO2, Inc. (http://wso2.com) >>>>> email: same...@wso2.com >>>>> blog: http://blog.sameera.org >>>>> twitter: https://twitter.com/sameerajayasoma >>>>> flickr: http://www.flickr.com/photos/sameera-jayasoma/collections >>>>> Mobile: 0094776364456 >>>>> >>>>> Lean . Enterprise . Middleware >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> Dev@wso2.org >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> 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 >>>> >>> >>> >>> >>> -- >>> Isuru Perera >>> Associate Technical Lead | WSO2, Inc. | http://wso2.com/ >>> Lean . Enterprise . Middleware >>> >>> about.me/chrishantha >>> Contact: +IsuruPereraWSO2 >>> <https://www.google.com/+IsuruPereraWSO2/about> >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >>> >>> >>> -- >>> Sagara Gunathunga >>> >>> Architect; WSO2, Inc.; http://wso2.com >>> V.P Apache Web Services; http://ws.apache.org/ >>> Linkedin; http://www.linkedin.com/in/ssagara >>> Blog ; http://ssagara.blogspot.com >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Thanks and Regards, >> >> Isuru H. >> +94 716 358 048* <http://wso2.com/>* >> >> >> > > > -- > Isuru Perera > Associate Technical Lead | WSO2, Inc. | http://wso2.com/ > Lean . Enterprise . Middleware > > about.me/chrishantha > Contact: +IsuruPereraWSO2 <https://www.google.com/+IsuruPereraWSO2/about> > -- Sameera Jayasoma, Software Architect, WSO2, Inc. (http://wso2.com) email: same...@wso2.com blog: http://blog.sameera.org twitter: https://twitter.com/sameerajayasoma flickr: http://www.flickr.com/photos/sameera-jayasoma/collections Mobile: 0094776364456 Lean . Enterprise . Middleware
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
