FAQFAQ   SearchSearch   RegisterRegister   ProfileProfile   Log inLog in 

Unable to create queries in flowview

 
Post new topic   Reply to topic    CactiUsers.org Forum Index -> General
View previous topic :: View next topic  
Author Message
gster
New User


Joined: 06 May 2008
Posts: 7

PostPosted: Mon May 12, 2008 12:27 pm    Post subject: Unable to create queries in flowview Reply with quote

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
View user's profile
jimmy
Site Admin


Joined: 11 Nov 2004
Posts: 1560

PostPosted: Mon May 12, 2008 10:43 pm    Post subject: Reply with quote

IE or firefox, not sure if I fixed that version to work with IE, as IE has major issues with standards.
Back to top
View user's profile Visit poster's website
gster
New User


Joined: 06 May 2008
Posts: 7

PostPosted: Tue May 13, 2008 1:46 am    Post subject: Reply with quote

Using Firefox 2.0.0.14, also tried in IE7 and get the same result
Back to top
View user's profile
davenpro
New User


Joined: 13 May 2008
Posts: 2

PostPosted: Tue May 13, 2008 11:50 am    Post subject: Reply with quote

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
View user's profile
gster
New User


Joined: 06 May 2008
Posts: 7

PostPosted: Wed May 14, 2008 3:26 am    Post subject: Reply with quote

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
View user's profile
jimmy
Site Admin


Joined: 11 Nov 2004
Posts: 1560

PostPosted: Mon May 26, 2008 4:34 pm    Post subject: Reply with quote

Does the plugin_flowview_queries table exist?
Back to top
View user's profile Visit poster's website
gster
New User


Joined: 06 May 2008
Posts: 7

PostPosted: Tue May 27, 2008 7:36 am    Post subject: Reply with quote

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
View user's profile
Linuxx
New User


Joined: 29 Jan 2008
Posts: 16

PostPosted: Mon Jun 09, 2008 4:00 pm    Post subject: Quick Fix Reply with quote

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
View user's profile
gster
New User


Joined: 06 May 2008
Posts: 7

PostPosted: Thu Jun 12, 2008 11:36 am    Post subject: Reply with quote

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
View user's profile
Linuxx
New User


Joined: 29 Jan 2008
Posts: 16

PostPosted: Thu Jun 12, 2008 12:06 pm    Post subject: oops Reply with quote

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
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    CactiUsers.org Forum Index -> General All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
Forums Sitemap