| Just an additional insight...
|
| All I know is that it is not always easy to pinpoint
| this kind of problem. A client of ours was running
| CF against oracle. They could connect to oracle just
| fine, but after 10 minutes, the CF Server would become
| unresponsive. They also thought that it was CF or
| even oracle, but found out that it was their firewall.
| They did not suspect the firewall because things ran
| fine for 10 minutes.
I'm not completely ruling out the possibility that it's not the CF server
(heck, anything is possible with computers), but I'm pretty sure it has
nothing to do with the firewall. When it works, it works forever. We've
gone days durring testing without any problems. The ONLY time we have this
problem is when we send the database invalid connection parameters AND use
connectstring. If we don't use connectstring, we don't have a problem. If
we use connectstring, but pass in the correct connection parameters, we
don't have a problem, either.
The "firewall" is really just a Linux box that does NAT for our private IP
addresses. It also provides some routing for our LAN and has some strong
IPChains rulesets to keep people from tunneling in to the private network
and doing naughty things. There is no problem with connecting to the DB
server, that I have seen, other than the one I mentioned above. In fact,
when the CF server thread locks up, we check the log file generated by the
DSN on that CF machine and the error message is in there. So, it's getting
back to the CF machine without any interference.
This entire application is built around being able to use connectstring
reliably. I don't know what I'm going to do if this problem can't be solved
... We've been on hold for 2 weeks now .. argh! heh.
<cf_mini_rant>
Hopefully MM tech support will get their act together soon. I mean,
it's kind of bad when I'm sitting here waiting on a response from them and
finaly E-mail the tech support guy I've been talking to only to have him
E-mail me back saying, more or less, "oh, by the way, I'm not in tech
support any more. Call the support number again and get the next available
engineer.". Gee .. nice of them to let me know ... not like I'm 2 weeks
behind schedule already or anything ...
OK .. I feel a little better now .. what a Monday, heh.
</cf_mini_rant>
Thanks all,
Todd
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
