[opencms-dev] Noob install problem with MySQL
Jonathan Langdale
jlangdale at mac.com
Mon Apr 11 19:08:01 CEST 2005
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.jav
a:888)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
621)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:163)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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(StandardContextValv
e.java:144)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.java
:133)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.i
nvokeNext(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.processC
onnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.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.jav
a:888)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
621)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:163)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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(StandardContextValv
e.java:144)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.java
:133)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.i
nvokeNext(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.processC
onnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.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.jav
a:888)
> at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
621)
> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:163)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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(StandardContextValv
e.java:144)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.java
:133)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.i
nvokeNext(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.processC
onnection(Http11Protocol.java:705)
> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
577)
> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.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(CmsResourceBroke
r.java:62)
>> at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.jav
a: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.jav
a:888)
>> at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
621)
>> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:163)
>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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(StandardContextValv
e.java:144)
>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.java
:133)
>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
>> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
>> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.i
nvokeNext(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.processC
onnection(Http11Protocol.java:705)
>> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
577)
>> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.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(CmsResourceBroke
r.java:62)
>>> at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.jav
a: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.jav
a:888)
>>> at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:
621)
>>> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:163)
>>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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(StandardContextValv
e.java:144)
>>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.java
:133)
>>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:596)
>>> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:118)
>>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:594)
>>> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:116)
>>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(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.i
nvokeNext(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.processC
onnection(Http11Protocol.java:705)
>>> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
577)
>>> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:683)
>>> at java.lang.Thread.run(Thread.java:552)
Jonathan Langdale
jon at langdale.ca
http://www.langdale.ca:81
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 19419 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050411/f2cd33e7/attachment.bin>
More information about the opencms-dev
mailing list