[pgpool-general: 7138] Re: md5 authentication failed on pgpool failover

[Wolf Schwurack]

I attached pgpool.conf, pool_hba.conf and pg_hba.conf from all 3 nodes. 

Wolf

On 7/7/20, 10:44 PM, "Bo Peng" <pengbo at sraoss.co.jp> wrote:

    Hello,
    
    On Wed, 8 Jul 2020 03:09:27 +0000
    Wolf Schwurack <wolf at uen.org> wrote:
    
    > I have 3 pgpool/postgresql nodes with watchdog.  When I start pgpool on the primary node 0. All my application host connect without any errors. When stop pgpool on node 0 to test the failover. Watchdog fails over to node 1 but in pgpool.log on node 1 I’m getting an error md5 authentication failed
    > 
    > Before failover
    > Node 0 pgpool.log
    > 
    > 2020-07-07 14:02:17: pid 1062067: DETAIL:  connecting host=hosted-prev-01.uen.org port=40268
    > 
    > 2020-07-07 14:02:17: pid 1068342: LOG:  new connection received
    > 
    > After failover
    > Node 1 pgpool.log
    > 
    > 2020-07-07 20:49:04: pid 3850: DETAIL:  connecting host=hosted-prev-01.uen.org port=40498
    > 
    > 2020-07-07 20:49:04: pid 3850: ERROR:  md5 authentication failed
    > 
    > 2020-07-07 20:49:04: pid 3850: DETAIL:  password does not match
    > 
    > pool_hba.conf, pool_passwd, pcp.conf and .pgpass are the same on all 3 nodes
    
    I think it may occur due to the settings.
    Could you share your pgpool.conf, pool_hba.conf and pg_hba.conf?
    
    > Host info
    > Ubuntu 20
    > Pgpool II 4.1.1
    > PostgreSQL 12
    > 
    > Wolfgang Schwurack
    > Database/System Administrator
    > Utah Education Network
    > 801-587-9444
    > wolf at uen.org<mailto:wolf at uen.org>
    > 
    
    
    -- 
    Bo Peng <pengbo at sraoss.co.jp>
    SRA OSS, Inc. Japan
    

-------------- next part --------------
A non-text attachment was scrubbed...
Name: pool_hba.node3
Type: application/octet-stream
Size: 17190 bytes
Desc: pool_hba.node3
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pool_hba.node2
Type: application/octet-stream
Size: 17183 bytes
Desc: pool_hba.node2
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pool_hba.node1
Type: application/octet-stream
Size: 17185 bytes
Desc: pool_hba.node1
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.node3
Type: application/octet-stream
Size: 44052 bytes
Desc: pgpool.node3
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0003.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.node1
Type: application/octet-stream
Size: 44052 bytes
Desc: pgpool.node1
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0004.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.node2
Type: application/octet-stream
Size: 44052 bytes
Desc: pgpool.node2
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0005.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pg_hba.node2
Type: application/octet-stream
Size: 5945 bytes
Desc: pg_hba.node2
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0006.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pg_hba.node3
Type: application/octet-stream
Size: 5865 bytes
Desc: pg_hba.node3
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0007.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pg_hba.node1
Type: application/octet-stream
Size: 6026 bytes
Desc: pg_hba.node1
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200708/565b4369/attachment-0008.obj>