From 10858bda7f3c24bf8010f227297a0e0ab3e0b2d1 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 829642608f..5a8e2f4958 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