Re: Ident authentication failed

Thanks for the many responses I've gotten!  What a useful and welcoming
community!

I finally managed to get it configured following:
https://github.com/miniflux/miniflux/issues/80#issuecomment-375996546

On 3/26/20 4:24 PM, Adrian Klaver wrote:
> 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
>>>>
>>>
>
>