[opencms-dev] error creating the database

Thu Nov 12 08:34:09 CET 2009

Hi Ignacio,

As Christian Steinert told it is root with no password.

Give root user or if you have changed the password give the correct set of login credentials.

This will resolve the issue.

Regards,

Kumar. A

--- On Thu, 11/12/09, Christian Steinert <christian_steinert at web.de> wrote:

From: Christian Steinert <christian_steinert at web.de>
Subject: Re: [opencms-dev] error creating the database
To: "The OpenCms mailing list" <opencms-dev at opencms.org>
Date: Thursday, November 12, 2009, 12:37 PM

kumar wrote:

  Hi Ignacio,

In MySql, for creating a local database, the default password must be 
username:root
Password:root
Both are in smaller cases,

As far as I know, the default setting is 

user:root

but without a password. 

Kind regards

Christian

  So while installing OpenCms give this userId and password as 'root' and try to install now.

Hopefully this issue should be resolved.

Regards,

Kumar. A

--- On Thu, 11/12/09, ignacio nieto <ignacio.nieto at hotmail.com> wrote:

From: ignacio nieto <ignacio.nieto at hotmail.com>
Subject: [opencms-dev] error creating the database
To: opencms-dev at opencms.org
Date: Thursday, November 12, 2009, 6:24 AM

Dear List

I try several times to install OpenCMS but an error occur

Could someone help me please.

thanks,

IN

Tables could not be created!

Error connecting to database using: "jdbc:mysql://localhost:3306/test".
-------------------------------------------
java.sql.SQLException: Access denied for user 'admin'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748) at com.mysql.jdbc.Connection.(Connection.java:1553) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:480) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:348) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Unknown Source) 
-------------------------------------------
Error parsing database setup SQL script in line: ) ENGINE = MYISAM CHARACTER SET UTF8;
-------------------------------------------
java.lang.NullPointerException at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:735) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:651) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:714) at org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:215) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:359) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Unknown Source) 
-------------------------------------------

Guarda correos, fotos, archivos, documentos; todo. ¡Con Windows Live tienes 25 GB gratis! 

-----Inline Attachment Follows-----

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev

-----Inline Attachment Follows-----

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20091112/5c3c7fe5/attachment.htm>