[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,
Check your ifconfig for different addresses attached to the the loopback device. Also you will get a lot more info by running tcpdump on the loopback and then on ethernet and filtering by destination port = mysql port. A wild guess is that the ethernet device is being used as a loopback. Caleb
not from localhost. Please, does this make any sense for you? Thanks!!!
Thank you so much for your help!
Ricardo