<html theme="themeKey88rand710" iconset="monochrome"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body text="#000000">Hi Marinos,<br>
<br>
I'm afraid MariaDB hasn't been a supported database for IXP Manager
since v3 iirc.<br>
<br>
We develop on and use MySQL v8 in production and we do not run / develop
/ test on any other databases (should work fine on v5.7 too btw but 8
is the development target).<br>
<br>
Your best bet is to use MySQL and it should be an easy dump / import
operation.<br>
<br>
That said, if you want to open an issue on Github for the below, please
do. The query could be refactored to remove ANY_VALUE(). But, again,
there's diminishing returns here as settling on a single database allows
us to use MySQL8 specific functions which we may do.<br>
<br>
- Barry<br>
<br>
<span>Marinos Dimolianis wrote on 26/07/2021 19:24:</span><br>
<blockquote type="cite"
cite="mid:e55ca7c5-e9a6-c96f-75d4-74a7ace730f5@netmode.ntua.gr">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<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"
moz-do-not-send="true">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:part2.3678AE03.E404FF95@inex.ie" alt=""
name="image.png"></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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
INEX IXP Manager mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ixpmanager@inex.ie">ixpmanager@inex.ie</a>
Unsubscribe or change options here: <a class="moz-txt-link-freetext" href="https://www.inex.ie/mailman/listinfo/ixpmanager">https://www.inex.ie/mailman/listinfo/ixpmanager</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br><br>
Kind regards,
<br>
Barry O'Donovan
<br>
INEX <br>
<br>
<a class="moz-txt-link-freetext" href="https://www.inex.ie/support/">https://www.inex.ie/support/</a>
<br>
+353 1 531 3339<br>
<br>
<br>
</div>
</body></html>