[xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Antoine Berthelin
Hello, I have a question about create a new wiki feature on xwiki, regarding the code and after test, this feature create a schema. In Oracle, to create a schema, you have to create user. The problem is : Oracle administrator don't allow xwiki user to create user/schema in oracle database ...

Re: [xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Jeremie BOUSQUET
Hello, This is normal, see here [1] New wiki creates a new schema. BR, Jeremie [1] - http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Virtualization 2015-01-06 11:49 GMT+01:00 Antoine Berthelin antoine.berthe...@gmail.com: Hello, I have a question about create a new wiki feature on

Re: [xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Antoine Berthelin
Hello, Thanks for your response. Yes, I understand xwiki has to use a new schema for sub wiki for scalability raison etc ... But, in production environnement in a real (big) company, Oracle DBA disallow autorisation on create user / schema operation for xwiki user (only DBA administrator can do

Re: [xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Thomas Mortagne
Old wiki manager UI used to propose you to force wiki creation when the DB/schema already existed but this feature seems to not be available anymore in the new UI. But as far as I can see this is supported by the wiki manager script API so one solution might be to either customize

Re: [xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Antoine Berthelin
Hello Thomas, Yes, I set failOnExist parameter to false, xwiki don't check it. However, just after, he try to create user and schema. = Throw JDBC exception Antoine 2015-01-06 17:58 GMT+01:00 Thomas Mortagne thomas.morta...@xwiki.com: On Tue, Jan 6, 2015 at 5:03 PM, Antoine Berthelin

Re: [xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Antoine Berthelin
Thanks Thomas, Good idea to use WikiManagerScriptService, I test it, but this service use the same method as UI with database creation, same method == same result :) So, I am writing a patch in Xwiki, I will improve my code and propose a push request in order to add an option on database

Re: [xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Thomas Mortagne
On Tue, Jan 6, 2015 at 5:03 PM, Antoine Berthelin antoine.berthe...@gmail.com wrote: Thanks Thomas, Good idea to use WikiManagerScriptService, I test it, but this service use the same method as UI with database creation, same method == same result :) As I explained in my first mail you have

Re: [xwiki-users] Create a new wiki on Oracle database autorisation

2015-01-06 Thread Thomas Mortagne
On Tue, Jan 6, 2015 at 6:11 PM, Antoine Berthelin antoine.berthe...@gmail.com wrote: Hello Thomas, Yes, I set failOnExist parameter to false, xwiki don't check it. However, just after, he try to create user and schema. This sounds like a bug to me, you should probably create a bug issue on