[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#HInstalling... 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#HInstalland... 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.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) I have attached the full error message report, as well as my current hibernate.cfg.xml file. Thanks, - James Cuzella -------- This e-mail may contain confidential and privileged material for the sole use of the intended recipient. If this email is not intended for you, or you are not responsible for the delivery of this message to the intended recipient, please note that this message may contain SEAKR Engineering (SEAKR) Privileged/Proprietary Information. In such a case, you are strictly prohibited from downloading, photocopying, distributing or otherwise using this message, its contents or attachments in any way. If you have received this message in error, please notify us immediately by replying to this e-mail and delete the message from your mailbox. Information contained in this message that does not relate to the business of SEAKR is neither endorsed by nor attributable to SEAKR.
Hi, To me it seems like you have an error in your hibernate configuration file. Can you post it to this list? Btw I think you can't send attachments to this list, better paste the content itself. - Asiri
On 05/22/2010 01:44 AM, James Cuzella wrote:
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#HInstalling...
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.
You must also add the connector jar in WEB-INF/lib: http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.12/
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#HInstalland... 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 rvlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
I have attached the full error message report, as well as my current hibernate.cfg.xml file.
Attachments are not allowed on the list. -- Sergiu Dumitriu http://purl.org/net/sergiu/
What version of Tomcat are you using? Sent from my BlackBerry® smartphone -----Original Message----- From: Sergiu Dumitriu <[email protected]> Date: Sat, 22 May 2010 11:10:47 To: XWiki Users<[email protected]> Subject: Re: [xwiki-users] Help setting up XWiki in Tomcat container with MySQL on Windows On 05/22/2010 01:44 AM, James Cuzella wrote:
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#HInstalling...
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.
You must also add the connector jar in WEB-INF/lib: http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.12/
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#HInstalland... 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 rvlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
I have attached the full error message report, as well as my current hibernate.cfg.xml file.
Attachments are not allowed on the list. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Sergiu Dumitriu <[email protected]> 5/22/2010 3:10 AM >>> You must also add the connector jar in WEB-INF/lib:
http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.12/ Attachments are not allowed on the list. -- Sergiu Dumitriu http://purl.org/net/sergiu/ Thanks for pointing this out. With all the configuration I had to do setting this up, it was easy to forget that step ;-) I'll remember to post errors in the email body next time too. Thanks, - James Cuzella -------- This e-mail may contain confidential and privileged material for the sole use of the intended recipient. If this email is not intended for you, or you are not responsible for the delivery of this message to the intended recipient, please note that this message may contain SEAKR Engineering (SEAKR) Privileged/Proprietary Information. In such a case, you are strictly prohibited from downloading, photocopying, distributing or otherwise using this message, its contents or attachments in any way. If you have received this message in error, please notify us immediately by replying to this e-mail and delete the message from your mailbox. Information contained in this message that does not relate to the business of SEAKR is neither endorsed by nor attributable to SEAKR.
participants (4)
-
Asiri Rathnayake -
James Cuzella -
Sergiu Dumitriu -
ziggy25＠gmail.com