[pgpool-general: 8339] authentication error

[Todd Stein]

I've seen this before and gotten past it, but don't remember how I did it.

-bash-4.2$ psql -h 10.78.121.250 -p 9999 -U pgpool postgres -c "show pool_nodes"
Password for user pgpool:
psql: error: ERROR:  backend authentication failed
DETAIL:  backend response with kind 'E' when expecting 'R'
ERROR:  backend authentication failed
DETAIL:  backend response with kind 'E' when expecting 'R'

-bash-4.2$ yum list installed | grep pgpool
pgpool-II-pg13.x86_64                   4.3.2-1pgdg.rhel7              @pgpool43
pgpool-II-pg13-debuginfo.x86_64         4.3.2-1pgdg.rhel7              @pgpool43
pgpool-II-pg13-devel.x86_64             4.3.2-1pgdg.rhel7              @pgpool43
pgpool-II-pg13-extensions.x86_64        4.3.2-1pgdg.rhel7              @pgpool43
pgpool-II-release.noarch                4.3-1                          @/pgpool-II-release-4.3-1.noarch
-bash-4.2$ yum list installed | grep postgres
postgresql13.x86_64                     13.7-1PGDG.rhel7               @pgdg13
postgresql13-contrib.x86_64             13.7-1PGDG.rhel7               @pgdg13
postgresql13-libs.x86_64                13.7-1PGDG.rhel7               @pgdg13
postgresql13-server.x86_64              13.7-1PGDG.rhel7               @pgdg13


Regards,

Todd Stein




-----Original Message-----
From: pgpool-general <pgpool-general-bounces at pgpool.net> On Behalf Of Tatsuo Ishii
Sent: Tuesday, July 12, 2022 9:55 PM
To: dcristini at gmail.com
Cc: pgpool-general at pgpool.net
Subject: [pgpool-general: 8337] Re: Problems starting pgpgool

Glad to hear that!

> That was exactly the problem. Thanks a lot
> 
> On Tue, Jul 12, 2022 at 9:37 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> Not reproduced here (Ubuntu 20). Maybe OS setting problem?
>>
>>
>> https://stackoverflow.com/questions/39482704/why-do-i-get-duplicate-a
>> ddrinfo-objects-in-the-linked-list-returned-by-getaddrin
>>
>> > Hi
>> >
>> > I am using pgpool_setup to test if it's working. So I am using 
>> > localhost
>> >
>> > On Tue, Jul 12, 2022 at 9:20 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> >
>> >> What is the setting for "listen_addresses" of pgpool.conf?
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese:http://www.sraoss.co.jp
>> >>
>> >> > Hi all
>> >> >
>> >> > I am trying to install pgpool and I am having problems testing 
>> >> > with pgpool-setup it can't bind to a port and it refuses to 
>> >> > start. I've
>> tried
>> >> > multiple ports and of course checked that those ports are free
>> >> >
>> >> > Here's the log. I am using RHEL8 with postgres 13 installed from 
>> >> > the
>> >> Redhat
>> >> > Repository and installed pgpool 4.3.2 from source code
>> >> >
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DEBUG:  initializing 
>> >> > pool configuration
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DETAIL:  
>> >> > num_backends: 2
>> >> > total_weight: 2.000000
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DEBUG:  initializing 
>> >> > pool configuration
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DETAIL:  backend 0 weight:
>> >> > 1073741823.500000 flag: 0000
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DEBUG:  initializing 
>> >> > pool configuration
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DETAIL:  backend 1 weight:
>> >> > 1073741823.500000 flag: 0000
>> >> > 2022-07-12 14:54:20.045: main pid 3683880: LOG:  Backend status 
>> >> > file /var/lib/pgsql2/log/pgpool_status discarded
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: DEBUG:  pool_coninfo_size:
>> >> > num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) *
>> >> > sizeof(ConnectionInfo) (160) = 2621440 bytes requested for 
>> >> > shared
>> memory
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG:
>> >> >  health_check_stats_shared_memory_size: requested size: 12288
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG:  memory cache
>> initialized
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: DETAIL:  memcache 
>> >> > blocks
>> :64
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG:  allocating
>> (136981824)
>> >> > bytes of shared memory segment
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG:  allocating 
>> >> > shared
>> memory
>> >> > segment of size: 136981824
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: DEBUG:  pool_coninfo_size:
>> >> > num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) *
>> >> > sizeof(ConnectionInfo) (160) = 2621440 bytes requested for 
>> >> > shared
>> memory
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: LOG:
>> >> >  health_check_stats_shared_memory_size: requested size: 12288
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: LOG:
>> >> >  health_check_stats_shared_memory_size: requested size: 12288
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: LOG:  memory cache
>> initialized
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: DETAIL:  memcache 
>> >> > blocks
>> :64
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: DEBUG:  memory cache
>> request
>> >> > size : 67108864
>> >> > 2022-07-12 14:54:20.144: main pid 3683880: LOG:
>> pool_discard_oid_maps:
>> >> > discarded memqcache oid maps
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: LOG:  Setting up 
>> >> > socket for
>> >> > ::1:11000
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: LOG:  Setting up 
>> >> > socket for
>> >> > ::1:11000
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: FATAL:  failed to 
>> >> > create
>> INET
>> >> > domain socket
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: DETAIL:  bind on 
>> >> > socket
>> failed
>> >> > with error "Address already in use"
>> >> > 2022-07-12 14:54:20.164: main pid 3683880: LOG:  shutting down
>> >> >
>> >> > Regards
>> >> >
>> >> > Daniel Cristini
>> >>
>>
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general