[opencms-dev] MySQL, OpenCms and a 3Com Superstack firewall

[Arash Kaffamanesh]

Hi,
 
I had the same problem some times ago with OpenCms alpha 2 and I
experimentet with the conection pooling (idle connection time out, or
some thing like this in opencms.properties, but it didn't help, because
the connections didn't close anymore, I think that's a bug), the
firewall cutted the connection exactly after 2 hours and I came up with
the following simple solution, I used "wget" in a cron job to retrieve
the index page of my OpenCms Installation hourly and deleted the file
via another cron job from the filesystem and that works for me till then
as a charme :-)
 
I think I had post some thing about it to this list ..
 
If that helps, please let me know, we shall post it to the
opencms-forum.de or ask OpenCms Experts about it :-)
 
HTH,
Arash
 
--
http://www.pomegranate.de <http://www.pomegranate.de/> 
Portal & Content Management Solutions
-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Corbey, Clayton
Sent: Freitag, 16. September 2005 22:30
To: OpenCms mailing list
Subject: [opencms-dev] MySQL, OpenCms and a 3Com Superstack firewall


Help, my firewall hates mysql.
 
I've installed OpenCms on our production server in the DMZ and the new
database was created inside our network on the LAN. I've entered the
rules on the firewall to allow port 3306 TCP and UDP to be open from the
DMZ (the OpenCms app) to the MySQL 4.1.14 DB. I've confirmed it's open
with 'telnet DB_SERVER 3306'.
 
I fired up Tomcat, and everything worked great. Ran setup, configured
the server, displayed our website and was proud!
 
Now, after about 10 or 20 minutes or so of inactivity, I can't connect;
not to the website OR the admin area of OpenCms. No errors at all.
Nothing, absolutely nothing. I've done 'tcpdump port 3306' on both ends
and the request is being sent from the CMS server in the DMZ, but not
received by the DB server on the inside. I know this means that the
connection has been lost (ie firewall is eating the request up. Netstat
says that I'm still connected, but I'm not so sure. I know Tomcat is
fine, b/c I can go other web shares on the server.
 
Why would everything work initially but after a period of inactivity it
fails with NO ERROR!??!?!?!?!
WHAT CAN I DO????!?!??!
 
Somebody help.
 
-Clayton
 
CONFIDENTIALITY NOTICE:  This message is intended only for the use of
the individual or entity to which it is addressed and may contain
information that is privileged, confidential and exempt from disclosure
under applicable law.  If the reader of this message is not the intended
recipient you are hereby notified that any distribution, copying,
disclosure and use of, or reliance on the contents of this transmission
is strictly prohibited.  If you have received this transmission in
error, please notify us immediately by return e-mail and destroy the
transmission by deleting the original message, attachments and all
copies.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050916/da13a1e2/attachment.htm>