<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [opencms-dev] openCMS too much connections problem</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Thanks I think so..</FONT>
</P>
<P><FONT SIZE=2>Nico</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Petr Hollay [<A HREF="mailto:ph@ethikom.de">mailto:ph@ethikom.de</A>] </FONT>
<BR><FONT SIZE=2>Sent: Freitag, 7. März 2003 15:18</FONT>
<BR><FONT SIZE=2>To: opencms-dev@www.opencms.org</FONT>
<BR><FONT SIZE=2>Subject: RE: [opencms-dev] openCMS too much connections problem</FONT>
</P>
<P><FONT SIZE=2>> What means:</FONT>
<BR><FONT SIZE=2>> pool.mysqlonline.maxage=360</FONT>
<BR><FONT SIZE=2>> 6 minutes?</FONT>
</P>
<P><FONT SIZE=2>It seems (from Java sources) that 360 minutes. CmsPool destroys (closes)</FONT>
<BR><FONT SIZE=2>connection, if it is older than this interval, when putting back to pool.</FONT>
</P>
<P><FONT SIZE=2>I would try to use MySQL Standard, not Max,</FONT>
<BR><FONT SIZE=2>and then latest version 3.23.55. And then OpenCms 5 RC2 :-)</FONT>
</P>
<P><FONT SIZE=2>Regards</FONT>
<BR><FONT SIZE=2>Petr</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: owner-opencms-dev@www.opencms.org</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:owner-opencms-dev@www.opencms.org">mailto:owner-opencms-dev@www.opencms.org</A>]On Behalf Of Nico Krause</FONT>
<BR><FONT SIZE=2>Sent: Friday, March 07, 2003 3:03 PM</FONT>
<BR><FONT SIZE=2>To: 'opencms-dev@www.opencms.org'</FONT>
<BR><FONT SIZE=2>Subject: RE: [opencms-dev] openCMS too much connections problem</FONT>
</P>
<BR>
<P><FONT SIZE=2>What means:</FONT>
<BR><FONT SIZE=2>pool.mysqlonline.maxage=360</FONT>
<BR><FONT SIZE=2>6 minutes?</FONT>
<BR><FONT SIZE=2>Here is my configuration.. the online and backup config is equal</FONT>
<BR><FONT SIZE=2>pool.mysql.driver=org.gjt.mm.mysql.Driver</FONT>
<BR><FONT SIZE=2>pool.mysql.url=jdbc:mysql://localhost:3306/opencms</FONT>
<BR><FONT SIZE=2>pool.mysql.user=</FONT>
<BR><FONT SIZE=2>pool.mysql.password=</FONT>
<BR><FONT SIZE=2>pool.mysql.minConn=10</FONT>
<BR><FONT SIZE=2>pool.mysql.maxConn=20</FONT>
<BR><FONT SIZE=2>pool.mysql.increaseRate=5</FONT>
<BR><FONT SIZE=2>pool.mysql.timeout=120</FONT>
<BR><FONT SIZE=2>pool.mysql.maxage=360</FONT>
<BR><FONT SIZE=2>But the connections will not be closed.. that's the thing it grows and</FONT>
<BR><FONT SIZE=2>grows..</FONT>
<BR><FONT SIZE=2>Thanks for any tips..</FONT>
<BR><FONT SIZE=2>Nico</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Petr Hollay [<A HREF="mailto:ph@ethikom.de">mailto:ph@ethikom.de</A>]</FONT>
<BR><FONT SIZE=2>Sent: Freitag, 7. März 2003 14:50</FONT>
<BR><FONT SIZE=2>To: opencms-dev@www.opencms.org</FONT>
<BR><FONT SIZE=2>Subject: RE: [opencms-dev] openCMS too much connections problem</FONT>
<BR><FONT SIZE=2>Hello Nico,</FONT>
<BR><FONT SIZE=2>did you check your opencms.properties?</FONT>
<BR><FONT SIZE=2>pool.mysql.minConn=10</FONT>
<BR><FONT SIZE=2>pool.mysql.maxConn=20</FONT>
<BR><FONT SIZE=2>pool.mysql.increaseRate=5</FONT>
<BR><FONT SIZE=2>pool.mysqlonline.minConn=5</FONT>
<BR><FONT SIZE=2>pool.mysqlonline.maxConn=10</FONT>
<BR><FONT SIZE=2>pool.mysqlonline.increaseRate=5</FONT>
</P>
<BR>
<P><FONT SIZE=2>Regards</FONT>
<BR><FONT SIZE=2>Petr</FONT>
<BR><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: owner-opencms-dev@www.opencms.org</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:owner-opencms-dev@www.opencms.org">mailto:owner-opencms-dev@www.opencms.org</A>]On Behalf Of Nico Krause</FONT>
<BR><FONT SIZE=2>Sent: Friday, March 07, 2003 2:40 PM</FONT>
<BR><FONT SIZE=2>To: opencms-dev@opencms.com</FONT>
<BR><FONT SIZE=2>Subject: [opencms-dev] openCMS too much connections problem</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi,</FONT>
<BR><FONT SIZE=2>I don't know that cause, but I've a problem with my database connections to</FONT>
<BR><FONT SIZE=2>MySQL. (OpenCMS 5.rc1 / 3.23.54-Max-log)</FONT>
<BR><FONT SIZE=2>I close in my applications every connection (from OpenCMS Pool) with</FONT>
<BR><FONT SIZE=2>con.close();</FONT>
<BR><FONT SIZE=2>But OpenCMS seems to open so much connections again and again a new pool of</FONT>
<BR><FONT SIZE=2>about 15.</FONT>
<BR><FONT SIZE=2>Then if it's full it could be I cannot work any more clear.</FONT>
<BR><FONT SIZE=2>Is there a way to setup the connection pool of opencms in a way?</FONT>
<BR><FONT SIZE=2>Please help me.</FONT>
<BR><FONT SIZE=2>Nico</FONT>
<BR><FONT SIZE=2>____________________________________</FONT>
<BR><FONT SIZE=2>Nico Krause</FONT>
<BR><FONT SIZE=2>NorthStar Communications GmbH</FONT>
<BR><FONT SIZE=2>Wallbergstr. 20-22 85221 Dachau</FONT>
<BR><FONT SIZE=2>Telefon: +49 (0) 81 31 / 9 96 87 - 53</FONT>
<BR><FONT SIZE=2>Fax: +49 (0) 81 31 / 9 96 87 - 29</FONT>
<BR><FONT SIZE=2>Mobil: +49 (0) 1 74 / 9 89 19 49</FONT>
<BR><FONT SIZE=2>Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte</FONT>
<BR><FONT SIZE=2>Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail</FONT>
<BR><FONT SIZE=2>irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und</FONT>
<BR><FONT SIZE=2>vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte</FONT>
<BR><FONT SIZE=2>Weitergabe dieser Mail ist nicht gestattet.</FONT>
<BR><FONT SIZE=2>This e-mail may contain confidential and/or privileged information. If you</FONT>
<BR><FONT SIZE=2>are not the intended recipient (or have received this e-mail in error)</FONT>
<BR><FONT SIZE=2>please notify the sender immediately and destroy this e-mail. Any</FONT>
<BR><FONT SIZE=2>unauthorized copying, disclosure or distribution of the material in this</FONT>
<BR><FONT SIZE=2>e-mail is strictly forbidden.</FONT>
</P>
</BODY>
</HTML>