[xwiki-users] Tomcat error: 500 Could not initialize main XWiki context

Hi, I'm trying to install XWiki on a FreeBSD 8.0 x64 server and so far I've managed to get all the necessary components installed. It took me quite a bit of digging to get this far as most examples and guides are built for either Windows or Linux. Anyway, I took a look and adapted these resources: ############################################## http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat http://www.calebscreek.com/2010/07/how-to-install-apache-tomcat-6-on-freebs… http://www.xwiki.org/xwiki/bin/view/Main/Download http://www.yoursoftcopy.com/xwiki-install/xwiki-install.html http://www.howtoforge.com/xwiki-tomcat-mysql-debian-etch http://www.mydigitallife.info/2006/04/13/installing-web-server-in-freebsd-6… http://wiki.freebsd.org/AppserverJailsHOWTO http://dev.mysql.com/doc/refman/5.1/en/adding-users.html http://www.pubbs.net/200911/xwiki/44724-xwiki-users-could-not-initialize-ma… http://lists.xwiki.org/pipermail/users/2007-November/009312.html ############################################## Basically the log file claims this: 2010-08-07 08:30:17,253 [EvictionTimer-3] WARN eviction.EvictionTimerTask - Eviction task encountered an unexpected error java.lang.NullPointerException at org.apache.log4j.Category.isEnabledFor(Category.java:749) at org.apache.commons.logging.impl.Log4JLogger.isTraceEnabled(Log4JLogger.java:333) at org.jboss.cache.eviction.EvictionTimerTask.processRegions(EvictionTimerTask.java:102) at org.jboss.cache.eviction.EvictionTimerTask.access$100(EvictionTimerTask.java:42) at org.jboss.cache.eviction.EvictionTimerTask$Task.run(EvictionTimerTask.java:135) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) My prerequisites for building XWiki are these: Tomcat 6.0.29 Mysql-server 5.1.49 diablo-latte-freebsd7-amd64-1.6.0_07-b02.tar.bz2 tzupdater-1_3_29-2010f.zip mysql-connector-java-5.1.5 The error on the html page in the browser claims there's an issue with my hibernate.cfg.xml file which looks like this when all comments have been removed: wiki# cat hibernate.cfg.xml <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) --> <!-- Generic parameters common to all Databases --> <property name="show_sql">false</property> <property name="use_outer_join">true</property> <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxActive">20</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. --> <property name="jdbc.use_scrollable_resultset">false</property> <property name="connection.url">jdbc:mysql://127.0.0.1/xwiki?useServerPrepStmts=false</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</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"/> <mapping resource="activitystream.hbm.xml"/> Also I created a few additions in /usr/local/apache-tomcat-6.0/conf/catalina.policy: grant codeBase "file:${catalina.base}/webapps/xwiki/-" { permission java.security.AllPermission; permission java.io.FilePermission "${catalina.base}/webapps/xwiki/-", "read,write,delete"; permission java.io.FilePermission "/var/log/tomcat60/-", "read,write"; permission java.io.FilePermission "/WEB-INF/xwiki.cfg", "read"; permission java.io.FilePermission "/WEB-INF/hibernate.cfg.xml", "read"; permission java.lang.reflect.ReflectPermission "suppressAccessChecks"; permission java.util.PropertyPermission "user.name", "read"; permission java.net.SocketPermission "127.0.0.1:3306", "connect,resolve"; }; However am completely stuck now...... I guess the only 2 reasons could be an invalid hibernate.cfg.cml file or the incorrect connector in /usr/local/apache-tomcat-6.0/webapps/xwiki/WEB-INF/lib/ My configuration is most closely based around the howtoforge page specified earlier: http://www.howtoforge.com/xwiki-tomcat-mysql-debian-etch ??? Can anyone help me? Thanks!! Regards, Kaya