[opencms-dev] OpenCMS Initialization Error

M Butcher mbutcher at grcomputing.net
Thu Apr 22 20:19:06 CEST 2004 

Can you manually log into the database with the OpenCms username and 
password?

Chad Badiyan wrote:
> 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 
> <mailto:%@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! <http://g.msn.com/8HMAENUS/2740??PS=> 
> _______________________________________________ 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

More information about the opencms-dev mailing list