[opencms-dev] MySQL db problem

[Alexander Kandzior]

Robert,

this is because of MySQL 4.0.10. OpenCms 5.0rc2 does not officially
support MySQL 4.x versions. 

I recently removed that exact issue you have reported so the 5.0 final
will at last not have this problem. The 5.0 final will be released in 4
- 8 weeks.

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com



> -----Original Message-----
> From: owner-opencms-dev at www.opencms.org 
> [mailto:owner-opencms-dev at www.opencms.org] On Behalf Of Robert Bialek
> Sent: Monday, February 24, 2003 10:57 AM
> To: opencms-dev at opencms.com
> 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(StandardW
> rapper.java:93
> 4)
> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrap
> per.java:666)
> at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.ja
> va:214)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.ja
> va:191)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2415)
> at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:180
> )
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at 
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.
> java:170)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:172
> )
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java
> :174)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.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(Http11Process
> or.java:432)
> at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
> r.processConne
> ction(Http11Protocol.java:386)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.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(StandardW
> rapper.java:93
> 4)
> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrap
> per.java:666)
> at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.ja
> va:214)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.ja
> va:191)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2415)
> at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:180
> )
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at 
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.
> java:170)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:172
> )
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java
> :174)
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.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(Http11Process
> or.java:432)
> at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
> r.processConne
> ction(Http11Protocol.java:386)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.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(StandardW
> rapper.java:93
> 4)
> >at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrap
> per.java:666)
> >at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.ja
> va:214)
> >at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> >at 
> >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> >at
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.ja
> va:191)
> >at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> >at 
> >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> >at
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2415)
> >at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:180
> )
> >at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.
> java:170)
> >at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> >at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:172
> )
> >at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> >at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> >at 
> >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> >at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java
> :174)
> >at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.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(Http11Process
> or.java:432)
> >at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
> r.processConne
> ction(Http11Protocol.java:386)
> >at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.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(CmsRes
> ourceBroker.ja
> va:62)
> >>at
> com.opencms.file.genericSql.CmsResourceBroker.init(CmsResource
> Broker.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(StandardW
> rapper.java:93
> 4)
> >>at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrap
> per.java:666)
> >>at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.ja
> va:214)
> >>at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >>at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> >>at 
> >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.
> java:995)
> >>at
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.ja
> va:191)
> >>at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >>at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> >>at 
> >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.
> java:995)
> >>at
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2415)
> >>at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:180
> )
> >>at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >>at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.
> java:170)
> >>at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> >>at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:172
> )
> >>at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:641)
> >>at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:480)
> >>at 
> >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.
> java:995)
> >>at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java
> :174)
> >>at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invok
> eNext(StandardPipeline.java:643)
> >>at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.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(Http11Process
> or.java:432)
> >>at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
> r.processConne
> ction(Http11Protocol.java:386)
> >>at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.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
>