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

      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

        Gliffy Diagrams

          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: