[opencms-dev] Problem with DB Tables Creation during Installa tion. Could be simple.
Jonathan Roberts
j_droberts at yahoo.co.uk
Sat Nov 20 13:05:36 CET 2004
We had a similair issue on linux,
try using the locahost ( 127.0.0.1) address instead.
Jonathan
Gritsayuk Igor <igorg at manaproducts.com> wrote:
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 maketables. Check out http://dev.mysql.com/doc/mysql/en/Adding_users.htmlfor clear directions about that. Also make sure you have the properlogin/password for the root.Marc-----Original Message-----From: Gritsayuk Igor [mailto:igorg at manaproducts.com]Sent: Friday, November 19, 2004 11:32 AMTo: The OpenCms mailing listSubject: [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. Lookslike I misunderstood explanation for the setup wizard screen where you enterDB 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. Whatshould I specify for "OpenCms Connection" user and passw? What ever Iprovide, 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_PASSWORDVARCHAR(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_FLAGSINT NOT NULL, USER_INFO BLOB, USER_ADDRESS VARCHAR(100) NOT NULL, USER_TYPEINT 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) atcom.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) atcom.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) atcom.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) atcom.mysql.jdbc.Connection.execSQL(Connection.java:2244) atcom.mysql.jdbc.Connection.execSQL(Connection.java:2192) atcom.mysql.jdbc.Statement.execute(Statement.java:906) atorg.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:334) atorg.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:260) atorg.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:195) atorg.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:159) atorg.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:350) atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:802) atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) atjavax.servlet.http.HttpServlet.service(HttpServlet.java:802) atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) atorg.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) atorg.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)atorg.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) atno pass for
root.org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) atorg.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) atorg.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) atorg.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) atorg.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) atorg.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) atorg.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) atorg.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) atorg.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)atorg.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) -------------------------------------------Igor GritsayukThis email message and any attachments are confidential to Endeca. If youare not the intended recipient, please notify Endeca immediately -- byreplying to this message or by sending an email to: legal at endeca.com -- anddestroy 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
---------------------------------
ALL-NEW Yahoo! Messenger - all new features - even more fun!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041120/a7c7d8ae/attachment.htm>
More information about the opencms-dev
mailing list