<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi all,</p>
<p>We tried in GR-IX to activate the port utilization feature (that
is available in the IXP Stastics). <br>
</p>
<p>For testing we ran by hand the following command:</p>
<p><i>/srv/ixpmanager/artisan grapher:upload-pi-stats-to-db </i><br>
</p>
<p>ensuring that the user was www-data as specified in the
following URL
<a class="moz-txt-link-freetext" href="https://docs.ixpmanager.org/grapher/mrtg/#inserting-traffic-data-into-the-database-reporting-emails">https://docs.ixpmanager.org/grapher/mrtg/#inserting-traffic-data-into-the-database-reporting-emails</a>.</p>
<p>After that, we observed new records in the <b>traffic_daily_phys_int
</b>table, however when we attempt to click on the <i>Port
Utilization </i>button on the menu we get the following
message:</p>
<p><img src="cid:part1.324D3CC5.93E885C1@netmode.ntua.gr" alt=""></p>
<p><br>
</p>
<p>Based on the above, we inferred that is something related to the
ANY_VALUE function. <br>
</p>
<p>Has anyone faced a similar behavior?</p>
<p>P.S.</p>
<p>In our setup we are using MariaDB.</p>
<p>BR,</p>
<p>Marinos <br>
</p>
</body>
</html>