Re: Insecurity of ODBC debug logging files

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 05 October 2005 18:50
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Insecurity of ODBC debug logging files
>
> I have a gripe here:
> https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=154126
> about the fact that ODBC is willing to store passwords into debug log
> files that aren't secure. Anyone want to do something about it?
>
> Offhand it seems like simply omitting the password from the
> log wouldn't
> be a bad idea.

That was fixed almost 2.5 years ago by Hiroshi. I just check my own logs
and it does mask the passwords appropriately.

> But even then, a log file will frequently contain
> sensitive data (eg, credit card numbers appearing in INSERT
> statements).
> Seems to me that there should also be some care taken to make the log
> file not world-readable.

I'll have a look at writing them with mode 600 on *nix. On Win9x and NT
based systems with FAT partitions there's nothing we can do of course.
I'd rather not make the filenames unpredicatable though as that'll make
it difficult for us to tell users how to track down the right debug log.

Regards, Dave.