Re: PHP/postgreSQL
От | vince@weaktight.com |
---|---|
Тема | Re: PHP/postgreSQL |
Дата | |
Msg-id | 20060204185757.smqraps7408kwgog@webmail.weaktight.com обсуждение исходный текст |
Ответ на | Re: PHP/postgreSQL ("Gavin M. Roy" <gmr@ehpg.net>) |
Ответы |
Re: PHP/postgreSQL
(Jeff MacDonald <jam@zoidtechnologies.com>)
|
Список | pgsql-php |
> 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" <gmr@ehpg.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@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: >> >> <?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 > > > ---------------------------(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 >
В списке pgsql-php по дате отправления: