Re: [PATCH] Prompt for password on Windows platforms - Mailing list pgsql-patches

From Robert Kinberg
Subject Re: [PATCH] Prompt for password on Windows platforms
Date
Msg-id 4617D1C9A5981841B2BF61010024710B05D0A9@exchhq01p.internal.tecore.com
Whole thread Raw
In response to [PATCH] Prompt for password on Windows platforms  ("Robert Kinberg" <kinberg@tecore.com>)
List pgsql-patches
Tom,

There are several posts to the internet about this issue. I found no
solution to these posts either.


Here is a except from a post on the pgsql-bugs mailing list:

Hello,

I have a problem with psql on Windows XP Pro. After an attempt to
connect to a database I get this error:

psql: FATAL:  password authentication failed for user "<username>"

This happens both for local (Windows) and remote (Linux) database. Both
databases are easily accessible from other clients (psql for Linux,
pgAdmin III, jdbc).

The problem is that there is no password prompt even if I try to force
it by -W option. According to pg_hba.conf, there should be no need to
ask for password at all (local/all databases/trust).

There is the same error message in the postgresql log as on the screen
(see above).

Version: psql (PostgreSQL) 8.0.0
Similar bug report: #1354

Best regards
  Filip Hrbek

http://archives.postgresql.org/pgsql-bugs/2005-02/msg00023.php

Another post on the internet indicates that you must change the
authentication type to trust or else you will not be able to
authenticate in a Windows environment.

Install Postgres 8.x (http://www.postgresql.org/download/). Requires
Windows 2000 or later and NTFS. See
http://pginstaller.projects.postgresql.org/FAQ_windows.html for more
info.

    * Create a regular windows user "postgres" with password "postgres".
THIS MUST NOT be an administrator account since the postgres server WILL
NOT RUN as an admin.
    * Install as a service. Use the above postgres account as owner of
the service.
    * Check /your_dir/data/pg_hba.conf file. Change md5 or password
methods to trust:
          o host all all md5 change this to:
          o host all all trust
    * If you don't make this change, then running psql commands will
fail with:
          o psql: FATAL: password authentication failed for user
"postgres"

http://www.metatrontech.com/sql-ledger-wiki/index.php?WindowsInstallatio
n

I was very surprised by this issue as well. I am just assuming that not
many people have a c:\dev directory on their machines where they run
postgreSQL from. That is the only way that you would be able to open the
file '/dev/tty', if the cwd is c:.

If I switch my cwd to a drive that does not have a dev directory at the
root, the problem goes away.

I realize that this seems unbelievable, but I think it is a *real*
problem.

Let me know what you think.

Robert

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, February 22, 2006 2:02 PM
To: Robert Kinberg
Cc: pgsql-patches@postgresql.org
Subject: Re: [PATCHES] [PATCH] Prompt for password on Windows platforms

"Robert Kinberg" <kinberg@tecore.com> writes:
> The current version of psql, pg_dump, ... do not properly prompt the
> user for a password, when the backend database is setup for password
> authentication on a Windows platform.

Curious that you are the *only* person to have noticed such a
fundamental problem... please provide some evidence that this patch is
needed.

            regards, tom lane

pgsql-patches by date:

Previous
From: "P. Scott DeVos"
Date:
Subject: Re: plpython tracebacks
Next
From: "Magnus Hagander"
Date:
Subject: Re: [PATCH] Prompt for password on Windows platforms