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@192.168.1.8 <xwiki@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 <molofi...@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 <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>
>
--
*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>
