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

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
getcerts2019
Posts: 2
Joined: Tue Jul 02, 2024 11:18 am

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

Post by 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,
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

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

Post by macan »

flowview is under heavy development now, errors may occurs.
Thank you for reporting.
Fixed here:
https://github.com/Cacti/plugin_flowview/pull/157
Let the Cacti grow!
getcerts2019
Posts: 2
Joined: Tue Jul 02, 2024 11:18 am

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

Post by 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?
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

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

Post by 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.
Let the Cacti grow!
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

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

Post by macan »

please report any issues with develop version here:
https://github.com/Cacti/plugin_flowview/issues
Let the Cacti grow!
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

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

Post by 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..
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 2 guests