X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 751BF9DC832 for ; Sat, 4 Feb 2006 19:58:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71203-06 for ; Sat, 4 Feb 2006 19:58:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hurricane.stormweb.net (hurricane.stormweb.net [65.39.129.23]) by postgresql.org (Postfix) with ESMTP id DF1439DC81E for ; Sat, 4 Feb 2006 19:57:55 -0400 (AST) Received: (qmail 44640 invoked from network); 4 Feb 2006 18:57:58 -0500 Received: from localhost (127.0.0.1) by localhost with SMTP; 4 Feb 2006 18:57:58 -0500 Received: from S0106001310f09c28.vc.shawcable.net (S0106001310f09c28.vc.shawcable.net [24.85.82.132]) by webmail.weaktight.com (Horde MIME library) with HTTP for ; Sat, 04 Feb 2006 18:57:57 -0500 Message-ID: <20060204185757.smqraps7408kwgog@webmail.weaktight.com> Date: Sat, 04 Feb 2006 18:57:57 -0500 From: vince@weaktight.com To: "Gavin M. Roy" Cc: pgsql-php@postgresql.org Subject: Re: PHP/postgreSQL References: <20060204171435.7lfphylyooggs08c@webmail.weaktight.com> <1FC4E0E4-F55C-4308-8493-5680FEBD797E@ehpg.net> In-Reply-To: <1FC4E0E4-F55C-4308-8493-5680FEBD797E@ehpg.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0.3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.67 required=5 tests=[AWL=0.120, NO_REAL_NAME=0.55] X-Spam-Score: 0.67 X-Spam-Level: X-Archive-Number: 200602/19 X-Sequence-Number: 3435 > Can you try and telnet to the box from your server on port 5432? I don't have shell access to the webserver machine. I can connect from one of my local machines via: telnet 24.85.82.xxx 5432 It brings up an empty console that closes after I enter input. Quoting "Gavin M. Roy" : > 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@weaktight.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: >> >> > $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) . "
\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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >