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 20:24:05 |
Message-ID: | e5091d75-e79e-7121-9760-9e9c12fe2654@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.
Alright from here:
https://miniflux.app/docs/configuration.html
The Golang Postgres client pq is being used and:
"The default value for DATABASE_URL is user=postgres password=postgres
dbname=miniflux2 sslmode=disable."
From here:
https://godoc.org/github.com/lib/pq#hdr-Connection_String_Parameters
"host - The host to connect to. Values that start with / are for unix
domain sockets. (default is localhost)"
So unless you have specified a host in the conf file you need to be
paying attention to the lines in pg_hba.conf that start with host.
Where the two lines you added above for host?
You can check what is happening on the server end by looking in the
Postgres logs. That will also show you the connection string.
Do you have more then one instance of Postgres on the machine?
>
> 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 | Christoph Moench-Tegeder | 2020-03-26 20:33:51 | Re: Ident authentication failed |
Previous Message | Rob Sargent | 2020-03-26 20:21:08 | Re: Ident authentication failed |