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

LDAP authentication (sync_users) doesn't support MSSQL and Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7, 1.8
    • Fix Version/s: 1.8
    • Labels:
      None
    • Environment:
      MSSQL & ORACLE
    • Database:
      Microsoft SQL, Oracle
    • Affected Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE

      Description

      In the ldap authentication plugin, the sync_users() function, has some conditional code to use temporal tables under MySQL and PostgreSQL, but there isn't corresponding code for MSSQL and Oracle.

      While it shouldn't be problematic for Oracle:

      create global temporary table $CFG->prefix .'extuser'
      ......
      (on commit preserve rows?)

      MSSQL has a limitatio: All the temp tables are named with '#' being the 1st char in the name. Obviously this breaks current code and $CFG->prefix usage

      Any idea?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              stronk7 Eloy Lafuente (stronk7)
              Tester:
              Nobody
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                31/Mar/07