<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Mensaje</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1491" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005>Hello
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005>I'm
having randomly a problem whe the jsp pages try to connect with the mysql
database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005>I see this error at
the log file</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005>com.opencms.core.CmsException: 4 Sql exception.
Detailed error: [com.opencms.file.mySql.CmsDbAccess] Communication link failure:
java.net.SocketException.<BR>root cause was java.sql.SQLException: Communication
link failure: java.net.SocketException.<BR>root cause was
com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mySql.CmsDbAccess] Communication link failure:
java.net.SocketException.<BR>root cause was java.sql.SQLException: Communication
link failure: java.net.SocketException</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005>I'm using opencms
5.0.1 with Tomcat 4.1.30 and MySQL 4.0.23</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005>I've tried to
increase the timeout at the mysql connection-pool (opencms.properties), but the
problem persist randomly</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005>Here is the current
configuration that I have</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005><SPAN
class=843142409-08072005>pool.mysql.driver=org.gjt.mm.mysql.Driver<BR></SPAN></SPAN></FONT><FONT
face=Arial size=2><SPAN
class=843142409-08072005>pool.mysql.minConn=10<BR>pool.mysql.maxConn=40<BR>pool.mysql.increaseRate=5<BR>pool.mysql.timeout=300<BR>pool.mysql.maxage=360<BR></DIV></SPAN></FONT>
<DIV><FONT face=Arial size=2><SPAN class=843142409-08072005><SPAN
class=843142409-08072005>pool.mysqlonline.driver=org.gjt.mm.mysql.Driver<BR></SPAN>pool.mysqlonline.minConn=5<BR>pool.mysqlonline.maxConn=40<BR>pool.mysqlonline.increaseRate=5<BR>pool.mysqlonline.timeout=300<BR>pool.mysqlonline.maxage=360<BR></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=843142409-08072005>pool.mysqlbackup.driver=org.gjt.mm.mysql.Driver<BR>pool.mysqlbackup.minConn=5<BR>pool.mysqlbackup.maxConn=40<BR>pool.mysqlbackup.increaseRate=5<BR>pool.mysqlbackup.timeout=300<BR>pool.mysqlbackup.maxage=360<BR></DIV></SPAN></FONT>
<DIV><SPAN class=843142409-08072005><FONT face=Arial size=2>Anyone can help me
please?</FONT></SPAN></DIV>
<DIV align=left><FONT face=Arial size=2><FONT size=2>
<P>César López Jarillo</P></FONT><FONT face=Arial></FONT><FONT size=2>
<P>T-Systems ITC Services España, S.A.<BR>Area Hosting/Internet<BR>Computing
Services<BR>C/Sancho de Ávila, 110-130 <BR>08018 Barcelona<BR>Phone: 93 501
54 05<BR>Fax : 93 501 52 75<BR>E-mail: </FONT><A
href="mailto:cesar.lopez@cesar.lopez@t-systems.es"><U><FONT color=#0000ff
size=2>cesar.lopez@t-systems.es</U></FONT></A><FONT
face=Tele-GroteskNor><BR></FONT><FONT size=2>Internet: </FONT><A
href="http://www.t-systems.es/"><U><FONT color=#0000ff
size=2>http://www.t-systems.es</U></FONT></A></P></FONT></DIV>
<DIV> </DIV><p></p><p>--------------------------------------------------------------------------------<br>This e-mail may contain confidential or privileged information. Any unauthorised<br>copying, use or distribution of this information is strictly prohibited. If you are not the<br>intended recipient, please notify the sender and destroy this e-mail together with all of<br>its content.<br>--------------------------------------------------------------------------------<br>Este mensaje electrónico puede contener información confidencial o privilegiada, por lo<br>que está completamente prohibida la copia, el uso o la distribución no autorizada de<br>dicha información. Si usted no es el destinatario del mensaje, le rogamos que lo<br>notifique al remitente y que lo destruya junto con todo su contenido.<br>--------------------------------------------------------------------------------<br>Aquest missatge electrònic pot contenir informació confidencial o privilegiada i està<br>completament prohibida qualsevol còpia, ús o distribució no autoritzada d'aquesta<br>informació. Si vostè no és el seu destinatari, si us plau notifiqui-ho al remitent i<br>destrueixi el missatge amb tot el seu contingut.<br>--------------------------------------------------------------------------------<br>Mezu elektroniko honek informazio konfidentziala edo pribilegiatua eduki dezake.<br>Erabat debekaturik dago informazio hori baimenik gabe kopiatu, erabili edo banatzea.<br>Mezu hau ez bada zuri zuzendua, arren, igortzaileari jakinarazi eta bere edukiarekin<br>batera ezaba ezazu.<br>--------------------------------------------------------------------------------<br>Esta mensaxe electrónica pode conter información confidencial ou privilexiada e está<br>completamente prohibida calquera copia, uso ou distribución non autorizado desta<br>información. Se vostede non é o seu destinatario, faga o favor de llo notificar ao<br>remitente e destrúa a mensaxe e todo o seu contido.<br>--------------------------------------------------------------------------------</BODY></HTML>