Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.VincentMassol
	1	+XWiki.vmassol

Content

...	...	@@ -1,6 +1,9 @@
1	1	1 MySQL Installation
2	2
3		-Steps:
	3	+1.1 Installation Steps
	4	+
	5	+Follow these instructions:
	6	+
4	4	* Download and install [MySQL>http://www.mysql.com/]
5	5	** Note that XWiki will not work with MySQL version 4.0 or lower as one library we're using (C3P0) is not compatible with MySQL 4.x.
6	6	* Start the MySQL server. You can do that in several ways. For example:
...	...	@@ -15,7 +15,8 @@
15	15	{code}
16	16	mysql -u root -e "grant all privileges on xwiki.* to xwiki@127.0.0.1 identified by 'xwiki'"
17	17	{code}
18		-* Tell XWiki to use MySQL. To do this, edit the ~~WEB-INF/hibernate.cfg.xml~~ file where you have expanded the XWiki WAR file. Replace the matching properties with the following ones:
	21	+* You need to have the MySQL JDBC Driver JAR (named <tt>mysql-connector-java*.jar</tt> installed in XWiki's WAR file. If this file isn't present in XWiki's <tt>WEB-INF/lib</tt> diredctory 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/products/connector/j/] or directly from the [Maven Central Repository>http://repo1.maven.org/maven2/mysql/mysql-connector-java/].
	22	+* Now you need to tell XWiki to use MySQL. To do this, edit the <tt>WEB-INF/hibernate.cfg.xml</tt> file where you have expanded the XWiki WAR file and replace the matching properties with the following ones:
19	19	{code}
20	20	<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
21	21	<property name="connection.username">xwiki</property>
...	...	@@ -29,3 +29,21 @@
29	29	mysqld --console --max_allowed_packet=32M
30	30	{code}
31	31
	36	+1.1 Troubleshooting
	37	+
	38	+1.1.1 Field 'XWD_ARCHIVE' doesn't have a default value
	39	+
	40	+If you get an error like the one below it probably means you had an old XWiki version installed which had a wrong schema. We're normally automatically fixing schemas at startup when you set the <tt>xwiki.store.hibernate.updateschema</tt> configuration parameter in <tt>xwiki.cfg</tt> (it's set to on by default). However it's currently not done for this error as we need to investigate it more.
	41	+
	42	+{code:none}
	43	+Wrapped Exception: Could not execute JDBC batch update
	44	+[...]
	45	+Wrapped Exception:
	46	+java.sql.BatchUpdateException: Field 'XWD_ARCHIVE' doesn't have a default value
	47	+{code}
	48	+
	49	+To fix this run the following SQL command on your database:
	50	+
	51	+{code:sql}
	52	+alter table xwikidoc modify column XWD_ARCHIVE mediumtext null;
	53	+{code}