From: operationsengineer1@yahoo.com
To: JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>
To: gmr@ehpg.net
Cc: operationsengineer1@yahoo.com
Cc: pgsql-php@postgresql.org
Subject: Re: autentication problem
Date: Fri, 14 Oct 2005 17:00:12 -0700 (PDT)
Message-ID: <20051015000012.33150.qmail@web33309.mail.mud.yahoo.com> (raw)
In-Reply-To: <BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: operationsengineer1@yahoo.com, juanernestof@hotmail.com, gmr@ehpg.net
Subject: Re: autentication problem
In-Reply-To: <20051015000012.33150.qmail@web33309.mail.mud.yahoo.com>
References: <BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl> <20051015000012.33150.qmail@web33309.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox