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

From Bing Du
Subject Re: catch password on Postgres server
Date
Msg-id 1196.129.186.197.127.1075761005.squirrel@mail.eng.iastate.edu
Whole thread Raw
In response to Re: catch password on Postgres server  (Richard Huxton <dev@archonet.com>)
Responses Re: catch password on Postgres server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
Regarding of changing ereport(), what's its syntax supposed to be?  Would

ereport(LOG, (buf.data))

echo password to logs?

Appreciate any help as always,

Bing

> 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: Jeff Eckermann
Date:
Subject: Re: using pgsql-odbc with ASP and ADO
Next
From: Jon Willeke
Date:
Subject: experimental Unicode support