[opencms-dev] OpenCms and MySql on XP

[Dmitry]

On Thursday 06 January 2005 15:06, Francis wrote:

The 3.0.7-stable version of the JDBC driver will not work with MySQL-4.1.1 or
newer, because the protocol changed in MySQL-4.1.1. Th opencms 5.1 use this 
driver. You can to change mysql-connector-java-3.0.7-stable-bin.jar or MySQL.


> Impossible to connect OpenCms on MySql
>
> PC with XP SP2, Opencms 5.0.1, JBoss 4.0.1 and MySql 4.1.8
>
> mysqladmin ping =>mysqld is alive
>
> The PC is in our network.
>
> Same problem with the IP adress in place of localhost
>
> The port 3306 is indicated in my.ini
>
> winmysqladmin run perfectly.
>
> I can't find solution on the mailing-list archive
>
> I'm running an instance of OpenCms on our Unix Server (Solaris) with JBoss
> and Oracle whitout problem
>
> Error Msg :
>
> 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.ocsetup.create_005fdatabase_jsp._jspService(create_005fdatab
>a se_jsp.java:119)
>  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>  at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
>3 24)
>  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:810)
>  at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>n FilterChain.java:237)
>  at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>h ain.java:157)
>  at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.j
>a va:75)
>  at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>n FilterChain.java:186)
>  at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>h ain.java:157)
>  at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>a va:214)
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.java:104)
>  at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
>  at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContex
>t Valve.java:198)
>  at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>a va:152)
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.java:104)
>  at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalVa
>l ve.java:66)
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.java:102)
>  at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssoc
>i ationValve.java:153)
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.java:102)
>  at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java
>: 54)
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.java:102)
>  at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
>  at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:13
>7 .
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.java:104)
>  at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:11
>8 .
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.java:102)
>  at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
>  at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a
>
> :109)
>
>  at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte
>x t.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.processConn
>e 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.ja
>v a:683)
>  at java.lang.Thread.run(Thread.java:534)
>
> ** END NESTED EXCEPTION **
>
> -------------------------------------------
> java.lang.NullPointerException
>
> -------------------------------------------
>
> Thank's in advance
>
> Francis
>
>
>
>
> _______________________________________________
> 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