----- Original Message ----- From: "Michael Fuhr" <[EMAIL PROTECTED]>
Sent: Thursday, December 16, 2004 5:07 PM
Subject: Re: [ADMIN] Notifications
On Thu, Dec 16, 2004 at 02:20:07PM -0000, Donald Fraser wrote:
I'm having problems receiving NOTIFY messages when outside our local network.
Define "problems." What are you doing, what are you expecting to happen, and what actually does happen? Have you tested whether you have the same problems when *inside* the local network? The distinction between inside or outside may be a red herring.
Ok the problem is that outside our local network, and more precise on the outside of our firewall, users do not receive NOTIFY messages. The exact same software running on the local network, albeit not using SSL does receive NOTIFY messages.
I have dissabled firewall setting but nothing seems to fix the problem.
What firewall setting did you disable and why? Best not to mess around with things unless you have reason to think they'll work (in other words, avoid using a stab-in-the-dark approach).
I didn't change anything on our corporate firewall - it has tunnels through so that we can connect to the database, what I was disabling was the microsoft firewall on a PC connected to the database.
I was wandering if NOTIFY messages use UDP or TCP, as that would possibly explain why they are not arriving?
PostgreSQL's NOTIFY messages ride inside your connection to the database, so if you're connected across a network then they'll be TCP. But you shouldn't have to do anything special to allow them: if you can connect to the database then you'll get notifications.
A possible problem is that a firewall or other intermediate device times out idle connections. Do you notice the problem after periods of no activity?
The problem is immediate, I can instanciate the sending of a NOTIFY message from my own connection and I don't receive a return message yet users on the local network do.
Basically now that I know NOTIFY uses TCP and therefore "should" clearly not be getting lost anywhere, I will do a lot more investigating into our software as that is the most likely place for the proble!. It just seems a bit strange that the same software can receive messages when on the local network... The one thing I can be sure of is that it will be software! I think the clue must be the setting up of SSL on our software....
Thanks for the input, regards Donald Fraser.
-- Michael Fuhr http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
