[opencms-dev] MySQL db problem

[Robert Bialek]

Hello,

I'm evaluating different CMSes for our future development, and I want to
test opencms.org, since it looks very promissing.

I have downloaded RC2 and I have followed the setup procedure.
Everything goes fine in the setup scripts. The opencms database in MySQL is
being created and no error messages are being displayed.

But when I enter the login page I get an error message related to database
connections.

Has anyone experienced this problem? How to solve it fast?

I'm using: Win2k Pro, JDK 1.4.1_01, Apache 4.1.18 and MySQL 4.0.10-gamma-nt

Please help,
++Robert

------- Error message: ----------------------
HTTP Status 500 -

type Exception report
message
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception

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:228)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
4)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:214)
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.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:170)
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.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:432)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:386)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:530)
at java.lang.Thread.run(Thread.java:536)
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 java.lang.NullPointerException
at com.opencms.core.OpenCms.(OpenCms.java:255)
at com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:225)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
4)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:214)
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.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:170)
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.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:432)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:386)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:530)
at java.lang.Thread.run(Thread.java:536)
>-----------
>Root cause:
>com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed
error: Critical error while loading resourcebroker.
>root cause was java.lang.NullPointerException
>at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
>at com.opencms.core.OpenCms.(OpenCms.java:251)
>at com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:225)
>at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
4)
>at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666)
>at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:214)
>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.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:170)
>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.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:432)
>at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:386)
>at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
>at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:530)
>at java.lang.Thread.run(Thread.java:536)
>>-----------
>>Root cause:
>>java.lang.NullPointerException
>>at com.opencms.file.mySql.CmsDbAccess.readTask(CmsDbAccess.java:843)
>>at
com.opencms.file.genericSql.CmsDbAccess.createTask(CmsDbAccess.java:1834)
>>at com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:570)
>>at com.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:293)
>>at com.opencms.file.mySql.CmsDbAccess.(CmsDbAccess.java:125)
>>at
com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.ja
va:62)
>>at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:41
74)
>>at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
>>at com.opencms.core.OpenCms.(OpenCms.java:251)
>>at com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:225)
>>at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
4)
>>at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666)
>>at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:214)
>>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.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:170)
>>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.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:432)
>>at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:386)
>>at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
>>at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:530)
>>at java.lang.Thread.run(Thread.java:536)

Apache Tomcat/4.1.18