opengisch / QgisModelBaker

Create QGIS projects from database schemas or Interlis models
https://opengisch.github.io/QgisModelBaker/
GNU Lesser General Public License v3.0
55 stars 17 forks source link

Usage of SSL certs in pg_service #961

Open cymed opened 2 months ago

cymed commented 2 months ago

Suppose we have a service defined in the pg_service.conf such as

[myservice]
host=remotehost
port=5432
dbname=mydb
sslrootcert=path_to_sslrootcert
sslcert=path_to_sslcert
sslkey=path_to_sslkey
sslmode=verify-full

When using this service in model baker (i.e. to export an xtf), the sslrootcert, sslcert and sslkey are ignored and Model Baker requires to add the user info that might be inside the cert.

signedav commented 2 months ago

Out of curiosity: is that read when adding a QGIS layer with a service?

cymed commented 2 months ago

Out of curiosity: is that read when adding a QGIS layer with a service?

Yes it is