[pgpool-general: 6635] Re: pgpool Authentication

[Tatsuo Ishii]

What is the IP address of the host which PostgreSQL is running on?
(I assume that Pgpool-II is running on 192.168.1.233).

> Hi Tatsuo,
> 
> When i directly connect to PostgreSQL, it does ask for password
> 
> On Wed, Jul 10, 2019 at 3:54 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> > ---------- Forwarded message ---------
>> > From: temp temp <ttemp666 at gmail.com>
>> > Date: Tue, Jul 9, 2019 at 10:38 PM
>> > Subject: Re: [pgpool-general: 6626] pgpool Authentication
>> > To: Tatsuo Ishii <ishii at sraoss.co.jp>
>> >
>> >
>> >> Regarding pgpool authentication (pgpool 4.2)
>> >>
>> >> >There's no such a version "4.2". You mean 4.0?
>> >> My mistake, its 4.0
>> >>
>> >> > Configuration are
>> >> >
>> >> > pgpool.conf
>> >> > enable_pool_hba = on
>> >> >
>> >> > pool_hba.conf
>> >> > host    all             all     all    md5
>> >> > local   all             all                                    md5
>> >>
>> >> >What is your pg_hba.conf?
>> >>
>> >> > pool_passwd
>> >> > postgres: "someValue"
>> >> > mpspostgres: "someValue"
>> >> >
>> >> > When i tried to connection to pgpool  (with password as "someValue")
>> >> > psql  -U mpsroot -p 5432 -h 192.168.1.233 mpsdb
>> >> >
>> >> > Que 1 :I am successfully able to connection even though password for
>> >> > mpsroot user is not present in pool_passwd file and axxording to
>> >> >
>> >> >
>> >>
>> https://pgpool.net/mediawiki/index.php/FAQ#I_created_pool_hba.conf_and_pool_passwd_to_enable_md5_authentication_through_pgpool-II_but_it_does_not_work._Why.3F
>> >> >        Auth should fail
>> >>
>> >> >Probably you are of the pattern in the FAQ above.
>> >>
>> >> >pg_hba.conf     pool_hba.conf   pool_passwd     result
>> >> >------------------------------------------------------
>> >> >trust           md5             yes             no auth
>> >>
>> >> I don't think above pattern is hit, because i don't have password
>> mpsroot
>> >> in pool_passwd
>> >>
>> >> >If not, please share pg_hba.conf.
>> >>
>> >> pg_hba.conf
>> >>
>> >> local   all             all                                    trust
>> >> host    all             all             127.0.0.1/32            md5
>> >> host    all             all             0.0.0.0/0            md5
>> >> host    replication     primaryuser     0.0.0.0/0            md5
>>
>> When you directly connect to PostgreSQL (no via Pgpool-II), does
>> PostgreSQL ask password?
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>