mahara-contributors team mailing list archive

[Mahara Bot <1694342@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/7862
Committed: https://git.mahara.org/mahara/mahara/commit/6e8fbeea486d7c10524dfc1c273b3e531c0e5f4d
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    17.04_STABLE

commit 6e8fbeea486d7c10524dfc1c273b3e531c0e5f4d
Author: Ilya Tregubov <ilya@xxxxxxxxxxxxxxx>
Date:   Thu Jun 1 15:34:10 2017 +1000

Bug #1694342: clean password from event_log takes long time

behatnotneeded

Change-Id: I26a13d2ef060078abd14bb21a61db147112a4100

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1694342

Title:
  Eventlog update in upgrade taking hours to process

Status in Mahara:
  Fix Committed
Status in Mahara 16.10 series:
  Fix Committed
Status in Mahara 17.04 series:
  Fix Committed
Status in Mahara 17.10 series:
  Fix Committed

Bug description:
  OS: Linux
  DB: Postgres
  Mahara: 16.10.4
  Browser: N/A

  With the latest security release for 16.10.4, the upgrade to clean the
  eventlog of sensitive data can take hours to process.

  We have over 56K records for the 'createuser' event. Most of them are
  LDAP accounts so the data looks like this:

  
  "{"username":"abc","authinstance":"3","firstname":"first","lastname":"last","password":"","email":"myemail@xxxxxxxxxxx","studentid":"1234","ctime":"2016-07-05 11:29:21","urlid":"1234","quota":"524288000","id":85}"

  The upgrade updates these records to remove the '"password":""' data.

  I'll try to improve on this.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1694342/+subscriptions