<
From version < 66.2 >
edited by Vincent Massol
on 2020/12/02
To version < 66.4 >
edited by Vincent Massol
on 2020/12/02
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -27,7 +27,7 @@
27 27  Follow these instructions:
28 28  
29 29  * Download and install [[MySQL>>http://www.mysql.com/]] 5.x or greater.
30 -* Start the MySQL server. You can do that in several ways. For example use {{code}}mysqld --console{{/code}}
30 +* Start the MySQL server. You can do that in several ways. For example use {{code language='shell'}}mysqld --console{{/code}}
31 31  * Create the wiki database. You can use the name you want for the database, but you will have to set the hibernate configuration file and ##xwiki.cfg## file accordingly.(((
32 32  You can create the database in several ways. For example use:
33 33  
... ... @@ -40,7 +40,7 @@
40 40  mysql -u root -e "CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'xwiki'";
41 41  {{/code}}
42 42  )))
43 -* Give privileges to the ##xwiki## user for accessing and creating databases (for the multi wiki support). Specifically the ##xwiki## users needs permissions to be able to execute {{code}}CREATE DATABASE{{/code}}, {{code}}DROP SCHEMA{{/code}}, and then all CRUD operations on tables. Note that the command below should be tuned to be more restrictive as granting all permissions is not required:(((
43 +* Give privileges to the ##xwiki## user for accessing and creating databases (for the multi wiki support). Specifically the ##xwiki## users needs permissions to be able to execute {{code language='sql'}}CREATE DATABASE{{/code}}, {{code language='sql'}}DROP SCHEMA{{/code}}, and then all CRUD operations on tables. Note that the command below should be tuned to be more restrictive as granting all permissions is not required:(((
44 44  {{code language='shell'}}
45 45  mysql -u root -e "grant all privileges on *.* to xwiki@localhost"
46 46  {{/code}}
... ... @@ -68,7 +68,7 @@
68 68  {{/code}}
69 69  
70 70  {{info}}
71 -* By default MySQL only accepts packets that are smaller than 1MB. If you get the "Packet for query is too large (max_allowed_packet)" error then see the [[Packet too large error page>>http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html]]. For example to increase the packet size to 32M you could start the MySQL server with {{code}}mysqld --console --max_allowed_packet=32M{{/code}} or you can modify directly the ##my.cnf## configuration file to set this value permanently.
71 +* By default MySQL only accepts packets that are smaller than 1MB. If you get the "Packet for query is too large (max_allowed_packet)" error then see the [[Packet too large error page>>http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html]]. For example to increase the packet size to 32M you could start the MySQL server with {{code language='shell'}}mysqld --console --max_allowed_packet=32M{{/code}} or you can modify directly the ##my.cnf## configuration file to set this value permanently.
72 72  * If an empty XWiki starts with no errors, but you are unable to upload the default set of pages (XAR file) try to increase the ##max_allowed_packet## parameter as shown above.
73 73  {{/info}}
74 74  )))

Get Connected