| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | John Taber <jtaber(at)johntaber(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: php + postgresql pg_connect problem |
| Date: | 2005-12-13 20:44:28 |
| Message-ID: | 439F32AC.2050702@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John Taber wrote:
> I am having trouble connecting php(5.1.1) and postgresql(8.1) running on
> Ubuntu Breezy. Both run fine separately. I created a user (tempuser) and
> a database (tempdb). If I run psql -l it shows the database "tempdb"
> with the username "tempuser". But I get the following error using
> pg_connect:
>
> Warning: pg_connect() [function.pg-connect]: Unable to connect to
> PostgreSQL server: FATAL: Ident authentication failed for user
> "tempuser" in /var/www/db_connect.php on line 14
You are using "ident" authentication in your pg_hba.conf file. You
probably don't want this. Start with trust if you are connecting
locally, then turn passwords on once you are happy you can connect.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-12-13 20:45:31 | Re: triggering on deletes, NEW row or OLD row? |
| Previous Message | Jerry LeVan | 2005-12-13 20:41:13 | Installing the latest 8.1.1 rpms question. |