summaryrefslogtreecommitdiffstats
path: root/makeprofilestable.sh
diff options
context:
space:
mode:
authorterry%netscape.com <>1998-09-03 03:52:48 +0200
committerterry%netscape.com <>1998-09-03 03:52:48 +0200
commit968e9d7a88eeb91e635b88b7e5ae5b795e0b4225 (patch)
tree48fd47f41237d9436e4d066be67a869ca4769992 /makeprofilestable.sh
parenta40c093d9249b8afcf14a4eccc02127d0bd18a08 (diff)
downloadbugzilla-968e9d7a88eeb91e635b88b7e5ae5b795e0b4225.tar.gz
bugzilla-968e9d7a88eeb91e635b88b7e5ae5b795e0b4225.tar.xz
Changed the way password validation works. We now keep a
crypt'd version of the password in the database, and check against that. (This is silly, because we're also keeping the plaintext version there, but I have plans...) Stop passing the plaintext password around as a cookie; instead, we have a cookie that references a record in a new database table, logincookies. IMPORTANT: if updating from an older version of Bugzilla, you must run the following commands to keep things working: ./makelogincookiestable.sh echo "alter table profiles add column cryptpassword varchar(64);" | mysql bugs echo "update profiles set cryptpassword = encrypt(password,substring(rand(),3, 4));" | mysql bugs
Diffstat (limited to 'makeprofilestable.sh')
-rwxr-xr-xmakeprofilestable.sh1
1 files changed, 1 insertions, 0 deletions
diff --git a/makeprofilestable.sh b/makeprofilestable.sh
index 2780d6134..76ce65c31 100755
--- a/makeprofilestable.sh
+++ b/makeprofilestable.sh
@@ -31,6 +31,7 @@ create table profiles (
userid mediumint not null auto_increment primary key,
login_name varchar(255) not null,
password varchar(16),
+cryptpassword varchar(64),
realname varchar(255),
index(login_name)
);