[pgpool-general: 6638] Re: pgpool Authentication
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Jul 10 15:56:03 JST 2019
All right. Can you please provide pgpool.conf and full debug log when
you execute:
psql -U mpsroot -p 5432 -h 192.168.1.233 mpsdb
(You need to add "log_min_messages = debug5" to pgpool.conf and
restart Pgpool-II).
> 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
>> >>
>>
More information about the pgpool-general
mailing list