Search found 16 matches

by ehelm
Fri Jan 25, 2008 4:45 pm
Forum: Scripts and Templates
Topic: Data Query For Non-Indexed Table
Replies: 19
Views: 7477

Well, it may sound awful, but everything's in here. With the last post of mine I only missed the final answer. You may provide it! To overcome start porblems, please refer to http://docs.cacti.net HowTo section on Data Queries Reinhard I believe it is close, however the oid_index_parse in several r...
by ehelm
Fri Jan 25, 2008 2:04 pm
Forum: Scripts and Templates
Topic: Data Query For Non-Indexed Table
Replies: 19
Views: 7477

Anyone got this data query to work properly? I just began looking at this same problem with Foundry's implementation of their CPU usage on their newer chassis switches.

/Eric
by ehelm
Thu Apr 26, 2007 8:53 pm
Forum: Plugin: (MAC Track)
Topic: [SOLVED] ERROR: SQL Exec Failed "INSERT INTO mac_track_
Replies: 7
Views: 8641

I did put on the SVN version earlier today, and it did fix my issue. Oh what joy it has provided in the short amount of time. Great work! Thanks.
by ehelm
Wed Apr 25, 2007 11:52 am
Forum: Plugin: (MAC Track)
Topic: [SOLVED] ERROR: SQL Exec Failed "INSERT INTO mac_track_
Replies: 7
Views: 8641

I've got the same issue... mactrack 0.0.1b. When I run 'php database_upgrade.php', I get a bunch of CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE errors. And of course, the same CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_...
by ehelm
Sat Apr 15, 2006 9:46 pm
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

Unfortunately, no. I am at a loss. We had changed the order that the script ran, so to see if there was a filelock, but that didn't change anything. In fact, we disabled the script from updating the txt file so cacti should have been able to cat the file and just graph the same data every poll, but ...
by ehelm
Mon Apr 10, 2006 2:45 pm
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

rony wrote:Question concerning ssh...

Is there a WAN link between the 2 servers?
No, 100base-TX LAN.

When run manually, the entire ssh session takes less than 1 second to cat the file on the remote box.
by ehelm
Mon Apr 10, 2006 1:15 pm
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

We totally disabled updating the txt file on the remote server for about 25 minutes. Still the poller reported "Result from SCRIPT not valid. Partial Result:".
How much debug would you like to see? I have all of it from a couple of polls during this time.

/Eric
by ehelm
Mon Apr 10, 2006 11:33 am
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

Tony, We have considered there could be a file lock problem or that the cat command is executed as the file is being written to, which would explain the partial results. We have changed the way the script runs on the remote box a bit to see if that is the problem. I'll update after we let it run a f...
by ehelm
Mon Apr 10, 2006 8:21 am
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

So, we know the script runs. And, when I run it manually, it is fine. The other 2 nearly identical scripts are working perfectly.
The question is: What happens when the poller returns "Result from SCRIPT not valid. Partial Result:"? And, why does it work sometimes?

/Eric
by ehelm
Sun Apr 09, 2006 6:49 pm
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

There should only be 1 command that the poller is running, ssh, since cat is being run on the remote box. Would I need to provide the path to cat on the remote box? The 'time' command in my previous post was just to record the resources used, and to show how long the actual command takes to run, whi...
by ehelm
Sun Apr 09, 2006 9:24 am
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

Currently, I have the Script and Script Server Timeout Value set at 60 seconds. Do you think this value is too low? I had previously adjusted it thinking it may help. The scripts, when run manually, only take milliseconds. time /usr/bin/ssh -i /root/.ssh/id_rsa dccd.ruraltel.net cat /usr/local/doubl...
by ehelm
Sat Apr 08, 2006 9:25 pm
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

That post talks about testing the PHP Script server. The script in question is not running from the script server. In the poller cache it is listed as "Action 1:", not "Action 2:". The Data Input Method is of type "Script/Command" Not Script Server. Is there any way to ...
by ehelm
Sat Apr 08, 2006 9:15 am
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

1) Is all output on one line? No <CR>? 2) Perhaps "." in the output vars is the problem. May you have a go replacing this by some other chars or omitting it? Reinhard 1) There are no <CR>. 2) I thought of that, but I have 2 other nearly identical scripts, 1 for RBL DNS BPS, and another fo...
by ehelm
Fri Apr 07, 2006 11:37 am
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

Here is from a debug: 04/07/2006 11:30:03 AM - CACTID: Poller[0] Host[0] DS[6529] WARNING: Result from SCRIPT not valid. Partial Result: multi.uribl.com_byte... 04/07/2006 11:30:03 AM - CACTID: Poller[0] Host[0] DS[6529] SCRIPT: /usr/bin/ssh -i /root/.ssh/id_rsa dccd.blah.net cat /usr/local/doublech...
by ehelm
Fri Apr 07, 2006 11:00 am
Forum: Help: General
Topic: Script/Command is not consistent
Replies: 20
Views: 5701

Script/Command is not consistent

I have a Data Input Method using Script/Command that will graph data occasionally, but mostly I get the "SCRIPT not valid. Partial Result" log messages. I've doublechecked my output and it all looks good. I have several other Script/Command Data Input Methods doing almost the exact same th...