Re: password authentication failed for user postgres

From: Major Services <services(dot)major(at)gmail(dot)com>
To: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: password authentication failed for user postgres
Date: 2010-03-04 11:32:14
Message-ID: 375c2da1003040332p14fde480v6a1aef06d21cd1a5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I see.

I have pgAdmin III on my local system and have been able to create database
and tables through it. I hope this is fine?

Thanks once again; though I am sure I'll be back with some query for you and
the community.[?]

On Thu, Mar 4, 2010 at 1:54 PM, Iñigo Martinez Lasala <
imartinez(at)vectorsf(dot)com> wrote:
> dbadmin is a database user, not a Linux user.
> You cannot use dbadmin in order to get logged to your machine. Only to
> access database.
>
> Why are you using dbadmin to login to unix? Use root.
>
> Configure your web app using your root user to login to postgresql with
> dbadmin. You will have to modify a config file somewhere in the path of
this
> app. Read INSTALL or README files of your web app.
>
> Use phppgadmin as alternative. It's also free and it will be probably at
> RedHat/CentOS repos. "yum install phppgadmin" or "up2date install
> phppgadmin"
> Or webmin if you want to admin all server without having to use command
> line. http://www.webmin.com/
>
>
>
>
> -----Original Message-----
> From: Major Services <services(dot)major(at)gmail(dot)com>
> To: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 23:40:39 +0530
>
> When I try to login as dbadmin through shell, I get 'access denied'.
>
> What could be wrong?
>
> On Wed, Mar 3, 2010 at 10:49 PM, Iñigo Martinez Lasala
> <imartinez(at)vectorsf(dot)com> wrote:
>> 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(dot)major(at)gmail(dot)com>
>> To: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
>> Cc: pgsql-admin(at)postgresql(dot)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(at)vectorsf(dot)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(dot)major(at)gmail(dot)com>
>>> To: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
>>> Cc: pgsql-admin(at)postgresql(dot)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(at)vectorsf(dot)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(dot)major(at)gmail(dot)com>
>>>> To: pgsql-admin(at)postgresql(dot)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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Clements 2010-03-05 07:25:24 PostgreSQL Active-Active Configuration
Previous Message Iñigo Martinez Lasala 2010-03-04 08:24:58 Re: password authentication failed for user postgres