FOG Inventory Blank

[Scott B]

FOG inventory creates a blank export with their csv or pdf. I’ve included the apache.log output, but I don’t know if its a FOG, PHP, or Apache issue. Any suggestions?

edit: SVN 5283, but I’ve seen it for the past several SVNs.

root@fog:~# tail /var/log/apache2/error.log
[Mon Nov 09 15:48:58.308174 2015] [:error] [pid 3498] [client 10.195.65.148:51081] PHP Warning:  mcrypt_decrypt(): Key of size 0 not supported by this algorithm. Only keys of sizes 16, 24 or 32 supported in /var/www/fog/lib/fog/FOGBase.class.php on line 375
[Mon Nov 09 15:48:58.308269 2015] [:error] [pid 3498] [client 10.195.65.148:51081] PHP Warning:  mcrypt_decrypt(): Key of size 0 not supported by this algorithm. Only keys of sizes 16, 24 or 32 supported in /var/www/fog/lib/fog/FOGBase.class.php on line 375
[Mon Nov 09 15:48:58.308398 2015] [:error] [pid 3498] [client 10.195.65.148:51081] PHP Warning:  mcrypt_decrypt(): Key of size 0 not supported by this algorithm. Only keys of sizes 16, 24 or 32 supported in /var/www/fog/lib/fog/FOGBase.class.php on line 375
[Mon Nov 09 15:48:58.308494 2015] [:error] [pid 3498] [client 10.195.65.148:51081] PHP Warning:  mcrypt_decrypt(): Key of size 0 not supported by this algorithm. Only keys of sizes 16, 24 or 32 supported in /var/www/fog/lib/fog/FOGBase.class.php on line 375
[Mon Nov 09 15:48:59.659375 2015] [:error] [pid 3498] [client 10.195.65.148:51081] PHP Warning:  Error while sending STMT_PREPARE packet. PID=3498 in /var/www/fog/lib/db/MySQL.class.php on line 56

[Wayne Workman]

What SVN / Cloud version?

[Scott B]

@Wayne-Workman said:

What SVN / Cloud version?

SVN 5283, but I’ve seen it for the past several SVNs.

[Wayne Workman]

@Scott-B I’ve just confirmed that SVN 4323 Cloud 5293 exports correctly. I’m marking this as solved.

[Scott B]

@Wayne-Workman said:

@Scott-B I’ve just confirmed that SVN 4323 Cloud 5293 exports correctly. I’m marking this as solved.

Okay, but its still broken for me.

[Wayne Workman]

@Scott-B Are the apache errors the same or have they changed?

Can you run this command before you do the export, and then export while watching the output of the command?

tail -f /var/log/apache2/error.log

[Scott B]

@Wayne-Workman said:

@Scott-B Are the apache errors the same or have they changed?

Can you run this command before you do the export, and then export while watching the output of the command?

tail -f /var/log/apache2/error.log

Done. Those errors don’t match up with the workstation I’m using so they are errors from something other then the inventory?

[Tue Nov 10 11:16:27.009667 2015] [:error] [pid 6329] [client 10.195.82.135:49774] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6329 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Tue Nov 10 11:16:32.932891 2015] [:error] [pid 6329] [client 10.195.82.135:49774] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6329 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Tue Nov 10 11:16:36.833697 2015] [:error] [pid 6708] [client 10.195.65.61:50551] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6708 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Tue Nov 10 11:16:38.388949 2015] [:error] [pid 6708] [client 10.195.65.61:50551] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6708 in /var/www/fog/lib/db/MySQL.class.php on line 56

[Scott B]

The apache errors are gone with SVN 5313, but the report is still blank. The hosts do show up when you click on inventory, before choosing csv or pdf so at least the data is there. Same for just doing a hosts report.

[Tom Elliott]

@Scott-B are there any error logs in regards to the blank page? My guess is memory?

[Scott B]

@Tom-Elliott said:

@Scott-B are there any error logs in regards to the blank page? My guess is memory?

The apache errors are back, but otherwise im not seeing any other errors.

apache log

E packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Thu Nov 12 15:21:14.097505 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Thu Nov 12 15:21:15.033770 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Thu Nov 12 15:21:16.357790 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Thu Nov 12 15:21:18.014239 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56

[Tom Elliott]

@Scott-B I’m going to try my best to reach out tomorrow if that’s okay so I can teamviewer in to try to figure out what’s going on.

[Scott B]

@Tom-Elliott said:

@Scott-B I’m going to try my best to reach out tomorrow if that’s okay so I can teamviewer in to try to figure out what’s going on.

That would be great, thanks!

[Scott B]

@Tom-Elliott

I wanted to post an update to this topic. As suggested it seems it was a memory issue in regards to just the white page. I was seeing errors similar to the one below in my apache log.

[Tue Nov 17 09:59:55.127379 2015] [:error] [pid 14071] [client xx.xx.xx.xx.xx:60299] PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 339292729 bytes) in /var/www/fog/commons/init.php on line 175

So I upped the amount of memory and time PHP is allowed to use. After doing so I was able to run the inventory report (as well ask config save), but there is always a catch. The report has several hundred rows of “\\\\\\\\\\\\\\\\\\\\\…” and some of the rows are shifted one row to the left. My fear this is or will create a corrupt DB.

If I watch the apache logs I am still getting the errors below.

[Tue Nov 17 13:01:23.304484 2015] [:error] [pid 5672] [client 10.195.65.61:55864] PHP Warning:  Error while sending STMT_PREPARE packet. PID=5672 in /var/www/fog/lib/db/MySQL.class.php on line 56
[Tue Nov 17 13:01:31.145496 2015] [:error] [pid 5919] [client 10.195.65.148:50685] PHP Warning:  Error while sending STMT_PREPARE packet. PID=5919 in /var/www/fog/lib/db/MySQL.class.php on line 56

[Wayne Workman]

@Scott-B Just get rid of those…

Backup your DB first. FOG Configuration -> Configuration Save -> Export

For an individual:

update inventory set iOtherTag='' where iID=1972;

For everything:

update inventory set iOtherTag='' where iOtherTag like '%\\\\\\\\\\\\\\%';

[Scott B]

@Wayne-Workman said:

@Scott-B Just get rid of those…

Backup your DB first. FOG Configuration -> Configuration Save -> Export

For an individual:

update inventory set iOtherTag='' where iID=1972;

For everything:

update inventory set iOtherTag='' where iOtherTag like '%\\\\\\\\\\\\\\%';

Thank you, that cleaned up the list very well.