[opencms-dev] Noob install problem with MySQL
Jonathan Langdale
jlangdale at mac.com
Mon Apr 11 19:15:21 CEST 2005
Ok so, I fixed this problem by having my host '%' with no password.
It seems that my host was root at 192.168.0.5 which was the problem. But
when I goto setup it has a new error, it's like it's expecting the
opencms database to already be made when I haven't gone through the
wizard yet.
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.dbpool.CmsIdGenerator]General error: Table
'opencms.cms_systemid' doesn't exist.
root cause was java.sql.SQLException: General error: Table
'opencms.cms_systemid' doesn't exist
On Apr 11, 2005, at 1:08 PM, Jonathan Langdale wrote:
> Tomcat 4.1.x running on Mac OS X with OpenCMS 5.0.1 fat binary
> distribution. Expanded the war file & restarted Tomcat. Then I go
> to the http://localhost:8080/opencms/opencms/ocsetup but I get an
> error. I've not even been able to go through the setup wizard yet.
>
> I've tried resetting to no password in Mysql for root, making an
> opencms user and granting privs to opencms database, setting the
> username and password in the conf/opencms.properties file too. I
> don't understand why it keeps getting denied. Could this have to do
> with the host setting? I'm trying to use localhost obviously. Please
> help!
>
> I keep getting:
>
> 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.ja
> va:888)
> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
> 621)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:163)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:144)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
> 2358)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:133)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV
> alve.java:118)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:116)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:127)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:
> 152)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
> 799)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process
> Connection(Http11Protocol.java:705)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
> 577)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:683)
> at java.lang.Thread.run(Thread.java:552)
>
>
> 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
> authorization specification: Access denied for user:
> 'root at 192.168.0.5' (Using password: NO).
> root cause was java.sql.SQLException: Invalid authorization
> specification: Access denied for user: 'root at 192.168.0.5' (Using
> password: NO)
> 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.ja
> va:888)
> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
> 621)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:163)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:144)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
> 2358)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:133)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV
> alve.java:118)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:116)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:127)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:
> 152)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
> 799)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process
> Connection(Http11Protocol.java:705)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
> 577)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:683)
> at java.lang.Thread.run(Thread.java:552)
> >-----------
> >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
> authorization specification: Access denied for user:
> 'root at 192.168.0.5' (Using password: NO).
> >root cause was java.sql.SQLException: Invalid authorization
> specification: Access denied for user: 'root at 192.168.0.5' (Using
> password: NO)
> > 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.ja
> va:888)
> > at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
> 621)
> > at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:163)
> > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> > at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> > at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:144)
> > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> > at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> > at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
> 2358)
> > at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:133)
> > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> > at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV
> alve.java:118)
> > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> > at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:116)
> > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> > at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> > at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:127)
> > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> > at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> > at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:
> 152)
> > at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
> 799)
> > at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process
> Connection(Http11Protocol.java:705)
> > at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
> 577)
> > at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:683)
> > at java.lang.Thread.run(Thread.java:552)
> >>-----------
> >>Root cause:
> >>com.opencms.core.CmsException: 4 Sql exception. Detailed error:
> [com.opencms.file.mySql.CmsDbAccess] Invalid authorization
> specification: Access denied for user: 'root at 192.168.0.5' (Using
> password: NO).
> >>root cause was java.sql.SQLException: Invalid authorization
> specification: Access denied for user: 'root at 192.168.0.5' (Using
> password: NO)
> >> 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(CmsResourceBrok
> er.java:62)
> >> at
> com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.ja
> va: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.ja
> va:888)
> >> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
> 621)
> >> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:163)
> >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:144)
> >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
> 2358)
> >> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:133)
> >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV
> alve.java:118)
> >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> >> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:116)
> >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> >> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:127)
> >> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >> at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:
> 152)
> >> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
> 799)
> >> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process
> Connection(Http11Protocol.java:705)
> >> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
> 577)
> >> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:683)
> >> at java.lang.Thread.run(Thread.java:552)
> >>>-----------
> >>>Root cause:
> >>>java.sql.SQLException: Invalid authorization specification: Access
> denied for user: 'root at 192.168.0.5' (Using password: NO)
> >>> at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
> >>> at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
> >>> at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown
> Source)
> >>> at org.gjt.mm.mysql.Driver.connect(Unknown Source)
> >>> at
> com.opencms.dbpool.CmsPool.createConnection(CmsPool.java:338)
> >>> at
> com.opencms.dbpool.CmsPool.createConnections(CmsPool.java:320)
> >>> at com.opencms.dbpool.CmsPool.<init>(CmsPool.java:118)
> >>> at com.opencms.dbpool.CmsPool.<init>(CmsPool.java:149)
> >>> at com.opencms.dbpool.CmsDriver.createPool(CmsDriver.java:214)
> >>> at com.opencms.dbpool.CmsDriver.getPool(CmsDriver.java:188)
> >>> at com.opencms.dbpool.CmsDriver.connect(CmsDriver.java:107)
> >>> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> >>> at java.sql.DriverManager.getConnection(DriverManager.java:193)
> >>> at
> com.opencms.file.mySql.CmsDbAccess.createGroup(CmsDbAccess.java:411)
> >>> 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(CmsResourceBrok
> er.java:62)
> >>> at
> com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.ja
> va: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.ja
> va:888)
> >>> at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
> 621)
> >>> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:163)
> >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >>> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >>> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >>> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:144)
> >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >>> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >>> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >>> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
> 2358)
> >>> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:133)
> >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >>> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV
> alve.java:118)
> >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> >>> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:116)
> >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:594)
> >>> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >>> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >>> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:127)
> >>> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invokeNext(StandardPipeline.java:596)
> >>> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 433)
> >>> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> >>> at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:
> 152)
> >>> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
> 799)
> >>> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process
> Connection(Http11Protocol.java:705)
> >>> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
> 577)
> >>> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:683)
> >>> at java.lang.Thread.run(Thread.java:552)
>
>
>
> Jonathan Langdale
> jon at langdale.ca
> http://www.langdale.ca:81
>
> _______________________________________________
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 20801 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050411/f917e4d4/attachment.bin>
More information about the opencms-dev
mailing list