Hello Martin, Thanks for reporting this, I corrected the page, with a grant privileges applied on every databases. Since 5.0, every xwiki instance is able to create subwikis (WikiManager always installed), so I guess it's best to avoid the privileges issues, by giving the good rights from the beginning.
Have a good day Guillaume Fenollar 2013/11/26 Martin Hamant <m...@ow2.org> > Le 26/11/2013 12:37, Martin Hamant a écrit : > > Hi! >> >> I am running Xwiki 5.2 and trying to create a new wiki from the Wiki >> Manager. >> >> If fails with the following message in container logs: Access denied for >> user 'xwiki'@'localhost' to database 'ezr' (where 'ezr' is the wiki >> name). >> >> I verified my installation reading the steps specified here : >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL >> >> My guess is the 'xwiki' user can't create a new database : what if the >> official documentation about xwiki MySQL user for multi-tenant usage ? >> Do I have to modify something in MySQL privileges ? >> >> Here is the resulting privileges of "grant all privileges on xwiki.* to >> xwiki@localhost identified by 'xxx'" >> >> +----------------------------------------------------------- >> ---------------------------------------------------+ >> | Grants for xwiki@localhost | >> +----------------------------------------------------------- >> ---------------------------------------------------+ >> | GRANT USAGE ON *.* TO 'xwiki'@'localhost' IDENTIFIED BY PASSWORD '***' >> | >> | GRANT ALL PRIVILEGES ON `xwiki`.* TO 'xwiki'@'localhost' | >> +----------------------------------------------------------- >> ---------------------------------------------------+ >> >> From my understanding of the above , xwiki user only have all privileges >> access to xwiki db... So the user can't create any additional xwiki >> database !? >> >> Thanks ! >> >> > Answering to my own question : Found the answer here : > http://manager.xwiki.org/xwiki/bin/view/AdminGuide/Installation# > HInstallXEMusingDebian28.DEB29PackagesandExtensionManager > > > Convert an existing XWiki Enterprise instance > > * In order for XEM to be able to create new wikis on demand, you will > need to give all rights to your database user. For example for > MySQL, execute: > mysql -u root -e "grant all privileges on *.* to xwiki@127.0.0.1 > identified by 'xwiki'" > > > This step is required. (I am using DEB distribution of XWiki.) > Maybe this could be reminded somewhere on http://platform.xwiki.org/ > xwiki/bin/view/AdminGuide/InstallationMySQL ?? What do you think ? > > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
