Issue with FlowView 1.1

[spyda46]

Hi there,

I am hoping someone can help me, i ve been trying to overcome this issue for over a day now and have hit a brick wall -

Issue:

I have installed the plugin via PIA 2.9

All it is active, however i cannot add any listeners or really do anything with it, the log shows DB errors, i have tried to change Type to Engine but no go

Logs:

07/04/2012 11:49:56 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"TRUNCATE plugin_flowview_ports'
07/04/2012 11:49:56 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE `plugin_flowview_ports` (`id` int(12) NOT NULL auto_increment,`service` varchar(20) NOT NULL default '',`port` int(12) NOT NULL,`proto` char(4) NOT NULL,`description` varchar(255) NOT NULL default '', PRIMARY KEY (`id`)) TYPE = MyISAM COMMENT = 'Plugin Flowview - Database of well known Ports''
07/04/2012 11:49:56 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE `plugin_flowview_schedules` (`id` int(12) NOT NULL auto_increment,`title` varchar(128) NOT NULL default '',`enabled` varchar(3) NOT NULL default 'on',`sendinterval` int(20) NOT NULL,`lastsent` int(20) NOT NULL,`start` datetime NOT NULL,`email` text NOT NULL,`savedquery` int(12) NOT NULL, PRIMARY KEY (`id`), KEY `savedquery` (`savedquery`)) TYPE = MyISAM COMMENT = 'Plugin Flowview - Scheduling for running and emails of saved queries''
07/04/2012 11:49:56 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE `plugin_flowview_queries` (`id` int(12) NOT NULL auto_increment,`name` varchar(255) NOT NULL,`device` varchar(32) NOT NULL,`startdate` varchar(32) NOT NULL,`starttime` varchar(32) NOT NULL,`enddate` varchar(32) NOT NULL,`endtime` varchar(32) NOT NULL,`tosfields` varchar(32) NOT NULL,`tcpflags` varchar(32) NOT NULL,`protocols` varchar(8) NOT 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,`destinterface` varchar(64) NOT NULL,`destas` varchar(64) NOT NULL,`statistics` int(3) NOT NULL,`printed` int(3) NOT NULL,`includeif` int(2) NOT NULL,`sortfield` int(2) NOT NULL,`cutofflines` varchar(8) NOT NULL,`cutoffoctets` varchar(8) NOT NULL,`resolve` varchar(2) NOT NULL, PRIMARY KEY (`id`), KEY `name` (`name`)) TYPE = MyISAM COMMENT = 'Plugin Flowview - List of Saved Flow Queries''
07/04/2012 11:49:56 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"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`), KEY `folder` (`folder`)) TYPE = MEMORY COMMENT = 'Plugin Flowview - List of Devices to collect flows from''
07/04/2012 11:49:56 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE `plugin_flowview_dnscache` (`ip` varchar(32) NOT NULL default '',`host` varchar(255) NOT NULL default '',`time` int(20) NOT NULL default 0, KEY `ip` (`ip`)) TYPE = MEMORY COMMENT = 'Plugin Flowview - DNS Cache to help speed things up''


I looked in the setup.php and changed type to engine but this makes no difference

$data['type'] = 'MyISAM';
$data['engine'] = 'MyISAM';

Also changed the flowview.sql file to ENGINE but still doesn't work

Setup details:

Cacti Version 0.8.7g
Plugin Architecture Version: 2.9
Flowview version 1.1
MySQL server version 5.5.25


Any know what the issue is?

Thanks!!!