pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhelp 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