LDAP sync_users.php problem

LDAP sync_users.php problem

by Peter Easton -
Number of replies: 5

HI All,

I hope someone has solved this issue and can shed some light on it for me.

We have Moodle 2.8.x (on freebsd) set up and working (everyone can log in properly) but when we run the sync_user script we get the following:

Connecting to LDAP server...
Creating temporary table tmp_extuser

and then it stops (as far as i can tell), no errors just keeps processing but no results.

we have 12,000 active users that get synced nightly, which worked flawlessly before we upgraded to 2.8 over the winter break.


Any ideas, suggestion of things to try would be greatly appreciated

Pete

Average of ratings: -
In reply to Peter Easton

Re: LDAP sync_users.php problem

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Hi

May be it is too late. I saw it thanks to the other "I have the same problem" bump! This enquiry should have appeared in the Authentication forum: https://moodle.org/mod/forum/view.php?id=42.

Just as a start, since you say sync_user had been working, repeated calls just need to re-sync incrementally, right? I mean, it is not trying to pull 12'000 odd users at once?

And your users can still log in, even those who are new in the LDAP?

The sync_user is CLI. It usually print a full log of what has been done. You say, it just goes to "Creating temporary table tmp_extuser" and gets stuck? Did you raise the https://docs.moodle.org/28/en/Debugging level and inspected Apache logs?
Average of ratings: -
In reply to Visvanath Ratnaweera

Re: LDAP sync_users.php problem

by Dean Montgomery -

Problems started happening after dist-ugrade to the base server.

Fixed the problem with:

Site Administration => Plugins => Authentication => LDAP server

** Page Size 20.


The remote server was set to handle 1000 and it had been working fine prior to the upgrade.  I then reduced the page size in moodle and it started working again.


Average of ratings: -
In reply to Dean Montgomery

Re: LDAP sync_users.php problem

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Very interesting. What is your system, what kind of upgrade (from, to) have you done? Since you use the phrase "dist-upgrade" it could be a Debian or an derived Linux. What exactly was the upgrade? What were the system software, especially PHP, before and after the upgrade?

P.S. I was talking about the original problem, https://moodle.org/mod/forum/discuss.php?d=282300. Since you replied to my post, both issues got entangled now!

P.P.S. The whole thing is the subject of the Authentication forum https://moodle.org/mod/forum/view.php?id=42, I believe.
Average of ratings: -
In reply to Visvanath Ratnaweera

Re: LDAP sync_users.php problem

by Dean Montgomery -
dist-upgraded to debian "stable".  It was a double dist-upgrade.
Average of ratings: -