FlowView - not show data

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
chsonly
Posts: 1
Joined: Fri Jul 02, 2021 4:20 am

FlowView - not show data

Post by chsonly »

FlowView - not show data

Hello !

I using Cacti 1.2.17 with maria dba 10.x in CentOS 7

CentOS Version:CentOS Linux release 7.9.2009 (Core)
Cacti Version:1.2.17
MariaDB Version: 10.3.29
Flowview Version 3.2

The Flowview listener is up
[root@cacti ~]# netstat -ano | grep 2055
udp 0 0 0.0.0.0:2055 0.0.0.0:* off (0.00/0/0)

The flowDATA not show in web interface
What is the problem
who can help me
Thanks

01.png
01.png (27.76 KiB) Viewed 8135 times
02.png
02.png (30.12 KiB) Viewed 8135 times
03.png
03.png (84.95 KiB) Viewed 8135 times
04.png
04.png (194.65 KiB) Viewed 8135 times
srle
Posts: 1
Joined: Thu Sep 27, 2007 6:20 am

Re: FlowView - not show data

Post by srle »

Same here:

13-Jul-2021 09:18:03 - CMDPHP SQL Backtrace: (/plugins/flowview/flowview_process.php[116]:db_fetch_cell_prepared(), /lib/database.php[427]:db_execute_prepared())
13-Jul-2021 09:18:03 - CMDPHP ERROR: A DB Cell Failed!, Error: Table 'cacti.plugin_flowview_raw_2021193' doesn't exist
13-Jul-2021 09:18:03 - CMDPHP SQL Backtrace: (/plugins/flowview/flowview_process.php[109]:get_tables_range(), /plugins/flowview/functions.php[3865]:create_raw_partition(), /plugins/flowview/functions.php[3662]:api_plugin_db_table_create(), /lib/plugins.php[480]:db_execute(), /lib/database.php[238]:db_execute_prepared())
13-Jul-2021 09:18:03 - CMDPHP ERROR: A DB Exec 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 'start_time`,`end_time`)) ENGINE = InnoDB ROW_FORMAT = Dynamic COMMENT = 'Plug...' at line 1

Anybody solved this? I am not database expert or programmer, so please be gentle with me :)

Cacti 1.2.18
Flowview 3.2
installer
Posts: 3
Joined: Thu Jul 08, 2021 4:28 am

Re: FlowView - not show data

Post by installer »

srle wrote: Tue Jul 13, 2021 2:21 am Same here:

13-Jul-2021 09:18:03 - CMDPHP SQL Backtrace: (/plugins/flowview/flowview_process.php[116]:db_fetch_cell_prepared(), /lib/database.php[427]:db_execute_prepared())
13-Jul-2021 09:18:03 - CMDPHP ERROR: A DB Cell Failed!, Error: Table 'cacti.plugin_flowview_raw_2021193' doesn't exist
13-Jul-2021 09:18:03 - CMDPHP SQL Backtrace: (/plugins/flowview/flowview_process.php[109]:get_tables_range(), /plugins/flowview/functions.php[3865]:create_raw_partition(), /plugins/flowview/functions.php[3662]:api_plugin_db_table_create(), /lib/plugins.php[480]:db_execute(), /lib/database.php[238]:db_execute_prepared())
13-Jul-2021 09:18:03 - CMDPHP ERROR: A DB Exec 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 'start_time`,`end_time`)) ENGINE = InnoDB ROW_FORMAT = Dynamic COMMENT = 'Plug...' at line 1

Anybody solved this? I am not database expert or programmer, so please be gentle with me :)

Cacti 1.2.18
Flowview 3.2
Hello! Faced the same problem, I have been looking for a solution for 3 days and also did not achieve any result :(
software version is the same
cigamit
Developer
Posts: 3369
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Re: FlowView - not show data

Post by cigamit »

Have you tried the development version? This was fixed nearly a year ago.

https://github.com/Cacti/plugin_flowview/issues/60
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: FlowView - not show data

Post by TheWitness »

Totally agree. FlowView is working pretty good. There are some snafu's related to IPFIX/V9, but V5 is rock solid for sure.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests