8 Feb
2017
8 Feb
'17
10:14 p.m.
Here are the mysql database creation instructions on FreeBSD that finally
worked for me:
*In the mysql console...*
*mysql -u root -p *
(enter password in *.mysql_secret* file)
*SET PASSWORD = PASSWORD('my_new_password');*
*exit*
*In the FreeBSD command line...*
*mysql -u root -p -e "create database xwiki default character set utf8
collate utf8_bin"**mysql -u root -p -e "grant all privileges on *.*
to xwiki(a)192.168.1.8 <xwiki(a)192.168.1.8> identified by 'xwiki'"
**(Where
192.168.1.8 is the local IP. Replacing "192.168.1.8" with "localhost"
did
not work for me.)*
*mysql -u root -p -e "flush privileges"*
*Check what things look like...**mysql -u root -p -e "select host from
mysql.user where user = 'xwiki'"*
+--------------+
| host |
+--------------+
| 192.168.1.8 |
+--------------+
On 9 February 2017 at 07:08, Oliver Angélil <molofishy(a)gmail.com> wrote:
Could someone with a working version of xwiki please
execute the following
command in mysql and let me know what is returned.
*SELECT host FROM mysql.user WHERE User = 'xwiki';*
Thanks,
Oliver
On 8 February 2017 at 02:39, Sergiu Dumitriu <sergiu(a)xwiki.org> wrote:
--
*Oliver Marc Angélil*
PhD Candidate at the University of New South Wales, Australia
*http://web.maths.unsw.edu.au/~oangelil/oliver/page_oliver.html*
<http://web.maths.unsw.edu.au/~oangelil/oliver/page_oliver.html>
On 02/07/2017 12:32 AM, Oliver Angélil wrote:
--
*Oliver Marc Angélil*
PhD Candidate at the University of New South Wales, Australia
*http://web.maths.unsw.edu.au/~oangelil/oliver/page_oliver.html*
<http://web.maths.unsw.edu.au/~oangelil/oliver/page_oliver.html>
Thanks Sergiu,
Seems I had misunderstood the "replace the matching properties with the
following ones" in the xwiki mysql installation instructions. I think I
have done this part correctly now. Unfortunately I have encountered
another
exception (pasted below).
I am guessing the following is the problem: message from server: *"Host
'kokopu.ddns.net <http://kokopu.ddns.net>' is not allowed to connect to
this MySQL server". *
I'm doing this on FreeBSD. The main host is "kokopu" (192.168.1.7) and
the
entire xwiki installation is in a FreeBSD jail
(192.168.1.8).
Oliver
*type* Exception report
*message* *com.xpn.xwiki.XWikiException: Error number 11007 in 0:
Failed to
extract Entity Resource Reference from URL
[http://192.168.1.8:8080/xwiki-enterprise-web-8.4.4/bin/view/Main/
<http://192.168.1.8:8080/xwiki-enterprise-web-8.4.4/bin/view/Main/>]*
*description* *The server encountered an internal error that prevented
it
from fulfilling this request.*
*root cause*
java.sql.SQLException: null, message from server: "Host
'kokopu.ddns.net' is not allowed to connect to this MySQL server"
This is no longer related to XWiki, but to security rules on the
operating system. I'm not familiar with FreeBSD, but I'd investigate
either mysql access rules ("grant" commands) or firewall rules.
--
Sergiu Dumitriu
http://purl.org/net/sergiu