[xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB
Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost. Cheers Sebastian -- View this message in context: http://xwiki.475771.n2.nabble.com/HTTP-500-war-installation-with-Jetty-and-H... Sent from the XWiki- Users mailing list archive at Nabble.com.
Sebastian, the log was not included. Can it be you made it an attachment? Make it part of the text. I believe that your lack of setup of hsqldb is correct; that's the way this DB is meant to work. Error 500, however, is the generic thing. WIthout the log, we can't say much. paul
s.schafer <mailto:[email protected]> 27 septembre 2015 20:07 Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Cheers
Sebastian
-- View this message in context: http://xwiki.475771.n2.nabble.com/HTTP-500-war-installation-with-Jetty-and-H... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi Sebastian, On 27 Sep 2015 at 20:07:53, s.schafer ([email protected](mailto:[email protected])) wrote:
Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
That looks ok (see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationHSQL). Yes you need to use “/“ in xwiki.properties.
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Missing the logs to know what your problem is. Normally it should be ok Thanks -Vincent
Cheers
Sebastian
Hi, thank you Paul, Vincent for your quick feedback. I inserted the log as raw text in the nabble forum but it looks like it disappeared... I later tried to send the complete browser output text but the message was rejected (~300kB) - so I'll try just sending the first part. I guess usually zipping and attaching the output is not recommended? Here is the browser output/log I get when I request the main page, sorry that it's so long... HTTP ERROR 500 Problem accessing /xwiki/bin/view/Main/. Reason: Server Error Caused by: javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://100.100.100.10:8080/xwiki/bin/view/Main/] at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:816) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1686) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:115) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:137) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1156) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1088) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:119) at org.eclipse.jetty.server.Server.handle(Server.java:517) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:306) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:242) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:245) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:75) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:213) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.execute(ExecuteProduceConsume.java:101) at org.eclipse.jetty.io.ManagedSelector.run(ManagedSelector.java:136) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.lang.Thread.run(Unknown Source) Caused by: com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://100.100.100.10:8080/xwiki/bin/view/Main/] at com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:753) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:695) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:229) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:184) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) ... 45 more Caused by: java.lang.RuntimeException: Failed to located wiki descriptor for alias [100.100.100.10] at org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:69) at org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) at org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) at org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) at org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) at org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) at org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) at org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) at org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:64) at org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) at org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) at org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) at com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:749) ... 49 more Caused by: org.xwiki.wiki.manager.WikiManagerException: Failed to locate XWiki.XWikiServerClass document for wiki alias [100.100.100.10] at org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:128) at org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140) at org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146) at org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:67) ... 61 more Caused by: org.xwiki.query.QueryException: Exception while translating [where doc.object(XWiki.XWikiServerClass).server = :wikiAlias and doc.name like 'XWikiServer%'] XWQL query to the [hql] language. Query statement = [where doc.object(XWiki.XWikiServerClass).server = :wikiAlias and doc.name like 'XWikiServer%'] at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:123) at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:71) at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287) at org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121) ... 64 more Caused by: com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiServerClass] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:978) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:299) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1568) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1615) at com.xpn.xwiki.XWiki.getXClass(XWiki.java:5738) at com.xpn.xwiki.XWiki.getClass(XWiki.java:5751) at com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:491) at org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153) at org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122) at org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37) at org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70) at org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61) at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:90) ... 67 more Caused by: org.hibernate.MappingException: invalid configuration at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2241) at org.hibernate.cfg.Configuration.configure(Configuration.java:2158) at com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.configure(DefaultHibernateSessionFactory.java:132) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:247) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:681) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:842) ... 79 more Caused by: org.xml.sax.SAXParseException; lineNumber: 230; columnNumber: 21; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)". at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.dom4j.io.SAXReader.read(SAXReader.java:465) at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238) ... 84 more Caused by: com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://100.100.100.10:8080/xwiki/bin/view/Main/] at com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:753) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:695) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:229) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:184) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:816) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1686) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:115) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:137) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1156) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1088) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:119) at org.eclipse.jetty.server.Server.handle(Server.java:517) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:306) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:242) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:245) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:75) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:213) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.execute(ExecuteProduceConsume.java:101) at org.eclipse.jetty.io.ManagedSelector.run(ManagedSelector.java:136) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.RuntimeException: Failed to located wiki descriptor for alias [100.100.100.10] at org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:69) at org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61) at org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47) at org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51) at org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92) at org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51) at org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61) at org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47) at org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:64) at org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43) at org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93) at org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48) at com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:749) ... 49 more Caused by: org.xwiki.wiki.manager.WikiManagerException: Failed to locate XWiki.XWikiServerClass document for wiki alias [100.100.100.10] at From: Vincent Massol [mailto:[email protected]] On Behalf Of [email protected] Sent: Sunday, September 27, 2015 12:46 PM To: XWiki Users Cc: Sebastian Schafer Subject: Re: [xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB Hi Sebastian, On 27 Sep 2015 at 20:07:53, s.schafer ([email protected](mailto:[email protected])) wrote:
Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
That looks ok (see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationHSQL). Yes you need to use "/" in xwiki.properties.
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Missing the logs to know what your problem is. Normally it should be ok Thanks -Vincent
Cheers
Sebastian
-----Original Message----- From: users [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: Sunday, September 27, 2015 12:36 PM To: XWiki Users Subject: Re: [xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB Sebastian, the log was not included. Can it be you made it an attachment? Make it part of the text. I believe that your lack of setup of hsqldb is correct; that's the way this DB is meant to work. Error 500, however, is the generic thing. WIthout the log, we can't say much. paul
s.schafer <mailto:[email protected]> 27 septembre 2015 20:07 Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Cheers
Sebastian
-- View this message in context: http://xwiki.475771.n2.nabble.com/HTTP-500-war-installation-with-Jetty -and-HSQLDB-tp7596203.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, The error is “Caused by: org.xml.sax.SAXParseException; lineNumber: 230; columnNumber: 21; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)". “ This means that you have modified hibernate.cfg.xml and have made some errors in it (you’re not following the schema). You should verify the changes you’ve brought to this file. Thanks -Vincent On 29 Sep 2015 at 18:26:31, Sebastian Schafer ([email protected](mailto:[email protected])) wrote:
Hi, thank you Paul, Vincent for your quick feedback. I inserted the log as raw text in the nabble forum but it looks like it disappeared... I later tried to send the complete browser output text but the message was rejected (~300kB) - so I'll try just sending the first part. I guess usually zipping and attaching the output is not recommended? Here is the browser output/log I get when I request the main page, sorry that it's so long...
HTTP ERROR 500
Problem accessing /xwiki/bin/view/Main/. Reason:
[snip]
Caused by: org.xml.sax.SAXParseException; lineNumber: 230; columnNumber: 21; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)". at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.dom4j.io.SAXReader.read(SAXReader.java:465) at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238) ... 84 more
[snip]
From: Vincent Massol [mailto:[email protected]] On Behalf Of [email protected] Sent: Sunday, September 27, 2015 12:46 PM To: XWiki Users Cc: Sebastian Schafer Subject: Re: [xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB
Hi Sebastian,
On 27 Sep 2015 at 20:07:53, s.schafer ([email protected](mailto:[email protected])) wrote:
Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
That looks ok (see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationHSQL).
Yes you need to use "/" in xwiki.properties.
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Missing the logs to know what your problem is.
Normally it should be ok
Thanks -Vincent
Cheers
Sebastian
-----Original Message----- From: users [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: Sunday, September 27, 2015 12:36 PM To: XWiki Users Subject: Re: [xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB
Sebastian,
the log was not included. Can it be you made it an attachment? Make it part of the text. I believe that your lack of setup of hsqldb is correct; that's the way this DB is meant to work.
Error 500, however, is the generic thing. WIthout the log, we can't say much.
paul
s.schafer 27 septembre 2015 20:07 Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Cheers
Sebastian
Hi Vincent, thank you for the hint! It works now after starting over with a ‘fresh’ hibernate.cfg.xml from the .war. I was so sure I only did sane changes in that file, but it looks like I was wrong. I guess I was mostly confused by the lack of any configuration for the hsqldb database and thought I must’ve missed something there, seemed too easy : ) Cheers Sebastian From: Vincent Massol [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, September 29, 2015 9:30 AM To: XWiki Users Cc: Sebastian Schafer Subject: Re: [xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB Hi, The error is “Caused by: org.xml.sax.SAXParseException; lineNumber: 230; columnNumber: 21; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)". “ This means that you have modified hibernate.cfg.xml and have made some errors in it (you’re not following the schema). You should verify the changes you’ve brought to this file. Thanks -Vincent On 29 Sep 2015 at 18:26:31, Sebastian Schafer ([email protected](mailto:[email protected]))<mailto:[email protected](mailto:[email protected]))> wrote:
Hi, thank you Paul, Vincent for your quick feedback. I inserted the log as raw text in the nabble forum but it looks like it disappeared... I later tried to send the complete browser output text but the message was rejected (~300kB) - so I'll try just sending the first part. I guess usually zipping and attaching the output is not recommended? Here is the browser output/log I get when I request the main page, sorry that it's so long...
HTTP ERROR 500
Problem accessing /xwiki/bin/view/Main/. Reason:
[snip]
Caused by: org.xml.sax.SAXParseException; lineNumber: 230; columnNumber: 21; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)". at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.dom4j.io.SAXReader.read(SAXReader.java:465) at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238) ... 84 more
[snip]
From: Vincent Massol [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]> Sent: Sunday, September 27, 2015 12:46 PM To: XWiki Users Cc: Sebastian Schafer Subject: Re: [xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB
Hi Sebastian,
On 27 Sep 2015 at 20:07:53, s.schafer ([email protected](mailto:[email protected]))<mailto:[email protected](mailto:[email protected]))> wrote:
Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
That looks ok (see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationHSQL).
Yes you need to use "/" in xwiki.properties.
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Missing the logs to know what your problem is.
Normally it should be ok
Thanks -Vincent
Cheers
Sebastian
-----Original Message----- From: users [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: Sunday, September 27, 2015 12:36 PM To: XWiki Users Subject: Re: [xwiki-users] HTTP 500 - war installation with Jetty and HSQLDB
Sebastian,
the log was not included. Can it be you made it an attachment? Make it part of the text. I believe that your lack of setup of hsqldb is correct; that's the way this DB is meant to work.
Error 500, however, is the generic thing. WIthout the log, we can't say much.
paul
s.schafer 27 septembre 2015 20:07 Hi all, I'm new with xwiki and need help before I go crazy here. I just tried to install the 'proper' .war installation after a being happy with the xwiki standalone installation. The main reason to switch is not performance (it'll be a small wiki), but the fact that I can't seem to run it as a service and it stopped running after not being logged on for a couple of days. Back to topic... I chose what seemed like the easiest path to me from the manual install documentation: Jetty (9.3.3) + HSQLDB (2.3.3) + xwiki (7.2) on Windows server 2008 R2 (don't have a choice of using something else there) I think my problem is an utter lack of knowledge of how to configure jetty+hsqldb. The good news is that I get to the xwiki initialization screen when I access hostname:8080/xwiki/ Bad news is that it throws a http 500 error once it's done initializing, see the log below. Here is what I did: I literally wet by the documentation and I suspect that I'm missing the part where I define the hsqldb setup (db location and connection): - extracted jetty in a folder - extracted the xwiki 7.2 .war file into the webapps subfolder in jetty - copied the hsqldb.jar file in the WEB-INF/lib subfolder in xwiki - uncommented the HSQLDB part in the hibernate.cfg.xml - set the directory to environment.permanentDirectory="E:/Data/Wiki/data/" in xwiki.properties; I used unix-like path even though I'm on windows. Using \ instead of / did not work either
I did not set up a database, user, etc for hsqldb, is that my problem? The documentation made it sound like this is not necessary. I would really appreciate any input because I started over again a few times already and am lost.
Cheers
Sebastian
participants (4)
-
Paul Libbrecht -
s.schafer -
Sebastian Schafer
-
vincent＠massol.net