Bugs item #1153614, was opened at 2005-02-28 11:44
Message generated for change (Comment added) made by greggmc
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1153614&group_id=8956
Category: SQL
Group: None
>Status: Closed
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Matthew Gregg (greggmc)
Summary: too small password fields
Initial Comment:
In 1.7 rc(something) the password char columns are too
narrow to accomodate the mysql 4 password() hashes. The
following patch seems to fix it:
===================================================================
RCS file: RCS/mysql_populate.sql,v
retrieving revision 1.1
diff -u -r1.1 mysql_populate.sql
--- mysql_populate.sql 2005/02/28 16:40:32 1.1
+++ mysql_populate.sql 2005/02/28 16:41:25
@@ -31,7 +31,7 @@
-- # table of respondents (people who enter data /
take surveys)
CREATE TABLE respondent (
username CHAR(64) NOT NULL,
- password CHAR(16) NOT NULL,
+ password CHAR(64) NOT NULL,
auth CHAR(16) NOT NULL DEFAULT 'BASIC',
realm CHAR(16) NOT NULL,
fname CHAR(16),
@@ -46,7 +46,7 @@
-- # table of designers (people who create forms /
surveys)
CREATE TABLE designer (
username CHAR(64) NOT NULL,
- password CHAR(16) NOT NULL,
+ password CHAR(64) NOT NULL,
auth CHAR(16) NOT NULL DEFAULT 'BASIC',
realm CHAR(16) NOT NULL,
fname CHAR(16),
----------------------------------------------------------------------
Comment By: Matthew Gregg (greggmc)
Date: 2005-03-08 15:22
Message:
Logged In: YES
user_id=14116
Fixed in CVS.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1153614&group_id=8956
|
