Re: [xwiki-users] XE Installation with PostgreSQL or HSQLDB Succeeds. With MySQL Fails.

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&amp;useUnicode=true&amp;\ characterEncoding=UTF-8&amp;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. _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users