[opencms-dev] Noob install problem with MySQL

[Frans Postma]

Try removing webapps/opencms dir and re-extracting the war, maybe something got stuck during previous attempt.


  _____  

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:15
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Noob install problem with MySQL


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.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

_______________________________________________
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 --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050411/fb45f70c/attachment.htm>