Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sun Aug 20, 2017 10:18 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 18 posts ]  Go to page Previous  1, 2
Author Message
 Post subject:
PostPosted: Thu Jun 11, 2009 5:57 am 
Offline
Cacti User

Joined: Thu Nov 06, 2008 7:57 am
Posts: 127
When i try save my report i see error


Code:
06/11/2009 02:46:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"INSERT INTO `plugin_flowview_queries` (`name` , `device` , `startdate` , `starttime` , `enddate` , `endtime` , `tosfields` , `tcpflags` , `protocols`, `sourceip` , `sourceport` , `sourceinterface` , `sourceas` , `destip` , `destport` , `destinterface` , `destas` , `statistics` , `printed` , `includeif` , `sortfield` , `cutofflines` , `cutoffoctets` , `resolve` ) VALUES ( '10.0.0.0/8 every day', '', '', '-24 HOURS', '', 'NOW', '', '', '', '10.0.0.0/8', '', '', '', '', '', '', '', 10, 0, 1, 4, 100, '', 'Y')'


how i can repair it?

Quote:
+---------------------------------------+
| Tables_in_cacti |
+---------------------------------------+
| plugin_flowview_devices |
| plugin_flowview_dnscache |
| plugin_flowview_queries |
| plugin_flowview_schedules |
+---------------------------------------+


Quote:
mysql> show columns FROM plugin_flowview_queries
-> ;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| id | int(12) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | MUL | NULL | |
| device | varchar(32) | NO | | NULL | |
| startdate | varchar(32) | NO | | NULL | |
| starttime | varchar(32) | NO | | NULL | |
| enddate | varchar(32) | NO | | NULL | |
| endtime | varchar(32) | NO | | NULL | |
| tosfields | varchar(32) | NO | | NULL | |
| tcpflags | varchar(32) | NO | | NULL | |
| protocols | varchar(8) | NO | | NULL | |
| sourceip | varchar(255) | NO | | NULL | |
| sourceport | varchar(255) | NO | | NULL | |
| sourceinterface | varchar(64) | NO | | NULL | |
| sourceas | varchar(64) | NO | | NULL | |
| destip | varchar(255) | NO | | NULL | |
| destport | varchar(255) | NO | | NULL | |
| destinterface | varchar(64) | NO | | NULL | |
| destas | varchar(64) | NO | | NULL | |
| statistics | int(3) | NO | | NULL | |
| printed | int(3) | NO | | NULL | |
| includeif | int(2) | NO | | NULL | |
| sortfield | int(2) | NO | | NULL | |
| cutofflines | int(4) | NO | | NULL | |
| curoffoctets | varchar(8) | NO | | NULL | |
| resolve | varchar(2) | NO | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+
25 rows in set (0.00 sec)

mysql> show columns FROM plugin_flowview_schedules;
+--------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+----------------+
| id | int(12) | NO | PRI | NULL | auto_increment |
| enabled | varchar(3) | NO | | on | |
| sendinterval | int(20) | NO | | NULL | |
| lastsent | int(20) | NO | | NULL | |
| start | datetime | NO | | NULL | |
| email | text | NO | | NULL | |
| savedquery | int(12) | NO | MUL | NULL | |
+--------------+------------+------+-----+---------+----------------+

_________________
Cacti v.087g + PAv2.9


Top
 Profile  
 
 Post subject: how efficient is netflow
PostPosted: Fri Apr 16, 2010 8:55 am 
Offline
Cacti User

Joined: Thu May 17, 2007 9:18 am
Posts: 234
We are evaluating options to deploy this plugin but would like to know how efficient is netflow. I was told that we are currently doing one million netflow per minute. Can this plugin handle this type of load? I am looking for some input and appreciate any response.

thanks,

hasan


Top
 Profile  
 
 Post subject: how efficient is netflow
PostPosted: Fri Apr 16, 2010 8:56 am 
Offline
Cacti User

Joined: Thu May 17, 2007 9:18 am
Posts: 234
We are evaluating options to deploy this plugin but would like to know how efficient is netflow. I was told that we are currently doing one million netflow per minute. Can this plugin handle this type of load? I am looking for some input and appreciate any response.

thanks,

hasan


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 18 posts ]  Go to page Previous  1, 2

All times are UTC - 5 hours


Who is online

Users browsing this forum: Yahoo [Bot] and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group