Re: [xwiki-users] Help setting up XWiki in Tomcat container with MySQL on Windows

Hello, I am trying to set up XWiki on my company's intranet, and have stumbled into some problems with the configuration steps. Initially I'm setting things up locally on my Windows XP desktop to test it out and find out what I need to configure to get it running for production. Hopefully we will be able to install this on a linux server more easily. I have followed the directions here: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HInstallin… I have uncommented the lines in WEB-INF/hibernate.cfg.xml within my XWiki installation relating to MySQL database, and added a database called xwiki with user xwiki@localhost in MySQL.

I added the following permissions for the Java Security Manager to the file C:\Program Files\Apache Software Foundation\Tomcat 6.0\conf\catalina.policy // *** PERMISSIONS FOR XWiki Enterprise as documented at: // http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HInstallan… grant codeBase "file:C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/xwiki-enterprise-web-2.3/WEB-INF/lib/-" { permission java.util.PropertyPermission "file.encoding", "read"; // Needed by Hibernate -> antlr permission java.util.PropertyPermission "ANTLR_DO_NOT_EXIT", "read"; permission java.util.PropertyPermission "ANTLR_USE_DIRECT_CLASS_LOADING", "read"; // Needed by Hibernate and others permission java.lang.reflect.ReflectPermission "suppressAccessChecks"; permission java.lang.RuntimePermission "createClassLoader"; permission java.lang.RuntimePermission "setContextClassLoader"; // Needed by commons-logging permission java.util.PropertyPermission "org.apache.commons.logging.LogFactory.HashtableImpl", "read"; // Needed for connecting to the database permission java.net.SocketPermission "127.0.0.1:3306", "connect,resolve"; // Needed by the scheduler plugin -> quartz, but works without (maybe except scheduling? should be checked) // permission java.util.PropertyPermission "org.quartz.properties", "read"; }; When I point my browser to the install url: http://localhost/xwiki-enterprise-web-2.3, it gives me error messages like: description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: com.xpn.xwiki.XWikiException: 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. org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpSe

I have attached the full error message report, as well as my current hibernate.cfg.xml file.