Postgresql and PHP4 not working on Debian

tomj88 · 10-12-2005, 07:11 PM

Hi

I have used mysql in the past, and I though I might have a look at postgresql (7.4.8). Well, I installed that and I can conenct through the command line, it shows up on a portscan (port 5432) so it appears to be working. I created a new user (tom) and went to look at getting it to work with php4 on apache2.

I installed php4-pgsql, and made a simple test file. It didn't work (I can't remember the error). So I tried to connect using pear:

B and I got this message:

DB Error: connect failed

This is the php script:

PHP Code:



<?php 
require_once('DB.php'); 
  $dsn = array( 
        'phptype'  => 'pgsql', 
        'hostspec' => 'localhost', 
        'database' => 'tom', 
        'username' => 'tom', 
        'password' => '' 
  ); 
  $db = DB::connect($dsn); 
 
  if (DB::isError($db)) { 
    die ($db->getMessage()); 
  } 
 
?>

Is there something I'm doing wrong here? I know the database 'tom' exists, I know the use 'tom' exists, and I modified the 'phptype' to mysql and it worked.

Thanks in advance,

Tom.

Tinkster · 10-12-2005, 07:52 PM

How is Postgres set-up?
hint: pg_hba.conf

Cheers,
Tink

tomj88 · 10-12-2005, 08:07 PM

This is at the end of the file (the top 50 or so lines are comments):

Code:

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
# Database administrative login by UNIX sockets
local   all         postgres                                        ident sameuser
#
# All other connections by UNIX sockets
local   all         all                                             ident sameuser
#
# All IPv4 connections from localhost
host    all         all         127.0.0.1         255.255.255.255   ident sameuser
#
# All IPv6 localhost connections
host    all         all         ::1               ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        ident sameuser
host    all         all         ::ffff:127.0.0.1/128                ident sameuser
#
# reject all other connection attempts
host    all         all         0.0.0.0           0.0.0.0           reject

(I haven't messed with any of postgresql config files yet)

Tinkster · 10-12-2005, 08:17 PM

Assuming that OS username equals DB username this line

Code:

local   all         all                                             ident sameuser

should catch you. Next question would be whether you
can connect to the database outside of PHP. Open a
console (as user tom) and go
psql

If that fails, check postgres' logfile.

Cheers,
Tink

tomj88 · 10-12-2005, 08:43 PM

I can connect fine from the command line using the user tom so I don't think it's a problem with postgresql, rather with php4. Would you like me to post phpinfo() here or some other place?