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

[Dennis Gearon]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160722/94a6572a/attachment.html>