user exists but mylog says it does not???

From: "Bing Du" <bdu(at)iastate(dot)edu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: user exists but mylog says it does not???
Date: 2004-01-14 17:10:37
Message-ID: 3768.129.186.197.127.1074100237.squirrel@mail.eng.iastate.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Greetings,

PostgreSQL 7.4 on RedHat 9.

I don't get this. I can use 'psql -U maxware -W' from the command line to
access the database. I've set up the same username and password in the
system DSN. However, the application using the DSN gives the following
user not exists error in mylog. How so?

By the way, the application is running on the IIS on a Windows 2000.

Also, I apologize for the poor format of the following extracted log
information. Right now, both my mylog and psqlodbc files are not easy to
read due to no line breaks. What I can do to get it better formated?

===============
conn=35927096, PGAPI_DriverConnect( in)='DSN=opal;UID=MAXWARE;PWD=xxxxx;',
fDriverCompletion=0
DSN info:
DSN='opal',server='butterfinger.eng.iastate.edu',port='5432',dbase='maxware',user='MAXWARE',passwd='xxxxx'
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
Global Options: Version='07.03.0200', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
ERROR from backend during authentication: 'FATAL: user "MAXWARE" does not
exist
'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=210, errmsg='FATAL: user "MAXWARE" does not exist
'
------------------------------------------------------------
henv=35927040, conn=35927096, status=0, num_stmts=16
sock=35938096, stmts=35946376, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1380, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=35938168, buffer_out=35942272
buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45
conn=35927096, PGAPI_DriverConnect( in)='DSN=opal;UID=MAXWARE;PWD=xxxxx;',
fDriverCompletion=0
DSN info:
DSN='opal',server='butterfinger.eng.iastate.edu',port='5432',dbase='maxware',user='MAXWARE',passwd='xxxxx'
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
Global Options: Version='07.03.0200', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
ERROR from backend during authentication: 'FATAL: user "MAXWARE" does not
exist
'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=210, errmsg='FATAL: user "MAXWARE" does not exist
'
------------------------------------------------------------
henv=35927040, conn=35927096, status=0, num_stmts=16
sock=35946376, stmts=35938096, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1416, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=35938168, buffer_out=35942272
buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45
conn=35927096, PGAPI_DriverConnect( in)='DSN=opal;UID=MAXWARE;PWD=xxxxx;',
fDriverCompletion=0
DSN info:
DSN='opal',server='butterfinger.eng.iastate.edu',port='5432',dbase='maxware',user='MAXWARE',passwd='xxxxx'
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
Global Options: Version='07.03.0200', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
ERROR from backend during authentication: 'FATAL: user "MAXWARE" does not
exist
'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=210, errmsg='FATAL: user "MAXWARE" does not exist
'
------------------------------------------------------------
henv=35927040, conn=35927096, status=0, num_stmts=16
sock=35938096, stmts=35946376, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1420, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=35938168, buffer_out=35942272
buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45
================

Thanks in advance for any help,

Bing

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Simeó Reig 2004-01-14 17:25:05 Re: user exists but mylog says it does not???
Previous Message Richard Huxton 2004-01-14 15:10:08 Re: ODBC driver on Windows XP Pro