[opencms-dev] MySQL db problem

[Dejan Krsmanovic]

Try with MySQL 3.23. A lot of users experienced problems when running
OpenCMS on MySql 4.0

Best Regards,
Dejan
----- Original Message -----
From: "Robert Bialek" <r.bialek at cochrane.dk>
To: <opencms-dev at opencms.com>
Sent: Monday, February 24, 2003 10:56 AM
Subject: [opencms-dev] MySQL db problem


> 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
>