AW: [opencms-dev] MySQL initialization error

Petr Hollay ph at ethikom.de
Mon Feb 9 12:12:01 CET 2004 

Hi,

problem seems to be in encoding, not in database - see below in your
exception stacktrace:

 

> 21 XML parsing error. Detailed error: Cannot parse XML file "null".
org.xml.sax.SAXParseException: Invalid encoding name "ISO-8859-15".. 

 

So double-check your encoding settings.

 

Best regards

Petr

 

 

 

  _____  

Von: opencms-dev-admin at opencms.org [mailto:opencms-dev-admin at opencms.org] Im
Auftrag von kkaal at timologic.com
Gesendet: Sonntag, 8. Februar 2004 22:45
An: opencms-dev at opencms.org
Betreff: [opencms-dev] MySQL initialization error

 

I installed OpenCMS 5.0.1 on JBoss 3.2.3 and MySQL 4.0

 

Finally, I had the installation running without any error or warning. When I
try to start opencms, I get a Exception "Could not connect to the database"
(Full exception log below)

 

I doublechecked the database. It is running. It has all rights exept the
grant right for the "opencms" database from localhost (changed it to ip,
without change). The tables are populated. With the same rights as openCMS
has, I can access all tables. In the prrocesslist, I can see that opencms
maintains about 10 connections. Maxconnections of MySQL is at 100.

 

What else can I do????

 

Thanx for your help.

 

Klaus

 

----------------------------------------------------------------------------
----------------

javax.servlet.ServletException: OpenCms initialization error!
 
Could not connect to the database. Is the database up and running?
 
 
        at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:245)
        at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
        at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
        at java.lang.Thread.run(Thread.java:534)

root cause 

com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error:
Database init failed. 
root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Critical error while loading resourcebroker. 
root cause was com.opencms.core.CmsException: 34 Registry error. Detailed
error: couldn't init registry. 
root cause was com.opencms.core.CmsException: 21 XML parsing error. Detailed
error: Cannot parse XML file "null". org.xml.sax.SAXParseException: Invalid
encoding name "ISO-8859-15".. 
        at com.opencms.core.OpenCms.(OpenCms.java:259)
        at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
        at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
        at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
        at java.lang.Thread.run(Thread.java:534)
>-----------
>Root cause:
>com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed
error: Critical error while loading resourcebroker. 
>root cause was com.opencms.core.CmsException: 34 Registry error. Detailed
error: couldn't init registry. 
>root cause was com.opencms.core.CmsException: 21 XML parsing error.
Detailed error: Cannot parse XML file "null". org.xml.sax.SAXParseException:
Invalid encoding name "ISO-8859-15".. 
>       at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
>       at com.opencms.core.OpenCms.(OpenCms.java:255)
>       at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
>       at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
>       at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
>       at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>       at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>       at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>       at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>       at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>       at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>       at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>       at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
>       at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>       at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>       at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>       at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>       at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>       at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>       at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
>       at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>       at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>       at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>       at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
>       at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
>       at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
>       at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>       at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
>       at java.lang.Thread.run(Thread.java:534)
>>-----------
>>Root cause:
>>com.opencms.core.CmsException: 34 Registry error. Detailed error: couldn't
init registry. 
>>root cause was com.opencms.core.CmsException: 21 XML parsing error.
Detailed error: Cannot parse XML file "null". org.xml.sax.SAXParseException:
Invalid encoding name "ISO-8859-15".. 
>>      at com.opencms.file.CmsRegistry.(CmsRegistry.java:184)
>>      at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:42
03)
>>      at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
>>      at com.opencms.core.OpenCms.(OpenCms.java:255)
>>      at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
>>      at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
>>      at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
>>      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>      at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>      at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
>>      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>      at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>      at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
>>      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>      at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
>>      at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
>>      at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
>>      at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>>      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
>>      at java.lang.Thread.run(Thread.java:534)
>>>-----------
>>>Root cause:
>>>com.opencms.core.CmsException: 21 XML parsing error. Detailed error:
Cannot parse XML file "null". org.xml.sax.SAXParseException: Invalid
encoding name "ISO-8859-15".. 
>>>     at
com.opencms.template.A_CmsXmlContent.throwException(A_CmsXmlContent.java:194
3)
>>>     at
com.opencms.template.A_CmsXmlContent.parse(A_CmsXmlContent.java:1363)
>>>     at com.opencms.file.CmsRegistry.(CmsRegistry.java:181)
>>>     at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:42
03)
>>>     at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
>>>     at com.opencms.core.OpenCms.(OpenCms.java:255)
>>>     at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
>>>     at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
>>>     at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
>>>     at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>>     at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>>     at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>>     at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>>     at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>>     at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>>     at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>>     at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
>>>     at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>>     at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>>     at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>>     at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>>>     at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>>     at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>>     at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
>>>     at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>>>     at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>>>     at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>>>     at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
>>>     at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
>>>     at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
>>>     at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>>>     at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
>>>     at java.lang.Thread.run(Thread.java:534)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20040209/4a3179fd/attachment.htm>

More information about the opencms-dev mailing list