<
From version < 32.1 >
edited by Paul Libbrecht
on 2015/08/17
To version < 32.3 >
edited by Douglas Landau
on 2017/01/06
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.polx
1 +XWiki.dkl
Content
... ... @@ -14,7 +14,7 @@
14 14  
15 15  == MySQL versions older than 5.0 ==
16 16  
17 -XWiki does not fully work with MySQL versions 4.x or lower, due to several limitations of the way the SQL standards are implemented in MySQL, limited support for non-latin1 encodings, the flaky integration of Hibernate and MySQL 4, and other things. Most parts of the application work fine, but there are some parts that cannot be easily fixed, so if you must use MySQL 4.x, you're doing it on your own. MySQL 4 is pretty old and buggy so I recommend upgrading.
17 +XWiki does not fully work with MySQL versions 4.x or lower, due to several limitations of the way the SQL standards are implemented in MySQL, limited support for non-latin1 encodings, the flaky integration of Hibernate and MySQL 4, and other things. Most parts of the application work fine, but there are some parts that cannot be easily fixed, so if you must use MySQL 4.x, you're doing it on your own. MySQL 4 is pretty old and buggy so we recommend upgrading.
18 18  
19 19  = Installation Steps =
20 20  
... ... @@ -22,7 +22,8 @@
22 22  
23 23  * Download and install [[MySQL>>http://www.mysql.com/]] 5.x or greater.
24 24  * Start the MySQL server. You can do that in several ways. For example use {{code}}mysqld --console{{/code}}
25 -* 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.((( You can create the database in several ways. For example use:
25 +* 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.(((
26 +You can create the database in several ways. For example use:
26 26  
27 27  {{code}}
28 28  mysql -u root -e "create database xwiki default character set utf8 collate utf8_bin"
... ... @@ -33,6 +33,8 @@
33 33  mysql -u root -e "grant all privileges on *.* to xwiki@localhost identified by 'xwiki'"
34 34  {{/code}}
35 35  )))
37 +* If the above command fails because the password does not meet requirements, uninstall the password_validate plugin:
38 +{{code}}mysql -u root -p -e "uninstall plugin validate_password;"{{/code}}
36 36  * Please make sure that the DNS-name "localhost" is defined in your hosts-file (i.e. ##/etc/hosts##)
37 37  * You need to have the MySQL JDBC Driver JAR (named ##mysql-connector-java*.jar##) installed in XWiki's WAR file. If this file isn't present in XWiki's ##WEB-INF/lib## directory you'll need to download it and copy it there. You can download it from the [[MySQL Connector/J Driver page>>http://www.mysql.com/downloads/connector/j/]] or directly from the [[Maven Central Repository>>http://repo1.maven.org/maven2/mysql/mysql-connector-java/]].(((
38 38  {{warning}}
... ... @@ -40,13 +40,15 @@
40 40  {{/warning}}
41 41  )))
42 42  * Now you need to tell XWiki to use MySQL. To do this, edit the ##WEB-INF/hibernate.cfg.xml## file where you have expanded the XWiki WAR file and replace the matching properties with the following ones:(((
43 -{{code language="xml"}}<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
46 +{{code language="xml"}}
47 +<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
44 44  <property name="connection.username">xwiki</property>
45 45  <property name="connection.password">xwiki</property>
46 46  <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
47 47  <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
48 48  <property name="connection.useUnicode">true</property>
49 -<property name="connection.characterEncoding">UTF-8</property>{{/code}}
53 +<property name="connection.characterEncoding">UTF-8</property>
54 +{{/code}}
50 50  
51 51  {{info}}
52 52  * 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.
... ... @@ -224,6 +224,7 @@
224 224  If this is the case [[you need to tell XWiki that you're using a different schema by setting the ##xwiki.db## configuration property>>AdminGuide.Configuration#HConfigurethenamesofdatabaseschemas]].
225 225  
226 226  == MySQLSyntaxErrorException: Row size too large (> 8126) ==
232 +
227 227  if you get the following error:
228 228  
229 229  {{code language="none"}}

Get Connected