[opencms-dev] OpenCMS Initialization Error
Jeff Greer
jgreer at fdusa.com
Fri Apr 23 16:28:02 CEST 2004
I know that when I was playing with 5.0 I had to upgrade the jdbc mysql connector.
http://www.mysql.com/products/connector/j
Good luck.
Chad Badiyan said:
> Yes, I can log into MySQL as "root" using MySQL Control Center and MySQL Administrator. The opencms.properties file
> lists the correct account ("root") and password: pool.mysql.user=root
> pool.mysqlonline.user=root
> pool.mysqlbackup.user=root
> - Chad
>
>
> M Butcher wrote:
>
> Can you manually log into the database with the OpenCms username and password?
> Jeff Greer wrote:
>
> Can you connect to the database using some other MySQL client?
> 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: Open
> Cms 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> & nbsp; 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(StandardW rapper.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.Stan
> dardHostValve.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$Standard PipelineValveContext.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.cat
> alina.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(Sta ndardPipeline.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(StandardPi peline.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.apa
> che.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.StandardWrap per.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.StandardConte xt.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(StandardWrap per.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.St andardContext.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(ContainerB ase.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.ThreadPo ol$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