[opencms-dev] Noob install problem with MySQL

Mon Apr 11 19:17:10 CEST 2005

Which MySql version ?? If it's 4.1 that won't work with OpenCMS5 due to differences in password authorisation between mysql 4.0.23
en 4.1, easiest would be to either downgrade to mysql 4.0.23 or upgrade to opencms6b2.

Frans

  _____  

From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Jonathan Langdale
Sent: maandag 11 april 2005 19:08
To: opencms-dev at opencms.org
Subject: [opencms-dev] Noob install problem with MySQL

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.java:888)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:621)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.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(StandardContextValve.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.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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.processConnection(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.java:888)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:621)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.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(StandardContextValve.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.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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.processConnection(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.java:888)
> at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:621)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.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(StandardContextValve.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.java:133)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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.processConnection(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(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:888)
>> at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:621)
>> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.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(StandardContextValve.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.java:133)
>> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
>> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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.processConnection(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(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:888)
>>> at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:621)
>>> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.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(StandardContextValve.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.java:133)
>>> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>>> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
>>> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>>> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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.processConnection(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 --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050411/3c8b6971/attachment.htm>