Uploaded image for project: 'Moodle QA'
  1. Moodle QA
  2. MDLQA-16122 Moodle 4.0 QA
  3. MDLQA-16428

CLONE - Logs may be stored in an external database

    XMLWordPrintable

Details

    Description

      Setup

      1. Create a database other than your Moodle database.
      2. Create a table in the above database identical to the logstore_standard in your Moodle database.

      Test

      1. Log in as an admin and go to 'Manage log stores' in the Site administration.
      2. Enable External database log.
      3. Create a table in the above database identical to the logstore_standard_log in your Moodle database.
      4. Go to settings for the logstore.
      5. Enter your new database and table details and save.
      6. Click on "Test connection" and make sure you can successfully connect to the database table.
      7. Perform multiple actions that trigger events, such as creating/editing/deleting activities.
      8. For activity deletion, after deleting go to the recycle bin via More... (or the Administration block is using Classic theme) and click 'Delete all'.
      9. Run cron php admin/cli/cron.php
      10. Go to 'Log report' in the Site administration.
      11. Select "External database" from the drop down for logstores and click on "Get these logs"
      12. Make sure you see a list of log entries related to the actions you performed earlier.

      Attachments

        1. m40TEST-Administration-Plugins-Logging-Test-connection.png
          86 kB
          Fernando Acedo
        2. m40TEST-Logs.png
          294 kB
          Fernando Acedo
        3. m40TEST-Logs(1).png
          90 kB
          Fernando Acedo

        Issue Links

          Activity

            People

              facedo Fernando Acedo
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: