[opencms-dev] installation error while running setup application

[wang neil]

opencms setup wizard haven't insert the db user correctly. you can try to
give username and password manually when you do step 4

On 11/10/05, Vinod Pillai <vinod_bp2000 at yahoo.com> wrote:
>
> WIN XP PRO
> Tomcat 4.1 (stand alone )
> MySQL 4.0.x
> OpenCms 6.0.2
> JRE 1.4_02
>
> Both tomcat (installed on E:) and (MySQL installed on
> C:) are up and running.
>
> When I use standard jdbc driver from a stand alone
> java client with same 'root' user and '<empty string>'
> password, the connection, creation and commit
> operations in the database works perfectly fine.
>
> When running the setup application after deploying the
> opencms.war the following error is output by the
> setup wizard at step_5_database_creation.jsp page
>
> Can anyone please help
>
> Thanks
>
> Vinod
>
>
>
> ------------------------ Stacktrace Error Stdout from
> the browser client
> -----------
>
> Database has been successfully created.
>
>
> Creating tables ... 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:1997)
> at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
> at
> com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:954)
> at
> com.mysql.jdbc.Connection.createNewIO(Connection.java:1782)
> at com.mysql.jdbc.Connection.(Connection.java:450) at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
> at
> java.sql.DriverManager.getConnection(DriverManager.java:512)
> at
> java.sql.DriverManager.getConnection(DriverManager.java:171)
> at
> org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:266)
> at
> org.apache.jsp.step_5_database_creation_jsp._jspService
> (step_5_database_creation_jsp.java:339)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java
> :162)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:200)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:146)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:209)
> 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(
> StandardContextValve.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.java
> :133)
> at
>
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
> (StandardPipeline.java:596)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(
> ErrorDispatcherValve.java:118)
> at
>
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
> (StandardPipeline.java:594)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :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.processConnection
> (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:534)
> -------------------------------------------
> Error executing SQL statement: CREATE TABLE CMS_USERS
> ( USER_ID VARCHAR(36) BINARY NOT NULL, USER_NAME
> VARCHAR(64) BINARY NOT NULL, USER_PASSWORD VARCHAR(32)
> BINARY NOT NULL, USER_DESCRIPTION VARCHAR(255) NOT
> NULL, USER_FIRSTNAME VARCHAR(50) NOT NULL,
> USER_LASTNAME VARCHAR(50) NOT NULL, USER_EMAIL
> VARCHAR(100) NOT NULL, USER_LASTLOGIN BIGINT NOT NULL,
> USER_FLAGS INT NOT NULL, USER_INFO BLOB, USER_ADDRESS
> VARCHAR(100) NOT NULL, USER_TYPE INT NOT NULL, PRIMARY
> KEY (USER_ID), UNIQUE (USER_NAME) )
> -------------------------------------------
> java.sql.SQLException: No operations allowed after
> connection closed. Connection was closed explicitly by
> the application at the following location: ** BEGIN
> NESTED EXCEPTION ** java.lang.Throwable STACKTRACE:
> java.lang.Throwable at
> com.mysql.jdbc.Connection.close(Connection.java:1119)
> at
> org.opencms.setup.CmsSetupDb.closeConnection(CmsSetupDb.java:102)
> at
> org.apache.jsp.step_5_database_creation_jsp._jspService
> (step_5_database_creation_jsp.java:327)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java
> :162)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:200)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:146)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:209)
> 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(
> StandardContextValve.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.java
> :133)
> at
>
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
> (StandardPipeline.java:596)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(
> ErrorDispatcherValve.java:118)
> at
>
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
> (StandardPipeline.java:594)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :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.processConnection
> (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:534) ** END NESTED
> EXCEPTION ** at
> com.mysql.jdbc.Connection.checkClosed(Connection.java:2470)
> at
> com.mysql.jdbc.Connection.createStatement(Connection.java:1175)
> at
> com.mysql.jdbc.Connection.createStatement(Connection.java:1194)
> at
> org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:457)
> at
> org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:364)
> at
> org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:428)
> at
> org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:142)
> at
> org.apache.jsp.step_5_database_creation_jsp._jspService
> (step_5_database_creation_jsp.java:346)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java
> :162)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:200)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:146)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:209)
> 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(
> StandardContextValve.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.java
> :133)
> at
>
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
> (StandardPipeline.java:596)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(
> ErrorDispatcherValve.java:118)
> at
>
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext
> (StandardPipeline.java:594)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :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.processConnection
> (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:534)
> -------------------------------------------
>
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
>
> _______________________________________________
> 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 --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20051111/9c9bd112/attachment.htm>