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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8
    • 1.7, 1.8
    • Authentication, Database SQL/XMLDB
    • None
    • MSSQL & ORACLE
    • Microsoft SQL, Oracle
    • MOODLE_17_STABLE, MOODLE_18_STABLE
    • MOODLE_18_STABLE

      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?

            stronk7 Eloy Lafuente (stronk7)
            stronk7 Eloy Lafuente (stronk7)
            Nobody Nobody (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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