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 <ser...@xwiki.org> 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>