Snipe-IT Departmental Reporting

black3dynamite

@wirestyle22 said in Snipe-IT Departmental Reporting:

LDAP User Sync is timing out. I will need to fix that and automate the process via a script I think. Probably need to give php more memory or make the scope smaller.

https://snipe-it.readme.io/docs/ldap-sync

wirestyle22

Still timing out even with a gig of memory allocated to php. Unsure how to sync all of AD. There is about 6k users.

notverypunny

I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.

....

here it is

http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html

wirestyle22

This post is deleted!

wirestyle22

@notverypunny said in Snipe-IT Departmental Reporting:

I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.

....

here it is

http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html

Even with that change it still timed out. I allocated 1024 memory to the php memory_limit as well.

notverypunny

@wirestyle22 said in Snipe-IT Departmental Reporting:

@notverypunny said in Snipe-IT Departmental Reporting:

I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.

....

here it is

http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html

Even with that change it still timed out. I allocated 1024 memory to the php memory_limit as well.

damn... maybe try running the query (or an equivalent) via cli just to validate that it's not a problem with the underlying client-server connection? Do the docs make any mention of tweaking the php timeouts?

wirestyle22

@notverypunny said in Snipe-IT Departmental Reporting:

@wirestyle22 said in Snipe-IT Departmental Reporting:

@notverypunny said in Snipe-IT Departmental Reporting:

I can't remember what the fix is, but I seem to recall there being a default limit of 500 or 1k on LDAP query results.

....

here it is

http://www.microsoftnow.com/2008/10/increasing-number-of-objects-returned.html

Even with that change it still timed out. I allocated 1024 memory to the php memory_limit as well.

damn... maybe try running the query (or an equivalent) via cli just to validate that it's not a problem with the underlying client-server connection? Do the docs make any mention of tweaking the php timeouts?

Documentation looks old. it doesn't use artisan anymore. Not sure how to run it from the cli as a result

black3dynamite

Here’s something from Moodle forum
https://moodle.org/mod/forum/discuss.php?d=49336

wirestyle22

@black3dynamite said in Snipe-IT Departmental Reporting:

Here’s something from Moodle forum
https://moodle.org/mod/forum/discuss.php?d=49336

Involved for something so simple

wirestyle22

Trying to sync each individual OU and then seeing if I can sync just the changes made after that. Hopefully makes it manageable.

wirestyle22

@wirestyle22 said in Snipe-IT Departmental Reporting:

Trying to sync each individual OU and then seeing if I can sync just the changes made after that. Hopefully makes it manageable.

Didn't work. Sigh

wirestyle22

Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit

ini_set('max_execution_time', 1200); //600 seconds = 10 minutes

ini_set('memory_limit', '1000M');

Dashrender

@wirestyle22 said in Snipe-IT Departmental Reporting:

Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_set('memory_limit', '1000M');

what was the default in those?

wirestyle22

@Dashrender said in Snipe-IT Departmental Reporting:

@wirestyle22 said in Snipe-IT Departmental Reporting:
Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_set('memory_limit', '1000M');
what was the default in those?

ini_set('max_execution_time', 600); //600 seconds = 10 minutes
ini_set('memory_limit', '500M');

Dashrender

@wirestyle22 said in Snipe-IT Departmental Reporting:

@Dashrender said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_set('memory_limit', '1000M');
what was the default in those?
ini_set('max_execution_time', 600); //600 seconds = 10 minutes
ini_set('memory_limit', '500M');

Wow - so it took more than 10 or more than 500 M RAM to import all that - due to your numbers, I 'm guessing it was the RAM more than the time.

wirestyle22

@Dashrender said in Snipe-IT Departmental Reporting:

@wirestyle22 said in Snipe-IT Departmental Reporting:
@Dashrender said in Snipe-IT Departmental Reporting:
@wirestyle22 said in Snipe-IT Departmental Reporting:
Got it to work. Edit the below file.

app/Console/Commands/LdapSync.php

Edit max_execution time and memory_limit
ini_set('max_execution_time', 1200); //600 seconds = 10 minutes 
ini_set('memory_limit', '1000M');
what was the default in those?
ini_set('max_execution_time', 600); //600 seconds = 10 minutes
ini_set('memory_limit', '500M');
Wow - so it took more than 10 or more than 500 M RAM to import all that - due to your numbers, I 'm guessing it was the RAM more than the time.

Not sure honestly--it took awhile. I spoke to a snipe-it Dev and they could sync 15k accounts with these settings. I needed this functionality so I can create a script to sync users every day at 1:00 AM.