[opencms-dev] HELP - Can't connect to Database

[Gibson Stephen]

Can anyone help me?

 

I am setting up a Windows installation of OpenCMS for an evaluation

 

OS - Windows Server 2003 standard Edition

 

I have installed 

JDK 1.4.2

Tomcat 4.1

MySQL 4.1

OpenCMS 5.0

 

I have set up JAVA_HOME and CATALINA_HOME.

 

Everything seems to be OK until I try and configure OpenCMS using
http://localhost:8080/opencms/ocsetup

 

This fails to connect to the database when trying to create the tables:

 

Could no connect to database via: jdbc:mysql://localhost:3306/

java.sql.SQLException: Communication link failure: java.io.IOException,
underlying cause: Unexpected end of input stream

 

** BEGIN NESTED EXCEPTION ** 

 

java.io.IOException

MESSAGE: Unexpected end of input stream

 

STACKTRACE:

 

java.io.IOException: Unexpected end of input stream

      at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1080)

      at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:619)

      at com.mysql.jdbc.Connection.createNewIO(Connection.java:1532)

      at com.mysql.jdbc.Connection.<init>(Connection.java:486)

      at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:326)

      at java.sql.DriverManager.getConnection(DriverManager.java:512)

      at java.sql.DriverManager.getConnection(DriverManager.java:171)

      at com.opencms.boot.CmsSetupDb.setConnection(CmsSetupDb.java:30)

      at
org.apache.jsp.create_database_jsp._jspService(create_database_jsp.java:119)

      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(JspServletWrapper.java:1
62)

      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.internalDoFilter(Application
FilterChain.java:200)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:146)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:209)

      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:596)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)

      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:144)

      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:596)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)

      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)

      at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)

      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133
)

      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:596)

      at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:118)

      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:594)

      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116
)

      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:594)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)

      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)

      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:127)

      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:596)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.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(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)

 

 

** END NESTED EXCEPTION **

 

 

 

-------------------------------------------

java.lang.NullPointerException

 

 

The Connection string is :

            jdbc:mysql://localhost:3306/

 

 

Can anyone tell me what I have done wrong?

 

Cheers

 

 

Steve Gibson

Core Services, Business Solutions, Enterprise Content Management Practice

This e-mail is only for the use of its intended recipient. Its contents are
confidential and may be privileged. Fujitsu Services does not guarantee that
this e-mail has not been intercepted and amended or that it is virus-free.

FUJITSU SERVICES

Wenlock Way, West Gorton, Manchester, M12 5DR

 

Tel:         +44 (0) 870 325 2872 Internal: 7308 2872

Mob :     +44 (0) 786 782 2818 Internal: 7382 2818

E-mail:   stephen.gibson at uk.fujitsu.com

Web:      services.fujitsu.com

 

Fujitsu Services Limited, Registered in England no 96056, Registered Office
26, Finsbury Square, London, EC2A 1SL

 

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