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
