[ixpmanager] Issue with port utilization feature

[Barry O'Donovan (INEX)]

Hi Marinos,

I'm afraid MariaDB hasn't been a supported database for IXP Manager 
since v3 iirc.

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).

Your best bet is to use MySQL and it should be an easy dump / import 
operation.

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.

  - Barry

Marinos Dimolianis wrote on 26/07/2021 19:24:
>
> Hi all,
>
> We tried in GR-IX to activate the port utilization feature (that is 
> available in the IXP Stastics).
>
> For testing we ran by hand the following command:
>
> //srv/ixpmanager/artisan grapher:upload-pi-stats-to-db /
>
> ensuring that the user was www-data as specified  in the following URL 
> https://docs.ixpmanager.org/grapher/mrtg/#inserting-traffic-data-into-the-database-reporting-emails.
>
> After that, we observed new records in the *traffic_daily_phys_int 
> *table, however when we attempt to click on the /Port Utilization 
> /button on the menu we get the following message:
>
>
> Based on the above, we inferred that is something related to the 
> ANY_VALUE function.
>
> Has anyone faced a similar behavior?
>
> P.S.
>
> In our setup we are using MariaDB.
>
> BR,
>
> Marinos
>
>
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> Unsubscribe or change options here: https://www.inex.ie/mailman/listinfo/ixpmanager

-- 

Kind regards,
Barry O'Donovan
INEX

https://www.inex.ie/support/
+353 1 531 3339


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20210726/e3f8d3ed/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 18327 bytes
Desc: not available
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20210726/e3f8d3ed/attachment-0001.png>