cant conect to dynamic host-URL

Поиск
Список
Период
Сортировка
Искать

cant conect to dynamic host-URL

От:
Dirk Becker <becker@adocom.de>
Дата:
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.
I dont know where my i did something wrong, i use an Java-Applet which 
connects also with the dynamic Address and works fine too.   :(

Here is my php-Code i use:

// Option-class which holds some information
class Option {
    var $host    = "myname.dyndns.org";     // Adresse des DBMS-Servers
    var $port    = "5432";                              // Port auf dem 
das DBMS laeuft
    var $dbname  = "Database";                   // Name der Datenbank
    var $user    = "postgres";                        // DBMS Benutzer
    var $passwd  = "secret";                         // DBMS Passwort
}

// Connection in index.php
$conn = pg_connect("host=".$OptObj->host." port=".$OptObj->port." 
dbname=".$OptObj->dbname." user=".$OptObj->user." 
password=".$OptObj->passwd);

Re: cant conect to dynamic host-URL

От:
Brew <brew@theMode.com>
Дата:
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

Re: cant conect to dynamic host-URL

От:
"Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
Дата:
[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! 

Re: cant conect to dynamic host-URL

От:
Dirk Becker <becker@adocom.de>
Дата:
Andy Shellam (Mailing Lists) wrote:
> 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.)  from your client for a minute and see if any time out 
> and/or fail.
>
> Andy.

Thanks, but the error only apears while using php / pg_connect()
With pgsql i can connect through the dynamic url without problems :/
Could it be that pg_connect cant connect through real URLs ?

I run php 4.3.3 and PostgreSQL 8.1.0

Re: cant conect to dynamic host-URL

От:
"Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
Дата:
 > Could it be that pg_connect cant connect through real URLs ?

The only difference with a dynamic URL is that the DNS expiry 
(time-to-cache) is much lower (usually 5 minutes as opposed to a day.)  
DNS clients don't see it any differently.
I would try a newer PHP version (latest in the 4 series is 4.4.4).

I must admit I've never had a problem with pg_connect not seeing a 
domain the server itself can.

Is the PostgreSQL server on the same box as PHP?  Have you tried 
connecting through domain sockets instead?

Andy.

Dirk Becker wrote:
> Andy Shellam (Mailing Lists) wrote:
>> 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.)  from your client for a minute and see if any time out 
>> and/or fail.
>>
>> Andy.
>
> Thanks, but the error only apears while using php / pg_connect()
> With pgsql i can connect through the dynamic url without problems :/
> Could it be that pg_connect cant connect through real URLs ?
>
> I run php 4.3.3 and PostgreSQL 8.1.0
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> !DSPAM:37,4549ab3440414261817806!
>
>

Re: cant conect to dynamic host-URL

От:
Dirk Becker <becker@adocom.de>
Дата:
The Server i want to contact only runs the Database, no other services 
and on my Client i had compiled the same postgres version.
I also use an Java-Applet which runs in Browser and with that Applet i 
can connect via jdbc3 (8.1-407) with the dynamic-Address.
So I think it must be a problem with the php libs, i will upgrade soon 
my php-version to php5 for testing ...

Thanks for all your reply's until now :)


Andy Shellam (Mailing Lists) wrote:
> > Could it be that pg_connect cant connect through real URLs ?
>
> The only difference with a dynamic URL is that the DNS expiry 
> (time-to-cache) is much lower (usually 5 minutes as opposed to a 
> day.)  DNS clients don't see it any differently.
> I would try a newer PHP version (latest in the 4 series is 4.4.4).
>
> I must admit I've never had a problem with pg_connect not seeing a 
> domain the server itself can.
>
> Is the PostgreSQL server on the same box as PHP?  Have you tried 
> connecting through domain sockets instead?
>
> Andy.

Re: cant conect to dynamic host-URL

От:
Chris <dmagick@gmail.com>
Дата:
Dirk Becker wrote:
> Andy Shellam (Mailing Lists) wrote:
>> 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.)  from your client for a minute and see if any time out 
>> and/or fail.
>>
>> Andy.
> 
> Thanks, but the error only apears while using php / pg_connect()
> With pgsql i can connect through the dynamic url without problems :/
> Could it be that pg_connect cant connect through real URLs ?

You mean urls coming through mod_rewrite or something?

If it works in general then it's not a php/pgsql issue but a code issue.

-- 
Postgresql & php tutorials
http://www.designmagick.com/
FAQ