[opencms-dev] Problem in installing opencms.
Steve
steve.welsh at redplanetuk.com
Tue Oct 19 15:33:36 CEST 2004
Sorry I didn't see the 'screen' at the end of the stack trace.
Recommendation is to set up an opencms user in mysql and grant all
priviledges to that user for database opencms.
Then supply the same username and password for both Server Connection
and OpenCms connection. Works for me
every time.
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 John Edwards
Sent: 19 October 2004 14:00
To: The OpenCms mailing list
Subject: RE: [opencms-dev] Problem in installing opencms.
I think your problem is that you need to also supply the "OpenCms
Connection" user - by default this is also root I think.
-----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
<http://localhost:8080/opencms/setup/resources/help.gif>
OpenCms Connection
<http://localhost:8080/opencms/setup/resources/help.gif>
Connection String
<http://localhost:8080/opencms/setup/resources/help.gif>
Database
<http://localhost:8080/opencms/setup/resources/help.gif>
Create database and tables
<http://localhost:8080/opencms/setup/resources/help.gif>
Please let me know the solution to this problem....
Thanks in advance.
Regards,
Pallavi
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041019/3c2d4579/attachment.htm>
More information about the opencms-dev
mailing list