Re: catch password on Postgres server - Mailing list pgsql-odbc

From Richard Huxton
Subject Re: catch password on Postgres server
Date
Msg-id 200401292133.02310.dev@archonet.com
Whole thread Raw
In response to catch password on Postgres server  ("Bing Du" <bdu@iastate.edu>)
Responses Re: catch password on Postgres server  ("Bing Du" <bdu@iastate.edu>)
Re: catch password on Postgres server  ("Bing Du" <bdu@iastate.edu>)
List pgsql-odbc
On Thursday 29 January 2004 19:42, Bing Du wrote:
> Greetings,
>
> Postgres 7.4 running on RedHat 9.
>
> We are trying to migrate a MS SQL server based comertial application
> software to a Postgres database.  We know what password that application
> uses to connect to the MS SQL database.

> Is there anyway on the server side to
> see what was  submitted in the password field by the application from the
> client side?

Don't think you can get to the password without changing the code. I can think
of two options:
1. In src/backend/libpq/auth.c search for "echo password to logs" and change
the ereport() to log the password rather than not to. Reply to this if C
isn't your thing.

2. Use tcpdump -s 255 port 5432 and see what's going over the wire. You'd need
to set plaintext passwords though.

Before any of this though, make sure you can connect from Access using that
password.
--
  Richard Huxton
  Archonet Ltd

pgsql-odbc by date:

Previous
From: "Bing Du"
Date:
Subject: catch password on Postgres server
Next
From: Zbynek Houska
Date:
Subject: Setting up ODBC interface