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

auth_ldap_sync_users failing badly when can't create temporary table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.8.1
    • Fix Version/s: 1.9
    • Labels:
      None
    • Environment:
      mysql 5.0.32, etch
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      The LDAP sync seems to be failing, seems likely to be related to the temp tables (and perhaps lack of XMLDB stuff in ldap sync, remembering the recent discussion on the dev forum). Haven't had a detailed look yet, but:

      /usr/bin/php -c /etc/php5/cli/php.ini /var/www/moodle/auth/ldap/auth_ldap_sync_users.php
      Configuring temp table
      Creating temp table extuser
      Connecting to ldap...
      + 4 users
      <div class="notifytiny" style="text-align:center">Table 'moodletest.extuser' doesn't exist</div><br />

      Notice: Trying to get property of non-object in /var/www/moodle/auth/ldap/auth.php on line 456
      Did not get any users from LDAP – error? – exiting

      That notice seems to centre around:
      $count = get_record_sql('SELECT COUNT(username) AS count, 1 FROM ' . $temptable);

        Attachments

          Activity

            People

            Assignee:
            poltawski Dan Poltawski
            Reporter:
            poltawski Dan Poltawski
            Tester:
            Nobody
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan, Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              3/Mar/08