Re: [xwiki-users] Help setting up XWiki in Tomcat container with MySQL on Windows
>>> Sergiu Dumitriu 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. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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#HInstallingtheXWikiWARmanually > > 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 xw...@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#HInstallandconfigureaServletContainer > 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Help setting up XWiki in Tomcat container with MySQL on Windows
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 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[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#HInstallingtheXWikiWARmanually 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 xw...@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#HInstallandconfigureaServletContainer 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. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users