21 Aug
2010
21 Aug
'10
4:08 a.m.
[Ricardo Rodriguez] eBioTIC. wrote:
Thanks, Caleb,
Caleb James DeLisle wrote:
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
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