Summary

• Page properties (1 modified, 0 added, 0 removed)
• Objects (0 modified, 0 added, 1 removed)
  • XWiki.XWikiComments[0]

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,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:
	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	20	<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
21	21	<property name="connection.username">xwiki</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