[QGIS-Developer] Problems when connecting to a PostGIS DB using "ssl mode require".

[Schmid Andreas]

Did you find any solution for this? I can confirm it on Version 3.4.5 (Standalone Installer, on Windows).

Additionally, I observed the following behaviour:

* When I observe the connections on the DB, I see four connections from QGIS after opening my test project and navigating around in the project. When I stop any activity in QGIS, two of these connections are closed after 60 seconds, and after 60 more seconds, a third connection is closed. When I now start panning around again, new connections are opened, and on this occasion QGIS asks me for the DB credentials again. (It happens even after the first two connections have been closed and then opened again.)

* When QGIS asks for the credentials again and again, if I click on "Cancel", rendering seems to work nonetheless.

* If I disable multi-threaded rendering ("Render layers in parallel using many CPU cores"), this doesn't happen, i.e. I'm asked for the PostGIS credentials only once after opening the project. So I suspect multi-threaded rendering to cause the problem. Maybe it doesn't handle the connection pool correctly?


Just for completeness: It's about a PostGIS connection with no credentials saved, neither in the project nor in the authentication database, with SSL mode set to "prefer", and a DB accepting SSL connections only.


Best regards,
Andy


Andreas Schmid
Amt für Geoinformation
Rötistrasse 4
4501 Solothurn
Telefon +41 32 627 75 93
andreas.schmid at bd.so.ch
http://www.so.ch




> -----Ursprüngliche Nachricht-----
> Von: QGIS-Developer <qgis-developer-bounces at lists.osgeo.org> Im Auftrag
> von Burghardt.Scholle at stadt.wolfsburg.de
> Gesendet: Mittwoch, 20. Februar 2019 14:50
> An: qgis-developer at lists.osgeo.org
> Betreff: [QGIS-Developer] Problems when connecting to a PostGIS DB using
> "ssl mode require".
> 
> Hi,
> 
> with Windows 10 / Windows 7, QGIS 3.4.4.3 (OSGeo4W64, code version
> af723c4942) I have the problem that the window "Enter Credentials" is
> called again and again during work. The "Log Messages" says:
> 
>  WARNING    Connection to database failed
>              fe_sendauth: no password supplied
> 
> 
> But I can't find a corresponding message in the PG server log. No entry is
> made there.
> This error does not occur with QGIS version 3.4.4.1 (OSGeo4W64, code
> version f6ddc62fdb) or with Xubuntu 18.04 with 3.4.4+28bionic (code
> version f6ddc62).
> 
> Can anyone confirm this bug?
> 
> Thanks a lot and kind regards
> 
> Burghardt
> 
> ***************
> 
> Stadt Wolfsburg
> Geschäftsbereich IT - 15-3 GIS
> Rathaus E, Zi. E 313, Porschestraße 47A, D-38440 Wolfsburg Tel +49 5361
> 28-2531 Fax +49 5361 28-1765 mailto:burghardt.scholle at stadt.wolfsburg.de
> 
> 
> 
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer