Re: Ident authentication failed

On 3/26/20 12: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"

Can you show the entire connection string used by miniflux?

Did you reload/restart the server after making the changes below?

> 
> 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.klaver@aklaver.com