Not all statistical information available

[Tom Jones]

Having piler running for several weeks now, I am still missing a graph at statistics menu (totally blank) and the information on the estimated time when the partition space runs out on the health screen. Interestingly the information about archive accounting and most data under "cumulative counts" and "message disposition" on the health screen is available.

Does anyone have an idea where to look for the problem?

Thanks in advance!

[Janos SUTO]

Check the web server error logs for clues what's going on.

[Tom Jones]

Thanks for your quick response. Here's the relevant snippet from the error log.

[Janos SUTO]

Thanks. That count(): Parameter .... message troubles me. There must be some problem in the model/stat/chart.php with the lineChartHamSpam() function.

[Janos SUTO]

One more trick to try: check with the latest gui as well. To do so download the latest master branch, get the webui directory to serve as documentroot (you may need to fix the line containing config-site.php). Then check if the problem persists. Btw. what linux is this?

[Tom Jones]

I'll try your suggestion and will report later about the results. Our Linux Version here ist Ubuntu 18.04 LTS.

[Tom Jones]

Unfortunately using the new webui apache throws another error: The requested URL /EXTERNAL_DASHBOARD_URL was not found on this server.

[Janos SUTO]

Run the configure script in the downloaded build, which creates webui/config.php.

[Tom Jones]

Meanwhile I tested the new gui and the error still persists. It's delivering exactly the same errors in apaches error log.

[Janos SUTO]

Did you run the configure script, and you have config.php in the new documentroot?

[Tom Jones]

Yes, I did. After running the configure script, config.php had been created and was copied to the new documentroot. The new gui now worked well (beforehand it stated the above mentioned error concerning EXTERNAL_DASHBOARD_URL). Nevertheless, calling the statistics menu it further on logs the same errors as in my post dated 2018-07-24.

[Janos SUTO]

Finally I've found it. It's a mysql change from 5.7. To fix it apply the following patch, and you'll be fine: https://bitbucket.org/jsuto/piler/commits/5a96b65eadd717b8d317a0e61f9241412f91f79c

[Tom Jones]

Thank you very much Janos! The statistics graph works perfectly well now.

Unfortunately the information about the estimated time the partition runs full keeps missing, both on health screen and in the daily piler report by e-mail. Interestingly the rest of the space projection data differs significantly between health screen and daily mail.

[Janos SUTO]

Show me df -h output, and the value for DATA_PARTITION in your config. Also I need you to debug the value in controller/health/worker.php between lines 125 and 139. You may syslog or simply print them somewhere.

[Tom Jones]

I provided some screenshots of the requested data. Please be aware that the screenshot of the daily mail is from this morning, so additional archiving already happened. If you need more information, please let me know.

[Mindbender666]

I just noticed that you fixed the “graph issue” in this case with commit “https://bitbucket.org/jsuto/piler/commits/5a96b65eadd717b8d317a0e61f9241412f91f79c”; which is exactly what introduced the “empty graph error” to my installation. With commit “https://bitbucket.org/jsuto/piler/commits/a6393ae909224a12c01077e1cb6dfe5877ee7fbc” you reverted the code back to what it once was.
However - with the 1.3.7 code and the a6393ae commit I get a graph, but I also(!) get the warning mentioned above:

2019/11/20 10:38:42 [error] 822#822: *1897 FastCGI sent in stderr: "PHP message: PHP Warning:  count(): Parameter must be an array or an object that implements Countable in /var/piler/www/system/helper/libchart/classes/view/axis/Bound.php on line 71" while reading response header from upstream, client: 0.0.0.0, server: sub.domain.tld, request: "GET /index.php?route=stat/graph&timespan=daily&uid= HTTP/2.0", upstream: "fastcgi://unix:/var/run/www-data-php7.2-fpm.sock:", host: "sub.domain.tld", referrer: "https://sub.domain.tld/index.php?route=stat/stat&timespan=daily"

‌

I have a problem with the “space projection” as well.
The projection when a partion is full is not shown or not calculated at all.

‌

[Janos SUTO]

I’m still in the middle of it, I need more time to figure it out. I’ll keep you posted.

[Janos SUTO]

I’ve updated model/stat/chart.php, so the warning in the error log should be fixed by now.

[Janos SUTO]

To fix the projection numbers fix the DATA_PARTITION to be root / partition. In a nutshell the calculus uses the df -h output, the greps the DATA_PARTITION value.