[opencms-dev] OpenCMS Initialization Error
Jeff Greer
jgreer at fdusa.com
Thu Apr 22 20:18:01 CEST 2004
Can you connect to the database using some other MySQL client?
Chad Badiyan said:
>
> Hi, I searched the mailing list archives and found several others with the same problem I am enountering. I tried
> the recommended fixes but am still having the same problem.
> I am trying to run OpenCMS on a Windows 2003 Server (more on my configuration below). Ran the Installation Wizard
> and it notified me that I needed to change encoding so I set it to "Cp1252" in the opencms.properties file. I
> was then able to proceed with the Wizard to create the database and tables and to import the data without errors.
> After clicking on the link to the http://localhost:8080/opencms/opencms/ page, I get the following error:
>
> HTTP STATUS 500
> javax.servlet.ServletException: OpenCms initialization error!Could not connect to the database. Is the database up
> and running?(exception and root cause are listed below)
> I checked permissions in MySQL Control Center and "root" has full permissions. I then saw that one user created an
> account %@localhost so I tried that too and reinstalled but am experiencing the same problem. Checked
> opencms.properties and the username and password are listed correctly for MySQL.
> The follwoing programs and services are installed and running:
> OS: Windows 2003 Server
> Java SDK: 1.4.1.02
> JMS Server: 0.7.5 Release Candidate 1
> Web Server: Apache 2.0.45
> App Server: Tomcat 4.1.8
> Database: MySQL 4.0.12
>
> Here are the specifics on the error I am receiving:
>
>
> 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:245) at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:934) at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:386) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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 com.opencms.core.CmsException: 4 Sql exception. Detailed error:
> [com.opencms.file.mySql.CmsDbAccess] Invalid argument value, message from server: "Duplicate entry 'Guests' for key
> 2". root cause was java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry 'Guests'
> for key 2"
> 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:934) at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:386) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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 com.opencms.core.CmsException: 4 Sql exception. Detailed error:
> [com.opencms.file.mySql.CmsDbAccess] Invalid argument value, message from server: "Duplicate entry 'Guests' for key
> 2". >root cause was java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry
> 'Guests' for key 2" > 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:934) > at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666) > at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191) > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643) > at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) > at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:386) > at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) > at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) > at
> java.lang.Thread.run(Thread.java:536)
> >>-----------
> >>Root cause:
> >>com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid
> argument value, message from server: "Duplicate entry 'Guests' for key 2". >>root cause was
> java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry 'Guests' for key 2"
> >> at com.opencms.file.mySql.CmsDbAccess.createGroup(CmsDbAccess.java:431) >> at
> com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:558) >> at
> com.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:300) >> at
> com.opencms.file.mySql.CmsDbAccess.(CmsDbAccess.java:125) >> at
> com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:62) >> at
> com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182) >> 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:934) >> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666) >> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191) >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
> >> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> >> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:386)
> >> at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) >> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) >> at
> java.lang.Thread.run(Thread.java:536)
> >>>-----------
> >>>Root cause:
> >>>java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry 'Guests' for key
> 2" >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626) >>> at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886) >>> at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945) >>> at
> com.mysql.jdbc.Connection.execSQL(Connection.java:1844) >>> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602) >>> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488) >>> at
> com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.java:177) >>> at
> com.opencms.file.mySql.CmsDbAccess.createGroup(CmsDbAccess.java:424) >>> at
> com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:558) >>> at
> com.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:300) >>> at
> com.opencms.file.mySql.CmsDbAccess.(CmsDbAccess.java:125) >>> at
> com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:62) >>> at
> com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182) >>> 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:934) >>> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:666) >>> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191) >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
> >>> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> >>> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:386)
> >>> at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) >>> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) >>> at
> java.lang.Thread.run(Thread.java:536)
> Thank you in advance for any assistance you can provide. Chad Watch LIVE baseball games on your computer with
> MLB.TV, included with MSN Premium! _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
--
Jeff Greer
Technical Support Consultant
Fretwell-Downing, Inc.
Phone: (913) 239-1214
The information transmitted in this electronic mail message may contain
confidential and or privileged materials. For full details and restrictions
see http://www.fdgroup.com/emaildisclaimer.html
More information about the opencms-dev
mailing list