Re: user exists but mylog says it does not???

Is it possible that username / password is case sensitive ?? :-)

Best regards
Simeó Reig

----- Original Message -----
From: "Bing Du" <bdu(at)iastate(dot)edu>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Wednesday, January 14, 2004 6:10 PM
Subject: [ODBC] user exists but mylog says it does not???

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly