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

Re: php -postgresql

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Jay <jspothar(at)cs(dot)uccs(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: php -postgresql
Date: 2004-07-28 19:15:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
El Mié 28 Jul 2004 15:12, Jay escribió:
> hi people,
> i have been trying to connect to the database using php. but i am not
> able to do so .i am getting the following errors
>       *Warning*: pg_connect(): Unable to connect to PostgreSQL server:
>       FATAL: IDENT authentication failed for user "jay" . in
>       */var/www/proj/psql_results.php* on line *37*

The error message is quite obvious. You have an authentication problem.

First, you are not sending the password, and it looks like you are using the 
ident method to autenticate, so jay should authenticate againt the ident 

You should take a good look at pg_hba.conf before you continue with the 

 16:05:01 up 23 days,  7:42,  1 user,  load average: 1.86, 0.97, 0.57
Martín Marqués        | select 'mmarques' || '@' || ''
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral

In response to

pgsql-general by date

Next:From: Jerry LeVanDate: 2004-07-28 19:45:10
Subject: Re: [DEFAULT] Daily digest v1.4551 (20 messages)
Previous:From: Ian BarwickDate: 2004-07-28 19:08:24
Subject: Re: Tsearch2 dump/reload problem

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