<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
<BR>
<PRE>
<FONT COLOR="#000000">Hi all.</FONT>
<FONT COLOR="#000000">I am </FONT>stuck with OpenCMS (current cvs development 6 ver) installation. Looks like I misunderstood explanation for the setup wizard screen where you enter DB information.
</PRE>
This is current code from CVS.<BR>
<BR>
My environment: <BR>
Fedora, Core 3 version, <BR>
Tomcat 5.0, <BR>
MySQL 4.1 (freshly installed, no pass for root), <BR>
JDK 1.4.2<BR>
<BR>
<BR>
Database is created, (first step succeeds) but the tables are not. What should I specify for "OpenCms Connection" user and passw? What ever I provide, still the same error mess... <BR>
<BR>
<PRE>
Setup wizard generates the following error message:
</PRE>
<BR>
Tables could not be created!<BR>
<BR>
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) )<BR>
-------------------------------------------<BR>
java.sql.SQLException: Syntax error or access violation message from server: "Access denied for user ''@'iglinux.hp.manaproducts.com' to database 'opencms'" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at com.mysql.jdbc.Connection.execSQL(Connection.java:2244) at com.mysql.jdbc.Connection.execSQL(Connection.java:2192) at com.mysql.jdbc.Statement.execute(Statement.java:906) at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:334) 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.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:350) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) atno pass for root. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) 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) <BR>
-------------------------------------------<BR>
<BR>
<BR>
Igor Gritsayuk<BR>
<BR>
</BODY>
</HTML>