From 40a417662877fb4a7bc080d47ea7b07e4a34ad8e Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 17 Feb 2016 17:23:34 -0500 Subject: [PATCH] LP#1468422 Drop auth work factor from 14 to 10 Avoid what may be an unacceptible login delay caused by work factor 14 by dropping down to 10. This reduces the CRYPT() time from ~1 second to ~.1 seconds. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.password-storage.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 9223e79403..551fe6672a 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -2440,7 +2440,7 @@ INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) -- Admin user account INSERT INTO actor.passwd_type (code, name, login, crypt_algo, iter_count) - VALUES ('main', 'Main Login Password', TRUE, 'bf', 14); + VALUES ('main', 'Main Login Password', TRUE, 'bf', 10); INSERT INTO actor.usr ( profile, card, usrname, passwd, first_given_name, family_name, dob, master_account, super_user, ident_type, ident_value, home_ou ) VALUES ( 1, 1, md5(random()::text), md5(random()::text), 'Administrator', 'System Account', '1979-01-22', TRUE, TRUE, 1, 'identification', 1 ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.password-storage.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.password-storage.sql index 1c642b64bf..343eb39592 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.password-storage.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.password-storage.sql @@ -214,6 +214,6 @@ $$ STRICT LANGUAGE PLPGSQL; INSERT INTO actor.passwd_type (code, name, login, crypt_algo, iter_count) - VALUES ('main', 'Main Login Password', TRUE, 'bf', 14); + VALUES ('main', 'Main Login Password', TRUE, 'bf', 10); COMMIT; -- 2.11.0