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

Fri Jun 24 11:34:40 CEST 2005

Isn't it http://localhost:8080/opencms/opencms/ocsetup? May be I don't remember quite well. Check permission to access mysql. Did you follow the whole procedure installing mysql?
hope it helps

arian

________________________________

From: opencms-dev-bounces at opencms.org on behalf of Gibson Stephen
Sent: Fri 6/24/2005 11:30 AM
To: 'opencms-dev at opencms.org'
Subject: [opencms-dev] HELP - Can't connect to Database

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

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

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

      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:144)

      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:596)

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

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

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

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

** 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 --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 14183 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050624/ec0d8805/attachment.bin>