<html><div style='background-color:'><DIV class=RTE>I updated to the latest stable jdbc mysql connector, 3.0.11-stable but am experiencing the same results--cannot connect to the database--when trying to bring up the <A href="http://localhost:8080/opencms/opencms/">http://localhost:8080/opencms/opencms/</A> page. I re-installed MySQL but that did not make a difference. </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>
<DIV class=RTE>The odd thing is, once I changed the encoding to "Cp1252", the Installation Wizard was able to create the database and tables, and import data without errors. So it seems odd that the opencms site cannot access those tables. </DIV></DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>When I access the database using MySQL Administrator and the "root" account and password specified in opencms.properties, it works correctly on port 3306. Joachim Arrasz recommended that I set the port in the db conf to 127.0.0.1:3306. How do I do that? Also, I have a J2EE site running on the server and it connects to the database just fine using the same version of the jdbc connector. </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>
<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>A detailed description of the error is included below. Many thanks for any assistance. -Chad</DIV>
<DIV class=RTE> </DIV></DIV>
<DIV class=RTE><STRONG>Jeff Greer wrote:</STRONG></DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>I know that when I was playing with 5.0 I had to upgrade the jdbc mysql connector.<BR><A href="http://www.mysql.com/products/connector/j">http://www.mysql.com/products/connector/j</A><BR><BR>Good luck.<BR></DIV>
<DIV class=RTE><STRONG>Joachim Arrasz wrote:</STRONG></DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Hi,<BR><BR>then it`s possible that you haven`t set a port in your db conf?<BR><BR>Normally mysql speaks via Port 3306. When you use localhost then mysql use<BR>this port as default. Sometimes it helps then to set 127.0.0.1:3306 or in<BR>specialcases 127.0.0.1:YourMySqlPort<BR>Hope this helps<BR><BR>Achim<BR></DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE><STRONG>Detailed Error Message:</STRONG><BR></DIV>
<DIV class=RTE><B><FONT style="BACKGROUND-COLOR: #0086b2" color=#ffffff>type</FONT></B> Exception report</DIV>
<DIV class=RTE>
<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:1905)
>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2090)
>>> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680)
>>> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527)
>>> 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></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2755??PS=">Is your PC infected? Get a FREE online computer virus scan from McAfeeŽ Security.</a> </html>