ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Snipe-IT Departmental Reporting

    Scheduled Pinned Locked Moved IT Discussion
    snipe-itcentos 7
    20 Posts 5 Posters 2.8k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • wirestyle22W
      wirestyle22
      last edited by

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

      1 Reply Last reply Reply Quote 0
      • notverypunnyN
        notverypunny
        last edited by

        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

        wirestyle22W 2 Replies Last reply Reply Quote 2
        • wirestyle22W
          wirestyle22 @notverypunny
          last edited by

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • wirestyle22W
            wirestyle22 @notverypunny
            last edited by

            @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.

            notverypunnyN 1 Reply Last reply Reply Quote 0
            • notverypunnyN
              notverypunny @wirestyle22
              last edited by

              @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?

              wirestyle22W 1 Reply Last reply Reply Quote 0
              • wirestyle22W
                wirestyle22 @notverypunny
                last edited by 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

                1 Reply Last reply Reply Quote 0
                • black3dynamiteB
                  black3dynamite
                  last edited by

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

                  wirestyle22W 1 Reply Last reply Reply Quote 0
                  • wirestyle22W
                    wirestyle22 @black3dynamite
                    last edited by

                    @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

                    1 Reply Last reply Reply Quote 0
                    • wirestyle22W
                      wirestyle22
                      last edited by

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

                      wirestyle22W 1 Reply Last reply Reply Quote 0
                      • wirestyle22W
                        wirestyle22 @wirestyle22
                        last edited by

                        @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

                        1 Reply Last reply Reply Quote 0
                        • wirestyle22W
                          wirestyle22
                          last edited by

                          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');
                          
                          DashrenderD 1 Reply Last reply Reply Quote 0
                          • DashrenderD
                            Dashrender @wirestyle22
                            last edited by

                            @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?

                            wirestyle22W 1 Reply Last reply Reply Quote 0
                            • wirestyle22W
                              wirestyle22 @Dashrender
                              last edited by

                              @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');

                              DashrenderD 1 Reply Last reply Reply Quote 1
                              • DashrenderD
                                Dashrender @wirestyle22
                                last edited by

                                @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.

                                wirestyle22W 1 Reply Last reply Reply Quote 0
                                • wirestyle22W
                                  wirestyle22 @Dashrender
                                  last edited by 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.

                                  1 Reply Last reply Reply Quote 1
                                  • 1 / 1
                                  • First post
                                    Last post