<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=258525912-19102004><FONT face=Arial color=#0000ff size=2>I
think your problem is that you need to also supply the "<FONT
face="Times New Roman" color=#000000 size=3>OpenCms Connection</FONT>" user - by
default this is also root I think.</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]<B>On
Behalf Of </B>Pallavi Vidhate<BR><B>Sent:</B> 19 October 2004
13:52<BR><B>To:</B> opencms-dev@opencms.org<BR><B>Subject:</B> [opencms-dev]
Problem in installing opencms.<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am facing a problem while installing
opencms.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am using the MySql database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I get an error while creating the database and
the tables.</FONT></DIV>
<DIV><FONT face=Arial size=2>The database gets created but the tables are not
created.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The error that I get is as below :
</FONT></DIV>
<DIV> </DIV>
<DIV>Tables could not be created!</DIV>
<DIV>Error connecting to database using:
jdbc:mysql://localhost:3306/opencms<BR>-------------------------------------------<BR>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.<INIT>(Connection.java:440) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400) 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.java: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(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
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.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
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:405) at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
at java.lang.Thread.run(Thread.java:536)
<BR>-------------------------------------------<BR>Error parsing database
setup SQL script in line:
);<BR>-------------------------------------------<BR>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.java: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(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
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.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
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:405) at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
at java.lang.Thread.run(Thread.java:536)
<BR>-------------------------------------------<BR></DIV>
<DIV><FONT face=Arial size=2>I have not changed any of the default database
settings.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>They are as below :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=2 border=0>
<TBODY>
<TR>
<TD>Setup Connection</TD>
<TD><INPUT style="WIDTH: 150px" size=8 value=root name=dbCreateUser></TD>
<TD style="TEXT-ALIGN: right"><INPUT style="WIDTH: 150px" size=8
name=dbCreatePwd></TD>
<TD><IMG id=img1 onmouseover=showHelp(1); onmouseout=hideHelp(1);
src="http://localhost:8080/opencms/setup/resources/help.gif" border=0
name=img1></TD></TR>
<TR>
<TD>OpenCms Connection</TD>
<TD><INPUT style="WIDTH: 150px" size=8 name=dbWorkUser></TD>
<TD style="TEXT-ALIGN: right"><INPUT style="WIDTH: 150px" size=8
name=dbWorkPwd></TD>
<TD><IMG id=img2 onmouseover=showHelp(2); onmouseout=hideHelp(2);
src="http://localhost:8080/opencms/setup/resources/help.gif" border=0
name=img2></TD></TR>
<TR>
<TD>Connection String</TD>
<TD colSpan=2><INPUT style="WIDTH: 315px" size=22
value=jdbc:mysql://localhost:3306/ name=dbCreateConStr></TD>
<TD><IMG id=img3 onmouseover=showHelp(3); onmouseout=hideHelp(3);
src="http://localhost:8080/opencms/setup/resources/help.gif" border=0
name=img3></TD></TR>
<TR>
<TD>Database</TD>
<TD colSpan=2><INPUT style="WIDTH: 315px" size=22 value=opencms
name=db></TD>
<TD><IMG id=img4 onmouseover=showHelp(4); onmouseout=hideHelp(4);
src="http://localhost:8080/opencms/setup/resources/help.gif" border=0
name=img4></TD></TR>
<TR>
<TD> </TD>
<TD colSpan=2><INPUT type=checkbox CHECKED value=true name=createDb>
Create database and tables </TD>
<TD><IMG id=img5 onmouseover=showHelp(5); onmouseout=hideHelp(5);
src="http://localhost:8080/opencms/setup/resources/help.gif" border=0
name=img5></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Please let me know the solution to this
problem....</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Pallavi</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV><BR>_____________________________________________________________________<BR>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<BR></BLOCKQUOTE></BODY></HTML>