Обсуждение: 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
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
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 > >
Double check the client authentication configuration on the PostgreSQL server: <http://www.postgresql.org/docs/current/static/client-authentication.html> At 1/14/2004, Bing Du wrote: >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?