opencms setup wizard haven't insert the db user correctly. you can try to give username and password manually when you do step 4<br><br><div><span class="gmail_quote">On 11/10/05, <b class="gmail_sendername">Vinod Pillai</b>
<<a href="mailto:vinod_bp2000@yahoo.com">vinod_bp2000@yahoo.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">WIN XP PRO
<br>Tomcat 4.1 (stand alone )<br>MySQL 4.0.x<br>OpenCms 6.0.2<br>JRE 1.4_02<br><br>Both tomcat (installed on E:) and (MySQL installed on<br>C:) are up and running.<br><br>When I use standard jdbc driver from a stand alone
<br>java client with same 'root' user and '<empty string>'<br>password, the connection, creation and commit<br>operations in the database works perfectly fine.<br><br>When running the setup application after deploying the
<br>opencms.war the following error is output by the<br>setup wizard at step_5_database_creation.jsp page<br><br>Can anyone please help<br><br>Thanks<br><br>Vinod<br><br><br><br>------------------------ Stacktrace Error Stdout from
<br>the browser client<br>-----------<br><br>Database has been successfully created.<br><br><br>Creating tables ... Tables could not be created!<br><br>Error connecting to database using:<br>"jdbc:<a href="mysql://localhost:3306/opencms">
mysql://localhost:3306/opencms</a>".<br>-------------------------------------------<br>java.sql.SQLException: General error message from<br>server: "Access denied for user: '@localhost' to<br>database 'opencms'" at
<br>com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)<br>at<br>com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)<br>at<br>com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:954)<br>at<br>com.mysql.jdbc.Connection.createNewIO
(Connection.java:1782)<br>at com.mysql.jdbc.Connection.(Connection.java:450) at<br>com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)<br>at<br>java.sql.DriverManager.getConnection(DriverManager.java
:512)<br>at<br>java.sql.DriverManager.getConnection(DriverManager.java:171)<br>at<br>org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:266)<br>at<br>org.apache.jsp.step_5_database_creation_jsp._jspService(step_5_database_creation_jsp.java:339)
<br>at<br>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)<br>at<br>javax.servlet.http.HttpServlet.service(HttpServlet.java:809)<br>at<br>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java
:162)<br>at<br>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)<br>at<br>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)<br>at<br>javax.servlet.http.HttpServlet.service(HttpServlet.java
:809)<br>at<br>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)<br>at<br>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)<br>at<br>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
(StandardPipeline.java:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2358)<br>at<br>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java
:596)<br>at<br>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)<br>
at<br>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
(StandardPipeline.java:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.coyote.tomcat4.CoyoteAdapter.service
(CoyoteAdapter.java:152)<br>at<br>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)<br>at<br>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
<br>at<br>org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)<br>at<br>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)<br>at java.lang.Thread.run(Thread.java:534)<br>
-------------------------------------------<br>Error executing SQL statement: CREATE TABLE CMS_USERS<br>( USER_ID VARCHAR(36) BINARY NOT NULL, USER_NAME<br>VARCHAR(64) BINARY NOT NULL, USER_PASSWORD VARCHAR(32)<br>BINARY NOT NULL, USER_DESCRIPTION VARCHAR(255) NOT
<br>NULL, USER_FIRSTNAME VARCHAR(50) NOT NULL,<br>USER_LASTNAME VARCHAR(50) NOT NULL, USER_EMAIL<br>VARCHAR(100) NOT NULL, USER_LASTLOGIN BIGINT NOT NULL,<br>USER_FLAGS INT NOT NULL, USER_INFO BLOB, USER_ADDRESS<br>VARCHAR(100) NOT NULL, USER_TYPE INT NOT NULL, PRIMARY
<br>KEY (USER_ID), UNIQUE (USER_NAME) )<br>-------------------------------------------<br>java.sql.SQLException: No operations allowed after<br>connection closed. Connection was closed explicitly by<br>the application at the following location: ** BEGIN
<br>NESTED EXCEPTION ** java.lang.Throwable STACKTRACE:<br>java.lang.Throwable at<br>com.mysql.jdbc.Connection.close(Connection.java:1119)<br>at<br>org.opencms.setup.CmsSetupDb.closeConnection(CmsSetupDb.java:102)<br>at<br>
org.apache.jsp.step_5_database_creation_jsp._jspService(step_5_database_creation_jsp.java:327)<br>at<br>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)<br>at<br>javax.servlet.http.HttpServlet.service(HttpServlet.java
:809)<br>at<br>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)<br>at<br>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)<br>at<br>org.apache.jasper.servlet.JspServlet.service
(JspServlet.java:187)<br>at<br>javax.servlet.http.HttpServlet.service(HttpServlet.java:809)<br>at<br>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)<br>at<br>org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:146)<br>at<br>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java
:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:144)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)<br>at<br>org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:133)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)<br>at<br>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java
:118)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)<br>at<br>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
(StandardPipeline.java:594)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:127)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)<br>at<br>org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:799)<br>at<br>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)<br>at<br>org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)<br>at<br>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)<br>at java.lang.Thread.run(Thread.java:534) ** END NESTED<br>EXCEPTION ** at<br>com.mysql.jdbc.Connection.checkClosed(Connection.java
:2470)<br>at<br>com.mysql.jdbc.Connection.createStatement(Connection.java:1175)<br>at<br>com.mysql.jdbc.Connection.createStatement(Connection.java:1194)<br>at<br>org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java
:457)<br>at<br>org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:364)<br>at<br>org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:428)<br>at<br>org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:142)<br>
at<br>org.apache.jsp.step_5_database_creation_jsp._jspService(step_5_database_creation_jsp.java:346)<br>at<br>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)<br>at<br>javax.servlet.http.HttpServlet.service
(HttpServlet.java:809)<br>at<br>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)<br>at<br>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)<br>at<br>org.apache.jasper.servlet.JspServlet.service
(JspServlet.java:187)<br>at<br>javax.servlet.http.HttpServlet.service(HttpServlet.java:809)<br>at<br>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)<br>at<br>org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:146)<br>at<br>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java
:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:144)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)<br>at<br>org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:133)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)<br>at<br>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java
:118)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)<br>at<br>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
(StandardPipeline.java:594)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:127)<br>at<br>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)<br>at<br>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:433)<br>at<br>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)<br>at<br>org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)<br>at<br>org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:799)<br>at<br>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)<br>at<br>org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)<br>at<br>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)<br>at java.lang.Thread.run(Thread.java:534)<br>-------------------------------------------<br><br><br><br><br><br><br>__________________________________
<br>Yahoo! Mail - PC Magazine Editors' Choice 2005<br><a href="http://mail.yahoo.com">http://mail.yahoo.com</a><br><br><br>_______________________________________________<br>This mail is send to you from the opencms-dev mailing list
<br>To change your list options, or to unsubscribe from the list, please visit<br><a href="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</a><br></blockquote></div>
<br>