[pgpool-hackers: 3584] Re: [Proposal] Support LDAP Authentication

[Takuma Hoshiai]

Thank you for your review.

I have attached my regression test patch as reference information.

You need to do the following step in advance, for execute this regression test.

1. install and start openldap

2. apply patches to pgpool source .

3. update configure
 $ autoheader
 $ aclocal
 $ automake -a -c
 $ autoconf

4. build pgpool (execute ./configure with '--with-ldap' option);

5. execute ldap.sh (setup ldap_user)
 # cd src/test/regression/tests/030.ldap_auth/
 # sh ldap.sh

6. sh regression.sh
 $ cd src/test/regression/	
 $ sh regress.sh 030

Best Regards,

Takuma Hoshiai

On Mon, 20 Apr 2020 14:10:28 +0500
Muhammad Usama <m.usama at gmail.com> wrote:

> Hi Jianshen,
> 
> As discussed can you please help to test and review the patch?
> 
> 
> Thanks
> Best Regards
> Muhammad Usama
> 
> On Mon, Mar 9, 2020 at 11:42 AM Takuma Hoshiai <hoshiai at sraoss.co.jp> wrote:
> 
> > I created and attached a patch which support LDAP authentication between
> > client and Pgpool-II.
> >
> > LDAP authentication can operate in two modes(simple bind mode and search
> > and bind
> > mode), auth options is set by pool_hba.conf.  These are the same as
> > PostgreSQL LDAP
> > authentication.
> >
> > LDAP authentication require a password input from client. It is not used
> > for
> > authentication between Pgpool-II and PostgreSQL by default, because LDAP
> > and PostgreSQL
> > may have different passwords. If LDAP authentication password is the same
> > as PostgreSQL,
> > we can reuse it for authentication between Pgpool-II and PostgreSQL by
> > setting
> > backend_use_password to 1 in auth-options.
> >
> > If you test a this patch, you should need automake and autoconf because
> > this patch
> > edited configure.ac .
> >
> > for example:
> >  $ autoheader
> >  $ aclocal
> >  $ automake -a -c
> >  $ autoconf
> >
> > Comments and suggestions are welcome.
> >
> > --
> > Takuma Hoshiai <hoshiai at sraoss.co.jp>
> > _______________________________________________
> > pgpool-hackers mailing list
> > pgpool-hackers at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-hackers
> >


-- 
Takuma Hoshiai <hoshiai at sraoss.co.jp>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_ldap_auth_test.patch
Type: application/octet-stream
Size: 6626 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200421/9cdd894b/attachment.obj>