22 Aug
2010
22 Aug
'10
6:20 p.m.
On 08/20/2010 04:08 PM, [Ricardo Rodriguez] eBioTIC. wrote:
Thanks, Caleb,
Caleb James DeLisle wrote:
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/
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!!! 