30 Sep
2015
30 Sep
'15
3:16 a.m.
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:vmassol@gmail.com] On Behalf Of vincent(a)massol.net
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
(s.schafer@ssi.samsung.com(mailto:s.schafer@ssi.samsung.com))<mailto:s.schafer@ssi.samsung.com(mailto:s.schafer@ssi.samsung.com))>
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:vmassol@gmail.com] On
Behalf Of vincent@massol.net<mailto:vincent@massol.net>
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
(s.schafer@ssi.samsung.com(mailto:s.schafer@ssi.samsung.com))<mailto:s.schafer@ssi.samsung.com(mailto:s.schafer@ssi.samsung.com))>
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:users-bounces@xwiki.org] 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