Bugs item #1163968, was opened at 2005-03-15 14:46
Message generated for change (Comment added) made by greggmc
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1163968&group_id=8956
Category: SQL
Group: v1.7
>Status: Closed
>Resolution: Duplicate
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Error in DDL for password fields
Initial Comment:
The default fields for passwords in phpESP 1.7 are too
small for the v4 password() function:
mysql> select password('kaka');
+-------------------------------------------+
| password('kaka') |
+-------------------------------------------+
| *32A50981ABCB34C884B3C11008807BBCB589212A |
+-------------------------------------------+
1 row in set (0.00 sec)
More than will fit in CHAR(16). The attached patch fixes it
For running installations, one might try the following:
(However, I'm not certain the new password() will
understand
v3. hashes, but instead one should use old_password()
which does.)
-- begin
ALTER TABLE designer
MODIFY password CHAR(64) NOT NULL;
ALTER TABLE respondent
MODIFY password CHAR(64) NOT NULL;
--end
/Måns
man...@su...
----------------------------------------------------------------------
>Comment By: Matthew Gregg (greggmc)
Date: 2005-03-15 17:39
Message:
Logged In: YES
user_id=14116
Duplicate bug report already fixed in CVS.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1163968&group_id=8956
|
