All working now, top man. Thanks for your help.
Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Marius Dumitru Florea Sent: 28 March 2013 18:03 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki On Thu, Mar 28, 2013 at 7:35 PM, Hirji Patel <[email protected]> wrote: > Here is the Hibernate,cfg.xml file. > > <?xml version="1.0" encoding="UTF-8"?> > > <!-- > * See the NOTICE file distributed with this work for additional > * information regarding copyright ownership. > * > * This is free software; you can redistribute it and/or modify it > * under the terms of the GNU Lesser General Public License as > * published by the Free Software Foundation; either version 2.1 of > * the License, or (at your option) any later version. > * > * This software is distributed in the hope that it will be useful, > * but WITHOUT ANY WARRANTY; without even the implied warranty of > * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU > * Lesser General Public License for more details. > * > * You should have received a copy of the GNU Lesser General Public > * License along with this software; if not, write to the Free > * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA > * 02110-1301 USA, or see the FSF site: http://www.fsf.org. > --> > > <!DOCTYPE hibernate-configuration PUBLIC > "-//Hibernate/Hibernate Configuration DTD//EN" > "http://www.hibernate.org/dtd/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="connection.pool_size">2</property> > <property name="statement_cache.size">2</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> > > <!-- DBCP Connection Pooling configuration Comment opened but never closed. > > <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.maxWait">120000</property> > <property name="dbcp.ps.maxIdle">20</property> > <property > name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionPro > vider</property> > > <!-- Setting dbcp.ps.maxActive configuration tells DBCP whether to cache > Prepared Statement or not. > > Note 1: When using HSQLDB for example, it's important to NOT cache > prepared statements because HSQLDB > Prepared Statements (PS) contain the schema on which they were > initially created and thus when switching > schema if the same PS is reused it'll execute on the wrong schema! > Since HSQLDB does internally cache > prepared statement there's no performance loss. see > http://jira.xwiki.org/browse/XWIKI-1740. > Thus we recommend not turning on this configuration for > HSQLDB unless you know what you're doing :) > > Note 2: The same applies to PostGreSQL. > --> > > <!-- BoneCP Connection Pooling configuration. > <property name="bonecp.idleMaxAgeInMinutes">240</property> > <property name="bonecp.idleConnectionTestPeriodInMinutes">60</property> > <property name="bonecp.partitionCount">3</property> > <property name="bonecp.acquireIncrement">10</property> > <property name="bonecp.maxConnectionsPerPartition">60</property> > <property name="bonecp.minConnectionsPerPartition">20</property> > <property name="bonecp.statementsCacheSize">50</property> > <property name="bonecp.releaseHelperThreads">3</property> > <property > name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> > --> > > > <!-- Configuration for the default database. Comment opened but never closed. > Comment out this section and uncomment other sections below if you > want to use another database. > Note that the database tables will be created automatically if they > don't already exist. > > <property > name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property> > <property name="connection.username">sa</property> > <property name="connection.password"></property> > <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> > <property name="dialect">org.hibernate.dialect.HSQLDialect</property> > <mapping resource="xwiki.hbm.xml"/> > <mapping resource="feeds.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > > <!-- MySQL configuration. > Uncomment if you want to use MySQL and comment out other database > configurations. > --> <property > name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property> > <property name="connection.username">admin1</property> > <property name="connection.password">admin1</property> > <property name="connection.driver_class">com.mysql.jdbc.Driver</property> > <property > name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> > <property name="dbcp.ps.maxActive">20</property> > <mapping resource="xwiki.hbm.xml"/> > <mapping resource="feeds.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> Badly closed comment. No matching open comment. Hope this helps, Marius > > <!-- HSQLDB configuration. > Uncomment if you want to use HSQLDB and comment out other database > configurations. > <property > name="connection.url">jdbc:hsqldb:file:/some/path/xwikidb;shutdown=true</property> > <property name="connection.username">sa</property> > <property name="connection.password"></property> > <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> > <property name="dialect">org.hibernate.dialect.HSQLDialect</property> > <mapping resource="xwiki.hbm.xml"/> > <mapping resource="feeds.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > <!-- PostgreSQL configuration. > Uncomment if you want to use PostgreSQL and comment out other > database configurations. > Notes: > - "jdbc.use_streams_for_binary" needs to be set to "false", > see > https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 > - "xwiki.virtual_mode" can be set to either "schema" or > "database". Note that currently the database mode > doesn't support database creation (see > http://jira.xwiki.org/browse/XWIKI-8753) > > <property name="connection.url">jdbc:postgresql:xwiki</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property name="connection.driver_class">org.postgresql.Driver</property> > <property > name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> > <property name="jdbc.use_streams_for_binary">false</property> > <property name="xwiki.virtual_mode">schema</property> > <mapping resource="xwiki.postgresql.hbm.xml"/> > <mapping resource="feeds.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > <!-- Oracle configuration. > Uncomment if you want to use Oracle and comment out other database > configurations. > Notes: > - the 2 properties named "connection.SetBigStringTryClob" and > "jdbc.batch_size". They are required to tell Oracle to allow > CLOBs larger than 32K. > - "jdbc.use_streams_for_binary" needs to be set to "false", > see > https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 > > <property > name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property > name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> > <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> > <property name="connection.SetBigStringTryClob">true</property> > <property name="jdbc.batch_size">0</property> > <property name="jdbc.use_streams_for_binary">false</property> > <property name="dbcp.ps.maxActive">20</property> > <mapping resource="xwiki.oracle.hbm.xml"/> > <mapping resource="feeds.oracle.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > <!-- Derby configuration. > Uncomment if you want to use Derby and comment out other database > configurations. > <property > name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> > <property > name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> > <property name="dialect">org.hibernate.dialect.DerbyDialect</property> > <property name="dbcp.ps.maxActive">20</property> > <mapping resource="xwiki.derby.hbm.xml"/> > <mapping resource="feeds.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > </session-factory> > </hibernate-configuration> > > Thanks, > Hirji > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Sergiu Dumitriu > Sent: 28 March 2013 17:33 > To: XWiki Users > Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki > > On 03/28/2013 12:50 PM, Hirji Patel wrote: >> I have made that change and still no joy. >> >> Same error... about Wrapped Exception: Could not parse configuration: >> /WEB-INF/hibernate.cfg.xml >> >> Is my hibernate.cfg.xml configured correctly? > > If it's a parsing error, then something is syntactically wrong in the file. > Look for a stray <!-- or --> in it. Can you pastebin the whole contents of > the file? > >> Regards, >> Hirji >> >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] On >> Behalf Of Dmitry Bakbardin >> Sent: 28 March 2013 16:43 >> To: XWiki Users >> Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki >> >> Hi, Hirji! >> >> There is a parameter xwiki.db in xwiki.cfg. >> You used non-standard (xwiki) DB name, so you need to tell XWiki to use it: >> xwiki.db=xwiki_db >> >> Restart XWiki. Most probably should work >> >> >> Четверг, 28 марта 2013, 16:28 UTC от "Hirji Patel" <[email protected]>: >>> Hello, >>> >>> I'm still finding it difficult to get my xwiki working, can anyone >>> help me. >>> >>> I have installed MySQL, created DB using command "Create Database >>> xwiki_db;" >>> Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" >>> Copyied Xwiki*.war files in to "C:\Program >>> Files\Tomcat_Home\webapps\Xwiki" >>> Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders >>> >>> I have configured the hibernate.cfg.xml but it does not work keep >>> getting error: >>> >>> javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error >>> number 3 in 0: Could not initialize main XWiki context Wrapped >>> Exception: Error number 3202 in 3: Exception while reading document >>> [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse >>> configuration: >>> /WEB-INF/hibernate.cfg.xml >>> >>> Hibernate.cfg.xml >>> >>> <property >>> name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepS >>> t >>> mt s >>> =false&useUnicode=true&characterEncoding=UTF-8</property> >>> <property name="connection.username">admin1</property> >>> <property name="connection.password">admin1</property> >>> <property >>> name="connection.driver_class">com.mysql.jdbc.Driver</property> >>> <property >>> name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> >>> <property name="dbcp.ps.maxActive">20</property> >>> <mapping resource="xwiki.hbm.xml"/> >>> <mapping resource="feeds.hbm.xml"/> >>> <mapping resource="activitystream.hbm.xml"/> >>> >>> Not sure what im doing wrong, can someone help me configure xml file. >>> >>> Many thanks, >>> Hirji >>> >>> -----Original Message----- >>> From: [email protected] [mailto:[email protected]] On >>> Behalf Of Paul Libbrecht >>> Sent: 22 March 2013 14:45 >>> To: XWiki Users >>> Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki >>> >>> Hirji, >>> >>> please also look in your log (by default in Tomcat, >>> conf/catalina.out) to see the detailed error report about the hibernate >>> file. >>> The "web-facing" error you report does not provide a line number, >>> for example, if the error can be attributed to a line (e.g. a wrong >>> tag closing). >>> >>> paul >>> >>> >>> On 22 mars 2013, at 14:41, Sorin Burjan wrote: >>> >>>> org.hibernate. >>>> HibernateException: Could not parse configuration: >>>> /WEB-INF/hibernate.cfg.xml >>>> >>>> Seems you had an invalid configuration of hibernate file. It can't >>>> be properly parsed. >>>> Also make sure you put the MySQL JDBC driver in /lib folder from >>>> XWiki >>>> >>>> Sorin B. >>>> >>>> >>>> On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel < >>>> [email protected] >>>>> >>> wrote: >>>> >>>>> Hi, >>>>> >>>>> After installing TomCat7 + Mysql. >>>>> Created blank DB in mysql. >>>>> Configured hibernate.cfg.xml >>>>> >>>>> But now I get error below. Not sure what I'm doing wrong. >>>>> Xml file attached. >>>>> >>>>> HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: >>>>> Could not initialize main XWiki context >>>>> >>>>> ------------------------------------------------------------------ >>>>> - >>>>> - >>>>> - >>>>> --- >>>>> -------- >>>>> >>>>> type Exception report >>>>> >>>>> message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could >>>>> not initialize main XWiki context >>>>> >>>>> 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 3202 in 3: Exception while reading >>>>> document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse >>>>> configuration: >>>>> /WEB-INF/hibernate.cfg.xml >>>>> >>>>> org.apache.struts.action.RequestProcessor.processException(Request >>>>> P >>>>> r >>>>> o >>>>> ces >>>>> sor.java:535) >>>>> >>>>> org.apache.struts.action.RequestProcessor.processActionPerform(Req >>>>> u >>>>> e >>>>> s >>>>> tPr >>>>> ocessor.java:433) >>>>> >>>>> >>> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>>>> 236) >>>>> >>>>> org.apache.struts.action.ActionServlet.process(ActionServlet.java: >>>>> 1 >>>>> 1 >>>>> 9 >>>>> 6) >>>>> >>>>> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:621) >>>>> >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) >>>>> >>>>> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) >>>>> >>>>> org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi >>>>> o >>>>> n >>>>> F >>>>> ilt >>>>> er.java:144) >>>>> >>>>> >>> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java: >>>>> 66) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter. >>>>> doFilter(SavedRequestRestorerFilter.java:208) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter. >>>>> doFilter(SetCharacterEncodingFilter.java:111) >>>>> >>>>> >>>>> root cause >>>>> >>>>> com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not >>>>> initialize main XWiki context Wrapped Exception: Error number 3202 >>>>> in >>> >>>>> 3: Exception while reading document [xwiki:XWiki.TagClass] Wrapped >>>>> Exception: Could not parse configuration: >>>>> /WEB-INF/hibernate.cfg.xml >>>>> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) >>>>> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) >>>>> >>>>> org.apache.struts.action.RequestProcessor.processActionPerform(Req >>>>> u >>>>> e >>>>> s >>>>> tPr >>>>> ocessor.java:431) >>>>> >>>>> >>> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>>>> 236) >>>>> >>>>> org.apache.struts.action.ActionServlet.process(ActionServlet.java: >>>>> 1 >>>>> 1 >>>>> 9 >>>>> 6) >>>>> >>>>> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:621) >>>>> >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) >>>>> >>>>> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) >>>>> >>>>> org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi >>>>> o >>>>> n >>>>> F >>>>> ilt >>>>> er.java:144) >>>>> >>>>> >>> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java: >>>>> 66) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter. >>>>> doFilter(SavedRequestRestorerFilter.java:208) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter. >>>>> doFilter(SetCharacterEncodingFilter.java:111) >>>>> >>>>> >>>>> root cause >>>>> >>>>> com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception >>>>> while >>> >>>>> reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could >>>>> not parse configuration: >>>>> /WEB-INF/hibernate.cfg.xml >>>>> >>>>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernat >>>>> e >>>>> S >>>>> t >>>>> ore >>>>> .java:876) >>>>> >>>>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.j >>>>> a >>>>> v >>>>> a >>>>> :29 >>>>> 0) >>>>> com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) >>>>> com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) >>>>> com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) >>>>> com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) >>>>> com.xpn.xwiki.XWiki.<init>(XWiki.java:739) >>>>> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) >>>>> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) >>>>> >>>>> org.apache.struts.action.RequestProcessor.processActionPerform(Req >>>>> u >>>>> e >>>>> s >>>>> tPr >>>>> ocessor.java:431) >>>>> >>>>> >>> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>>>> 236) >>>>> >>>>> org.apache.struts.action.ActionServlet.process(ActionServlet.java: >>>>> 1 >>>>> 1 >>>>> 9 >>>>> 6) >>>>> >>>>> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:621) >>>>> >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) >>>>> >>>>> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) >>>>> >>>>> org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi >>>>> o >>>>> n >>>>> F >>>>> ilt >>>>> er.java:144) >>>>> >>>>> >>> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java: >>>>> 66) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter. >>>>> doFilter(SavedRequestRestorerFilter.java:208) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter. >>>>> doFilter(SetCharacterEncodingFilter.java:111) >>>>> >>>>> >>>>> root cause >>>>> >>>>> org.hibernate.HibernateException: Could not parse configuration: >>>>> /WEB-INF/hibernate.cfg.xml >>>>> >>>>> org.hibernate.cfg.Configuration.doConfigure(Configuration.java:224 >>>>> 6 >>>>> ) >>>>> >>>>> org.hibernate.cfg.Configuration.configure(Configuration.java:2158) >>>>> >>>>> com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.con >>>>> f >>>>> i >>>>> g >>>>> ure >>>>> (DefaultHibernateSessionFactory.java:105) >>>>> >>>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHib >>>>> e >>>>> r >>>>> n >>>>> ate >>>>> BaseStore.java:211) >>>>> >>>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHi >>>>> b >>>>> e >>>>> r >>>>> nat >>>>> eBaseStore.java:607) >>>>> >>>>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernat >>>>> e >>>>> S >>>>> t >>>>> ore >>>>> .java:749) >>>>> >>>>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.j >>>>> a >>>>> v >>>>> a >>>>> :29 >>>>> 0) >>>>> com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) >>>>> com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) >>>>> com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) >>>>> com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) >>>>> com.xpn.xwiki.XWiki.<init>(XWiki.java:739) >>>>> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) >>>>> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) >>>>> >>>>> org.apache.struts.action.RequestProcessor.processActionPerform(Req >>>>> u >>>>> e >>>>> s >>>>> tPr >>>>> ocessor.java:431) >>>>> >>>>> >>> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>>>> 236) >>>>> >>>>> org.apache.struts.action.ActionServlet.process(ActionServlet.java: >>>>> 1 >>>>> 1 >>>>> 9 >>>>> 6) >>>>> >>>>> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:621) >>>>> >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) >>>>> >>>>> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) >>>>> >>>>> org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi >>>>> o >>>>> n >>>>> F >>>>> ilt >>>>> er.java:144) >>>>> >>>>> >>> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java: >>>>> 66) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter. >>>>> doFilter(SavedRequestRestorerFilter.java:208) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter. >>>>> doFilter(SetCharacterEncodingFilter.java:111) >>>>> >>>>> >>>>> root cause >>>>> >>>>> org.dom4j.DocumentException: Error on line 47 of document : A >>>>> DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is >>>>> not >>> >>>>> allowed in content. >>>>> org.dom4j.io.SAXReader.read(SAXReader.java:482) >>>>> >>>>> org.hibernate.cfg.Configuration.doConfigure(Configuration.java:223 >>>>> 8 >>>>> ) >>>>> >>>>> org.hibernate.cfg.Configuration.configure(Configuration.java:2158) >>>>> >>>>> com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.con >>>>> f >>>>> i >>>>> g >>>>> ure >>>>> (DefaultHibernateSessionFactory.java:105) >>>>> >>>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHib >>>>> e >>>>> r >>>>> n >>>>> ate >>>>> BaseStore.java:211) >>>>> >>>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHi >>>>> b >>>>> e >>>>> r >>>>> nat >>>>> eBaseStore.java:607) >>>>> >>>>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernat >>>>> e >>>>> S >>>>> t >>>>> ore >>>>> .java:749) >>>>> >>>>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.j >>>>> a >>>>> v >>>>> a >>>>> :29 >>>>> 0) >>>>> com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) >>>>> com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) >>>>> com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) >>>>> com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) >>>>> com.xpn.xwiki.XWiki.<init>(XWiki.java:739) >>>>> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) >>>>> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) >>>>> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) >>>>> >>>>> org.apache.struts.action.RequestProcessor.processActionPerform(Req >>>>> u >>>>> e >>>>> s >>>>> tPr >>>>> ocessor.java:431) >>>>> >>>>> >>> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>>>> 236) >>>>> >>>>> org.apache.struts.action.ActionServlet.process(ActionServlet.java: >>>>> 1 >>>>> 1 >>>>> 9 >>>>> 6) >>>>> >>>>> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:621) >>>>> >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) >>>>> >>>>> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) >>>>> >>>>> org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi >>>>> o >>>>> n >>>>> F >>>>> ilt >>>>> er.java:144) >>>>> >>>>> >>> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java: >>>>> 66) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter. >>>>> doFilter(SavedRequestRestorerFilter.java:208) >>>>> >>>>> >>> org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter. >>>>> doFilter(SetCharacterEncodingFilter.java:111) >>>>> >>>>> >>>>> note The full stack trace of the root cause is available in the >>>>> Apache >>>>> Tomcat/7.0.37 logs. >>>>> >>>>> >>>>> ------------------------------------------------------------------ >>>>> - >>>>> - >>>>> - >>>>> --- >>>>> -------- >>>>> >>>>> Apache Tomcat/7.0.37 >>>>> >>>>> >>>>> Regards, >>>>> Hirji >>>>> >>>>> >>>>> -----Original Message----- >>>>> From: [email protected] [mailto:[email protected]] On >>>>> Behalf Of Thomas Mortagne >>>>> Sent: 20 March 2013 17:21 >>>>> To: XWiki Users >>>>> Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki >>>>> >>>>> You should follow >>>>> >>>>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWA >>>>> R >>>>> >>>>> >>>>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTo >>>>> m >>>>> c >>>>> a >>>>> t >>>>> is just one step >>>>> >>>>> On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel < >>>>> [email protected] > >>>>> wrote: >>>>>> Hi, >>>>>> >>>>>> Just installed Tomcat + Xwiki using link below, but it does not >>>>>> tell >>> >>>>>> me to install MySQL? Its telling me to install Nginx, should I be >>>>>> doing this? >>>>>> >>>>>> >>>>>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationT >>>>>> o >>>>>> m >>>>>> c >>>>>> at >>>>>> #H >>>>>> InstallationSteps >>>>>> >>>>>> This is what I have done so far... >>>>>> >>>>>> Windows 2008 server. >>>>>> Created folder in c:\Tomcat_Home (copied files from Zip) Created >>>>>> folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War >>>>>> file) >>>>>> >>>>>> What's Next.. to get my xwiki going? >>>>>> Install Mysql? >>>>>> >>>>>> Regards, >>>>>> Hirji >>>>>> >>>>>> -----Original Message----- >>>>>> From: [email protected] [mailto:[email protected]] >>>>>> On Behalf Of Hirji Patel >>>>>> Sent: 20 March 2013 16:39 >>>>>> To: XWiki Users >>>>>> Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki >>>>>> >>>>>> Thank you for helping me out here. >>>>>> >>>>>> Xwiki will be in production with large files. >>>>>> >>>>>> 15000 Pages... that's a lot of pages... ours will be much less >>>>>> then that. >>>>>> So Tomcat sounds good, but dot sure what you mean by filesystem >>>>>> attachments? How does that work or can that be done at later >>>>>> stage with Tomcat + MySQL? >>>>>> >>>>>> Regards, >>>>>> Hirji >>>>>> >>>>>> >>>>>> -----Original Message----- >>>>>> From: [email protected] [mailto:[email protected]] >>>>>> On Behalf Of Sorin Burjan >>>>>> Sent: 20 March 2013 16:23 >>>>>> To: XWiki Users >>>>>> Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki >>>>>> >>>>>> Hi, >>>>>> >>>>>> At the moment the safest way to go is Tomcat + MySQL. If you go >>>>>> with >>> >>>>>> Tomcat, make sure you set it to use UTF8 encoding, since the >>>>>> default >>> >>>>>> configuration of Tomcat is not UTF8. >>>>>> The standalone jetty+hsqldb is not good in production/large >>>>>> wikis because it uses an in memory hsqldb database, meaning that >>>>>> all your database is loaded at startup into your RAM memory. >>>>>> >>>>>> Regards, >>>>>> Sorin B. >>>>>> >>>>>> >>>>>> On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < >>>>>> [email protected] > wrote: >>>>>> >>>>>>> You didn't tell us if this wiki will be in production (ie, >>>>>>> available to many users, requiring to be up most of the time, >>>>>>> with proper backup >>>>>> >>>>>>> of data, etc...) or if it's only a test wiki for you, for example. >>>>>>> If it's only for tests, the standalone wiki with jetty + hsqldb >>>>>>> is good enough, for production jetty is not recommended by xwiki >>>>>>> I >>>>>> believe. >>>>>>> I can only give you a personal feedback : I have a wiki (in >>>>>>> production) with Tomcat 6 + MySql 5.1, with db attachments. The >>>>>>> wiki has around 15000 pages now, and 1,6Go of attachments >>>>>>> content in db (including all versions of course). I plan to move >>>>>>> to filesystem attachments, because during the course and >>>>>>> upgrades (this wiki started >>>>>> >>>>>>> several years ago with version 0.9), some attachments got >>>>>>> corrupted >>> >>>>>>> for any reason, and it might be easier to avoid/detect/repair >>>>>>> with >>>>>> filesystem based attachments than db. >>>>>>> Apart from that, it works pretty well. >>>>>>> >>>>>>> I don't think servlet container will have a big impact on the >>>>>>> way big >>>>> >>>>>>> attachments are managed, apart from possible limitations >>>>>>> specific to each container if they exist. The link I provided >>>>>>> gives you what >>> >>>>>>> is supported by xwiki, and with what it has been tested, but we >>>>>>> can't decide for you what container or rdbms to choose in the >>>>>>> end >>>>>>> :-) >>>>>>> >>>>>>> BR, >>>>>>> Jeremie >>>>>>> >>>>>>> >>>>>>> 2013/3/20 Hirji Patel < [email protected] > >>>>>>> >>>>>>>> Thanks, >>>>>>>> >>>>>>>> Which Servlet Container should I be using? >>>>>>>> >>>>>>>> My DB will have large attachments and images. >>>>>>>> >>>>>>>> Regards, >>>>>>>> H >>>>>>>> >>>>>>>> -----Original Message----- >>>>>>>> From: [email protected] [mailto:[email protected]] >>>>>>>> On Behalf Of Eugen Colesnicov >>>>>>>> Sent: 20 March 2013 13:46 >>>>>>>> To: [email protected] >>>>>>>> Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki >>>>>>>> >>>>>>>> Recommendations about DB & Container depend on Your scenario of >>>>>>>> XWiki using ... For example, if you will have many and large >>>>>>>> attachments - need to switch XWiki to "file-system attachments >>>>>>>> storage" or to use another database (not MySQL) - this is my >>>>>> opinion. >>>>>>>> >>>>>>>> My experience with big attachments - from the begging I have >>>>>>>> Windows >>>>>> >>>>>>>> + Glassfish + Oracle (attachments stored in DB), after I >>>>>>>> + migrated >>>>>>>> for Linux + MySQL + Tomcat, but with file-system attachments >>>>>>>> storage >>>>>> >>>>>>>> - and right now I prefer this variant - more speed and "lightness" >>>>>> ... >>>>>>>> >>>>>>>> But, in any case, Your selection is not bad variant for >>>>>>>> production >>> >>>>>>>> using (for example comparative to other java servlets). Also >>>>>>>> you should understand, that XWiki - it is not a BIG-BIG system, >>>>>>>> for example, likes MS SharePoint. Same results & more speed you >>>>>>>> can get >>>>> >>>>>>>> with more simple hardware & software... >>>>>>>> >>>>>>>> -- >>>>>>>> Best regards >>>>>>>> Eugen Colesnicov >>>>>>>> > > > -- > Sergiu Dumitriu > http://purl.org/net/sergiu > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > > ______________________________________________________________________ > __ This e-mail has been scanned for all viruses by Star. The service > is powered by MessageLabs. For more information on a proactive anti-virus > service working around the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________________ > __ > > ______________________________________________________________________ > __ This e-mail has been scanned for all viruses by Star. The service > is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________________ > __ _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
