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 [email protected] <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote:
On 02/07/2017 12:32 AM, Oliver Angélil wrote:
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
-- *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>
-- *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>