<
From version < 1.8 >
edited by Vincent Massol
on 2007/01/17
To version < 1.11 >
edited by Vincent Massol
on 2007/07/10
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,7 @@
1 1  1 MySQL Installation
2 2  
3 -Steps:
3 +Follow these instructions:
4 +
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,9 +15,10 @@
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:
19 +* 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/].
20 +* 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 -<property name="connection.url">jdbc:mysql://localhost/xwiki;shutdown=true</property>
22 +<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
21 21  <property name="connection.username">xwiki</property>
22 22  <property name="connection.password">xwiki</property>
23 23  <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
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
XWiki.XWikiComments[2]
Date
... ... @@ -1,1 +1,1 @@
1 -2007-01-17 14:12:05.97
1 +2007-01-17 14:12:05.0

Get Connected