X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 970453B7781 for ; Thu, 16 Dec 2004 18:54:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89974-10 for ; Thu, 16 Dec 2004 18:54:35 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 6FF103C9455 for ; Thu, 16 Dec 2004 18:54:34 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id iBGIsRfv012983 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 16 Dec 2004 11:54:30 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id iBGIsRv7002187; Thu, 16 Dec 2004 11:54:27 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id iBGIsQmt002186; Thu, 16 Dec 2004 11:54:26 -0700 (MST) (envelope-from mfuhr) Date: Thu, 16 Dec 2004 11:54:26 -0700 From: Michael Fuhr To: Donald Fraser Cc: "[ADMIN]" Subject: Re: Notifications Message-ID: <20041216185426.GA80816@winnie.fuhr.org> References: <002e01c4e37a$5ab3bae0$6464a8c0@DonAcer> <20041216170721.GA67633@winnie.fuhr.org> <003701c4e396$d9b4a270$6464a8c0@DonAcer> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <003701c4e396$d9b4a270$6464a8c0@DonAcer> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/185 X-Sequence-Number: 15771 On Thu, Dec 16, 2004 at 05:44:09PM -0000, Donald Fraser wrote: > > 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. As with the inside-vs-outside issue, SSL might be a red herring. It's curious that the same software behaves differently in different locations, but be careful not to use tunnel vision when investigating the cause. Is there *anything* else that's different between the systems whose connections work and those whose don't? Is it possible that the outside users are connecting to a different database server than the inside users? What OS are you using, what language, what database interface? How are you checking for NOTIFY messages? > 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. Have you done simple tests with psql? You'd probably have to issue a query before seeing the notification, but that should still tell you if the notification arrived at all. > 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.... Again, beware of putting on blinders. If the database connection is otherwise working then it would be strange if SSL configuration were causing the problem. *Is* the connection otherwise working? -- Michael Fuhr http://www.fuhr.org/~mfuhr/