Re: pg_connect troubles on localhost

John Taber <jtaber@johntaber.net> 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


--
-------------------------------------------------------------------------------
Jerry Sievers   305 854-3001 (home)     WWW ECommerce Consultant
                305 321-1144 (mobile    http://www.JerrySievers.com/