[Qgis-developer] Working on Postgres provider PKI authentication support

[Luigi Pirelli]

Hi SebDieBln (I've no your email)

I'm working for Boundless to add PKI authentication to postgres
provider. I see you did some work on it:
https://github.com/qgis/QGIS/pull/2473

This email is to share some instruments I did to allow a environmental
testing. I hope are useful for you and for all the community.

I'm developing qgis patches here (<- sorry SebDieBln ;) )
https://github.com/luipir/qgis/tree/postgis-pki

To allow a better testing env (integration test not unit test) I
prepared some docker data containers on the top of tim's
kartoza/postgis docker.
These containers allow to run a postgis container configured to accept
certified connections using test certs in:
https://github.com/qgis/QGIS/tree/master/tests/testdata/auth_system/certs_keys

You can find this containers here (sorry again ;) )
https://github.com/luipir/Postgis-pki-datacontainers

eventually you can use this container to setup a certified connection
for you db manager patches.

Luigi Pirelli

**************************************************************************************************
* Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS:
https://www.packtpub.com/application-development/mastering-qgis
**************************************************************************************************