[opencms-dev] java.sql.SQLException: Communication link failure

Mon Jul 11 10:50:45 CEST 2005

Hi Cesar,

Have a look to this notes that I posted last week. I have same problem but not randomly, just during installation. 

..............

Hi Team,

I'd like to post some instalation notes that i think may be interesting to OpenCms instalation and if your are novel:

1.- If Fedora FC4 is instaled 

     Disable ipv6 as reported in http://www.linuxforums.org/forum/topic-47483.html <http://www.linuxforums.org/forum/topic-47483.html> . If this is not done, OpenCms will not 

     have communication to MySQL and could not create de DB.

     I recommend FC4 full instalation without Firewall 

2.- Use RPM files as possible

     When java SDK is downloaded, use the RPM file, execute the bin and then execute the "rpm -Uvh <file>" command. 

    This will install everythink in the apropiate path

3.- Variables

     use in same command instruction "export JAVA_HOME= /usr/java/jj2sdk1.4.2_08. Same with other variables. 

4.- Tomcat:

     install it in "/usr/tomcat"  path

5.- MySQL

    If FC4 is full installed, dond install again MySQL as www.opencsm.org <http://www.opencsm.org>  says. 

    Only use the command to run de BD as says the instalation notes. Básicaly "mysql_install_db --user=mysql" 

    "mysqld_safe --user=mysql" without any special path.

6.- OpenCms

    Install the last version 6.0.0

    Do not use password in "Setup Connection". Select de 4.1x MySQL BBDD

    Try to fill de "MAC" address when is requested in "setup wizard-seting". Should be automatically detected. If is not 

    detected will not appear de login screen. If OpenCms suggest to run again the setup wizard, do it and MAC will be 

    detected automatically. This will permit to finalize the setup and have access to the login screen.

Hope it help.

Brgds, David

.............     

________________________________

De: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] En nombre de Lopez Jarillo, Cesar
Enviado el: viernes, 08 de julio de 2005 11:54
Para: opencms-dev at opencms.org
Asunto: [opencms-dev] java.sql.SQLException: Communication link failure

Hello all,

I'm having randomly a problem whe the jsp pages try to connect with the mysql database.

I see this error at the log file

com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] Communication link failure: java.net.SocketException.
root cause was java.sql.SQLException: Communication link failure: java.net.SocketException.
root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] Communication link failure: java.net.SocketException.
root cause was java.sql.SQLException: Communication link failure: java.net.SocketException

I'm using opencms 5.0.1 with Tomcat 4.1.30 and MySQL 4.0.23

I've tried to increase the timeout at the mysql connection-pool (opencms.properties), but the problem persist randomly

Here is the current configuration that I have

pool.mysql.driver=org.gjt.mm.mysql.Driver
pool.mysql.minConn=10
pool.mysql.maxConn=40
pool.mysql.increaseRate=5
pool.mysql.timeout=300
pool.mysql.maxage=360

pool.mysqlonline.driver=org.gjt.mm.mysql.Driver
pool.mysqlonline.minConn=5
pool.mysqlonline.maxConn=40
pool.mysqlonline.increaseRate=5
pool.mysqlonline.timeout=300
pool.mysqlonline.maxage=360

pool.mysqlbackup.driver=org.gjt.mm.mysql.Driver
pool.mysqlbackup.minConn=5
pool.mysqlbackup.maxConn=40
pool.mysqlbackup.increaseRate=5
pool.mysqlbackup.timeout=300
pool.mysqlbackup.maxage=360

Anyone can help me please?

César López Jarillo

T-Systems ITC Services España, S.A.
Area Hosting/Internet
Computing Services
C/Sancho de Ávila, 110-130 
08018 Barcelona
Phone: 93 501 54 05
Fax : 93 501 52 75
E-mail: cesar.lopez at t-systems.es <mailto:cesar.lopez at cesar.lopez@t-systems.es> 
Internet: http://www.t-systems.es <http://www.t-systems.es/> 

--------------------------------------------------------------------------------
This e-mail may contain confidential or privileged information. Any unauthorised
copying, use or distribution of this information is strictly prohibited. If you are not the
intended recipient, please notify the sender and destroy this e-mail together with all of
its content.
--------------------------------------------------------------------------------
Este mensaje electrónico puede contener información confidencial o privilegiada, por lo
que está completamente prohibida la copia, el uso o la distribución no autorizada de
dicha información. Si usted no es el destinatario del mensaje, le rogamos que lo
notifique al remitente y que lo destruya junto con todo su contenido.
--------------------------------------------------------------------------------
Aquest missatge electrònic pot contenir informació confidencial o privilegiada i està
completament prohibida qualsevol còpia, ús o distribució no autoritzada d'aquesta
informació. Si vostè no és el seu destinatari, si us plau notifiqui-ho al remitent i
destrueixi el missatge amb tot el seu contingut.
--------------------------------------------------------------------------------
Mezu elektroniko honek informazio konfidentziala edo pribilegiatua eduki dezake.
Erabat debekaturik dago informazio hori baimenik gabe kopiatu, erabili edo banatzea.
Mezu hau ez bada zuri zuzendua, arren, igortzaileari jakinarazi eta bere edukiarekin
batera ezaba ezazu.
--------------------------------------------------------------------------------
Esta mensaxe electrónica pode conter información confidencial ou privilexiada e está
completamente prohibida calquera copia, uso ou distribución non autorizado desta
información. Se vostede non é o seu destinatario, faga o favor de llo notificar ao
remitente e destrúa a mensaxe e todo o seu contido.
--------------------------------------------------------------------------------

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