[pgpool-general: 4991] failed to authenticate

Mephysto mephystoonhell at gmail.com
Wed Sep 14 00:29:18 JST 2016


Hi There,
I am getting this error:


2016-09-13 17:20:58: pid 868: ERROR:  failed to authenticate
2016-09-13 17:20:58: pid 868: DETAIL:  invalid authentication message
response type, Expecting 'R' and received 'E'
2016-09-13 17:20:58: pid 868: LOCATION:  child.c:1362


Pgpool-II 3.5.3
postgres 9.5.3


This is my pool_hba:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         postgres                          md5

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         ::1/128               trust

host    all         all         0.0.0.0/0             md5






And this is my pg_hba:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
#local   all             aptredevo                                     md5
#host    all             aptredevo             127.0.0.1/32            md5

local   replication     repmgr                                trust
host    replication     repmgr          0.0.0.0/0               trust
host    redevolution    redevolution    10.0.0.0/24             trust

# "local" is for Unix domain socket connections only
local   all             postgres                                trust
local   repmgr          repmgr                                  trust
# IPv4 local connections:
host    all             postgres        127.0.0.1/32            trust
# IPv6 local connections:
host    all             postgres        ::1/128                 trust
host    repmgr          repmgr          0.0.0.0/0               trust
host    repmgr          repmgr          ::1/128                 trust
host    all             postgres        10.0.0.200/32           md5
host    all             postgres        91.121.182.110/32       md5
host    all             postgres        91.121.117.6/32         md5
host    all             postgres        0.0.0.0/0               reject

local   redevolution    redevolution_db_link                    md5
host    redevolution    redevolution_db_link 127.0.0.1/32       md5
host    redevolution    redevolution_db_link ::1/128            md5


# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                trust
#host    replication     postgres        127.0.0.1/32            trust
#host    replication     postgres        ::1/128                 trust

host    all             all             0.0.0.0/0               md5





Can you help me please?

Thanks in advance.


Meph
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160913/af23da10/attachment.html>


More information about the pgpool-general mailing list