[ psqlodbc-Bugs-1000522 ] Enabling logging breaks ODBC for non administrators

Bugs item #1000522, was opened at 2006-01-07 18:52
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10005 22&group_id=1000125

Category: None
Group: None
Status: Closed
Resolution: Accepted
Priority: 3
Submitted By: Magnus Hagander (mha)
Assigned to: Ludek Finstrle (luf)
Summary: Enabling logging breaks ODBC for non administrators

Initial Comment:
Steps to reproduce (tested on windows 2003)

1. Create a user DSN logged in as a non-admin user
2. Create another user DSN logged in as admin user. As this user, enable logging ("mylog")
3. Try to configure the DSN logged in as a non admin user. The ODBC driver crashes with error 998.

This is probably because it can't write to the logfile? Which brings up two points:

1) There should be error checking for that :-) If that's exactly what it is.

2) The logfiles are completely usless for non-administrative users, since they are hardcoded to c:\. This should be configurable, or if it's hardcode dit should at least be hardcoded to the temp directory (as set in the environment), not to c:\. This is true even if my assumption that this permissions issue is what causes the problem specified.

------------------------------------------------------------ ----------

>Comment By: Magnus Hagander (mha)
Date: 2006-01-10 23:02

Message:
This is a good first step, but I think you'll want to fix it
properly at a later time. This way, there is now no way for
you to get an error log from a user who doesn't run as local
administrator! I'm sure that'll come back and bite you
eventually :-)

But it's no longer a deal-breaker, so this is definitly a
good start.

(I'll leave it up to you if you want to re-open the tracker
or if you want to open another somewhere, or just remember
it some other way)

------------------------------------------------------------ ----------

Comment By: Ludek Finstrle (luf)
Date: 2006-01-10 22:58

Message:
I solve it by the easier way. I add error checking.

Patch is attached at the bottom of the page.

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10005 22&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend