Moodle
  1. Moodle
  2. MDL-22906

Integrate Microsoft SQL Server Native PHP Driver into Moodle 2.0

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Labels:
      None
    • Difficulty:
      Moderate
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE
    • Rank:
      35945

      Description

      Once the Microsoft SQL Server Native PHP Driver has been committed (see MDL-15093), we need to integrate it with Moodle 2.0. I implies, at least:

      • add "sqlsrv" (version 9) to 2.0 environment.xml file
      • enable "sqlsrv" in install.php and check everything works (new lang strings, perhaps?)
      • modify any conditional use of get_dbtype() (we shouldn't have any) if necessary.

      Ciao

        Issue Links

          Activity

          Hide
          Eloy Lafuente (stronk7) added a comment -

          Adding some watchers...

          Show
          Eloy Lafuente (stronk7) added a comment - Adding some watchers...
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Oki, done. Now both the web and the cli installer are able to install Moodle 2.0 using the sqlsrv driver.

          Tested in server with/without the driver, both web and cli installers. Everything seems to work.

          Note that finally we don't need to modify environment nor other bits because they are "db-family" based and, as far as the family of "sqlsrv" is the already existing "mssql", everything works ok.

          The next tiny step is to enable, both in the database authentication and database enrolment plugins the ability to use your ADOdb native PHP driver. Note is isn't "sqlsrv" at all, but the name it has under ADOdb that seems to be "mssqlnative".

          Can you confirm it's "your" driver?

          Ciao

          PS: I'm packaging one current 2.0 to be sent to you as agreed.

          Show
          Eloy Lafuente (stronk7) added a comment - Oki, done. Now both the web and the cli installer are able to install Moodle 2.0 using the sqlsrv driver. Tested in server with/without the driver, both web and cli installers. Everything seems to work. Note that finally we don't need to modify environment nor other bits because they are "db-family" based and, as far as the family of "sqlsrv" is the already existing "mssql", everything works ok. The next tiny step is to enable, both in the database authentication and database enrolment plugins the ability to use your ADOdb native PHP driver. Note is isn't "sqlsrv" at all, but the name it has under ADOdb that seems to be "mssqlnative". Can you confirm it's "your" driver? Ciao PS: I'm packaging one current 2.0 to be sent to you as agreed.
          Hide
          Michael Ketcham added a comment -

          Install went fine. Break out the cigars, the baby is born.

          Run functional database tests
          Running tests on: Current database (native/sqlsrv)
          2/2 test cases complete: 689 passes, 0 fails and 0 exceptions.
          Run at Thursday, 24 June 2010, 11:12 AM. Time taken: 7 secs. Using SimpleTest version 1.0.1.
          --------------------------------------------------------------------------------
          Moodle unit tests: lib/dml
          1/1 test cases complete: 470 passes, 0 fails and 0 exceptions.
          Run at Thursday, 24 June 2010, 11:14 AM. Time taken: 3 secs. Using SimpleTest version 1.0.1.
          --------------------------------------------------------------------------------
          Moodle unit tests: lib/ddl
          1/1 test cases complete: 219 passes, 0 fails and 0 exceptions.
          Run at Thursday, 24 June 2010, 11:18 AM. Time taken: 4 secs. Using SimpleTest version 1.0.1.
          --------------------------------------------------------------------------------
          --------------------------------------------------------------------------------

          Win7 enterprise. IIS7, sqlsrv 1.1 NTS VC9, PHP 5.32, SQL*Server 2008 enterprise.

          <?php

          // MOODLE VERSION INFORMATION

          // This file defines the current version of the core Moodle code being used.
          // This is compared against the values stored in the database to determine // whether upgrades should be performed (see lib/db/*.php)

          $version = 2010062100; // YYYYMMDD = date of the last version bump
          // XX = daily increments

          $release = '2.0 Preview 3 (Build: 20100625)'; // Human-friendly version name

          Cheers,
          Mike K

          Show
          Michael Ketcham added a comment - Install went fine. Break out the cigars, the baby is born. Run functional database tests Running tests on: Current database (native/sqlsrv) 2/2 test cases complete: 689 passes, 0 fails and 0 exceptions. Run at Thursday, 24 June 2010, 11:12 AM. Time taken: 7 secs. Using SimpleTest version 1.0.1. -------------------------------------------------------------------------------- Moodle unit tests: lib/dml 1/1 test cases complete: 470 passes, 0 fails and 0 exceptions. Run at Thursday, 24 June 2010, 11:14 AM. Time taken: 3 secs. Using SimpleTest version 1.0.1. -------------------------------------------------------------------------------- Moodle unit tests: lib/ddl 1/1 test cases complete: 219 passes, 0 fails and 0 exceptions. Run at Thursday, 24 June 2010, 11:18 AM. Time taken: 4 secs. Using SimpleTest version 1.0.1. -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Win7 enterprise. IIS7, sqlsrv 1.1 NTS VC9, PHP 5.32, SQL*Server 2008 enterprise. <?php // MOODLE VERSION INFORMATION // This file defines the current version of the core Moodle code being used. // This is compared against the values stored in the database to determine // whether upgrades should be performed (see lib/db/*.php) $version = 2010062100; // YYYYMMDD = date of the last version bump // XX = daily increments $release = '2.0 Preview 3 (Build: 20100625)'; // Human-friendly version name Cheers, Mike K
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Resolving this as fixed. Congrats!

          Now MDL-22907 (docs) is the pending one. I've requested Luis help to put some love there in the Docs. Let's follow the progress in that bug.

          Ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Resolving this as fixed. Congrats! Now MDL-22907 (docs) is the pending one. I've requested Luis help to put some love there in the Docs. Let's follow the progress in that bug. Ciao

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: