High CPU usage IIS Worker and Mysql
-
Here is the processlist from mysql.
-
Seems to be something with AD.
We are deploying on a network with a large AD, but we only need to provision a specific OU of computers.
I tried setting up LDAP with OU=x,DN=y,DN=com
And that worked for only pulling organizaitons, but LDAP login stopped working.
-
Have you setup any groups or changed the default sync interval for AD?
-
@theopenem_admin I pinned a group from LD that was our ORGs
-
@theopenem_admin Looks like the task status for LDAP sync is on processing.
-
It's not a feature right now, but it sounds like it needs to be. You are free to submit a pull request if you want or I'll look into it for the next release. I'm probably planning to release an update in the next month or so.
-
It's not a feature right now, but it sounds like it needs to be. You are free to submit a pull request if you want or I'll look into it for the next release. I'm probably planning to release an update in the next month or so.
-
@theopenem_admin Okay, I appreciate the quick responses!
Thanks for open source software
-
@theopenem_admin Last quick question, is it safe to delete computers/groups from the computers/groups table in sql?
I have a ton of them, even after disabling LDAP
-
Anything with id greater than 0 should be fine. You can also try to look at some of the jobs in hangfire to see if there is a reason the LDAP sync is causing issues. You can browse to
http://localhost:8080/hangfire
It must be from the server itself, it won't load remotely. Once there you should see the jobs list and you can poke around at some of the LDAP sync jobs to see if there is any indication as to what is happening.
-
Here is a pic from my last AD sync. Took less than a minute. I have about 5000 computers and 10000 users.
-
@theopenem_admin Okay, mine ran successfully, but I specified OU this time.
So login doesn't work.
Hmm, I feel like a quick way to make this work how I'd need would be to implement specific OU filtering on the groups feature.
Ill try to look into this when I get a chance.
-
@theopenem_admin Im in a university setting on a sub orginzation level.
We have only 100 computers in our ORG, but our AD has over 20,000