Moodle
  1. Moodle
  2. MDL-41259

Duplicate shortname can crash LDAP sync

        Details

        • Database:
          Any
        • Testing Instructions:
          Hide

          1/ configure ldap sync with an LDAP server
          2/ configure mapping for shortname, fullname and idnumber of courses
          3/ enable course auto creation
          4/ add two course objects with same value for shortname field to the ldap server
          5/ run cli script enrol/ldap/cli/sync.php

          Show
          1/ configure ldap sync with an LDAP server 2/ configure mapping for shortname, fullname and idnumber of courses 3/ enable course auto creation 4/ add two course objects with same value for shortname field to the ldap server 5/ run cli script enrol/ldap/cli/sync.php
        • Affected Branches:
          MOODLE_24_STABLE, MOODLE_25_STABLE
        • Fixed Branches:
          MOODLE_24_STABLE, MOODLE_25_STABLE, MOODLE_26_STABLE
        • Pull from Repository:
        • Pull Master Branch:
        • Pull Master Diff URL:
        • Rank:
          52231

          Description

          In LDAP enrolment if two course records have the same short name the sync proccess will crash with a "Duplicate Short Name" moodle_exception.

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Nadav Kavalerchik added a comment -

            Hi Michael de Raadt,
            Please elevate Nitzan Bar's permissions so he can request peer-review/code-review.
            (He is a developer on my team)

            Show
            Nadav Kavalerchik added a comment - Hi Michael de Raadt , Please elevate Nitzan Bar 's permissions so he can request peer-review/code-review. (He is a developer on my team)
            Hide
            Permalink
            Michael de Raadt added a comment -

            Thanks for recommending Nitzan, Nadav.

            Nitzan: I've added you to the developers group here in tracker.

            It's good to have another person with LDAP skills around.

            Show
            Michael de Raadt added a comment - Thanks for recommending Nitzan, Nadav. Nitzan: I've added you to the developers group here in tracker. It's good to have another person with LDAP skills around.
            Hide
            Permalink
            Nitzan Bar added a comment -

            Thanks Michael de Raadt

            Show
            Nitzan Bar added a comment - Thanks Michael de Raadt
            Hide
            Permalink
            Petr Škoda added a comment -

            hi, there are a few cosmetic problems:

            1. the comments do not comply with are coding style rules http://docs.moodle.org/dev/Coding_style#Inline_comments
            2. the lang strings should be ordered by keys
            3. the new string has two dots intead of three, and the idnumber should be probably before that

            My +1 to get this to master if the above issues get resolved, thanks for the report and patch.

            Show
            Petr Škoda added a comment - hi, there are a few cosmetic problems: the comments do not comply with are coding style rules http://docs.moodle.org/dev/Coding_style#Inline_comments the lang strings should be ordered by keys the new string has two dots intead of three, and the idnumber should be probably before that My +1 to get this to master if the above issues get resolved, thanks for the report and patch.
            Hide
            Permalink
            Nitzan Bar added a comment -

            Hi,
            Thanks for your comments.
            I fixed everything.

            Show
            Nitzan Bar added a comment - Hi, Thanks for your comments. I fixed everything.
            Hide
            Permalink
            Petr Škoda added a comment -

            hello, looks better now, there are two remaining issue, according to moodle coding style guide the comments should end with full stop and the MDL should not be there because we can use git log to find out which issue is related.

            // Check if the shortname already exists if it does - skip course creation.
            Show
            Petr Škoda added a comment - hello, looks better now, there are two remaining issue, according to moodle coding style guide the comments should end with full stop and the MDL should not be there because we can use git log to find out which issue is related. // Check if the shortname already exists if it does - skip course creation.
            Hide
            Permalink
            Nitzan Bar added a comment -

            Thanks. Fixed this also

            Show
            Nitzan Bar added a comment - Thanks. Fixed this also
            Hide
            Permalink
            Petr Škoda added a comment -

            Perfect thanks, submitting for next weeks integration.

            To integrators: feel free to cherry pick to older stable branches.

            Show
            Petr Škoda added a comment - Perfect thanks, submitting for next weeks integration. To integrators: feel free to cherry pick to older stable branches.
            Hide
            Permalink
            Damyon Wiese added a comment -

            Integrated to 24, 25 and master.

            This issue could do with some more detailed testing instructions.

            Thanks!

            Show
            Damyon Wiese added a comment - Integrated to 24, 25 and master. This issue could do with some more detailed testing instructions. Thanks!
            Hide
            Permalink
            Nitzan Bar added a comment -

            I have added more detailed testing instructions.
            Hope this is enough

            Thanks!

            Show
            Nitzan Bar added a comment - I have added more detailed testing instructions. Hope this is enough Thanks!
            Hide
            Permalink
            Damyon Wiese added a comment -

            Thanks for the extra detail - looks good now.

            Show
            Damyon Wiese added a comment - Thanks for the extra detail - looks good now.
            Hide
            Permalink
            Frédéric Massart added a comment -

            Failing on 2.4 (2.5 and master are OK):

            == Synching course 'LDAP 4b' for role 'student'
[ENROL LDAP] CREATE User enrolled to a nonexistant course 'LDAP 4b'
PHP Notice:  Undefined variable: trace in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982

Notice: Undefined variable: trace in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982
PHP Fatal error:  Call to a member function output() on a non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982

Fatal error: Call to a member function output() on a non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982
            Show
            Frédéric Massart added a comment - Failing on 2.4 (2.5 and master are OK): == Synching course 'LDAP 4b' for role 'student' [ENROL LDAP] CREATE User enrolled to a nonexistant course 'LDAP 4b' PHP Notice: Undefined variable: trace in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982 Notice: Undefined variable: trace in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982 PHP Fatal error: Call to a member function output() on a non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982 Fatal error: Call to a member function output() on a non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 982
            Hide
            Permalink
            Damyon Wiese added a comment -

            Thanks Fred,

            Pushed a fix for the 24 backport.

            Back to testing.

            Show
            Damyon Wiese added a comment - Thanks Fred, Pushed a fix for the 24 backport. Back to testing.
            Hide
            Permalink
            Frédéric Massart added a comment -

            Re-failed:

            [ENROL LDAP] Course creation failed. Duplicate short name. Skipping course with idnumber 'LDAP 4b'...
PHP Notice:  Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 470

Notice: Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 470
PHP Notice:  Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 471

Notice: Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 471
Default exception handler: Can not find data record in database table course. Debug: SELECT id,category FROM {course} WHERE id IS NULL
[array (
)]
Error code: invalidrecord
* line 1357 of /lib/dml/moodle_database.php: dml_missing_record_exception thrown
* line 1333 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
* line 6558 of /lib/accesslib.php: call to moodle_database->get_record()
* line 471 of /enrol/ldap/lib.php: call to context_course::instance()
* line 59 of /enrol/ldap/cli/sync.php: call to enrol_ldap_plugin->sync_enrolments()

!!! Can not find data record in database table course. !!

            It is missing a continue when the course has not been created.

            Show
            Frédéric Massart added a comment - Re-failed: [ENROL LDAP] Course creation failed. Duplicate short name. Skipping course with idnumber 'LDAP 4b'... PHP Notice: Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 470 Notice: Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 470 PHP Notice: Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 471 Notice: Trying to get property of non-object in /home/test/moodles/integration_24/moodle/enrol/ldap/lib.php on line 471 Default exception handler: Can not find data record in database table course. Debug: SELECT id,category FROM {course} WHERE id IS NULL [array ( )] Error code: invalidrecord * line 1357 of /lib/dml/moodle_database.php: dml_missing_record_exception thrown * line 1333 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select() * line 6558 of /lib/accesslib.php: call to moodle_database->get_record() * line 471 of /enrol/ldap/lib.php: call to context_course::instance() * line 59 of /enrol/ldap/cli/sync.php: call to enrol_ldap_plugin->sync_enrolments() !!! Can not find data record in database table course. !! It is missing a continue when the course has not been created.
            Hide
            Permalink
            Damyon Wiese added a comment -

            This was fixed on 25+ in MDL-35159 which was an improvement, so was not backported.

            Show
            Damyon Wiese added a comment - This was fixed on 25+ in MDL-35159 which was an improvement, so was not backported.
            Hide
            Permalink
            Damyon Wiese added a comment -

            Thanks Fred,

            I have backported that continue fix from 25 to 24. Back to testing.

            Show
            Damyon Wiese added a comment - Thanks Fred, I have backported that continue fix from 25 to 24. Back to testing.
            Hide
            Permalink
            Frédéric Massart added a comment -

            Now passing on 2.4, thanks!

            Show
            Frédéric Massart added a comment - Now passing on 2.4, thanks!
            Hide
            Permalink
            Dan Poltawski added a comment -

            Congratulations! This change has been integrated upstream and is now available from our git and download mirrors. To celebrate, here is a joke:

            A SQL query goes into a bar, walks up to two tables and asks, "Can I join you?"

            Show
            Dan Poltawski added a comment - Congratulations! This change has been integrated upstream and is now available from our git and download mirrors. To celebrate, here is a joke: A SQL query goes into a bar, walks up to two tables and asks, "Can I join you?"

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: