| View previous topic :: View next topic |
| Author |
Message |
gster New User
Joined: 06 May 2008 Posts: 7
|
Posted: Mon May 12, 2008 12:27 pm Post subject: Unable to create queries in flowview |
|
|
Hi, I can't seem to create queries in flowview. Running version 0.6 from SVN.
Otherwise flowview is working brilliantly. Looked in the logs but couldn't find anything of relevance. Only thing that may be relevant is from the technical support section on - System Utilities
plugin_flowview_dnscache 0 MEMORY latin1_swedish_ci The storage engine for the table doesn't support check
Any ideas what this could be? I'm sure I imported this table into the database when I set up flowview.
Any clues would be most appreciated
Graeme
|
|
| Back to top |
|
 |
jimmy Site Admin
Joined: 11 Nov 2004 Posts: 1495
|
Posted: Mon May 12, 2008 10:43 pm Post subject: |
|
|
| IE or firefox, not sure if I fixed that version to work with IE, as IE has major issues with standards.
|
|
| Back to top |
|
 |
gster New User
Joined: 06 May 2008 Posts: 7
|
Posted: Tue May 13, 2008 1:46 am Post subject: |
|
|
| Using Firefox 2.0.0.14, also tried in IE7 and get the same result
|
|
| Back to top |
|
 |
davenpro New User
Joined: 13 May 2008 Posts: 2
|
Posted: Tue May 13, 2008 11:50 am Post subject: |
|
|
I'm also having the same issue. I'm running Cacti 0.8.7b, Plugin Architecture 2.1, and Flowviewer 0.5.1. The plugin installed/appeared in cact just as it should however I'm not able to generate queries either, the results are just a blank table. All of my settings directories appear to be correct, and there isn't a single item in the cacti log file about flowviewer. I too get the same results in either Firefox or IE.
Any suggestions?
|
|
| Back to top |
|
 |
gster New User
Joined: 06 May 2008 Posts: 7
|
Posted: Wed May 14, 2008 3:26 am Post subject: |
|
|
Actually I can run queries, I just can't save them and therefore use the schedules function.
I did have a similar issue to you but managed to get it working.
Couple of things that I did around the time when it fixed itself.
1) sorted out ntp sync issues (I'm running on VMWARE)
2) re-compiled my kernel, as part of (1)
3) followed the clues in this post
http://cactiusers.org/forums/viewtopic.php?t=1496&highlight=netflow
4) make sure flow-capture is running and collecting stats
ps aux | grep flow-capture
If not check the permisions on /var/netflow/flows/completed/ or where ever your flows are created.
Not sure which of these resolved my issues but it's working for me now. Just can't save the queries.
|
|
| Back to top |
|
 |
jimmy Site Admin
Joined: 11 Nov 2004 Posts: 1495
|
Posted: Mon May 26, 2008 4:34 pm Post subject: |
|
|
| Does the plugin_flowview_queries table exist?
|
|
| Back to top |
|
 |
gster New User
Joined: 06 May 2008 Posts: 7
|
Posted: Tue May 27, 2008 7:36 am Post subject: |
|
|
| Yes, Just to be sure I dropped the table and re-ran the section of the .sql file pertaining to that table, but still get the same result
|
|
| Back to top |
|
 |
Linuxx New User
Joined: 29 Jan 2008 Posts: 16
|
Posted: Mon Jun 09, 2008 4:00 pm Post subject: Quick Fix |
|
|
Here is a quick fix to this. I didn't have time to find out why, but it works.
Replace line 153 with
if (isset($_POST['queryname']) && $_POST['queryname'] != '') {
For some reason it cant see that $_REQUEST['action2_x'] has a value...
Linuxx
P.S. I only had a problem saving a query..
|
|
| Back to top |
|
 |
gster New User
Joined: 06 May 2008 Posts: 7
|
Posted: Thu Jun 12, 2008 11:36 am Post subject: |
|
|
| thanks for your repsonse, can you just confirm which file and the code that I'm replacing, I suspect it is in flowview.php but line 153 does not match up to a line with '$_REQUEST['action2_x']' in my version.
|
|
| Back to top |
|
 |
Linuxx New User
Joined: 29 Jan 2008 Posts: 16
|
Posted: Thu Jun 12, 2008 12:06 pm Post subject: oops |
|
|
Oops!
Yeah, its flowview.php. I am using the latest downloaded from this site (0.5.1) and line 153 down looks like this...
| Code: |
if (isset($_REQUEST['action2_x']) && isset($_POST['queryname']) && $_POST['queryname'] != '') {
$queryname = $_POST['queryname'];
$queryname = form_input_validate($queryname, "queryname", "", false, 3);
|
Remove "isset($_REQUEST['action2_x']) && "
| Code: |
if (isset($_POST['queryname']) && $_POST['queryname'] != '') {
$queryname = $_POST['queryname'];
$queryname = form_input_validate($queryname, "queryname", "", false, 3);
|
Note: I only changed the top part...
Plus, any changes to the code could cause the program to not work as intended. Please make a backup before you change it. I personally have not noticed any adverse effects.
Linuxx
|
|
| Back to top |
|
 |
|