• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 May 10, 2021, 2:48 PM

    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 May 10, 2021, 2:59 PM Reply Quote 0
    • J
      John L Clark @John L Clark
      last edited by May 10, 2021, 2:59 PM

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

      J 1 Reply Last reply May 10, 2021, 3:05 PM Reply Quote 0
      • J
        John L Clark @John L Clark
        last edited by May 10, 2021, 3:05 PM

        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 May 10, 2021, 3:20 PM

          @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 May 10, 2021, 3:24 PM Reply Quote 0
          • J
            John L Clark @Sebastian Roth
            last edited by May 10, 2021, 3:24 PM

            @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 May 10, 2021, 6:40 PM

              @sebastian-roth inventory error.JPG

              1 Reply Last reply Reply Quote 0
              • J
                John L Clark
                last edited by May 10, 2021, 6:41 PM

                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 May 11, 2021, 5:21 PM

                  @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 May 12, 2021, 2:53 PM Reply Quote 0
                  • J
                    John L Clark @Sebastian Roth
                    last edited by May 12, 2021, 2:53 PM

                    @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 May 12, 2021, 3:01 PM

                      @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 May 12, 2021, 3:03 PM Reply Quote 0
                      • J
                        John L Clark @Sebastian Roth
                        last edited by May 12, 2021, 3:03 PM

                        @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 May 12, 2021, 8:22 PM

                          @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 May 13, 2021, 3:47 PM

                            @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 May 15, 2021, 12:14 PM

                              @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 May 19, 2021, 1:10 PM Reply Quote 0
                              • J
                                John L Clark @Sebastian Roth
                                last edited by May 19, 2021, 1:10 PM

                                @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 May 19, 2021, 1:12 PM

                                  @sebastian-roth mysql.JPG

                                  1 Reply Last reply Reply Quote 0
                                  • S
                                    Sebastian Roth Moderator
                                    last edited by May 20, 2021, 4:54 PM

                                    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
                                    1 / 1
                                    • First post
                                      7/17
                                      Last post

                                    156

                                    Online

                                    12.0k

                                    Users

                                    17.3k

                                    Topics

                                    155.2k

                                    Posts
                                    Copyright © 2012-2024 FOG Project