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