[opencms-dev] Problem installing opencms

Claus Priisholm cpr at codedroids.com
Wed Sep 22 10:47:50 CEST 2004 

Hi

I can tell you with what setup I have tested that particular jar:

MySQL 4.0.15-standard, Tomcat 5.0.25, JDK 1.4.1_02-b06 on SuSE 8.1. My  
M.O. (since I always set the root password on MySQL as the first thing  
after installing it along with an aptly defined user for opencms) is to  
edit the <webapps>/opencms/WEB-INF/opencms.properties before running  
the ocsetup to reflect the appropriate db username and password (in all  
the three places where they're listed), then restart the instance to  
reload the properties and then run the setup.

Now if you're sure that the access to the database is fine, then I  
wonder if there could be an issue with the JDBC driver included in  
opencms 5.0.1 vs. MySQL 5. I was on my way to get the latest drivers  
myself, but at this time it seems that there is a problem with  
mysql.com, so I don't know if they do list issue with that particular  
combo. But it seems to be a likely place to look considering the  
exception you get.

Claus

On 21/9-2004, at 18.29, John MccLain wrote:

> Howdy,
> I am using Mysql 5.0.*, Tomcat 5.0.28, opencms5.0.1, and the modified
> opencms.jar from from
> http://www.codedroids.com/codedroids/opencms/en/opencms/community.html  
> that
> supports tomcat 5.0.25(+) (the updated jar files in tomcat). I can  
> access
> the database fine, my user permissions are correct, and tomcat works,  
> BUT
> when I get to the
> configurtation of the database from within the opencms installer, I  
> get the
> following error. I also get this error when
> installing using MySQL 4.1.* ( there is a JDBC connectivity issue I  
> just
> don't understand). Is there a JDBC driver I need to download? Do I  
> have the
> correct versions for the tools? What is the most up to date opencms
> installation that works?
> ****************************************
>
> 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_005fd 
> ataba
> se_jsp.java:119)
> 	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> 	at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.j 
> ava: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:802)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic 
> ation
> FilterChain.java:237)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil 
> terCh
> ain.java:157)
> 	at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal 
> ve.ja
> va:214)
> 	at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC 
> ontex
> t.java:104)
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 
> 520)
> 	at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCo 
> ntext
> Valve.java:198)
> 	at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal 
> ve.ja
> va:152)
> 	at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC 
> ontex
> t.java:104)
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 
> 520)
> 	at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav 
> a:137
> )
> 	at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC 
> ontex
> t.java:104)
> 	at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav 
> a:118
> )
> 	at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC 
> ontex
> t.java:102)
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 
> 520)
> 	at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve 
> .java
> :109)
> 	at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC 
> ontex
> 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.process 
> Conne
> ction(Http11Protocol.java:705)
> 	at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java: 
> 577)
> 	at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo 
> l.jav
> a:683)
> 	at java.lang.Thread.run(Thread.java:534)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> -------------------------------------------
> java.lang.NullPointerException
>
> -------------------------------------------
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
> John McClain
> Senior Software Engineer
> TCS Healthcare
> jmcclain at tcshealthcare.com
> (530)886-1700x235
> "Before you criticize someone, walk a mile in their shoes.
> That way, you'll be a mile from them, and you'll have their shoes."
>
>
>
> _______________________________________________
> 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
>
>
OpenCms links & API's: http://www.codedroids.com/community/opencms
--
Claus Priisholm
+45 48 22 46 46
cpr <you know what> codedroids.com
http://www.codedroids.com

More information about the opencms-dev mailing list