[pgpool-general: 4791] Re: Pg pool setup issues

[Tatsuo Ishii]

[Cc: to pgpool-hackers removed since this is not related to the list]

See http://pgpool.net/mediawiki/index.php/FAQ and search "md5"
Also see the pgpool-II manual how to set up the pgpool-II authentication.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: "Vaidyanathaswamy, Sai (NBCUniversal)" <Sai.Vaidyanathaswamy at nbcuni.com>
Subject: [pgpool-general: 4789] Pg pool setup issues
Date: Mon, 18 Jul 2016 20:59:19 +0000
Message-ID: <F2FB436BF14DEB4FAC67561BEA46313BB772C9 at USUSHEMWP013.mail.tfayd.com>

> HI Support,
> 
> I am trying to implement pgpool database/creation and replication with 3 different server, Master/slave and class server.
> 
> I am not able to create a database, I am getting the following errors . Your help is much appreciated.
> I have changed the pg_hba.conf to the following
> 
> 
> 
> 2016-07-18 13:49:57: pid 2974: DETAIL:  Protocol Major: 3 Minor: 0 database: template1 user: openplatform
> 2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
> 2016-07-18 13:49:57: pid 2974: DETAIL:  connecting 0 backend
> 2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
> 2016-07-18 13:49:57: pid 2974: DETAIL:  connecting 1 backend
> 2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
> 2016-07-18 13:49:57: pid 2974: DETAIL:  skipping backend slot 1 because backend_status = 3
> 2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
> 2016-07-18 13:49:57: pid 2974: DETAIL:  connecting 2 backend
> 2016-07-18 13:49:57: pid 2974: DEBUG:  SSL is requested but SSL support is not available
> 2016-07-18 13:49:57: pid 2974: DEBUG:  SSL is requested but SSL support is not available
> 2016-07-18 13:49:57: pid 2974: DEBUG:  pool_read: read 13 bytes from backend 0
> 2016-07-18 13:49:57: pid 2974: DEBUG:  pool_read: read 13 bytes from backend 2
> 2016-07-18 13:49:57: pid 2974: DEBUG:  reading message length
> 2016-07-18 13:49:57: pid 2974: DETAIL:  slot: 0 length: 12
> 2016-07-18 13:49:57: pid 2974: DEBUG:  reading message length
> 2016-07-18 13:49:57: pid 2974: DETAIL:  slot: 2 length: 12
> 2016-07-18 13:49:57: pid 2974: DEBUG:  authentication backend
> 2016-07-18 13:49:57: pid 2974: DETAIL:  auth kind:5
> 2016-07-18 13:49:57: pid 2974: ERROR:  failed to authenticate with backend
> 2016-07-18 13:49:57: pid 2974: DETAIL:  MD5 authentication is not supported in replication and master-slave modes.
> 2016-07-18 13:49:57: pid 2974: HINT:  check pg_hba.conf settings on backend node
> 
> 
> 
> 
> 
> 
> 
> # If you want to allow non-local connections, you need to add more
> # "host" records. In that case you will also need to make pgpool listen
> # on a non-local interface via the listen_addresses configuration parameter.
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> # "local" is for Unix domain socket connections only
> #local   all             postgres              md5
> local   all                  all               trust
> # IPv4 local connections:
> host    all              postgres            127.0.0.1/32       ident
> #host    all              all               ::1/128              md5
> host      all             all               100.114.116.68/32    ident
> host      all             all               100.114.116.69/32    ident
> 
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> #local   replication     postgres                                peer
> host    replication     postgres        127.0.0.1/32            ident
> #host    replication     postgres        ::1/128                 ident
> host     replication     postgres       100.114.116.68/32       ident
> host    replication     postgres        100.114.116.69/32        ident
> 
> 
> 
> Thanks !
> sai