[phpesp-dev] [ phpesp-Bugs-1163968 ] Error in DDL for password fields

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Bugs item #1163968, was opened at 2005-03-15 11:46
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1163968&group_id=8956

Category: SQL
Group: v1.7
Status: Open
Resolution: None
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...

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1163968&group_id=8956