RE: [opencms-dev] Problem with DB Tables Creation during Installa tion. Could be simple.

[mdavenport at endeca.com]

Gritsayuk,

Did you create a user in the mysql database that has permissions to make
tables.  Check out 

http://dev.mysql.com/doc/mysql/en/Adding_users.html

for clear directions about that.  Also make sure you have the proper
login/password for the root.

Marc



-----Original Message-----
From: Gritsayuk Igor [mailto:igorg at manaproducts.com]
Sent: Friday, November 19, 2004 11:32 AM
To: The OpenCms mailing list
Subject: [opencms-dev] Problem with DB Tables Creation during Installation.
Could be simple.




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(st
ep_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:3
24) 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(Application
FilterChain.java:237) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:157) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:214) at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:104) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext
Valve.java:198) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:152) atno pass for root.
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.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(StandardValveContex
t.java:104) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118
) at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.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(StandardValveContex
t.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.processConne
ction(Http11Protocol.java:705) at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:683) at java.lang.Thread.run(Thread.java:534) 
-------------------------------------------


Igor Gritsayuk

This email message and any attachments are confidential to Endeca. If you
are not the intended recipient, please notify Endeca immediately -- by
replying to this message or by sending an email to: legal at endeca.com -- and
destroy all copies of this message and any attachments. Thank you.


_______________________________________________
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 --------------
A non-text attachment was scrubbed...
Name: GWAVA_unknown.dat
Type: application/octet-stream
Size: 5836 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041122/cc62c615/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Mime.822
Type: application/octet-stream
Size: 8194 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041122/cc62c615/attachment-0001.obj>
-------------- next part --------------
AdmID:B366484BC33351DDB5DFD8F8C9B05649