Flowview listener recreation required after reboots

[brianh44]

So, this has been bugging me for a while. Flowview is an awesome plugin and an invaluable tool for troubleshooting where data is flowing. The problem is that whenever my server running Cacti is rebooted, the Listener disappears, so flow-capture will not start automatically. I go in, recreate the Listener and everything restarts and is happy again. Is this the norm? Is there some setting I need to be using to get the Listener to stay?
Thanks!

edit: Realized that I might have forgotten to include some valuable info
Cacti - 0.8.7h
Flowview - 1.1

[brianh44]

So is nobody else having this problem? I had to do it again this morning after a power outage last night .

[etetz]

I have the same problem on two installations. I am Cacti 8.8a and Flowview 1.1.
-ed

[etetz]

What is odd, the data is in the database in the plugin tables, and after the reboot, the table is blank. What is not removed from the database are schedules and filters, just the listener.
-ed

[etetz]

Well I found the problem and I need to how to post this as a bug.

The FlowView devices table is initially created using the following command. But this stores the data in memory (engine option). When the mySQL service is restarted, the data is lost.

Code: Select all

CREATE TABLE `plugin_flowview_devices` (
	`id` INT(12) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(64) NOT NULL,
	`folder` VARCHAR(64) NOT NULL,
	`allowfrom` VARCHAR(32) NOT NULL DEFAULT '0',
	`port` INT(12) NOT NULL,
	`nesting` VARCHAR(4) NOT NULL DEFAULT '-1',
	`version` VARCHAR(12) NOT NULL DEFAULT '5',
	`rotation` INT(12) NOT NULL DEFAULT '1439',
	`expire` INT(3) NOT NULL DEFAULT '7',
	`compression` INT(1) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	INDEX `folder` (`folder`)
)
COMMENT='Plugin Flowview - List of Devices to collect flows from'
COLLATE='latin1_swedish_ci'
ENGINE=MEMORY
AUTO_INCREMENT=2;

If this command is run against your current cacti database, then the data will now be stored in the database files used by the mySQL engine.

Code: Select all

ALTER TABLE `plugin_flowview_devices`
	ENGINE=MyISAM;

Now you should be able to reboot or restart the mySQL processes without losing this data.

Cheers,
-ed

[brianh44]

Wow, that's great, thanks for checking that out!

[gwhite]

Thanks for this. Solved my problem.

I'm running Cacti 0.8.8b and FlowView 1.1

[rapport]

I have some trouble.
'ENGINE=MyISAM' in script flowview.sql
but after reboot listeners is disappear.
Yow to solve a proplem?