Re: Ident authentication failed

[Ted To <ted@xxxxxxx>]

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
> >         
> >         
> >       
>       
>