<
From version < 1.9 >
edited by Vincent Massol
on 2007/01/22
To version < 1.12 >
edited by vmassol
on 2007/09/06
>
Change comment: There is no comment for this version

Summary

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}
XWiki.XWikiComments[0]
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.kiwicmc
Comment
... ... @@ -1,5 +1,0 @@
1 -<property name="connection.url">jdbc:mysql://localhost/xwiki;shutdown=true</property>
2 -
3 -";shutdown=true" appears to be incorrect. Until removed, I saw this exception in the Catalina log
4 -
5 -org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'xwiki'@'127.0.0.1' to database 'xwiki;shutdown=true')
Date
... ... @@ -1,1 +1,0 @@
1 -2007-01-04 02:10:23.0

Get Connected