plugin_flowview icon indicating copy to clipboard operation
plugin_flowview copied to clipboard
verified publisher icon Cacti

Can't receive any results

Open GrayFox14048 opened this issue 2 years ago • 2 comments

Hello there!

I have successfully installed floview plugin on cacti 1.2.19, on ubuntu 20.04 (php 7.4.3). As you can see my listeners are online but I don't receive any data. I have not found screenshots of configuration examples but I am attaching mine. Could someone who has succeeded tell me what I have to change in the configuration of filters or schedules?

I've turned on debug mode for the plugin and I'm getting these errors:

2023-01-30 14:49:53 - SYSTEM FLOWVIEW SCHEDULE STATS: Time:0.0100 Schedule:1 2023-01-30 14:49:53 - CMDPHP MAILER ERROR Backtrace: (/plugins/flowview/run_schedule.php[103]:plugin_flowview_run_schedule(), /plugins/flowview/functions.php[1275]:mailer(), /lib/functions.php[4427]:cacti_debug_backtrace()) 2023-01-30 14:49:53 - MAILER ERROR: No recipient address set!! 2023-01-30 14:49:53 - CMDPHP SQL Backtrace: (/plugins/flowview/run_schedule.php[103]:plugin_flowview_run_schedule(), /plugins/flowview/functions.php[1237]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2177]:db_fetch_assoc(), /lib/database.php[501]:db_fetch_assoc_prepared(), /lib/database.php[515]:db_execute_prepared()) 2023-01-30 14:49:53 - CMDPHP ERROR: A DB Row Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM ( FROM plugin_flowview_raw_2023029 WHERE (start_time BETWEEN "2023-01-...' at line 1 2023-01-30 14:49:53 - DBCALL ERROR: A DB Row Failed!, Error: 1064, SQL: ' FROM ( FROM plugin_flowview_raw_2023029 WHERE (start_timeBETWEEN "2023-01-29 14:49:53" AND "2023-01-30 14:49:53" ORend_time BETWEEN "2023-01-29 14:49:53" AND "2023-01-30 14:49:53") AND (src_addr = INET6_ATON('0.0.0.0')) AND (dst_addr = INET6_ATON('0.0.0.0')) ) AS rs LIMIT 20' 2023-01-30 14:49:53 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/run_schedule.php[103]:plugin_flowview_run_schedule(), /plugins/flowview/functions.php[1237]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2170]:CactiErrorHandler()) 2023-01-30 14:49:53 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_order in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2170 2023-01-30 14:49:53 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/run_schedule.php[103]:plugin_flowview_run_schedule(), /plugins/flowview/functions.php[1237]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2170]:CactiErrorHandler()) 2023-01-30 14:49:53 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_groupby in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2170 2023-01-30 14:49:53 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/run_schedule.php[103]:plugin_flowview_run_schedule(), /plugins/flowview/functions.php[1237]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2170]:CactiErrorHandler()) 2023-01-30 14:49:53 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_query in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2170 2023-01-30 14:49:53 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/run_schedule.php[103]:plugin_flowview_run_schedule(), /plugins/flowview/functions.php[1237]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2166]:CactiErrorHandler()) 2023-01-30 14:49:53 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_inner_groupby in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2166 2023-01-30 14:49:53 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/run_schedule.php[103]:plugin_flowview_run_schedule(), /plugins/flowview/functions.php[1237]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2166]:CactiErrorHandler()) 2023-01-30 14:49:53 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_inner in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2166 2023-01-30 14:49:53 - POLLER: Poller[Main Poller] PID[3472778] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/html/cacti/plugins/flowview/run_schedule.php --force --schedule=1] 2023-01-30 14:49:43 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview_filters.php[65]:show_filters(), /plugins/flowview/flowview_filters.php[376]:CactiErrorHandler()) 2023-01-30 14:49:43 - ERROR PHP NOTICE in Plugin 'flowview': Trying to access array offset on value of type null in file: /var/www/html/cacti/plugins/flowview/flowview_filters.php on line: 376 2023-01-30 14:49:43 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview_filters.php[65]:show_filters(), /plugins/flowview/flowview_filters.php[376]:CactiErrorHandler()) 2023-01-30 14:49:43 - ERROR PHP NOTICE in Plugin 'flowview': Undefined offset: 0 in file: /var/www/html/cacti/plugins/flowview/flowview_filters.php on line: 376 2023-01-30 14:49:43 - DBCALL DEVEL: SQL Save on table 'plugin_flowview_queries': 'a:24:{s:2:"id";i:1;s:4:"name";s:10:"FILTROTEST";s:9:"device_id";i:1;s:8:"timespan";s:0:"";s:9:"startdate";s:16:"2023-01-29 14:49";s:7:"enddate";s:16:"2023-01-30 14:49";s:9:"tosfields";s:0:"";s:8:"tcpflags";s:0:"";s:9:"protocols";s:1:"0";s:8:"sourceip";s:7:"0.0.0.0";s:10:"sourceport";s:0:"";s:15:"sourceinterface";s:0:"";s:8:"sourceas";s:0:"";s:6:"destip";s:7:"0.0.0.0";s:8:"destport";s:0:"";s:13:"destinterface";s:0:"";s:6:"destas";s:0:"";s:10:"statistics";s:1:"0";s:7:"printed";s:1:"0";s:9:"includeif";i:1;s:9:"sortfield";s:0:"";s:11:"cutofflines";s:2:"20";s:12:"cutoffoctets";s:1:"0";s:7:"resolve";s:1:"Y";}' 2023-01-30 14:49:15 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview_filters.php[65]:show_filters(), /plugins/flowview/flowview_filters.php[376]:CactiErrorHandler()) 2023-01-30 14:49:15 - ERROR PHP NOTICE in Plugin 'flowview': Trying to access array offset on value of type null in file: /var/www/html/cacti/plugins/flowview/flowview_filters.php on line: 376 2023-01-30 14:49:15 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview_filters.php[65]:show_filters(), /plugins/flowview/flowview_filters.php[376]:CactiErrorHandler()) 2023-01-30 14:49:15 - ERROR PHP NOTICE in Plugin 'flowview': Undefined offset: 0 in file: /var/www/html/cacti/plugins/flowview/flowview_filters.php on line: 376 2023-01-30 14:49:15 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview_filters.php[56]:edit_filter(), /plugins/flowview/functions.php[113]:CactiErrorHandler()) 2023-01-30 14:49:15 - ERROR PHP NOTICE in Plugin 'flowview': Undefined offset: 0 in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 113 2023-01-30 14:49:14 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview_filters.php[65]:show_filters(), /plugins/flowview/flowview_filters.php[376]:CactiErrorHandler()) 2023-01-30 14:49:14 - ERROR PHP NOTICE in Plugin 'flowview': Trying to access array offset on value of type null in file: /var/www/html/cacti/plugins/flowview/flowview_filters.php on line: 376 2023-01-30 14:49:14 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview_filters.php[65]:show_filters(), /plugins/flowview/flowview_filters.php[376]:CactiErrorHandler()) 2023-01-30 14:49:14 - ERROR PHP NOTICE in Plugin 'flowview': Undefined offset: 0 in file: /var/www/html/cacti/plugins/flowview/flowview_filters.php on line: 376 2023-01-30 14:49:11 - DBCALL DEVEL: SQL Save on table 'plugin_flowview_schedules': 'a:8:{s:5:"title";s:12:"TESTSCHEDULE";s:8:"query_id";i:1;s:12:"sendinterval";i:3600;s:5:"start";s:19:"2023-01-30 14:16:52";s:5:"email";s:0:"";s:11:"format_file";s:18:"cacti_group.format";s:2:"id";i:1;s:7:"enabled";s:2:"on";}' 2023-01-30 14:48:49 - CMDPHP SQL Backtrace: (/plugins/flowview/flowview.php[65]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2177]:db_fetch_assoc(), /lib/database.php[501]:db_fetch_assoc_prepared(), /lib/database.php[515]:db_execute_prepared()) 2023-01-30 14:48:49 - CMDPHP ERROR: A DB Row Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM ( FROM plugin_flowview_raw_2023029 WHERE (start_time BETWEEN "2023-01-...' at line 1 2023-01-30 14:48:49 - DBCALL ERROR: A DB Row Failed!, Error: 1064, SQL: ' FROM ( FROM plugin_flowview_raw_2023029 WHERE (start_timeBETWEEN "2023-01-30 14:18:00" AND "2023-01-30 14:48:00" ORend_time BETWEEN "2023-01-30 14:18:00" AND "2023-01-30 14:48:00") ) AS rs LIMIT 20' 2023-01-30 14:48:49 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview.php[65]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2170]:CactiErrorHandler()) 2023-01-30 14:48:49 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_order in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2170 2023-01-30 14:48:49 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview.php[65]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2170]:CactiErrorHandler()) 2023-01-30 14:48:49 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_groupby in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2170 2023-01-30 14:48:49 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview.php[65]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2170]:CactiErrorHandler()) 2023-01-30 14:48:49 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_query in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2170 2023-01-30 14:48:49 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview.php[65]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2166]:CactiErrorHandler()) 2023-01-30 14:48:49 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_inner_groupby in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2166 2023-01-30 14:48:49 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/flowview/flowview.php[65]:load_data_for_filter(), /plugins/flowview/functions.php[1351]:run_flow_query(), /plugins/flowview/functions.php[2166]:CactiErrorHandler()) 2023-01-30 14:48:49 - ERROR PHP NOTICE in Plugin 'flowview': Undefined variable: sql_inner in file: /var/www/html/cacti/plugins/flowview/functions.php on line: 2166

Thanks everybody!!

filter schedule results listener

GrayFox14048 avatar Jan 30 '23 14:01 GrayFox14048

Is this the Development version or a tagged release?

TheWitness avatar Feb 18 '23 13:02 TheWitness

Is this the Development version or a tagged release?

What do you mean? I'm sorry but I'm not sure I have understood

GrayFox14048 avatar Feb 20 '23 07:02 GrayFox14048

I can not reproduce this in the latest develop. I'm planning a new release. If you would like to re-test on a new install, please open a new ticket.

TheWitness avatar May 20 '24 12:05 TheWitness