Connect error

From: Russell Shaw <rjshaw(at)iprimus(dot)com(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Connect error
Date: 2004-01-12 15:33:20
Message-ID: 4002BE40.6050908@iprimus.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I created a database in debian using psql (as database user russell). My php4 script
can't access it. It reports:

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL:
IDENT authentication failed for user "russell" . in /home/russell/public_html/hello.php on line 2

The script is:

<?php
$conn=pg_connect("dbname=parts_list user=russell");
if(!$conn)
exit(pg_result_error($conn));
?>

I have apache-1.3 running ok. In /etc/postgresql/pg_hba.conf, i
have "ident sameuser". I can access the database ok from my user
account using psql. What can i check now?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2004-01-12 15:39:59 Re: date comparison between perl and postgres
Previous Message Tom Lane 2004-01-12 14:35:08 Re: Delete from a table with JOIN