[opencms-dev] Problem in installing opencms.

Steve steve.welsh at redplanetuk.com
Tue Oct 19 15:27:48 CEST 2004 

Sounds like you might not have granted all priviledges to the opencms
user for the opencms database.
 
Steve,

REDPlanet Technologies Ltd,
Salters House, Salters Lane Ind. Est., Sedgefield, Stockton-on-Tees,
TS21 3EE

www.redplanetuk.com
Tel +44 (1740) 625222 


-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Pallavi Vidhate
Sent: 19 October 2004 13:52
To: opencms-dev at opencms.org
Subject: [opencms-dev] Problem in installing opencms.
 
Hi,
 
I am facing a problem while installing  opencms.
 
I am using the MySql database.
 
I get an error while creating the database and the tables.
The database gets created but the tables are not created.
 
The error that I get is as below : 
 
Tables could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/opencms
-------------------------------------------
java.sql.SQLException: General error, message from server: "Access
denied for user: '@localhost' to database 'opencms'" at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1900) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:950) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1771) at
com.mysql.jdbc.Connection.(Connection.java:440) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:40
0) at java.sql.DriverManager.getConnection(DriverManager.java:512) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.step_5_database_creation_jsp._jspService(step_5_database_
creation_jsp.java:325) at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:204) at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:260) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:239
6) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:40
5) at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:380) at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:50
8) at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:533) at java.lang.Thread.run(Thread.java:536) 
-------------------------------------------
Error parsing database setup SQL script in line: );
-------------------------------------------
java.lang.NullPointerException at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:336) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:260) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:195) at
org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:159) at
org.apache.jsp.step_5_database_creation_jsp._jspService(step_5_database_
creation_jsp.java:331) at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:204) at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:260) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:239
6) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:40
5) at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:380) at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:50
8) at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:533) at java.lang.Thread.run(Thread.java:536) 
-------------------------------------------
I have not changed any of the default database settings.
 
They are as below :
 

Setup Connection
 
 
 
 


OpenCms Connection
 
 
 
 


Connection String
 
 


Database
 
 


 
 
Create database and tables 

 
 
Please let me know the solution to this problem....
 
Thanks in advance.
 
 
Regards,
 
Pallavi
 
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041019/14532c22/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 169 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041019/14532c22/attachment.gif>

More information about the opencms-dev mailing list