14 Aug
2009
14 Aug
'09
4:27 p.m.
Currently writing special pages to extend functionality of MediaWiki,
but considering using XWiki instead.
Experimenting with XWiki Enterprise by attempting install of xwiki-
enterprise-web-1.9.3.war:
In Apache Tomcat 5.5.23
Using PostgreSQL 8.4.0 -- Succeeds
Or HSQLDB 1.8.0.7 -- Succeeds
But MySQL 5.0.45 -- Fails.
MySQL is required for XWiki Enterprise Manger, so I need to use MySQL.
I get this error in the browser:
javax.servlet.ServletException: Error number 3 in 0: Could not
initialize main XWiki context Wrapped Exception: Error number 3001 in
3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager
from param xwiki.store.migration.manager.class Wrapped Exception:
Error number 0 in 3: Exception while hibernate execute Wrapped
Exception: Could not create a DBCP pool. There is an error in the
hibernate configuration file, please review it.
I get this additionally in catalina.out:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused
STACKTRACE:
java.net.ConnectException: Connection refused
I have installed mysql-connector-java-5.0.8-bin.jar in /var/lib/
tomcat5/webapps/xwiki/WEB-INF/lib.
I have modified /var/lib/tomcat5/webapps/xwiki/WEB-
INF.hibernate.cfg.xml as follows:
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other
database configurations.
Note that the database will be created automatically if it
doesn't already exist.
We need to set the sql_mode to a less strict value, see
XWIKI-1945
-->
<property name="connection.url">jdbc:mysql://localhost/xwiki?
useServerPrepStmts=false&useUnicode=true&\
characterEncoding=UTF-8&sessionVariables=sql_mode=''</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">PASSWORD</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</
property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</
property>
<property
name
=
"connection
.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
I created an xwiki database and granted privileges in MySQL as follows:
$ mysql -u root -p
mysql> create database xwiki;
mysql> grant all privileges on xwiki.* to xwiki(a)127.0.0.1 identified
by 'xwiki';
mysql> grant all privileges on xwiki.* to xwiki@localhost identified
by 'xwiki';
OR
mysql> create database xwiki;
mysql> grant all privileges on xwiki.* to xwiki(a)127.0.0.1 identified
by 'SAMEASROOT';
mysql> grant all privileges on xwiki.* to xwiki@localhost identified
by 'SAMEASROOT';
Note that PASSWORD in the hibernate.cfg.xml file was set to either
'xwiki', or to the same password as for the root MySQL user, with the
thought that perhaps the Hibernate configuration assumed an empty root
MySQL user password, and that, somehow, this might help.
I then modified /var/lib/tomcat5/webapps/xwiki/WEB-
INF.hibernate.cfg.xml as follows, since this is what the installation
instructions actually show, that is, omitting some MySQL parameters:
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other
database configurations.
Note that the database will be created automatically if it
doesn't already exist.
We need to set the sql_mode to a less strict value, see
XWIKI-1945
-->
<property name="connection.url">jdbc:mysql://localhost/xwiki</
property>
<property name="connection.username">xwiki</property>
<property name="connection.password">PASSWORD</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</
property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</
property>
<property
name
=
"connection
.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
I have tried many permutations and scoured installation instructions,
FAQ, and archives. I definitely need some help here.