Search Postgresql Archives

Re: Ident authentication failed

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

 



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.

Without knowing how the client is trying to connect to the server this issue will be difficult to solve.


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