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

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

XMLWordPrintable

    • 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" .

      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.

        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

            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

              Created:
              Updated:
              Resolved:

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

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.