Обсуждение: BUG!!! or not?

Поиск
Список
Период
Сортировка

BUG!!! or not?

От
halturin
Дата:
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

Re: BUG!!! or not?

От
Tom Lane
Дата:
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