From 56c8b389191d741ac66d07975b29901a77be8d8f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 28 Feb 2019 17:20:31 -0500 Subject: [PATCH] LP1818153 Log user activity for websocket login/verify Adds support for logging additional user activity types: * websocket v1 login (apache2-websockets) * websocket v2 login (websocketd) * websocket v1 verify * websocket v2 verify * generic login (any ingress) * generic verify (any ingress) Signed-off-by: Bill Erickson Signed-off-by: Michele Morgan --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 23 +++++++++++++++ .../XXXX.data.websocket-activity-types.sql | 28 +++++++++++++++++++ 2 files changed, 51 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.websocket-activity-types.sql 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 80db67122d..4815b28461 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -19874,3 +19874,26 @@ INSERT INTO config.org_unit_setting_type 'bool' ); + +INSERT INTO config.usr_activity_type + (id, ewhat, ehow, egroup, enabled, transient, label) +VALUES ( + 25, 'login', 'ws-translator-v1', 'authen', TRUE, TRUE, + oils_i18n_gettext(25, 'Login via Websocket V1', 'cuat', 'label') +), ( + 26, 'login', 'ws-translator-v2', 'authen', TRUE, TRUE, + oils_i18n_gettext(26, 'Login via Websocket V2', 'cuat', 'label') +), ( + 27, 'verify', 'ws-translator-v1', 'authz', TRUE, TRUE, + oils_i18n_gettext(27, 'Verification via Websocket v1', 'cuat', 'label') +), ( + 28, 'verify', 'ws-translator-v2', 'authz', TRUE, TRUE, + oils_i18n_gettext(28, 'Verifiation via Websocket V2', 'cuat', 'label') +), ( + 29, 'login', NULL, 'authen', TRUE, TRUE, + oils_i18n_gettext(29, 'Generic Login', 'cuat', 'label') +), ( + 30, 'verify', NULL, 'authz', TRUE, TRUE, + oils_i18n_gettext(30, 'Generic Verify', 'cuat', 'label') +); + diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.websocket-activity-types.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.websocket-activity-types.sql new file mode 100644 index 0000000000..69e21e6712 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.websocket-activity-types.sql @@ -0,0 +1,28 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO config.usr_activity_type + (id, ewhat, ehow, egroup, enabled, transient, label) +VALUES ( + 25, 'login', 'ws-translator-v1', 'authen', TRUE, TRUE, + oils_i18n_gettext(25, 'Login via Websocket V1', 'cuat', 'label') +), ( + 26, 'login', 'ws-translator-v2', 'authen', TRUE, TRUE, + oils_i18n_gettext(26, 'Login via Websocket V2', 'cuat', 'label') +), ( + 27, 'verify', 'ws-translator-v1', 'authz', TRUE, TRUE, + oils_i18n_gettext(27, 'Verification via Websocket v1', 'cuat', 'label') +), ( + 28, 'verify', 'ws-translator-v2', 'authz', TRUE, TRUE, + oils_i18n_gettext(28, 'Verifiation via Websocket V2', 'cuat', 'label') +), ( + 29, 'login', NULL, 'authen', TRUE, TRUE, + oils_i18n_gettext(29, 'Generic Login', 'cuat', 'label') +), ( + 30, 'verify', NULL, 'authz', TRUE, TRUE, + oils_i18n_gettext(30, 'Generic Verify', 'cuat', 'label') +); + + +COMMIT; -- 2.43.2