BUG!!! or not?

Started by halturinover 24 years ago2 messagesbugs
Jump to latest
#1halturin
halturin@udmnet.ru

Hello pgsql-bugs,
my name is Taras (from Russia). sorry for my bad English.

i have set the password access to connecting to the database.
hash passwords stored in the '/usr/local/pgsql/data/pg_shadow' file.
for example, username is 'lanta' and password is 'asdfghjk'
When i'm connecting i need to enter only password (because user
name = user login name, i'm right? ), so...

servak:/usr/local/pgsql/bin# ./psql -h 192.168.1.1 homebase
Password: <-- entering password 'asdfghjk'
^^^^^^^^
8 - chars

connect is OK...

"where the BUG?"

servak:/usr/local/pgsql/bin# ./psql -h 192.168.1.1 homebase
Password: <-- entering password 'asdfghjkpmqwoeim10234'
^^^^^^^^^^^^^
i have added to the password
any char's and ...
connect is OK...

as far as i understand, you have reserved only 8 chars for the password
or i have found BUG?

--
Best regards,
halturin mailto:halturin@udmnet.ru

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: halturin (#1)
Re: BUG!!! or not?

halturin <halturin@udmnet.ru> writes:

Password: <-- entering password 'asdfghjkpmqwoeim10234'
^^^^^^^^^^^^^
i have added to the password
any char's and ...
connect is OK...

Blame Unix crypt(). It discards characters beyond the 8th on many
platforms. If you try setting an 8-or-more-character password on
your shell account, you'll probably find it behaves the same way.

regards, tom lane