pgpass do not work on qgis master

[qgib]

Author Name: Andy Harney (@andy-harney)
Original Redmine Issue: 16668
Affected QGIS version: master
Redmine category:data_provider

---

Hi,

On QGIS master, QGIS will fail to retrieve passwords from a pgpass.conf file.
This happens when expanding a db tree in Database > DB Manager
The database is added in the PostGIS data provider without a password, which can connect and load layers.

Attached is a screenshot showing this.

Many Thanks.

---

• PGPASS.png (Andy Harney)
• PGPASS_Master.png (Andy Harney)
• PGPASS_2.18.9.png (Andy Harney)

---

Related issue(s): #19290 (relates)
Redmine related issue(s): 10932

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• regression was changed from 0 to 1
• priority_id was changed from Normal to High
• subject was changed from pgpass - Windows to pgpass do not work on qgis master

[qgib]

Author Name: Sandro Santilli (@strk)

---

It could make a good case to add to the new DBManager testsuite: #4688
Can you tell which version was last found working ? Was 2.18 branch tested too ?

[qgib]

Author Name: Andy Harney (@andy-harney)

---

Sandro Santilli wrote:

It could make a good case to add to the new DBManager testsuite: #4688
Can you tell which version was last found working ? Was 2.18 branch tested too ?

I've just tested 2.18.9. Setting up a PostGIS connection fails, as does using DB Manager.
On master, setting up a PostGIS connection works, but DB Manager fails.
I've added more images to show.
Thanks.

---

• 11054 was configured as PGPASS_2.18.9.png
• 11053 was configured as PGPASS_Master.png

---

• PGPASS_2.18.9.png (Andy Harney)
• PGPASS_Master.png (Andy Harney)

[qgib]

Author Name: Sandro Santilli (@strk)

---

Giovanni as you marked this as a regression, do you know which older version worked fine ?

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Sandro Santilli wrote:

Giovanni as you marked this as a regression, do you know which older version worked fine ?

I overlooked the notification and assume that was something only affecting master.

---

• priority_id was changed from High to Normal
• regression was changed from 1 to 0

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Probably a duplicate of #19290 (unix style line endings (linefeed only) expected)

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• relates was configured as qgis not parsing pg_service.conf properly #19290

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Please check if this issue is still valid on QGIS 3.4.5 or 3.6.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Andy Harney (@andy-harney)

---

Giovanni Manghi wrote:

Please check if this issue is still valid on QGIS 3.4.5 or 3.6.

Just tested on QGIS 3.6, Windows 10. This issue is resolved.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• resolution was changed from to fixed/implemented
• status_id was changed from Feedback to Closed