Re: user exists but mylog says it does not??? - Mailing list pgsql-odbc

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

Best regards
Simeó Reig


----- Original Message -----
From: "Bing Du" <bdu@iastate.edu>
To: <pgsql-odbc@postgresql.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@postgresql.org so that your
>       message can get through to the mailing list cleanly