[opencms-dev] Problem with DB Tables Creation during Installa tion. Could be simple.
Gritsayuk Igor
igorg at manaproducts.com
Fri Nov 19 18:05:11 CET 2004
Marc,
thanks for your reply.
I did find it in this email archive. I am subscribed for it for last
five month. Just got a chance and need to roll it out now (opencms) and
get stuck... Is there any other way to create all the tables?
Here is what I get now:
Tables could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/opencms
-------------------------------------------
java.sql.SQLException: Invalid authorization specification message from
server: "Access denied for user
'opencms'@'iglinux.hp.manaproducts.com' (using password: YES)" at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906) at
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2520) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:817) 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:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:340) 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) 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.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)
-------------------------------------------
Error parsing database setup SQL script in line: );
-------------------------------------------
java.lang.NullPointerException at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:336) 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) 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.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)
-------------------------------------------
On Fri, 2004-11-19 at 11:40 -0500, Marc Davenport wrote:
> 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.
>
Tables could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/opencms
-------------------------------------------
java.sql.SQLException: Invalid authorization specification message from
server: "Access denied for user
'opencms'@'iglinux.hp.manaproducts.com' (using password: YES)" at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906) at
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2520) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:817) 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:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:340) 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) 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.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)
-------------------------------------------
Error parsing database setup SQL script in line: );
-------------------------------------------
java.lang.NullPointerException at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:336) 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) 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.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)
-------------------------------------------
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041119/02911cf6/attachment.htm>
More information about the opencms-dev
mailing list