Processing modeler: PostgreSQL execute and load SQL saves password in cleartext

[qgib]

Author Name: Samuel Oester (@soester)
Original Redmine Issue: 20662
Affected QGIS version: 3.4.2
Redmine category:processing/core

---

If using a Postgres Layer with authentication stored in authentication DB as input in 'PostgreSQL execute and load SQL', credentials are stored in cleartext in output layer.
Auth DB id is not used.

[qgib]

Author Name: Victor Olaya (@volaya)

---

I dont understand the error. The algorithm that you mention does not take a layer as input. Instead, it takes a DB connection (just identified with its name), and then a SQL sentence.

I just checked that, for other algorithms that take vector layers, if the layer is based on a PostGIS connection, it adds the authid as param in the log, not the credentials

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Closing for lack of feedback.

---

• resolution was changed from to no timely feedback
• status_id was changed from Feedback to Closed