Re: PHP/postgreSQL

["Gavin M. Roy" <gmr(at)ehpg(dot)net>]

Are you sure your isp isn't blocking access?  First thought to come  
to mind is shaw cable might be blocking port 5432.  Can you try and  
telnet to the box from your server on port 5432?  Also check to make  
sure pgsql is listening on tcp/ip.  Also if you're a home shaw  
customer, are you behind a nat router?  Have you opened up access on  
the nat router to get to your box behind it?

HTH,

Gavin

On Feb 4, 2006, at 2:14 PM, vince(at)weaktight(dot)com wrote:

> I'm running PHP/mySQL via a web hosting service.  I require my PHP  
> scripts to
> access an external PostgreSQL database.
>
> I have the PostgreSQL server setup to accept connections from anyone:
> [pg_hba_conf]
>
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
> host all all 0.0.0.0/0 trust
>
> [--]
>
> I've tested this connection via pgAdminIII and I'm able to connect  
> using this
> IP, but when I try to connect via php from the hosted webpage...
>
> My php script is simple:
>
> <?php
> $conn_string = "host=24.85.82.xxx port=5432 dbname=PGSQL1  
> user=postgres
> password=xxx";
>
> $dbconn = pg_connect($conn_string);
>
> if ($dbconn) {
>
> print "Successfully connected to: " . pg_host($dbconn) . "<br/>\n";
>
> } else {
>
> print pg_last_error($dbconn);
> exit;
> }
>
> pg_close($dbconn);
> ?>
>
> But I'm foiled by:
>
> Warning: pg_connect(): Unable to connect to PostgreSQL server:  
> could not connect
> to server: Operation timed out Is the server running on host  
> "24.85.82.xxx" and
> accepting TCP/IP connections on port 5432? in
> /usr/local/psa/home/vhosts/weaktight.com/httpdocs/mytest.php on  
> line 13
>
> Any thoughts or suggestions would be greatly appreciated. I'm not very
> experienced with any of this stuff.
>
> Thanks.
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster