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

Is password case sensitive for psql?  Giving 'abc' or 'ABC' (faked) as the
password both let me in from the psql command line though I set the
password for user 'maxware' to 'abc' on the PostgreSQL server.  But the
application keeps saying user does not exist regardless what case I set
the password up in the DSN.

Bing

> 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
>
>