pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
help with - psql: FATAL: Password authentication failed for user "gforge"
10+ messages / 5 participants
[nested] [flat]

* help with - psql: FATAL: Password authentication failed for user "gforge"
@ 2004-12-28 10:53  Sukhdeep Johar <sukhdeep@gmail.com>
  0 siblings, 2 replies; 10+ messages in thread

From: Sukhdeep Johar @ 2004-12-28 10:53 UTC (permalink / raw)
  To: pgsql-novice@postgresql.org, Sukhdeep Johar <sukhdeep@gmail.com>

I followed these steps to create a new user :
1. createuser -P gforge 
2. createdb -U gforge -E UNICODE gforge
3. createlang plpgsql gforge

this gave no errors. 
But when I try to log in, I get the foll error
# psql -h localhost -U gforge gforge 
psql: FATAL:  Password authentication failed for user "gforge"

Any comments, what may be going wrong ?
-- 
Neither success nor failure is ever final



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* help with - psql: FATAL: Password authentication failed for user "gforge"
@ 2004-12-28 10:54  Sukhdeep Johar <sukhdeep@gmail.com>
  parent: Sukhdeep Johar <sukhdeep@gmail.com>
  1 sibling, 2 replies; 10+ messages in thread

From: Sukhdeep Johar @ 2004-12-28 10:54 UTC (permalink / raw)
  To: Sukhdeep Johar <sukhdeep@gmail.com>; pgsql-admin

I followed these steps to create a new user :
1. createuser -P gforge
2. createdb -U gforge -E UNICODE gforge
3. createlang plpgsql gforge

this gave no errors.
But when I try to log in, I get the foll error
# psql -h localhost -U gforge gforge
psql: FATAL:  Password authentication failed for user "gforge"

Any comments, what may be going wrong ?
--
Neither success nor failure is ever final


-- 
Neither success nor failure is ever final



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed for user "gforge"
@ 2004-12-28 11:57  Benjamin GASSMANN <benjamin@actimage.net>
  parent: Sukhdeep Johar <sukhdeep@gmail.com>
  1 sibling, 1 reply; 10+ messages in thread

From: Benjamin GASSMANN @ 2004-12-28 11:57 UTC (permalink / raw)
  To: Sukhdeep Johar <sukhdeep@gmail.com>; pgsql-admin

Hello,

try without parameter "-h localhost"

Le Tue, 28 Dec 2004 16:24:58 +0530, Sukhdeep Johar <sukhdeep@gmail.com> a  
écrit:

> I followed these steps to create a new user :
> 1. createuser -P gforge
> 2. createdb -U gforge -E UNICODE gforge
> 3. createlang plpgsql gforge
>
> this gave no errors.
> But when I try to log in, I get the foll error
> # psql -h localhost -U gforge gforge
> psql: FATAL:  Password authentication failed for user "gforge"
>
> Any comments, what may be going wrong ?
> --
> Neither success nor failure is ever final
>
>



-- 
Benjamin GASSMANN
ACTIMAGE
http://www.actimage.net

GSM : 06.80.12.07.66



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed
@ 2004-12-28 13:15  "Lic. Guillermo González" <g.gonzalez@cybira.biz>
  parent: Sukhdeep Johar <sukhdeep@gmail.com>
  1 sibling, 1 reply; 10+ messages in thread

From: "Lic. Guillermo González" @ 2004-12-28 13:15 UTC (permalink / raw)
  To: Sukhdeep Johar <sukhdeep@gmail.com>; pgsql-admin

Sukhdeep Johar wrote:
> I followed these steps to create a new user :
> 1. createuser -P gforge
> 2. createdb -U gforge -E UNICODE gforge
> 3. createlang plpgsql gforge
> 
> this gave no errors.
> But when I try to log in, I get the foll error
> # psql -h localhost -U gforge gforge
> psql: FATAL:  Password authentication failed for user "gforge"
> 
> Any comments, what may be going wrong ?
> --
> Neither success nor failure is ever final
> 
> 
Did you check your pg_hba.conf for gforge database access permisions?




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed for user "gforge"
@ 2004-12-28 13:53  Sukhdeep Johar <sukhdeep@gmail.com>
  parent: "Lic. Guillermo González" <g.gonzalez@cybira.biz>
  0 siblings, 1 reply; 10+ messages in thread

From: Sukhdeep Johar @ 2004-12-28 13:53 UTC (permalink / raw)
  To: Lic. Guillermo González <g.gonzalez@cybira.biz>; +Cc: pgsql-admin@postgresql.org, Sukhdeep Johar <sukhdeep@gmail.com>

can i set database specific access permission in pg_hba.conf ? 
Can you give me some more details. 

My pg_hba.conf setting is : 
local   all         all         trust
host    all         all         127.0.0.1         255.255.255.255   crypt
I disabled all other lines. 

I changed the second line to this :
host    all         all    0.0.0.0      0.0.0.0  trust
Now the psql command passes, but even after removing
all access restrictions, pg_connct() is still failing.

Can you please give some pointers what is going wrong ? 

-Sukhdeep



On Tue, 28 Dec 2004 09:15:56 -0400, Lic. Guillermo González
<g.gonzalez@cybira.biz> wrote:
> Sukhdeep Johar wrote:
> > I followed these steps to create a new user :
> > 1. createuser -P gforge
> > 2. createdb -U gforge -E UNICODE gforge
> > 3. createlang plpgsql gforge
> >
> > this gave no errors.
> > But when I try to log in, I get the foll error
> > # psql -h localhost -U gforge gforge
> > psql: FATAL:  Password authentication failed for user "gforge"
> >
> > Any comments, what may be going wrong ?
> > --
> > Neither success nor failure is ever final
> >
> > 
> Did you check your pg_hba.conf for gforge database access permisions?
> 
> 


-- 
Neither success nor failure is ever final



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed for user "gforge"
@ 2004-12-28 14:03  Benjamin GASSMANN <benjamin@actimage.net>
  parent: Benjamin GASSMANN <benjamin@actimage.net>
  0 siblings, 0 replies; 10+ messages in thread

From: Benjamin GASSMANN @ 2004-12-28 14:03 UTC (permalink / raw)
  To: Benjamin GASSMANN <benjamin@actimage.net>; Sukhdeep Johar <sukhdeep@gmail.com>; pgsql-admin

have you launch postmaster with the option "-i"

Le Tue, 28 Dec 2004 12:57:26 +0100, Benjamin GASSMANN  
<benjamin@actimage.net> a écrit:

> Hello,
>
> try without parameter "-h localhost"
>
> Le Tue, 28 Dec 2004 16:24:58 +0530, Sukhdeep Johar <sukhdeep@gmail.com>  
> a écrit:
>
>> I followed these steps to create a new user :
>> 1. createuser -P gforge
>> 2. createdb -U gforge -E UNICODE gforge
>> 3. createlang plpgsql gforge
>>
>> this gave no errors.
>> But when I try to log in, I get the foll error
>> # psql -h localhost -U gforge gforge
>> psql: FATAL:  Password authentication failed for user "gforge"
>>
>> Any comments, what may be going wrong ?
>> --
>> Neither success nor failure is ever final
>>
>>
>
>
>



-- 
Benjamin GASSMANN
ACTIMAGE
http://www.actimage.net

GSM : 06.80.12.07.66



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed for user "gforge"
@ 2004-12-28 14:26  Sukhdeep Johar <sukhdeep@gmail.com>
  parent: "Lic. Guillermo González" <g.gonzalez@cybira.biz>
  0 siblings, 1 reply; 10+ messages in thread

From: Sukhdeep Johar @ 2004-12-28 14:26 UTC (permalink / raw)
  To: Lic. Guillermo González <g.gonzalez@cybira.biz>; +Cc: pgsql-admin@postgresql.org, Sukhdeep Johar <sukhdeep@gmail.com>

great !! 
ok, psql works now. 
But pg_connect() still fails.

pg_connect() gets executed when I try to access index.php ( homepage
for gforge )
Execution stalls on reaching pg_connect() .

can you give some pointers to this. I have tried all docs that I could :(
-Sukhdeep


On Tue, 28 Dec 2004 11:02:23 -0400, Lic. Guillermo González
<g.gonzalez@cybira.biz> wrote:
> Sukhdeep Johar wrote:
> > can i set database specific access permission in pg_hba.conf ?
> > Can you give me some more details.
> >
> > My pg_hba.conf setting is :
> > local   all         all         trust
> > host    all         all         127.0.0.1         255.255.255.255   crypt
> > I disabled all other lines.
> >
> > I changed the second line to this :
> > host    all         all    0.0.0.0      0.0.0.0  trust
> > Now the psql command passes, but even after removing
> > all access restrictions, pg_connct() is still failing.
> >
> > Can you please give some pointers what is going wrong ?
> >
> > -Sukhdeep
> >
> >
> >
> > On Tue, 28 Dec 2004 09:15:56 -0400, Lic. Guillermo González
> > <g.gonzalez@cybira.biz> wrote:
> >
> >>Sukhdeep Johar wrote:
> >>
> >>>I followed these steps to create a new user :
> >>>1. createuser -P gforge
> >>>2. createdb -U gforge -E UNICODE gforge
> >>>3. createlang plpgsql gforge
> >>>
> >>>this gave no errors.
> >>>But when I try to log in, I get the foll error
> >>># psql -h localhost -U gforge gforge
> >>>psql: FATAL:  Password authentication failed for user "gforge"
> >>>
> >>>Any comments, what may be going wrong ?
> >>>--
> >>>Neither success nor failure is ever final
> >>>
> >>>
> >>
> >>Did you check your pg_hba.conf for gforge database access permisions?
> >>
> >>
> >
> >
> > 
> Try this,
> 
> In your pg_hba.conf
> local   all         all                                             md5
> host    all         all         127.0.0.1         255.255.255.255   md5
> 
> then execute with postgres user to reload de pg_hba.conf changes:
> 
> pg_ctl reload
> 
> and to access your database:
> 
> psql gforge -U gforge -W
> 
> Obs.:
> - refer to the psql man pages for more information about psql options.
> - Note that in the psql command is not present the -h localhost option.
> 
> Regards,
> 


-- 
Neither success nor failure is ever final



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed
@ 2004-12-28 15:02  "Lic. Guillermo González" <g.gonzalez@cybira.biz>
  parent: Sukhdeep Johar <sukhdeep@gmail.com>
  0 siblings, 1 reply; 10+ messages in thread

From: "Lic. Guillermo González" @ 2004-12-28 15:02 UTC (permalink / raw)
  To: Sukhdeep Johar <sukhdeep@gmail.com>; +Cc: pgsql-admin

Sukhdeep Johar wrote:
> can i set database specific access permission in pg_hba.conf ? 
> Can you give me some more details. 
> 
> My pg_hba.conf setting is : 
> local   all         all         trust
> host    all         all         127.0.0.1         255.255.255.255   crypt
> I disabled all other lines. 
> 
> I changed the second line to this :
> host    all         all    0.0.0.0      0.0.0.0  trust
> Now the psql command passes, but even after removing
> all access restrictions, pg_connct() is still failing.
> 
> Can you please give some pointers what is going wrong ? 
> 
> -Sukhdeep
> 
> 
> 
> On Tue, 28 Dec 2004 09:15:56 -0400, Lic. Guillermo González
> <g.gonzalez@cybira.biz> wrote:
> 
>>Sukhdeep Johar wrote:
>>
>>>I followed these steps to create a new user :
>>>1. createuser -P gforge
>>>2. createdb -U gforge -E UNICODE gforge
>>>3. createlang plpgsql gforge
>>>
>>>this gave no errors.
>>>But when I try to log in, I get the foll error
>>># psql -h localhost -U gforge gforge
>>>psql: FATAL:  Password authentication failed for user "gforge"
>>>
>>>Any comments, what may be going wrong ?
>>>--
>>>Neither success nor failure is ever final
>>>
>>>
>>
>>Did you check your pg_hba.conf for gforge database access permisions?
>>
>>
> 
> 
> 
Try this,

In your pg_hba.conf
local   all         all                                             md5
host    all         all         127.0.0.1         255.255.255.255   md5

then execute with postgres user to reload de pg_hba.conf changes:

pg_ctl reload

and to access your database:

psql gforge -U gforge -W

Obs.:
- refer to the psql man pages for more information about psql options.
- Note that in the psql command is not present the -h localhost option.

Regards,



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed
@ 2004-12-28 15:47  Christian Fowler <spider@viovio.com>
  parent: Sukhdeep Johar <sukhdeep@gmail.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Christian Fowler @ 2004-12-28 15:47 UTC (permalink / raw)
  To: Sukhdeep Johar <sukhdeep@gmail.com>; +Cc: pgsql-admin


sounds like you don't have

tcpip_socket = true

in /var/lib/pgsql/data/postgresql.conf

it is false by default

On Tue, 28 Dec 2004, Sukhdeep Johar wrote:

> great !!
> ok, psql works now.
> But pg_connect() still fails.
>
> pg_connect() gets executed when I try to access index.php ( homepage
> for gforge )
> Execution stalls on reaching pg_connect() .
>
> can you give some pointers to this. I have tried all docs that I could :(
> -Sukhdeep
>

[ \ /
[ >X<   Christian Fowler      | spider AT viovio.com
[ / \   http://www.viovio.com | http://www.tikipro.org



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: help with - psql: FATAL: Password authentication failed for user "gforge"
@ 2004-12-28 21:59  boyd <tbmoore@bealenet.com>
  parent: Sukhdeep Johar <sukhdeep@gmail.com>
  1 sibling, 0 replies; 10+ messages in thread

From: boyd @ 2004-12-28 21:59 UTC (permalink / raw)
  To: pgsql-novice@postgresql.org

Have you set up the file pg_hba.conf in the postgres data directory?
Maybe the new user is not allowed to connect because of an exclusion
there.
Boyd




^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2004-12-28 21:59 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-28 10:53 help with - psql: FATAL: Password authentication failed for user "gforge" Sukhdeep Johar <sukhdeep@gmail.com>
2004-12-28 10:54 ` Sukhdeep Johar <sukhdeep@gmail.com>
2004-12-28 11:57   ` Benjamin GASSMANN <benjamin@actimage.net>
2004-12-28 14:03     ` Benjamin GASSMANN <benjamin@actimage.net>
2004-12-28 13:15   ` Re: help with - psql: FATAL: Password authentication failed "Lic. Guillermo González" <g.gonzalez@cybira.biz>
2004-12-28 13:53     ` Sukhdeep Johar <sukhdeep@gmail.com>
2004-12-28 15:02       ` Re: help with - psql: FATAL: Password authentication failed "Lic. Guillermo González" <g.gonzalez@cybira.biz>
2004-12-28 14:26         ` Sukhdeep Johar <sukhdeep@gmail.com>
2004-12-28 15:47           ` Re: help with - psql: FATAL: Password authentication failed Christian Fowler <spider@viovio.com>
2004-12-28 21:59 ` boyd <tbmoore@bealenet.com>

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