[opencms-dev] Problem with DB Tables Creation during Installation. Could be simple.

[Gritsayuk Igor]

Hi all.

I am stuck with OpenCMS (current cvs development 6 ver)  installation. Looks like I misunderstood explanation for the setup wizard screen where you enter DB information.

This is current code from CVS.

My environment: 
   Fedora, Core 3 version,  
   Tomcat  5.0,  
   MySQL  4.1 (freshly installed, no pass for root), 
  JDK 1.4.2
    

 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... 


 Setup wizard generates the following error message:


Tables could not be created!

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: 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) 
-------------------------------------------


Igor Gritsayuk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041119/1ebaacc1/attachment.htm>