<html><body>
<p>Hello Roman,<br>
<br>
thank you for this information.<br>
I changed the opencms.properties, as you suggested.<br>
I keep the other changes as well, so this should work for sure then ;-)<br>
<br>
HTW<br>
<br>
Best regards<br>
<br>
Frank<br>
<br>
<br>
<img width="16" height="16" src="cid:1__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt="Inactive hide details for "Roman Uhlig Maxity.de" ---27.04.2010 11:22:11---Hi Frank, if you have no activity on the weekends, "><font color="#424282">"Roman Uhlig Maxity.de" ---27.04.2010 11:22:11---Hi Frank, if you have no activity on the weekends, this approach will cause the</font><br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Von:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">"Roman Uhlig Maxity.de" <roman.uhlig@maxity.de></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">An:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">"The OpenCms mailing list" <opencms-dev@opencms.org></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Datum:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">27.04.2010 11:22</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Betreff:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">Re: [opencms-dev] Antwort: Re: server is not reacting after a time of inactivity</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Gesendet von:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFD80DFA998858f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">opencms-dev-bounces@opencms.org</font></td></tr>
</table>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<tt><br>
Hi Frank,<br>
<br>
if you have no activity on the weekends, this approach will cause the<br>
connection to fail on monday again. ;)<br>
IMO it's a better and more solid solution to use the pooling ping from<br>
the OpenCms connection pooling. This way, the pooling frequently pings<br>
the connection (e.g. once a hour) and keeps it alive no matter how long<br>
there is no activity. I think it's quite self-explaining, just have a<br>
look at these pooling options:<br>
<br>
db.pool.default.testWhileIdle=true<br>
db.pool.default.timeBetweenEvictionRuns=3600000<br>
db.pool.default.numTestsPerEvictionRun=3<br>
db.pool.default.minEvictableIdleTime=1800000<br>
db.pool.default.testQuery=SELECT 1 <br>
<br>
Since OpenCms is using Apache DBCP (afaik), you may look up the exact<br>
meanings of the parameters here:<br>
<br>
</tt><tt><a href="http://commons.apache.org/dbcp/configuration.html">http://commons.apache.org/dbcp/configuration.html</a></tt><tt><br>
<br>
Roman<br>
<br>
________________________________<br>
<br>
Von: opencms-dev-bounces@opencms.org<br>
[</tt><tt><a href="mailto:opencms-dev-bounces@opencms.org">mailto:opencms-dev-bounces@opencms.org</a></tt><tt>] Im Auftrag von Frank Pertack<br>
Gesendet: Dienstag, 27. April 2010 09:47<br>
An: The OpenCms mailing list<br>
Betreff: [opencms-dev] Antwort: Re: server is not reacting after a time<br>
of inactivity<br>
<br>
<br>
<br>
Hello Brett,<br>
<br>
yes I think that helped.<br>
Yesterday I implemented those two lines into the my.ini and today<br>
morning it started right away.<br>
I hope that stays that way.<br>
<br>
Thank you very much for your advise.<br>
<br>
Best regards<br>
<br>
Frank<br>
<br>
<br>
Inactive hide details for Brett Sheeran ---26.04.2010 12:28:26---Frank<br>
Pertack wrote: > After a certain time of inactivity the Brett Sheeran<br>
---26.04.2010 12:28:26---Frank Pertack wrote: > After a certain time of<br>
inactivity the server does not respond:<br>
<br>
<br>
<br>
Von: <br>
Brett Sheeran <brett.sheeran@gmail.com> <br>
<br>
An: <br>
opencms-dev@opencms.org <br>
<br>
Datum: <br>
26.04.2010 12:28 <br>
<br>
Betreff: <br>
Re: [opencms-dev] server is not reacting after a time of inactivity <br>
<br>
Gesendet von: <br>
opencms-dev-bounces@opencms.org <br>
________________________________<br>
<br>
<br>
<br>
<br>
Frank Pertack wrote:<br>
> After a certain time of inactivity the server does not respond:<br>
> Server Error 500<br>
> After a Browser-Refresh (F5) the page appears normally.<br>
> I don't understand this opencms-error, what causes this error?<br>
> Did anybody else experience this behaviour of OpenCms, what can I do<br>
to<br>
<br>
Hi Frank,<br>
<br>
I suggest editing your MySQL config file to increase the following two<br>
values from their defaults (of 8 hours) to 24 hours (as shown below):<br>
wait_timeout=86400<br>
interactive_timeout=86400<br>
<br>
As I understand it, the default value for wait_timeout is 28800<br>
(seconds) or 8 hours. After 8 hours of inactivity, MySQL closes the<br>
connection. The next time OpenCMS calls that connection, you get an<br>
error.<br>
<br>
I have had similar problem on systems that did not receive page<br>
requests outside working hours. The first request of the day would<br>
generate an error, but things would be fine after that. Since<br>
increasing those wait_timeout and interactive_timeout values, I have<br>
had no further problems.<br>
<br>
HTH.<br>
<br>
Regards<br>
<br>
Brett<br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please<br>
visit<br>
</tt><tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></tt><tt><br>
<br>
<br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
</tt><tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></tt><tt><br>
</tt><br>
</body></html>