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

[Dennis Gearon]

On Jul 22, 2016 11:02 PM, "Dennis Gearon" <gearond at gmail.com> wrote:
>
> My limited networking skills says to me that all those 127.x.x.x/32
addresses should be 127.x.x.x/24 if I am not mistaken.
>
>
> On Jul 18, 2016 5:02 PM, "Tatsuo Ishii" <ishii at postgresql.org> wrote:
>>
>> [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
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general

Sorry about too posting, it's the default for all the web basd mail
clients, and I seldom add to the great conversations here (and elsewhere)
so I forgot.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160722/81edcefa/attachment-0001.html>