DOS-style line endings in .pgpass

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: DOS-style line endings in .pgpass
Date: 2016-11-14 19:31:22
Message-ID: 0de37763-5843-b2cc-855e-5d0e5df25807@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Version Tested: 9.6.1
Platform: Fedora 24 Docker Base Image
Summary: DOS-style line endings (CRLF) cause .pgpass to fail.

Steps to Reproduce:

1. Install PostgreSQL
2. Set up user with md5 passwords
3. Create pgpass file using program which makes CRLF line endings, such
as Python's CSV module, or windows Notepad.
4. Try to log in
5. Get:

psql: FATAL: password authentication failed for user "postgres"
password retrieved from file "/var/lib/pgsql/.pgpass"

What appears to be happening here is that one of the characters of the
CRLF is being appended to the password, making it invalid.

Is this a known issue on Windows? Or is this peculiar to Fedora?

If it's a general issue, it would be friendly to Windows devs to fix it.

--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Vik Fearing 2016-11-14 19:48:37 Re: DOS-style line endings in .pgpass
Previous Message Rick Otten 2016-11-14 14:18:42 Re: BUG #14420: Parallel worker segfault