SVN 3582 - Hosts and Users Report Doesn't Load

[MRCUR]

SVN 3582 on Ubuntu 14.04 LTS - when I try to run the Hosts and Users report, I get a mostly blank page with the report title and the Excel/PDF icons. Downloading either gives me a 1KB file with no data.

Perhaps related - under host management if I try to list all hosts I just get a blank page. We do have ~8,000 hosts registered.

[Wayne Workman]

You backup your DB before every single update, right?

FOG Configuration -> Configuration Save -> Export.

I like to add the date and revision number to the file name.

[MRCUR]

I do, yes. But all of the hosts are there - it’s not like they’re gone from the DB. If I do a search for XYZ-LAB, I’ll get back the 30 machines that are in that lab. It’s only when trying to do something where ALL the hosts have to be returned it seems to fall apart.

[Wayne Workman]

@Developers should check it out, then.

You can likely expect a fix sometime today.

[ch3i]

@MRCUR said:

SVN 3582 on Ubuntu 14.04 LTS - when I try to run the Hosts and Users report, I get a mostly blank page with the report title and the Excel/PDF icons. Downloading either gives me a 1KB file with no data.

Perhaps related - under host management if I try to list all hosts I just get a blank page. We do have ~8,000 hosts registered.

Same problem here on SVN 3559.

[Wayne Workman]

I’d like to take this opportunity to say ---- when you need FOG to be stable, you should find a good working revision and just sit on it.

For many of us, we image during the summer. That’s why I’m sitting on r3537… It has some problems, but it’s working for me. I’ll worry about updating after the summer, and after “0 week”.

[Tom Elliott]

Whenever you get a “blank page” as you describe, it usually means there’s an error being thrown.

My guess, is either the reports were copied back from older revisions, and/or your memory limits have been met and it’s failing to display properly because it’s all used.

Please don’t be afraid to get a copy of the apache error logs as it will help us all out.

[ch3i]

@Tom-Elliott

[Mon Jun 22 14:43:09 2015] [error] [client 192.168.101.252] File does not exist: /var/www/fog/management/images/csv.png, referer: http://myfogserver/fog/management/index.php?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==
[Mon Jun 22 14:43:09 2015] [error] [client 192.168.101.252] File does not exist: /var/www/fog/management/images/pdf.png, referer: http://myfogserver/fog/management/index.php?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==
[Mon Jun 22 14:43:09 2015] [error] [client 192.168.101.252] File does not exist: /var/www/favicon.ico, referer: http://myfogserver/fog/management/index.php?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==
[Mon Jun 22 14:43:12 2015] [error] [client 192.168.101.252] PHP Fatal error:  Undefined class constant 'FOG_REPORT_HTML' in /var/www/fog/management/reports/Hosts and Users.php on line 61
[Mon Jun 22 14:43:13 2015] [error] [client 192.168.101.252] File does not exist: /var/www/fog/management/images/csv.png, referer: http://myfogserver/fog/management/index.php?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==
[Mon Jun 22 14:43:13 2015] [error] [client 192.168.101.252] File does not exist: /var/www/fog/management/images/pdf.png, referer: http://myfogserver/fog/management/index.php?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==
[Mon Jun 22 14:43:25 2015] [error] [client 192.168.101.252] PHP Fatal error:  Undefined class constant 'FOG_REPORT_HTML' in /var/www/fog/management/reports/Hosts and Users.php on line 61, referer: http://myfogserver/fog/management/?node=report
[Mon Jun 22 14:43:25 2015] [error] [client 192.168.101.252] File does not exist: /var/www/fog/management/images/csv.png, referer: http://myfogserver/fog/management/?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==
[Mon Jun 22 14:43:25 2015] [error] [client 192.168.101.252] File does not exist: /var/www/fog/management/images/pdf.png, referer: http://myfogserver/fog/management/?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==
[Mon Jun 22 14:43:42 2015] [error] [client 192.168.101.252] PHP Fatal error:  Call to a member function outputReport() on a non-object in /var/www/fog/management/export.php on line 4, referer: http://myfogserver/fog/management/?node=report&sub=file&f=SG9zdHMgYW5kIFVzZXJzLnBocA==

[MRCUR]

@Tom-Elliott [Mon Jun 22 09:07:40.448670 2015] [:error] [pid 20057] [client 172.16.236.118:50604] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 81 bytes) in /var/www/fog/lib/fog/FOGController.class.php on line 279, referer: http://fogserver.readingsd.org/fog/management/index.php?node=host

[Tom Elliott]

@MRCUR Please adjust your memory limit from FOG Configuration->FOG Settings->General Settings->FOG_MEMORY_LIMIT

It defaults to a minimum of 128M, so adjust to 256, 512, etc… as necessary.

[Wayne Workman]

@Tom-Elliott said:

Whenever you get a “blank page” as you describe, it usually means there’s an error being thrown.

My guess, is either the reports were copied back from older revisions, and/or your memory limits have been met and it’s failing to display properly because it’s all used.

Please don’t be afraid to get a copy of the apache error logs as it will help us all out.

What causes “Allowed memory size exhausted” ? Are we talking about RAM or partition space?

[MRCUR]

@Tom-Elliott I set it to 512 and was able to get the “List All Hosts” page to load. I’ve gone the whole way up to 3072 and the Hosts and Users report still won’t load. At this point I can’t allocate anymore without killing my host’s RAM. Any tricks to make this not use so much memory, or am I stuck?

[Tom Elliott]

@MRCUR The whole idea of the Hosts and Users report is to print All hosts, and all users that have signed into every Host.

So, my guess is this report is much more than what you’re wanting for right now.

Am I correct on this?

[MRCUR]

@Tom-Elliott You’re right. What I really wanted is the “Host List”. When I run that, the page loads but the export (for CSV or PDF) does not work. Apache error log below.

[Mon Jun 22 10:24:00.490124 2015] [:error] [pid 28258] [client 172.16.61.10:53025] PHP Fatal error:  Call to a member function outputReport() on a non-object in /var/www/fog/management/export.php on line 4, referer: http://fogserver.readingsd.org/fog/management/index.php?node=report&sub=host-list
[Mon Jun 22 10:24:03.048453 2015] [:error] [pid 28455] [client 172.16.61.10:53026] PHP Fatal error:  Call to a member function outputReport() on a non-object in /var/www/fog/management/export.php on line 4, referer: http://fogserver.readingsd.org/fog/management/index.php?node=report&sub=host-list
[Mon Jun 22 10:24:05.591325 2015] [:error] [pid 28486] [client 172.16.61.10:53027] PHP Fatal error:  Call to a member function outputReport() on a non-object in /var/www/fog/management/export.php on line 4, referer: http://fogserver.readingsd.org/fog/management/index.php?node=report&sub=host-list

[Tom Elliott]

@MRCUR Please update if you can. I just fixed a problem and it seems to be exporting the pdf’s properly now.

Thank you,

[MRCUR]

@Tom-Elliott Thanks Tom! I’ll update as soon as I can and report back.

[MRCUR]

@Tom-Elliott Updated to 3591. While I can get a CSV or PDF to download, the files are blank.