Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D4CF59FA61D for ; Wed, 1 Nov 2006 19:41:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 03531-02 for ; Wed, 1 Nov 2006 23:41:04 +0000 (UTC) X-Greylist: delayed 00:26:33.391706 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E73A49F93E4 for ; Wed, 1 Nov 2006 19:41:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by svr4.postgresql.org (Postfix) with ESMTP id 148615AF87F for ; Wed, 1 Nov 2006 23:14:28 +0000 (GMT) Received: from 80-43-41-26.dynamic.dsl.as9105.com ([80.43.41.26]:2840 helo=[192.168.1.2]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1GfPHx-0003n0-BO for pgsql-php@postgresql.org; Wed, 01 Nov 2006 23:14:29 +0000 Message-ID: <45492A53.6070707@mailnetwork.co.uk> Date: Wed, 01 Nov 2006 23:14:27 +0000 From: "Andy Shellam (Mailing Lists)" Reply-To: andy.shellam@mailnetwork.co.uk Organization: the Mail Network User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: cant conect to dynamic host-URL References: <4548E934.5090904@adocom.de> <1d7288990611011311u6e8c17bbt49a5e67a45faeffb@mail.gmail.com> In-Reply-To: <1d7288990611011311u6e8c17bbt49a5e67a45faeffb@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.47 tagged_above=0 required=5 tests=SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200611/3 X-Sequence-Number: 3621 [root@sydney ~]# nslookup adocom.dyndns.org Server: 80.175.29.73 Address: 80.175.29.73#53 Non-authoritative answer: Name: adocom.dyndns.org Address: 84.191.116.130 [root@sydney ~]# telnet adocom.dyndns.org 5432 Trying 84.191.116.130... Connected to adocom.dyndns.org. Escape character is '^]'. Connects fine from my box. How about firewalls? We had a weird case at work a while back where a router somewhere along the line was blocking all connections until it was ping'd - then after it received a ping, it'd keep the connection open for 20 minutes or so, then start blocking again. Turned out to be faulty! One thing I would check is the domain name lookup. Make sure your DNS servers are properly configured and respond timely (within 2 seconds.) Repeatedly do a "dig adocom.dyndns.org A" from your client for a minute and see if any time out and/or fail. Andy. Brew wrote: > Dirk...... > > Hi there, ive got a dynamic URL like myname.dyndns.org > which links to my > server > where my postgres database runs. The Problem is that the Connection > fails with error: > "Warning: pg_connect(): Unable to connect to PostgreSQL server: > unknown > host name: adocom.dyndns.org " > > Now, if i ping my dynamic address and use the resulting IP for the > Connection all works fine. > > > Are you running php on one machine and postgresql on a different machine? > > If so, maybe the dynamic address redirection service doesn't handle > port 5432. Web servers typically use port 80. > > I don't know where my i did something wrong, i use an Java-Applet which > > connects also with the dynamic Address and works fine too. :( > > > Does it connect with postgresql, or something else on the machine > using a different port? > > I think you can use telnet (or ssh?) to manually connect to any port > number of a host and see how (and if) the machine responds and get a > better idea of what's going on. > > brew > > -- > > Strange Brew (brew@theMode.com ) > > Check out my Stock Option website http://www.callpix.com > and my Musicians Free Classified http://www.TheMode.com > !DSPAM:37,454926c440414055797109!