no data output on data query (get)

Templates, scripts for templates, scripts and requests for templates.

Moderators: Developers, Moderators

szogun3k
Posts: 14
Joined: Thu Apr 13, 2006 4:48 am

Post by szogun3k »

with my script it will be a little porblem because its not collecting data from local machine but it connect to other host request for data and return theme. data is stored on other hosts as rrd files ( some other scripts also produce graphs from those rrd files), so i make some hack change rrd files in mysql database that rrd files are looking data in my rrd files downloaded from other hosts but its generating a lot of unnecesery traffic. here you've got my script it is very messy because it is still developed version and xml where i add arg prepend hostname which is easier now to add another host.
its nothing special rest job makes server on other site.
Attachments
stat.xml
xml
(1.05 KiB) Downloaded 102 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

I've had to delete the script as it contained valid IP@ of yours. As this might be a security risk, I deleted the attachment after downloading. Currently working on your item ...
Reinhard
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Here's what I've found from executing your script:

Code: Select all

xxx.xx.xxx.xxx  index                   OK
 266
 366
 101
 102
 ...
 172
xxx.xx.xxx.xxx  query   ip              OK
 266:sklep_2
 366:sklep_1
 101:some_name
 102:some_other_name
 ...
 172:again_some_name
xxx.xx.xxx.xxx  query   up              OK
 some_ip1:890

 some_ip2:890

 some_ip3:50433

 some_ip4:444

 ...

 some_ipnn:1792330

xxx.xx.xxx.xxx  query   mac             OK
 266:00-E0-7D-BA-B1-F9
 366:00-E0-7D-BA-B1-FC
 101:00-03-2F-1B-78-84
 ...
 172:00-10-60-74-54-A5
xxx.xx.xxx.xxx  query   down            OK
 some_ip1:31397751
 some_ip2:8355708
 some_ip3:354676920
 Some_ip4:7595083
 ...
 some_ipnn:5005228117
index, query ip and query mac are fine, but the indices of query up/down do not match those from the index run. Please provide test output of yours if mine was incorrect. Else, you've to correct that bit (if a change is required for the script you've sent, please provide this by pm). And I suspect that the newline found for query down must be skipped
Reinhard
szogun3k
Posts: 14
Joined: Thu Apr 13, 2006 4:48 am

Post by szogun3k »

sorry my mistake i forogot to change to older version because i thought it was wrong, because indexes were some string (ip with dots) and thats why i change indexes to integer values (i.e. maybe digits with dots are interpeted as real not integers separated by dots), but if indexes can be any type of unique string then i start older version with IP as index. to script which i send there is no need to change anything, as you can see its just a xml transporter. now you will get something like this
on index it should be list of IP for query it should be correct values (index:value)

another think with this script on graphs i did not get value of | query_ifIndex|
and have no clue how to fix it :/
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

I'm on the way. Some minor changes in the XML (see attached). I suppose the REAL change was to remove the leading blanks for the "get ..." output.
Will post screenshots from graphs soon (via pm)
Reinhard
Attachments
szogun3k.xml
XML file
(1.05 KiB) Downloaded 103 times
stat.pl.txt
Perl file (IP@ masked for security reason)
(1.46 KiB) Downloaded 94 times
szogun3k
Posts: 14
Joined: Thu Apr 13, 2006 4:48 am

Post by szogun3k »

ok i admit i am lame but this are screenshots form my data input method data query and graph template can you tell me what is wrong with this ? maybe some diffrence beetwheen my setup and yours.

on data input method in input data type <ip> there is only two think variable name and friendly name nothing else next on other shots you see setup.
Attachments
data query
data query
dq.JPG (44.48 KiB) Viewed 1612 times
data input method
data input method
dim.JPG (44.5 KiB) Viewed 1613 times
graph template
graph template
gt.JPG (73.89 KiB) Viewed 1613 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

The Data Input Method is not needed for Script Queries. The script to be executed is defined by the headers of the XML file. So you may delete this Data Input Method without problems.
Please find attached the Data Query I've generated, including all dependencies. Be aware of the fact, that I named your XML szogun3k.xml. Please rename to your liking after importing it.
Reinhard
Attachments
cacti_data_query_szogun3k.xml
Data Query XML to be imported
including all dependencies
(13.31 KiB) Downloaded 121 times
szogun3k
Posts: 14
Joined: Thu Apr 13, 2006 4:48 am

Post by szogun3k »

great thanks i fight with this for 2 weeks and i didnt make it and you made it at couple of days, once again great thanks
szogun3k
Posts: 14
Joined: Thu Apr 13, 2006 4:48 am

Post by szogun3k »

now i have a real problem when those script is run in cactid it produce many zombie proccesses but when it runs on cmd.php everything is fine, but here is a problem cmd.php is slow and collecting data for about 2000 graphs with this script takes about 15mins but it collect data and on cactid its just starts again new proccesses and makes theme zombie :/
on cactid i use max poller proccesses 3 max threads per proc 4 No of php script 2 script timeout 3sec max snmp requests 10
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please post your last problem as a seperate topic (with a link to this one). This may require TheWitness, the author of cactid. Please give your current cactid version (If possible, please try latest cactid from BRANCH SVN)
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests