[pgpool-general: 6632] Re: pgpool Authentication
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Jul 10 07:24:53 JST 2019
> ---------- 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
More information about the pgpool-general
mailing list