| From: | Michael Hanna <taojones(at)sympatico(dot)ca> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | Can't connect to 7.4 DB |
| Date: | 2004-02-12 13:36:45 |
| Message-ID: | 80431890-5D60-11D8-B81E-000A95B34330@sympatico.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-php |
Hi this php code:
// add to DB
// database access parameters
$host = "localhost";
$user = "postgres";
$pass = "postgres";
$db = "cosc3p94";
// open a connection to the database server
$connection = pg_connect("host=$host dbname=$db user=$user
password=$pass");
if (!$connection)
{
die("Could not open connection to database server");
}
...
results in:
Could not open connection to database server
and I'm not sure why. The web browser, web server, and database are on
the same machine..
I checked the pg_hba.conf and it says this:
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
local all all
trust
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255
trust
# IPv6-style local connections:
host all all ::1
ffff:ffff:ffff:ffff:ffff:ffff:ff$
which is untouched from the default settings...
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-02-12 15:08:42 | Re: I want to use postresql for this app, but... |
| Previous Message | Chris Travers | 2004-02-12 13:08:52 | Re: I want to use postresql for this app, but... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-02-12 15:30:17 | Re: Can't connect to 7.4 DB |
| Previous Message | David Costa | 2004-02-11 22:22:21 | PHP/PostGreSQL Articles |