DB manager: certificate is not searched for in QGIS Database

[bstroebl]

Describe the bug

A PostgreSQL-DB connection is configured with SSL-mode = verify full. The certificate has been added in QGIS' Authorities in Database (via Settings - Options - Authentification - Certificate Manager). Loading layers with that connections via the Data Soure Manager is working flawlessly. Opening DB manager and trying to connect opens the Enter credentials dialog stating that the root certificate file "path/root.crt" does not exist. It seems that DB manager does not know about the certificates stored in Authorities in Database.

How to Reproduce

1. Settings - Options - Authentification - Manage Certificates and add the certificate for the PostgreSQL database into the database.
2. Configure a PostgreSQL connection with sslmode = verify full.
3. Test that this connection works.
4. Go to Database - DB manager
5. Click on the just configured connection to connect
6. Enter Credentials Dialog pops up, stating that root certificate file "C:\users\Username\AppData\Roaming/postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification. (see screenshot)

QGIS and OS versions

QGIS 3.17.0 master, QGIS code revision cf37cb9 running on Win10 professional.

[Pedro-Murteira]

@bstroebl Hello, is this still valid on recent versions?

[github-actions]

The QGIS project highly values your report and would love to see it addressed. However, this issue has been left in feedback mode for the last 14 days and is being automatically marked as "stale".
If you would like to continue with this issue, please provide any missing information or answer any open questions. If you could resolve the issue yourself meanwhile, please leave a note for future readers with the same problem and close the issue.
In case you should have any uncertainty, please leave a comment and we will be happy to help you proceed with this issue.
If there is no further activity on this issue, it will be closed in a week.

[github-actions]

While we hate to see this happen, this issue has been automatically closed because it has not had any activity in the last 42 days despite being marked as feedback. If this issue should be reconsidered, please follow the guidelines in the previous comment and reopen this issue.
Or, if you have any further questions, there are also further support channels that can help you.

[miceg]

I'm able to reproduce this issue on QGIS 3.38.0 on macOS and Windows with the "layer properties" dialog.

Copying the CA certificate file to ~/.postgresql/root.crt (or %HOME%/AppData/Roaming/postgresql/root.crt on Windows) seems to work around the issue.