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

auth_ldap_sync_users failing badly when can't create temporary table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.8.1
    • 1.9
    • None
    • mysql 5.0.32, etch
    • MySQL
    • MOODLE_18_STABLE
    • 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

            poltawski Dan Poltawski
            poltawski Dan Poltawski
            Nobody Nobody
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Sujith Haridasan, Andrew Lyons, 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:
              3/Mar/08