From 79490cefc2a93154ce3835d23257d2f60c1534bc 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 Signed-off-by: Dan Wells --- 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 dbea2600f1..a6cc6686fb 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.43.2