pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
To: pgsql-php@postgresql.org
Subject: Re: cant conect to dynamic host-URL
Date: Wed, 01 Nov 2006 23:14:27 +0000
Message-ID: <45492A53.6070707@mailnetwork.co.uk> (raw)
In-Reply-To: <1d7288990611011311u6e8c17bbt49a5e67a45faeffb@mail.gmail.com>
References: <4548E934.5090904@adocom.de>
	<1d7288990611011311u6e8c17bbt49a5e67a45faeffb@mail.gmail.com>

[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
>     <http://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 <http://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 <mailto: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! 




view thread (7+ messages)  latest in thread

Message-ID: <45492A53.6070707@mailnetwork.co.uk>
Permalink:  ../45492A53.6070707@mailnetwork.co.uk/
Also on:    postgresql.org/message-id/45492A53.6070707@mailnetwork.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: andy.shellam-lists@mailnetwork.co.uk
  Subject: Re: cant conect to dynamic host-URL
  In-Reply-To: <45492A53.6070707@mailnetwork.co.uk>
  References: <4548E934.5090904@adocom.de> <1d7288990611011311u6e8c17bbt49a5e67a45faeffb@mail.gmail.com> <45492A53.6070707@mailnetwork.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox