Thread: help with - psql: FATAL: Password authentication failed for user "gforge"
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
Re: help with - psql: FATAL: Password authentication failed for user "gforge"
From
"Benjamin GASSMANN"
Date:
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
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?
Re: help with - psql: FATAL: Password authentication failed for user "gforge"
From
Sukhdeep Johar
Date:
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
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,
Re: help with - psql: FATAL: Password authentication failed for user "gforge"
From
"Benjamin GASSMANN"
Date:
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
Re: help with - psql: FATAL: Password authentication failed for user "gforge"
From
Sukhdeep Johar
Date:
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
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