Typo in setup.php for plugin flowview v3.7 making the creation of the table plugin_flowview_queries failed

[getcerts2019]

Hi all,

I am new to the plugin of flowview, and I tried to install this plugin to the Cacti.
I have followed the instruction to install it, but it keep saying the table plugin_flowview_queries is not exist.
After review the content in the setup.php, i can see the column ex_addr is defined with unsigned.
After removing the unsigned keyword, I can successfully create the table.

Hope this can help the other who is also setting up flowview.



flowview_db_execute("CREATE TABLE IF NOT EXISTS `" . $flowviewdb_default . "`.`plugin_flowview_queries` (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
device_id int(11) unsigned NOT NULL,
template_id int(11) unsigned NOT NULL DEFAULT '0',
ex_addr varchar(46) unsigned NOT NULL DEFAULT '',
timespan int(11) unsigned NOT NULL DEFAULT '0',
startdate varchar(32) NOT NULL,
enddate varchar(32) NOT NULL,
tosfields varchar(32) NOT NULL,
tcpflags varchar(32) NOT NULL,
protocols varchar(32) DEFAULT NULL,
sourceip varchar(255) NOT NULL,
sourceport varchar(255) NOT NULL,
sourceinterface varchar(64) NOT NULL,
sourceas varchar(64) NOT NULL,
destip varchar(255) NOT NULL,
destport varchar(255) NOT NULL,

[macan]

flowview is under heavy development now, errors may occurs.
Thank you for reporting.
Fixed here:
https://github.com/Cacti/plugin_flowview/pull/157

[getcerts2019]

Hi Macan,

Thank you so much for your information.

As I need to use netflow on Cacti, can you suggest a stable version of flowview to deploy?

[macan]

Use actual develop version from https://github.com/Cacti/plugin_flowvie ... evelop.zip

I said that in develop version is lot of changes now. It is true. But last release (3.3) is very old. Develop version is better and has a lot of new features. If develop version will work, use it. We will prepare new release later.

[macan]

please report any issues with develop version here:
https://github.com/Cacti/plugin_flowview/issues

[TheWitness]

I may send out a more generalized note once I have FlowView more ready for release. From my latest Snapchat there will be some changes required to cacti's database API as a result of my testing with regard to MaxScale and parallel queries

I will reference the cacti database.php commit in the README.md..