[pgpool-general: 6637] Re: pgpool Authentication

[temp temp]

Hi Tatsuo,

Sorry for adding one more question,
regardless of previous case  i have one more confusion:
Suppose  enable_pool_hba = off and at DB level we are doing authentication,
so in case for cached connection (pgpool to DB), how pgpool
authorized client because in that case connection is already there between
pgpool to DB


On Wed, Jul 10, 2019 at 12:20 PM temp temp <ttemp666 at gmail.com> wrote:

> Hi Tatsuo,
>
> PostgreSQL is running on 192.168.1.103
>
> On Wed, Jul 10, 2019 at 11:59 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
>> 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
>> >>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190710/e163d076/attachment-0001.html>