On 08/20/2010 04:08 PM, [Ricardo Rodriguez] eBioTIC. wrote:
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!!!
Sometimes the connection comes from 127.0.0.1, not from localhost. Although they're actually the same thing, it seems that mysql doesn't do a normalization of the host. Or something else, maybe an alias of the host. Anyway, you could connect to the mysql server from a console and run "show processlist;" to see which hostname is printed for the connections from XWiki. -- Sergiu Dumitriu http://purl.org/net/sergiu/