Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 136C46330EE for ; Wed, 3 Mar 2010 13:19:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 46616-07 for ; Wed, 3 Mar 2010 17:19:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id DD8CB632FDD for ; Wed, 3 Mar 2010 13:19:15 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id D897711C023F; Wed, 3 Mar 2010 18:19:11 +0100 (CET) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 3aTUomkBYIBA; Wed, 3 Mar 2010 18:19:07 +0100 (CET) Received: from [10.70.4.200] (unknown [10.70.4.200]) (Authenticated sender: imartinez) by hermes.vectorsf.com (Postfix) with ESMTP id 1AC7E11C0231; Wed, 3 Mar 2010 18:19:07 +0100 (CET) Subject: Re: password authentication failed for user postgres From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala To: Major Services Cc: pgsql-admin@postgresql.org In-Reply-To: <375c2da1003030911o526a14f0hb9ee1cfcf99db6fa@mail.gmail.com> References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com> <1267521253.2942.55.camel@deimos> <375c2da1003030637k6c3ffca6ma65651f1927c02eb@mail.gmail.com> <1267629985.17535.175.camel@deimos> <375c2da1003030911o526a14f0hb9ee1cfcf99db6fa@mail.gmail.com> Content-Type: multipart/alternative; boundary="=-2ry2w3vcpRj/vTXXah/P" Date: Wed, 03 Mar 2010 18:19:09 +0100 Message-ID: <1267636749.17535.192.camel@deimos> Mime-Version: 1.0 X-Mailer: Evolution 2.28.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.839 tagged_above=-10 required=5 tests=AWL=-0.655, BAYES_40=-0.185, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/31 X-Sequence-Number: 33830 --=-2ry2w3vcpRj/vTXXah/P Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit OK, it's a web app installed locally... Modify config file for this app (I don't know about it, so you will have to search by yourserlf) and point to 127.0.0.1 instead of use unix sockets, and also change use postgres for user dbadmin. Or modify your pg_hba.conf like this local all postgres trust I don't suggest to revert to "local all postgres password" since you will have to enter password for any local operation in your server, but anyway, it's your decision. -----Original Message----- From: Major Services To: Iñigo Martinez Lasala Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] password authentication failed for user postgres Date: Wed, 3 Mar 2010 22:41:47 +0530 Thanks. I already have created a user. And can connect to the server through the PgAdmin on my local system. My query now is : Now when I try to connect to the server through DBWebAdmin (in Parallels Plesk Panel); I get the following : Error: FATAL: Ident authentication failed for user "postgres" (earlier, with this link I could reach the login screen for PgAdmin ) Do I need to remove the following from pg_hba.conf now? local all postgres ident sameuser Thanks for all your help & support. On Wed, Mar 3, 2010 at 8:56 PM, Iñigo Martinez Lasala wrote: > Great. You managed to start server. :-) > > You are using user postgres and you shoudn't use it.I suggest you to create > your own dbadmin... > > In your linux box, as root user: > > su - postgres > createuser -s dbadmin -P > > You will create a new user called dbadmin. It will ask you for a password > for this user and some extra options. Response YES to all. > > Now you can connect remotely with this dbadmin user. > > > > -----Original Message----- > From: Major Services > To: Iñigo Martinez Lasala > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] password authentication failed for user postgres > Date: Wed, 3 Mar 2010 20:07:23 +0530 > > > Finally, I am able to create a user. > > Now when I try to connect to the server through DBWebAdmin (in > Parallels Plesk Panel); I get the following : > Error: FATAL: Ident authentication failed for user "postgres" > > (earlier, with this link I could reach the login screen for PgAdmin ) > > Do I need to remove the following from pg_hba.conf now? > local all postgres ident sameuser > > > > > > On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala > wrote: >> In order to lauch createuser you don't need to modify listen_address since >> you can use unix sockets. But anyway it's a requirement if you are goint >> to >> access remotely. >> >> Add this line in first place to your pg_hba.conf >> local all postgres ident sameuser >> >> >> Reload postgresql and launch createuser as postgres user. >> >> >> -----Original Message----- >> From: Major Services >> To: pgsql-admin@postgresql.org >> Subject: [ADMIN] password authentication failed for user postgres >> Date: Tue, 2 Mar 2010 14:13:10 +0530 >> >> Hi, >> >> 1. I have added listen_addresses = '*' ; in postgresql.conf >> >> 2. And have made the following changes to pg_hba.conf >> >> local DATABASE USER METHOD >> local samegroup all password >> host DATABASE USER CIDR-ADDRESS METHOD [OPTION] >> > >> hostssl all all 0.0.0.0/0 md5 >> >> 3. Have restarted the server >> >> 4. I can login to the server as user postgres. >> >> But while trying to createuser I get the following message : >> 'createuser: could not connect to database postgres: FATAL : >> password authentication failed for user "postgres" >> >> This is on Redhat running Plesk also. >> >> I am new to Linux as well as PostgreSQL. Help would be much appreciated. >> >> Thanks >> Viv >> >> >> > > --=-2ry2w3vcpRj/vTXXah/P Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit OK, it's a web app installed locally...

Modify config file for this app (I don't know about it, so you will have to search by yourserlf) and point to 127.0.0.1 instead of use unix sockets, and also change use postgres for user dbadmin.

Or modify your pg_hba.conf like this
local     all     postgres     trust

I don't suggest to revert to "local all postgres password" since you will have to enter password for any local operation in your server, but anyway, it's your decision.

-----Original Message-----
From: Major Services <services.major@gmail.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] password authentication failed for user postgres
Date: Wed, 3 Mar 2010 22:41:47 +0530

Thanks.
I already have created a user.
And can connect to the server through the PgAdmin on my local system.

My query now is :
Now when I try to connect to the server through DBWebAdmin (in
 Parallels Plesk Panel); I get the following :
 Error: FATAL: Ident authentication failed for user "postgres"

 (earlier, with this link I could reach the login screen for PgAdmin )

  Do I need to remove the following from pg_hba.conf now?
  local   all         postgres                          ident sameuser

Thanks for all your help & support.



On Wed, Mar 3, 2010 at 8:56 PM, Iñigo Martinez Lasala
<imartinez@vectorsf.com> wrote:
> Great. You managed to start server. :-)
>
> You are using user postgres and you shoudn't use it.I suggest you to create
> your own dbadmin...
>
> In your linux box, as root user:
>
> su - postgres
> createuser -s dbadmin -P
>
> You will create a new user called dbadmin. It will ask you for a password
> for this user and some extra options. Response YES to all.
>
> Now you can connect remotely with this dbadmin user.
>
>
>
> -----Original Message-----
> From: Major Services <services.major@gmail.com>
> To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 20:07:23 +0530
>
>
> Finally, I am able to create a user.
>
> Now when I try to connect to the server through DBWebAdmin (in
> Parallels Plesk Panel); I get the following :
> Error: FATAL: Ident authentication failed for user "postgres"
>
> (earlier, with this link I could reach the login screen for PgAdmin )
>
>  Do I need to remove the following from pg_hba.conf now?
>  local   all         postgres                          ident sameuser
>
>
>
>
>
> On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala
> <imartinez@vectorsf.com> wrote:
>> In order to lauch createuser you don't need to modify listen_address since
>> you can use unix sockets. But anyway it's a requirement if you are goint
>> to
>> access remotely.
>>
>> Add this line in first place to your pg_hba.conf
>> local   all         postgres                          ident sameuser
>>
>>
>> Reload postgresql and launch createuser as postgres user.
>>
>>
>> -----Original Message-----
>> From: Major Services <services.major@gmail.com>
>> To: pgsql-admin@postgresql.org
>> Subject: [ADMIN] password authentication failed for user postgres
>> Date: Tue, 2 Mar 2010 14:13:10 +0530
>>
>> Hi,
>>
>> 1. I have added  listen_addresses = '*' ; in  postgresql.conf
>>
>> 2. And have made the following changes to pg_hba.conf
>>
>> local   DATABASE    USER   METHOD
>> local    samegroup      all      password
>> host    DATABASE    USER    CIDR-ADDRESS  METHOD  [OPTION]
>>
>
>> hostssl      all                 all       0.0.0.0/0            md5
>>
>> 3. Have restarted the server
>>
>> 4. I can login to the server as user postgres.
>>
>> But  while trying to createuser I get the following message  :
>> 'createuser: could not connect to database postgres:  FATAL :
>> password authentication failed for user "postgres"
>>
>> This is on Redhat running Plesk also.
>>
>> I am new to Linux as well as PostgreSQL. Help would be much appreciated.
>>
>> Thanks
>> Viv
>>
>>
>>
>
>

--=-2ry2w3vcpRj/vTXXah/P--