Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-39588

Auto-detection if Oracle database used & info to run oci_native_moodle_package.sql

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.5, 2.6
    • Fix Version/s: 2.5.1
    • Component/s: Installation
    • Labels:
      None
    • Database:
      Oracle
    • Testing Instructions:
      Hide

      1/ execute "drop PACKAGE MOODLELIB" in your oracel to remove the package
      2/ access your moodle server - the package should be created automatically if your user has enough rights
      3/ execute phpunit tests
      4/ somehow break the /lib/dml/oci_native_moodle_package.sql and "drop PACKAGE MOODLELIB"
      5/ access moodle - now you should get a general message complaining about missing package
      6/ execute oci_native_moodle_package.sql and everything should be back to normal
      7/ execute phpunit tests

      note: it is enough to execute only ddl and dml unit tests

      Show
      1/ execute "drop PACKAGE MOODLELIB" in your oracel to remove the package 2/ access your moodle server - the package should be created automatically if your user has enough rights 3/ execute phpunit tests 4/ somehow break the /lib/dml/oci_native_moodle_package.sql and "drop PACKAGE MOODLELIB" 5/ access moodle - now you should get a general message complaining about missing package 6/ execute oci_native_moodle_package.sql and everything should be back to normal 7/ execute phpunit tests note: it is enough to execute only ddl and dml unit tests
    • Affected Branches:
      MOODLE_25_STABLE, MOODLE_26_STABLE
    • Fixed Branches:
      MOODLE_25_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w23_MDL-39588_m26_ociinstall

      Description

      Moodle Installation should include an auto-detection if a Oracle DB is used and if so, the user needs to be advised that oci_native_moodle_package.sql needs to be run before performing the installation / upgrade. Otherwise it leads to multiple errors https://moodle.org/mod/forum/discuss.php?d=228116.

      I know this is mentioned in the requirements, but the installer should integrate it as well.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  8/Jul/13