From: | Ted To <ted(at)theo(dot)to> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Ident authentication failed |
Date: | 2020-03-26 19:40:32 |
Message-ID: | 3d5c839c-3680-2dd5-01a6-94690e8a7907@theo.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you -- I added two lines to the hba file to allow for ident
authentication, restarted postgres and still the same errors.
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
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ted To | 2020-03-26 19:43:21 | Re: Ident authentication failed |
Previous Message | Adrian Klaver | 2020-03-26 19:35:34 | Re: Ident authentication failed |