Re: [xwiki-users] Tomcat + MySQL + Xwiki

28 Mar 2013

All working now, top man.

Thanks for your help.

Hirji

-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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 &lt;hirji.patel(a)akt-uk.com&gt; 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&amp;useUnicode=true&amp;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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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"
&lt;hirji.patel(a)akt-uk.com&gt;om>:
>>> 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&amp;useUnicode=true&amp;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:  users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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 < 
>>>> hirji.patel(a)akt-uk.com
>>>>>
>>> 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:  users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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 < 
>>>>> hirji.patel(a)akt-uk.com >
>>>>> 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:  users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 
>>>>>> 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:  users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 
>>>>>> 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 < 
>>>>>> jeremie.bousquet(a)gmail.com > 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 < hirji.patel(a)akt-uk.com >
>>>>>>>
>>>>>>>> Thanks,
>>>>>>>>
>>>>>>>> Which Servlet Container should I be using?
>>>>>>>>
>>>>>>>> My DB will have large attachments and images.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> H
>>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From:  users-bounces(a)xwiki.org
[mailto:users-bounces@xwiki.org] 
>>>>>>>> On Behalf Of Eugen Colesnicov
>>>>>>>> Sent: 20 March 2013 13:46
>>>>>>>> To:  users(a)xwiki.org
>>>>>>>> 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
> users(a)xwiki.org
> 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
> users(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
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
________________________________________________________________________

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Re: [xwiki-users] Tomcat + MySQL + Xwiki