Re: Weird password problem

["Dana M. Diederich" <dana@realms.org>]

What does that query return when run from the mysql monitor?  If it
does the right thing, you may want to consult the PHP mailing lists and
see if there's a bug.  As a workaround, you can use the LEFT() string
function to grab only the left most characters of the hash.

Cheers.
-Dana
-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,
Dana M. Diederich        Phone: 1.501.855.7175
SMTP: dana@realms.org    HTTP:  http://realms.org/dana/   ICQ: 16433785
Snail Mail: 19 Leicester Drive, Bella Vista, Ar 72714, USA
`Berkeley invented LSD and Unix, and I don't think that's a coincidence.'

> 
> OK,
> 
> >From PHPMySQLAdmin, I did a
> 
> select Passwd, password('[micah's password here]') from Users where
> Handle='micah'
> 
> The first column returned was 378b243e220ca49
> The second was                378b243e220ca493
> 
> This is probably why my script wasn't working.  Why is it adding the
> extra 3 when I use the password('') function???  My connect.php3 script
> compares the equality of these, so that's why it's been failing.
> 
> Any ideas???
>