[pgpool-general: 6296] Re: [pgpool-hackers: 3139] Re: Example for CERT authentication with Pgpool-II

Tatsuo Ishii ishii at sraoss.co.jp
Tue Nov 20 10:05:25 JST 2018


BTW, my environment is following. This may or may not affect the
error.

Ubuntu 18.04 LTS
Docker version 18.09.0, build 4d60db4
docker-compose version 1.23.1, build b02f1306

> Sorry, 2.txt was empty. Attached again.
> 
>>>> Usama,
>>>>
>>>> > Hi
>>>> >
>>>> > I have created a simple docker based example of using CERT authentication
>>>> > with Pgpool-II frontend connections  for the reference.
>>>> >
>>>> > Please have a look and let me know what you think
>>>> >
>>>> > https://github.com/codeforall/pgpool_cert_auth
>>>>
>>>> Unfortunately it does not work for me.
>>>>
>>>> docker exec -it clientnode sudo -u postgres psql "sslmode=require
>>>> port=9999 host=172.22.0.52 dbname=postgres user=certuser" -c "show
>>>> pool_nodes"
>>>> psql: server does not support SSL, but SSL was required
>>>>
>>>>
>>> This is very strange, I have rebuild the dockers by pulling the fresh code
>>> from repo and can run the test successfully.
>>> Seems like setting of ssl configuration is failing.
>>> 
>>> can you please help me identify the issue by sending the log of
>>> "docker-compose up " and of the output of following commands
>> 
>> Sure. Log attached.
>> 
>>> docker exec -it pgmaster  /bin/bash -c 'cat $PGDATA/postgresql.conf'
>> 
>> Attached (1.txt).
>> 
>>> docker exec -it pgmaster  /bin/bash -c 'cd $PGDATA/log && cat "$(ls -1rt  |
>>> tail -n1)"'
>> 
>> Attached (2.txt). 
>> 
>>> docker exec -it pgslave  /bin/bash -c 'cat $PGDATA/postgresql.conf'
>> 
>> Attached (3.txt).
>> 
>>> 
>>> docker exec -it pgslave  /bin/bash -c 'cd $PGDATA/log && cat "$(ls -1rt  |
>>> tail -n1)"'
>> 
>> Attached (4.txt).
>> 
>>> docker exec -it pgpoolnode  /bin/bash -c 'cat ${PGPOOLCONF}/pgpool.conf'
>> 
>> Attached (5.txt).
>> 
>>>> Also I noticed you do not use Pgpool-II RPMs provided by Pgpool-II
>>>> community:
>>>> https://pgpool.net/mediawiki/index.php/Yum_Repository
>>>>
>>>> Is there any reason for this?
>>>>
>>>> No reason as such, I just installed the Pgpool rpms from same repo from
>>> where I was getting the PG server.
>>> I have update the docker files to use the pgpool community rpms instead.
>>> 
>>> https://github.com/codeforall/pgpool_cert_auth/commit/218f7536330677597552330199d0fd637f88d5b0
>>> 
>>> Thanks
>>> Best Regards
>>> Muhammad Usama
>>> 
>>> 
>>> 
>>>> Best regards,
>>>> --
>>>> 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