Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. VincentMassol1 +XWiki.dkl - Content
-
... ... @@ -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"}}