[opencms-dev] Communication Link problem

[kylekc]

Steve, thanks for posting this. I was observing exactly the same symptoms you were -- if I hadn't used the site for awhile, then logged on, the first few pages would have these errors. Then I just kept going for a few pages they would clear up. I added ?autoReconnect = true to all my MySQL connection pools and the issue cleared up for me too.

Note: I had never observed this on my home PC -- only started seeing it once I put OpenCMS up on an ISP hoster. Must be the ISP hoster has different MySQL settings than the default I get on my own system. 

Probably a good FAQ item ;->
  ----- Original Message ----- 
  From: Steve 
  To: opencms-dev at opencms.org 
  Sent: Thursday, June 12, 2003 6:42 PM
  Subject: [opencms-dev] Communication Link problem


  Hello all,

      I think I finally found the problem, it maybe because that the mySQL wait_timeout variable is set to 100 miliseconds. Since I cannot update the mySQL server's variable on hosting service. I just add to the connection URL jdbc:mysql://localhost:3306/test_cms?autoReconnect=true. That's all.

      Thanks to all.

  Steven Ho.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20030614/1ea6d29a/attachment.htm>