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

Backport of MDL-64153: Allow administrator to override sqlsrv connection options

    XMLWordPrintable

Details

    • MOODLE_311_STABLE, MOODLE_400_STABLE, MOODLE_401_STABLE
    • MOODLE_311_STABLE, MOODLE_39_STABLE, MOODLE_400_STABLE, MOODLE_401_STABLE
    • MDL-77669-401
    • Hide
      1. Install Moodle with SQL server as the database, and ensure it's running well.
      2. Add the following to /config.php (or add the 'extrainfo' property if $CFG->dboptions is already defined):

        $CFG->dboptions = [
            'extrainfo' => [
                'Database' => 'SomeDbThatDoesntExist',
                'UID' => 'nouser'     
             ],
        ];
        

      3. Reload the page
      4. Verify that you cannot access Moodle, and you will get a page with a warning "Error: Database connection failed".
      Show
      Install Moodle with SQL server as the database, and ensure it's running well. Add the following to /config.php (or add the 'extrainfo' property if $CFG->dboptions is already defined): $CFG->dboptions = [ 'extrainfo' => [ 'Database' => 'SomeDbThatDoesntExist', 'UID' => 'nouser'     ], ]; Reload the page Verify that you cannot access Moodle, and you will get a page with a warning "Error: Database connection failed" .

    Description

      msodbcsql18 is the current version of msodbcsql and it has enabled encryption by default, with certificate verification too.

      We need to be able to configure the Encrypt options in places like CI.

      We can easily do this by backporting MDL-64153.

      Attachments

        1. mssql_311_expected.png
          mssql_311_expected.png
          103 kB
        2. mssql_39_expected.png
          mssql_39_expected.png
          89 kB
        3. mssql_400_expected.png
          mssql_400_expected.png
          101 kB
        4. mssql_401_expected.png
          mssql_401_expected.png
          103 kB

        Issue Links

          Activity

            People

              dobedobedoh Andrew Lyons
              dobedobedoh Andrew Lyons
              Paul Holden Paul Holden
              Jun Pataleta Jun Pataleta
              Sara Arjona (@sarjona) Sara Arjona (@sarjona)
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                24/Apr/23

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 43 minutes
                  2h 43m