From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ted To <ted(at)theo(dot)to>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Ident authentication failed |
Date: | 2020-03-26 19:45:34 |
Message-ID: | 45f37378-de5c-72eb-98a8-8d81ef51a5fe@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 3/26/20 12:40 PM, Ted To wrote:
> Thank you -- I added two lines to the hba file to allow for ident
> authentication, restarted postgres and still the same errors.
Without knowing how the client is trying to connect to the server this
issue will be difficult to solve.
>
> On 3/26/20 3:35 PM, Ron wrote:
>> You're only allowing "trust" authentication, not "ident" authentication.
>>
>> On 3/26/20 2:29 PM, Ted To wrote:
>>>
>>> Hi,
>>>
>>> I'm trying to configure miniflux and am struggling to figure out how
>>> to configure postgres for that purpose. (The miniflux instructions
>>> are very terse.) Regardless of whether I run the command as the
>>> postgres user or the miniflux user, I get similar errors. I am
>>> running Centos 7 using the updated scl version of postgres (9.6.10).
>>>
>>> With the following, the postgres user "miniflux" along with the
>>> password are specified in /etc/miniflux.conf.
>>>
>>> $ miniflux -c /etc/miniflux.conf -migrate
>>> Current schema version: 0
>>> Latest schema version: 26
>>> Migrating to version: 1
>>> [FATAL] [Migrate] pq: Ident authentication failed for user "miniflux"
>>>
>>> I have no problems logging into postgres as the miniflux user using
>>> the same password specified in /etc/miniflux.conf.
>>>
>>> Running the same command without specifying the configuration file
>>> uses the postgres user and also fails
>>>
>>> $ miniflux -migrate
>>> [INFO] The default value for DATABASE_URL is used
>>> Current schema version: 0
>>> Latest schema version: 26
>>> Migrating to version: 1
>>> [FATAL] [Migrate] pq: Ident authentication failed for user "postgres"
>>>
>>> My /var/opt/rh/rh-postgresql96/lib/pgsql/data/pg_hba.conf file includes
>>>
>>> # TYPE DATABASE USER ADDRESS METHOD
>>>
>>> local miniflux miniflux trust
>>> local miniflux postgres trust
>>>
>>> # "local" is for Unix domain socket connections only
>>> local all all peer
>>> # IPv4 local connections:
>>> host all all 127.0.0.1/32 trust
>>>
>>> I'm at a complete loss.
>>>
>>> Any suggestions?
>>>
>>> Thanks,
>>>
>>> Ted To
>>>
>>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-03-26 19:49:48 | Re: How can I recreate a view in a new schema such that the view def references tables in the new schema ? |
Previous Message | Ted To | 2020-03-26 19:43:21 | Re: Ident authentication failed |