[opencms-dev] Databse could not be created

Frans Postma fpostma at xs4all.nl
Thu Apr 14 20:19:22 CEST 2005 

Does user 'root' in your mysql database have a password at all? If not, give it one.
Secondly, can user 'root' actually login to mysql using something like 'mysql -p password_here' ?? 

Frans

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Giuliano Dessì
> Sent: donderdag 14 april 2005 17:09
> To: opencms-dev at opencms.org
> Subject: [opencms-dev] Databse could not be created
> 
> Hi all.
> OpenCms version: 6.0 beta 2 Corrin with OpenCms Setup Wizard.
> All component tests are ok, but no database is created.
> In the section "OpenCms Setup Wizard - Create database & tables" is 
> generated an error.
> How can I fix the problem??
> 
> Database could not be created!
> 
> Error connecting to database using: jdbc:mysql://localhost:3306/
> -------------------------------------------
> java.sql.SQLException: Access denied for user: 
> 'root at localhost.localdomain' (Using password: YES) at 
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at 
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750) at 
> com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1205) at 
> com.mysql.jdbc.Connection.createNewIO(Connection.java:1768) at 
> com.mysql.jdbc.Connection.(Connection.java:430) at 
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv
> er.java:268) 
> 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.step_5_database_creation_jsp._jspService(step_5
> _database_creation_jsp.java:111) 
> at 
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92) at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at 
> org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
> Wrapper.java:162) 
> at 
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> .java:240) 
> at 
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187) at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> er(ApplicationFilterChain.java:200) 
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> cationFilterChain.java:146) 
> at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.java:209) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.java:144) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2358) 
> at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:133) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.java:118) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:594) 
> at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:116) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:594) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java:127) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.
> java:152) 
> at 
> org.apache.coyote.http11.Http11Processor.process(Http11Process
> or.java:799) 
> at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
r.processConnection(Http11Protocol.java:705) 
> at 
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.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: CREATE DATABASE 
> ${database};
> -------------------------------------------
> java.lang.NullPointerException at 
> org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:407) at 
> org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:331) at 
> org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:266) at 
> org.opencms.setup.CmsSetupDb.createDatabase(CmsSetupDb.java:160) at 
> org.apache.jsp.step_5_database_creation_jsp._jspService(step_5
> _database_creation_jsp.java:273) 
> at 
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92) at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at 
> org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
> Wrapper.java:162) 
> at 
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> .java:240) 
> at 
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187) at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> er(ApplicationFilterChain.java:200) 
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> cationFilterChain.java:146) 
> at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.java:209) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.java:144) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2358) 
> at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:133) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.java:118) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:594) 
> at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:116) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:594) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java:127) 
> at 
> org.apache.catalina.core.StandardPipeline$StandardPipelineValv
eContext.invokeNext(StandardPipeline.java:596) 
> at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:433) 
> at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) 
> at 
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.
> java:152) 
> at 
> org.apache.coyote.http11.Http11Processor.process(Http11Process
> or.java:799) 
> at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
r.processConnection(Http11Protocol.java:705) 
> at 
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.java:577) 
> at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:683) 
> at java.lang.Thread.run(Thread.java:534)
> 
> 
> _______________________________________________
> 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
>

More information about the opencms-dev mailing list