Flowview filter not really working about plugin_flowview HOT 9 CLOSED

Doing a simple function to test the INET_NTOA and ATON look like it's causing the problem
When I did:
RETURN (
INET6_NTOA(ipadd & INET6_ATON(mask))

)
and a call with:
SELECT get_network(0x0a55a094, "255.255.0.0", "10.85.0.0")

return NULL

but having the function :
RETURN (
INET_NTOA(ipadd & INET_ATON(mask))

)
and same call as before, it return:
10.85.0.0

So verification with the function:
RETURN (
(ipadd & INET_ATON(mask))
= INET_ATON(test)
)
And allways the same call return true, and if I call with this:
SELECT get_network(0x0aa5a094, "255.255.0.0", "10.85.0.0")

it return false.

So why is the INET6_ATON and NTOA is not working ?

from plugin_flowview.

What MariaDB version are you on?

from plugin_flowview.

Ugh, I think some settings were lost. So much to do, only so many hours in a day.

from plugin_flowview.

I updated the dev branch to give you more control on the DNS front.

from plugin_flowview.

Doing a simple function to test the INET_NTOA and ATON look like it's causing the problem
When I did:
RETURN (
INET6_NTOA(ipadd & INET6_ATON(mask))

)
and a call with:
SELECT get_network(0x0a55a094, "255.255.0.0", "10.85.0.0")

return NULL

but having the function :
RETURN (
INET_NTOA(ipadd & INET_ATON(mask))

)
and same call as before, it return:
10.85.0.0

So verification with the function:
RETURN (
(ipadd & INET_ATON(mask))
= INET_ATON(test)
)
And allways the same call return true, and if I call with this:
SELECT get_network(0x0aa5a094, "255.255.0.0", "10.85.0.0")

it return false.

So why is the INET6_ATON and NTOA is not working ?

I'm using 10.5.0

from plugin_flowview.

Ok, so I upgrade to the new develop, and the DNS Iana thinks seams working, no more error!
But still the filter is not working as it should be.
I'm still see packet with source address that dosen't match the filter.

from plugin_flowview.

Well doing a query with ARIN 'on' is still not working:
06/04/2022 10:26:04 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flow_collector.php[338]:process_fv5(), /plugins/flowview/flow_collector.php[431]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3310]:flowview_get_owner_from_arin(), /plugins/flowview/functions.php[3579]:CactiErrorHandler())

06/04/2022 10:26:04 - ERROR PHP NOTICE in Plugin 'flowview': Trying to access array offset on value of type null in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3579
06/04/2022 10:26:04 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flow_collector.php[338]:process_fv5(), /plugins/flowview/flow_collector.php[431]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3310]:flowview_get_owner_from_arin(), /plugins/flowview/functions.php[3579]:CactiErrorHandler())
06/04/2022 10:26:04 - ERROR PHP NOTICE in Plugin 'flowview': Trying to access array offset on value of type null in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3579
06/04/2022 10:26:04 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flow_collector.php[338]:process_fv5(), /plugins/flowview/flow_collector.php[431]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3310]:flowview_get_owner_from_arin(), /plugins/flowview/functions.php[3579]:CactiErrorHandler())
06/04/2022 10:26:04 - ERROR PHP NOTICE in Plugin 'flowview': Trying to access array offset on value of type null in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3579

That's the output of:
cacti_log("FLOwVIEW: ". print_r(json_decode($response, true), true ) );
06/04/2022 10:26:04 - CMDPHP FLOwVIEW:

That's the query to ARIN:
06/04/2022 10:26:04 - CMDPHP FLOwVIEW: http://whois.arin.net/rest/ip/76.223.122.69

from plugin_flowview.

So I find the issue about the arin.net not accessible, I have a page from our firewall who denied the access. And since it's an http, this two flag are not set.
But a test of $json shold be able to solve that!

from plugin_flowview.

I gave you an option to disable Arin lookup. That's a better thing. It'll speed things up.

Since we have 3 separate issues on this ticket, I'm going to close. The filter save issue is resolved. You need to open a separate issue on the subnet calculation issues, if they persist after the filter issue is resolved.

from plugin_flowview.