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

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?

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?useServerPrepStmt > 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(RequestPr >>> o >>> ces >>> sor.java:535) >>> >>> org.apache.struts.action.RequestProcessor.processActionPerform(Reque >>> s >>> tPr >>> ocessor.java:433) >>> >>> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>> 236) >>> >>> org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 >>> 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(Conversion >>> 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(Reque >>> s >>> tPr >>> ocessor.java:431) >>> >>> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>> 236) >>> >>> org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 >>> 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(Conversion >>> 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(XWikiHibernateS >>> t >>> ore >>> .java:876) >>> >>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav >>> 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(Reque >>> s >>> tPr >>> ocessor.java:431) >>> >>> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>> 236) >>> >>> org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 >>> 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(Conversion >>> 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:2246) >>> >>> org.hibernate.cfg.Configuration.configure(Configuration.java:2158) >>> >>> com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.confi >>> g >>> ure >>> (DefaultHibernateSessionFactory.java:105) >>> >>> com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHiber >>> n >>> ate >>> BaseStore.java:211) >>> >>> com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibe >>> r >>> nat >>> eBaseStore.java:607) >>> >>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS >>> t >>> ore >>> .java:749) >>> >>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav >>> 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(Reque >>> s >>> tPr >>> ocessor.java:431) >>> >>> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>> 236) >>> >>> org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 >>> 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(Conversion >>> 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:2238) >>> >>> org.hibernate.cfg.Configuration.configure(Configuration.java:2158) >>> >>> com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.confi >>> g >>> ure >>> (DefaultHibernateSessionFactory.java:105) >>> >>> com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHiber >>> n >>> ate >>> BaseStore.java:211) >>> >>> com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibe >>> r >>> nat >>> eBaseStore.java:607) >>> >>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS >>> t >>> ore >>> .java:749) >>> >>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav >>> 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(Reque >>> s >>> tPr >>> ocessor.java:431) >>> >>> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: >>> 236) >>> >>> org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 >>> 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(Conversion >>> 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/InstallationWAR >>> >>> >>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomc >>> 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/InstallationTom >>>> 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 >>>>>>