Re: autentication problem - Mailing list pgsql-php

Juan,

Make sure that your linux user "postgres" has
permissions to access the tables on your linux box.

verify permissions for postgres on the postgres
directory structure.

it osunds like you aren't authenticating against some
check to make sure that postgres can access the
directories and/or tables.

best of luck.



--- JUAN ERNESTO FLORES BELTRAN
<juanernestof@hotmail.com> wrote:

> hi everyone, i tried as explained at:
>
>
http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#AUTH-PG-HBA-CONF
>
> i searched the file pg_hba.conf at:
> /usr/local/pgsql/data/pg_hba.conf
>

.......................................................................................................................................................................................
> Client authentication is controlled by the file
> pg_hba.conf in the data
> directory, e.g., /usr/local/pgsql/data/pg_hba.conf.
> (HBA stands for
> host-based authentication.) A default pg_hba.conf
> file is installed when the
> data directory is initialized by initdb.
>

.......................................................................................................................................................................................
>
> However, i didnt find any pg_hba.conf ahywhere in my
> computer. So how can i
> access to this information in order to configure my
> database system?
>
> I tried both, posgresql running mode and stopped. No
> pg_hba.conf file
> found.....
>               /etc/init.d/postgresql stop
>       and
> /etc/init.d/postgresql start
>
> What should i do next?
> Thanks for your help
> Juan
>
>
> >From: "Gavin M. Roy" <gmr@ehpg.net>
> >To: "JUAN ERNESTO FLORES BELTRAN"
> <juanernestof@hotmail.com>
> >CC: operationsengineer1@yahoo.com,
> pgsql-php@postgresql.org
> >Subject: Re: [PHP] autentication problem
> >Date: Fri, 14 Oct 2005 12:41:00 -0700
> >
>
>http://www.postgresql.org/docs/7.4/interactive/client-
>
> >authentication.html#AUTH-PG-HBA-CONF
> >
> >^^ should have everything you need to know :)
> >
> >Gavin
> >
> >On Oct 14, 2005, at 12:28 PM, JUAN ERNESTO FLORES
> BELTRAN wrote:
> >
> >>Sorry for the english message, i will translate it
> as follows:
> >>
> >>"Warning: pg_connect(): Unable to connect to
> PostgreSQL server:  FATAL:
> >>autentification has failed for      postgres user
> in /srv/
> >>www/htdocs/Prototipo/opciones.php on line 51"
> >>
> >>any other suggesttion?
> >>what shoudl i modify to pg_hba.conf?
> >>
> >>regards
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will
> ignore your desire to
>        choose an index scan if your joining column's
> datatypes do not
>        match
>





__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com