[opencms-dev] Noob install problem with MySQL

Mon Apr 11 19:55:44 CEST 2005

Strange... I assume you did stop/start tomcat ?

Anything else in the generated setup.log (generated by the installer ?)

Just in case you might want to check there really isn't an 'opencms' like database in mysql ("show databases").

Could it be the cache in your Explorer/browser ? 

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

I downloaded the 6.0 beta version and the wizard started fine. I stopped before it created the opencms database.

I then deleted my opencms folder and went back to the opencms_fat_5 distribution. Here is a log of how I unpacked it:

http://www.langdale.ca:81/opencmssetuplog.txt

I goto setup wizard again and I get:

java.sql.SQLException: General error: Unknown database 'opencms'

On Apr 11, 2005, at 1:25 PM, Frans Postma wrote:

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

_______________________________________________
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/4a8a5e48/attachment.htm>