• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    How to export full inventory?

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    17
    1.6k
    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.
    • J
      John L Clark
      last edited by

      When I click on host list or Inventory I get the a page that says this page is not working.

      J 1 Reply Last reply Reply Quote 0
      • J
        John L Clark @John L Clark
        last edited by

        I just need to export all inventory to a .xls or pdf.

        J 1 Reply Last reply Reply Quote 0
        • J
          John L Clark @John L Clark
          last edited by

          Fog-srv is currently unable to handle this request.

          HTTP Erro 500

          1 Reply Last reply Reply Quote 0
          • S
            Sebastian Roth Moderator
            last edited by

            @John-L-Clark Which version of FOG do you use? Can you please post a screenshot of the error page?

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            J 2 Replies Last reply Reply Quote 0
            • J
              John L Clark @Sebastian Roth
              last edited by

              @sebastian-roth We are on 1.5.9 I am able to select AD_creditiels and then each model and get the report for that but we are needing all inventory.

              1 Reply Last reply Reply Quote 0
              • J
                John L Clark @Sebastian Roth
                last edited by

                @sebastian-roth inventory error.JPG

                1 Reply Last reply Reply Quote 0
                • J
                  John L Clark
                  last edited by

                  I also get the same thing when I try to export all hosts.

                  1 Reply Last reply Reply Quote 0
                  • S
                    Sebastian Roth Moderator
                    last edited by

                    @John-L-Clark Need to ask further questions as I am not able to replicate the issue. Do you have any of the plugins enabled?

                    Please check the Apache and PHP-FPM logs and post those here (see my signature on where to find those on your FOG server).

                    I am able to select AD_creditiels and then each model and get the report for that but we are needing all inventory.

                    What do you mean by select AD credentials? Are we actually talking about the “Report Management” page in the FOG web UI?

                    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                    J 1 Reply Last reply Reply Quote 0
                    • J
                      John L Clark @Sebastian Roth
                      last edited by

                      @sebastian-roth Selection.JPG Report page.JPG error.log I have attached the error log . Thank you

                      1 Reply Last reply Reply Quote 0
                      • S
                        Sebastian Roth Moderator
                        last edited by

                        @John-L-Clark The error log did not get uploaded/posted. Please try again or upload to a file sharing platform and post a link here.

                        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                        J 2 Replies Last reply Reply Quote 0
                        • J
                          John L Clark @Sebastian Roth
                          last edited by

                          @sebastian-roth try this https://drive.google.com/file/d/1I_LFCwT0INMzg8vHbbi60KSqvYHtNDKN/view?usp=sharing

                          1 Reply Last reply Reply Quote 0
                          • J
                            John L Clark @Sebastian Roth
                            last edited by

                            @sebastian-roth PHP Log.JPG Here is a clip of the PHP log. Not sure what it means.

                            1 Reply Last reply Reply Quote 0
                            • S
                              Sebastian Roth Moderator
                              last edited by

                              @John-L-Clark While there are a lot of warnings in the error.log I don’t think any of those is related to what you describe here. The log is being rotated every day by what it looks like so you might need to request the inventory report in the FOG web UI once more (best if you query the report twice to easier find this in the logs) and copy the error.log file just after that.

                              Without knowing more about this I could imagine a database maintenance might help here: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL#Database_Maintenance_Commands (Stop imaging/multicasting before you run those commands and be aware that if you run all of those SQL queries that it will clear your history and userTracking table as well.)

                              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                              1 Reply Last reply Reply Quote 0
                              • S
                                Sebastian Roth Moderator
                                last edited by

                                @John-L-Clark Hmm, did see your post on PHP-FPM log just now. Looks like your setup is not handling the many requests you seem to get. How many machines with fog-client installed do you roughly have in your network?

                                You might need to adjust the PHP-FPM settings to your needs. Edit /etc/php/7.4/fpm/pool.d/www.conf and adjust values, then restart PHP-FPM (sudo systemctl restart php7.4-fpm).

                                There is a lot of information on the web on what settings might suite your setup (depending on server resources and so on):

                                • https://stackoverflow.com/questions/25097179/warning-pool-www-seems-busy-you-may-need-to-increase-pm-start-servers-or-pm
                                • https://www.sitepoint.com/php-fpm-tuning-using-pm-static-max-performance/

                                Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                J 2 Replies Last reply Reply Quote 0
                                • J
                                  John L Clark @Sebastian Roth
                                  last edited by

                                  @sebastian-roth I went through the entire database clean-up that you sent and I am still unable to run a full report of all inventory. Is there any way I can just get an Export of all hosts?

                                  1 Reply Last reply Reply Quote 0
                                  • J
                                    John L Clark @Sebastian Roth
                                    last edited by

                                    @sebastian-roth mysql.JPG

                                    1 Reply Last reply Reply Quote 0
                                    • S
                                      Sebastian Roth Moderator
                                      last edited by

                                      Looks like @John-L-Clark has a huge setup with many hosts. Talked in chat and figured that increasing the value of php_admin_value[memory_limit] in /etc/php/7.4/fpm/pool.d/www.conf fixed the issue.

                                      Possibly moving to InnoDB could help here as well. Though this is not supported in an official release yet. Take a look at those topics:
                                      https://forums.fogproject.org/topic/15162/the-list-all-hosts-tab-takes-a-long-time
                                      https://forums.fogproject.org/topic/14254/high-cpu-usage
                                      https://forums.fogproject.org/topic/14689/high-cpu-usage-on-fog-server/9

                                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

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

                                      221

                                      Online

                                      12.0k

                                      Users

                                      17.3k

                                      Topics

                                      155.2k

                                      Posts
                                      Copyright © 2012-2024 FOG Project