Ty Sarna wrote:
In article <Pine.LNX.3.96.990528114433.18413B-100000@taos.kavi.com>, John Eikenberry <jae@kavi.com> wrote:
Basically, it looks like I'm losing my connection from Zope to the MySQL database. While the site remains busy, it stays connected, but if there's a long dead period the connection goes away.
I believe newer versions of libmysqlclient (which may require a newer server) will reconnect transparently if the server closes the connection on timeout. Upgrading may be the simplest fix.
My simplest fix to this was to put wget as a cron job to request a page every 10 min.:-) Yes, the requested page must access the DB. I had to upgrade latter to be able to do an outer join, but the cron jot is still there. regards, -- Paulo Eduardo Neves mailto:neves@inf.puc-rio.br PUC-Rio de Janeiro