[opencms-dev] Noob install problem with MySQL

Jonathan Langdale jlangdale at mac.com
Mon Apr 11 20:21:31 CEST 2005


I start stop tomcat each time I change anything.   6.0 beta works fine  
with MySQL, but seems to be producing errors during the workplace  
import part of the wizard.

I'm sure it's not a IE cache because I'm looking at my catalina.out and  
*.log file:

 >>-----------
 >>Root cause:
 >>com.opencms.core.CmsException: 4 Sql exception. Detailed error:  
[com.opencms.file.mySql.CmsDbAccess] General error: Unknown database  
'opencms'.
 >>root cause was java.sql.SQLException: General error: Unknown database  
'opencms'
 >>	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: General error: Unknown database 'opencms'
 >>>	at org.gjt.mm.mysql.MysqlIO.sendCommand(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)


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

> 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.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
>
>
> _______________________________________________
> 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 --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 31395 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050411/6273e253/attachment.bin>


More information about the opencms-dev mailing list