1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2002
    Rep Power

    Exclamation PostgreSQL encrypted password bug?

    I've encounter a strange bug while opening a PostgreSQL connection from php4, with password set as encrypted under pg_hba.conf

    host all crypt -

    and the password set to "1234567890".

    However, I'm able to open the connection with password as "12345678" and even "12345678abcd", but not "1234567" or "1234567a".

    pg_connect ("host= port=5432 dbname=system user=foo password=12345678");

    I concluded that only the 1st 8 characters of the password is used for authentification when encrypted password is used. This doesn't happen password is set as plain text.

    Wondering if any of you guys out there encounter this bug.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Outside US
    Rep Power

IMN logo majestic logo threadwatch logo seochat tools logo