Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group