[pgpool-general: 6631] Fwd: pgpool Authentication

[temp temp]

---------- 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
>
>
>
> Thanks for clarifying my all question.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190709/ca966497/attachment.html>