Search Postgresql Archives

Re: Ident authentication failed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux