Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.9.5
-
Fix Version/s: 2.0
-
Component/s: Authentication
-
Labels:None
-
Environment:Gentoo
Apache
MySQL
-
Database:MySQL
-
Difficulty:Easy
-
Affected Branches:MOODLE_19_STABLE
-
Fixed Branches:MOODLE_20_STABLE
Description
I am a newbie to Moodle and hope informing this issue in the correct location. Here is the case:
Our Active Directory (AD) contains around 27,000 users and as I run the auth/ldap/auth_ldap_sync_users.php from the command line, the script inserts all the users in the AD into {mdl}_user table initially. However, in the subsequent executions the script prints "No updates to be done" and stalls. Besides the MySQL server hangs and the web site becomes unresponsive. When examining the codes I realized that the {mdl}_user table is left joined with the {mdl}_extuser table with the username column and there is no index for username in the {mdl}_user table. I created that index and the ldap sync operation started to work seamlessly. I think an index should be added to the username column.
Issue Links
| This issue will be resolved by: | ||||
| MDL-13458 | auth/ldap sync temp table misconfigured - Slow or Failed Syncronization |
|
|
|
Activity
Mr Wen,
I've had a look at lib/db/install.xml and there is no index defined for "username". In addition to it, I've just installed a fresh stock install of 1.9.5+ (current as of yesterday) on a MySQL database, and I get no index on mdl_user.username at all.
So I wonder where yours came from 
Anyway, the patch proposed in MDL-13458 should fix this issue.
Saludos,
Anyway, the patch proposed in MDL-13458 should fix this issue.
Saludos, 
I just checked with our 1.9.5 installation, and there is a "username" index created (by default) for mdl_user already? Did I miss something here?