Thanks, Caleb, Caleb James DeLisle wrote:
It doesn't make much sense to me either but if the database is dedicated to just that xwiki installation as indicated by GRANT ALL PRIVILEGES ON *.* TO 'xwiki'@'localhost' you could change the user in the hibernate.cfg.xml to 'root'. Not really a fix I know but perhaps it would reveal more information about the problem.
XWiki is the only application currently using this application, even though I would like to store there some other information. The command granting all privileges to xwiki@localhost is required by XEM to allow the application to create new wikis on the fly (I've submitted as proposed here URL). I think I perfectly understand this as each new wiki requires its own schema being templatexe the default template created during the installation. Following your proposal, I've done a different test: to grant xwiki user all privileges when connected from any host ('xwiki'@'%'). And it worked. After re-importing xwiki-enterprise-manager-application-xem-2.4.xar (if I don't import it, I can not select its contents to import it see this http://xen.net/fromPeat/importXEM.jpg), I get the same document in error. It claims that the default template must be imported. Going to the installation page offers the create the template button and it works without a glitch now. Creation of new wikis also works fine so far. I've added a second ethernet interface to the server, messed a bit with host names, edit sudoers file,.. but I don't know how this could affect to the privileges granted to xwiki@localhost. It seems like if MySQL identifies the connections as done from a different host in Internet, not from localhost. Please, does this make any sense for you? Thanks!!! Thank you so much for your help! Ricardo -- Ricardo RodrÃguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems