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

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Deferred
    • 2.5, 2.7
    • 2.7
    • Logging
    • MOODLE_25_STABLE, MOODLE_27_STABLE
    • MOODLE_27_STABLE
    • MDL-39933-master
    • 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.
    • 100
    • BACKEND Sprint 11

    Description

      Implement external database log storage.

      It should be possible to disable.

      Attachments

        Issue Links

          Activity

            People

              ankit_frenz Ankit Agarwal
              rajeshtaneja Rajesh Taneja
              Petr Skoda Petr Skoda
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                12/May/14