diff options
author | terry%netscape.com <> | 1998-09-03 03:52:48 +0200 |
---|---|---|
committer | terry%netscape.com <> | 1998-09-03 03:52:48 +0200 |
commit | 968e9d7a88eeb91e635b88b7e5ae5b795e0b4225 (patch) | |
tree | 48fd47f41237d9436e4d066be67a869ca4769992 /makeprofilestable.sh | |
parent | a40c093d9249b8afcf14a4eccc02127d0bd18a08 (diff) | |
download | bugzilla-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-x | makeprofilestable.sh | 1 |
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) ); |