Hi Andy, unfortunately, there is no solution at the moment. This is a bug that was caused by a change in the WMS provider handling. This change has resulted in disableling the cache for database logon. This leads to a new request of the credentials after 60 seconds of inactivity. But help is coming: I have contacted Jürgen Fischer, who is working on the problem. But we still need a little patience.
Regards Burghardt -----Ursprüngliche Nachricht----- Von: Schmid Andreas [mailto:[email protected]] Gesendet: Donnerstag, 21. März 2019 16:48 An: Scholle, Burghardt (15-3 GIS); [email protected] Betreff: AW: [QGIS-Developer] Problems when connecting to a PostGIS DB using "ssl mode require". 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 [email protected] http://www.so.ch > -----Ursprüngliche Nachricht----- > Von: QGIS-Developer <[email protected]> Im > Auftrag von [email protected] > Gesendet: Mittwoch, 20. Februar 2019 14:50 > An: [email protected] > 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:[email protected] > > > > _______________________________________________ > QGIS-Developer mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer _______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
