How to export full inventory?

[John L Clark]

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

[John L Clark]

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

[John L Clark]

Fog-srv is currently unable to handle this request.

HTTP Erro 500

[Sebastian Roth]

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

[John L Clark]

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

[John L Clark]

@sebastian-roth

[John L Clark]

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

[Sebastian Roth]

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

[John L Clark]

@sebastian-roth error.log I have attached the error log . Thank you

[Sebastian Roth]

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

[John L Clark]

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

[John L Clark]

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

[Sebastian Roth]

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

[Sebastian Roth]

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

[John L Clark]

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

[John L Clark]

@sebastian-roth

[Sebastian Roth]

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