Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-41266 Define logging interfaces in core
  3. MDL-39933

Implement external database log storage plugin

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Minor
    • Resolution: Deferred
    • Affects Version/s: 2.5, 2.7
    • Fix Version/s: 2.7
    • Component/s: Logging
    • Labels:
    • Testing Instructions:
      Hide

      A/ Execute unit tests for all supported databases

      B/ Optionally test manually

      1. This needs to be tested in all databases. (Note: Your actual Moodle can be in any single database, but this must be tested with all supported databases for external database)
      2. Enable external log storage plugin
      3. Setup a table in a database outside your regular Moodle database. The table should be identical to the one that is created by standard logstore plugin.
      4. Goto the settings for external log store plugin, My home ► Site administration ► Plugins ► Logging ► External database log.
      5. Enter your Db config, enter incorrect db password. Make sure an error is generated when you run the 'test connection' tool (after saving).
      6. Enter incorrect table name, with rest details accurate. Make sure an error is generated when you run the 'test connection' tool (after saving).
      7. Enter all correct details. Make sure all configs are saved and no errors are noticed when your run the 'test connection' tool.
      8. Goto any report for example livelogs, and update the drop down to use external database store to display the logs.
      9. Do some actions which generate log and make sure those actions are shown in the report.
      10. Look at the database and make sure entries are added to the table that you specified.
      11. Update filter settings to ignore guest actions.
      12. Do some action that generate guest logs, make sure logs are not generated.
      13. Exclude levels, teaching and participation and save.
      14. Do some action that generate logs with these actions, make sure logs are not generated.
      15. Exclude actions, create and delete and save.
      16. Do some action that generate logs with these actions, make sure logs are not generated.
      17. Repeat tests in MDL-43759, for external database store, to make sure buffering is working.
      Show
      A/ Execute unit tests for all supported databases B/ Optionally test manually This needs to be tested in all databases. (Note: Your actual Moodle can be in any single database, but this must be tested with all supported databases for external database) Enable external log storage plugin Setup a table in a database outside your regular Moodle database. The table should be identical to the one that is created by standard logstore plugin. Goto the settings for external log store plugin, My home ► Site administration ► Plugins ► Logging ► External database log. Enter your Db config, enter incorrect db password. Make sure an error is generated when you run the 'test connection' tool (after saving). Enter incorrect table name, with rest details accurate. Make sure an error is generated when you run the 'test connection' tool (after saving). Enter all correct details. Make sure all configs are saved and no errors are noticed when your run the 'test connection' tool. Goto any report for example livelogs, and update the drop down to use external database store to display the logs. Do some actions which generate log and make sure those actions are shown in the report. Look at the database and make sure entries are added to the table that you specified. Update filter settings to ignore guest actions. Do some action that generate guest logs, make sure logs are not generated. Exclude levels, teaching and participation and save. Do some action that generate logs with these actions, make sure logs are not generated. Exclude actions, create and delete and save. Do some action that generate logs with these actions, make sure logs are not generated. Repeat tests in MDL-43759 , for external database store, to make sure buffering is working.
    • Affected Branches:
      MOODLE_25_STABLE, MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE
    • Pull Master Branch:
      MDL-39933-master
    • Story Points:
      100
    • Sprint:
      BACKEND Sprint 11

      Description

      Implement external database log storage.

      It should be possible to disable.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  12/May/14