23 Aug
2010
23 Aug
'10
12:44 p.m.
Thanks, Sergiu,
Sergiu Dumitriu 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.
Here the output of "show processlist;"
RicardoRodriguez@peat:~> mysql -u xwiki -p -e "show processlist"
Enter password:
+-----+-------+-----------------+-------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State |
Info |
+-----+-------+-----------------+-------+---------+------+-------+------------------+
| 100 | xwiki | localhost:37677 | xwiki | Sleep | 4 | |
NULL |
| 135 | xwiki | localhost | NULL | Query | 0 | NULL | show
processlist |
+-----+-------+-----------------+-------+---------+------+-------+------------------+
RicardoRodriguez@peat:~>
It keeps been a mystery for me what is happening with that error when
installing/using XEM. Something related with
If XWiki generates tcp packets going in and out lo, it is clear that it
is not using sockets but tcp. But these packets are from/to localhost
so, why 'xwiki'@'localhost' with all privileges is not able to create
schemas on demand?
Just trying to understand what is going on here and if it could be of
any importance for XWiki development. Thanks for your help!
Ricardo
--
Ricardo RodrÃguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems