[opencms-dev] MySQL initialization error

[kkaal at timologic.com]

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/20040208/ae2652da/attachment.htm>