thks for info - but my pg_ident is empty (correctly I believe since
users are equal to pg_users) so I have:
pg_ident.conf
# MAPNAME IDENT-USERNAME PG-USERNAME
pg_hba.conf
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
I don't want to start manually editing these files before figuring out
what is going wrong or if something, somehow got corrupted, then how to
clean up and recreate. I am just starting out, so I can delete and
start over if I need to. Any ideas ?
Jerry Sievers wrote:
John Taber <jtaber@xxxxxxxxxxxxx> writes:
using postgresql 8.1 on Ubuntu Breezy
I cannot connect to a database I created - checking \du the username is
listed. I also created a password with #ALTER ROLE yyyy WITH PASSWORD
'zzzz' I tried without password but it calls for a password. Any ideas?
<?php
$vhost = 'localhost';
$vname = 'xxxx';
$vuser = 'yyyy';
$vpassword = 'zzzz';
$db_handle = pg_connect("dbname=$vname user=$vuser password=$vpassword");
pg_close($db_handle);
?>
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server:
FATAL: Ident authentication failed for user "yyyy" in /var/www/test.php
on line 12
See to it that there's an entry in pg_ident.conf to map the webserver
process owner to your vuser DB username.
The error message is telling you that your pg_hba.conf file has an
entry for the database that uses the ident map file.
See comments in both files and the Postgres docs as well for more
info.
HTH
