<html><div style='background-color:'><DIV class=RTE>
<DIV class=RTE>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. </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>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 <A href="http://localhost:8080/opencms/opencms/">http://localhost:8080/opencms/opencms/</A> page, I get the following error:</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>HTTP STATUS 500</DIV>
<DIV class=RTE>javax.servlet.ServletException: OpenCms initialization error!<BR>Could not connect to the database. Is the database up and running?<BR>(exception and root cause are listed below)</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>I checked permissions in MySQL Control Center and "root" has full permissions. I then saw that one user created an account <A href="mailto:%@localhost">%@localhost</A> 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.</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>The follwoing programs and services are installed and running:</DIV>
<DIV class=RTE> OS: Windows 2003 Server</DIV>
<DIV class=RTE> Java SDK: 1.4.1.02</DIV>
<DIV class=RTE> JMS Server: 0.7.5 Release Candidate 1</DIV>
<DIV class=RTE> Web Server: Apache 2.0.45</DIV>
<DIV class=RTE> App Server: Tomcat 4.1.8</DIV>
<DIV class=RTE> Database: MySQL 4.0.12<BR></DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Here are the specifics on the error I am receiving: </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>
<P><B><FONT style="BACKGROUND-COLOR: #0086b2" color=#ffffff>type</FONT></B> Exception report</P>
<P><B><FONT style="BACKGROUND-COLOR: #0086b2" color=#ffffff>message</FONT></B> <U></U></P>
<P><B><FONT style="BACKGROUND-COLOR: #0086b2" color=#ffffff>description</FONT></B> <U>The server encountered an internal error () that prevented it from fulfilling this request.</U></P>
<P><B><FONT style="BACKGROUND-COLOR: #0086b2" color=#ffffff>exception</FONT></B> <PRE>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)
</PRE>
<P></P>
<P><B><FONT style="BACKGROUND-COLOR: #0086b2" color=#ffffff>root cause</FONT></B> <PRE>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.<INIT>(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.<INIT>(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.<INIT>(CmsDbAccess.java:300)
>> at com.opencms.file.mySql.CmsDbAccess.<INIT>(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.<INIT>(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.<INIT>(CmsDbAccess.java:300)
>>> at com.opencms.file.mySql.CmsDbAccess.<INIT>(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.<INIT>(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)
</PRE><PRE>Thank you in advance for any assistance you can provide. Chad</PRE><PRE> </PRE></DIV></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2740??PS=">Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium!</a> </html>