Re: data query XML file

Azher Mughal gave me the pointer to get the latest version of "spine".

Downloaded, compiled and installed spine.

This is the output of the spine execution:

-sh-3.2$ ./spine -S -R --first=1  --last=4 
--conf=/usr/local/spine/etc/spine.conf
SPINE: Using spine config file [/usr/local/spine/etc/spine.conf]
08/12/2013 04:19:24 PM - SPINE: Poller[0] DEBUG: The path_php_server 
variable is /local/usr-local/cacti/script_server.php
08/12/2013 04:19:24 PM - SPINE: Poller[0] DEBUG: The path_cactilog 
variable is /local/usr-local/cacti/log/cacti.log
DEBUG: The log_destination variable is 4 (STDOUT)
DEBUG: The path_php variable is /usr/bin/php
DEBUG: The availability_method variable is 0
DEBUG: The ping_recovery_count variable is 0
DEBUG: The ping_failure_count variable is 0
DEBUG: The ping_method variable is 0
DEBUG: The ping_retries variable is 0
DEBUG: The ping_timeout variable is 0
DEBUG: The snmp_retries variable is 3
DEBUG: The log_perror variable is 1
DEBUG: The log_pwarn variable is 1
DEBUG: The boost_redirect variable is 0
DEBUG: The log_pstats variable is 1
DEBUG: The threads variable is 5
DEBUG: The polling interval is the system default
DEBUG: The number of concurrent processes is 1
DEBUG: The script timeout is 25
DEBUG: The number of php script servers to run is 2
DEBUG: StartHost='1', EndHost='4', TotalPHPScripts='0
DEBUG: The PHP Script Server is Not Required
DEBUG: The Maximum SNMP OID Get Size is 25
Version 0.8.8b starting
DEBUG: MySQL is Thread Safe!
WARNING: Spine NOT running asroot.  This is required if using ICMP.  
Please run "chmod +s;chown root:root spine" to resolve.
SPINE: Initializing Net-SNMP API
DEBUG: Issues with SNMP Header Version information, assuming old version 
of Net-SNMP.
SPINE: Initializing PHP Script Server(s)
NOTE: Spine will support multithread device polling.
NOTE: Spine is behaving in a 0.8.7g+ manner
DEBUG: Initial Value of Active Threads is 0
DEBUG: Valid Thread to be Created
DEBUG: In Poller, About to Start Polling of Host
DEBUG: The Value of Active Threads is 1
DEBUG: Valid Thread to be Created
DEBUG: In Poller, About to Start Polling of Host
DEBUG: The Value of Active Threads is 2
DEBUG: Valid Thread to be Created
DEBUG: In Poller, About to Start Polling of Host
Host[0] TH[1] Total Time: 0.0036 Seconds
Host[0] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread 
Function
DEBUG: The Value of Active Threads is 3
DEBUG: Valid Thread to be Created
DEBUG: In Poller, About to Start Polling of Host
Host[1] DEBUG: Entering SNMP Ping
DEBUG: The Value of Active Threads is 4
Host[1] SNMP Result: Host responded to SNMP
DEBUG: The Value of Active Threads is 3
Host[1] TH[1] Host has no information for recache.
Host[2] DEBUG: Entering SNMP Ping
Host[1] TH[1] NOTE: There are '6' Polling Items for this Host
Host[3] DEBUG: Entering SNMP Ping
Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
Host[1] TH[1] DS[3] SCRIPT: perl 
/local/usr-local/cacti/scripts/linux_memory.pl MemFree:, output: 105608
Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
Host[1] TH[1] DS[4] SCRIPT: perl 
/local/usr-local/cacti/scripts/linux_memory.pl SwapFree:, output: 2096336
Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
Host[1] TH[1] DS[5] SCRIPT: perl 
/local/usr-local/cacti/scripts/loadavg_multi.pl, output: 1min:0.97 
5min:0.96 10min:0.93
Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
Host[1] TH[1] DS[6] SCRIPT: perl 
/local/usr-local/cacti/scripts/unix_users.pl , output: 11
Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
Host[1] TH[1] DS[7] SCRIPT: perl 
/local/usr-local/cacti/scripts/unix_processes.pl, output: 133
Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 10
Host[1] TH[1] DS[8] SCRIPT: perl 
/local/usr-local/cacti/scripts/loadavg_multi.pl, output: 1min:0.97 
5min:0.96 10min:0.93
Host[1] TH[1] Total Time:   0.1 Seconds
Host[1] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread 
Function
DEBUG: The Value of Active Threads is 2
Host[2] SNMP Result: Host responded to SNMP
Host[2] TH[1] RECACHE: Processing 3 items in the auto reindex cache for 
'weather-a.cacr.caltech.edu
Host[2] TH[1] Recache DataQuery[10] OID: .1.3.6.1.2.1.1.3.0, output: 
53108977
Host[2] TH[1] Recache DataQuery[11] OID: .1.3.6.1.2.1.1.3.0, output: 
53108977
Host[2] TH[1] Recache DataQuery[12] OID: .1.3.6.1.2.1.1.3.0, output: 
53108977
Host[2] TH[1] Total Time:  0.21 Seconds
Host[2] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread 
Function
DEBUG: The Value of Active Threads is 1
Host[3] SNMP Ping Error: Unknown error: 2
Host[3] SNMP Result: Host did not respond to SNMP
Host[3] TH[1] Total Time:     2 Seconds
Host[3] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread 
Function
DEBUG: The Value of Active Threads is 0
DEBUG: Thread Cleanup Complete
DEBUG: PHP Script Server Pipes Closed
DEBUG: Allocated Variable Memory Freed
DEBUG: MYSQL Free & Close Completed
DEBUG: Net-SNMP Close Completed
Time: 2.1110 s, Threads: 5, Hosts: 4


Looks like 'weather-a.cacr.caltech.edu' (host 2) is responding to SNMP.  
Please ignore host 3
for now.

What is the next step to get the device 'weather-a' to be included in 
the poller cache?

Thanks.

Steven.


On 08/12/2013 02:30 PM, Steven Lo wrote:
>
> Hi Reinhard,
>
> Where can I locate "spine" so that I can run it in verbose mode?
> Does it come with Cacti installation or I have to download and
> then compile?
>
> FYI.  We are running RHEL 5.8 in i386.
>
>
> Thanks.
>
> Steven.
>
>
> On 08/09/2013 08:02 AM, Gandalf wrote:
>> Unfortunately, the tests differ to a specific extend:
>>
>> When accessing a device from the web-interface, the web server is 
>> using specific
>> code to test SNMP accessability.
>> Wheras spine has it's own code to perform the test.
>> There are certain conditions, where specific devices react 
>> differently to those
>> tests. Mainly, following reasons are known
>>
>> - some devices don't like snmpwalks, they work when using snmpget. 
>> This can be
>> handled to a specific extend by changing the XML file accordingly
>> - some devices don't like snmpbulkwalk either, but e.g. php performs 
>> this in the
>> background, even when not asking for that. Setting the MAX OID 
>> parameter for the
>> device unfortunately affects spine behavior only. For the rest, using 
>> SNMPV1
>> _forces_ php not to use snmpbulkwalks
>> - some devices act "specifically", when switching between SNMP V1 and 
>> SNMP V2c.
>> Usually, the higher version is performing better - but under some 
>> circumstances
>> you will only get data for SNMP V1
>>
>> You will get moreinformation when running spine in verbose mode for 
>> the device
>> in question, e.g.
>> spine --verbosity=5 <id> <id>
>> where <id> is the device id of the device in Cacti
>> Reinhard
>>
>> On 09.08.2013 06:29, Steven Lo wrote:
>>> Hi,
>>>
>>> I manage to modify one of the XML file (WxGoose-ext-temperature.xml) by
>>> editing the
>>> OID fields, copy it to /usr/local/cacti/resource/snmp_queries and 
>>> name it
>>> weather_goose_temperature_sensor.xml.  After that, Data Queries does 
>>> not
>>> complain
>>> since it's able to locate the XML file.
>>>
>>> I then run "Verbose Query" and seems like it's able to find the value
>>> with snmpwalk.
>>>
>>> Next, I create new graph for this host and seems like that is 
>>> working as
>>> well:
>>>
>>> -sh-3.2$ php -q add_perms.php --list-graphs --host-id=2
>>> Known Host Graphs: (id, name, template)
>>> 10    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 11    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 12    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 13    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 14    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 15    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 16    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 17    MiniGoose II - A - |query_temperatureSensorName| ITWatchdogs -
>>> Temperature Sensor
>>> 18    MiniGoose II - A - |query_AirFlowSensorName| ITWatchdogs -
>>> AirFlow Sensor
>>>
>>>
>>> Now, the problem I'm running into is that the device status is 
>>> "unknown"
>>> and the device never
>>> make it to the poller cache.  I did rebuild_poller_cache.php and
>>> poller_reindex_hosts.php but
>>> problem persist.
>>>
>>> What cause the device in "unknown" stage and how do we make it poll the
>>> device??
>>>
>>>
>>> When I do Console -> Device -> MiniGoose II - A, it's able to get the
>>> system information (System Name,
>>> Uptime, Hostname, etc) without any problem.  I did see the SNMP traffic
>>> when I probe the network
>>> interface.  So I guess it's not SNMP problem.
>>>
>>>
>>> Thanks in advance for your help.
>>>
>>>
>>> Steven.
>>>
>>>
>>> On 08/07/2013 11:46 PM, David RIBEIRO wrote:
>>>> Hello Steven,
>>>>
>>>> The contributor forget to put in the tar.gz the 3 XML.
>>>> The file in your zip file only import into cacti information about the
>>>> graph, where and how get values.
>>>>
>>>> Sorry for you but your only solution is to build the 3 XML or found 
>>>> the
>>>> coder ;)
>>>>
>>>> David
>>>>
>>>>
>>>> 2013/8/8 Steven Lo<[email protected]>
>>>>
>>>>> Hi Paul,
>>>>>
>>>>> On 08/07/2013 10:21 PM, Paul Gevers wrote:
>>>>>> Hi Steven,
>>>>>>
>>>>>> I have no experience with templates such as the one you are 
>>>>>> describing,
>>>>>> but...
>>>>>>
>>>>>>> /usr/local/cacti/resource/snmp_queries/ :
>>>>>> Are you running Debian? This location does not seem like a 
>>>>>> regular cacti
>>>>>> location, but indeed in Debian that would be the location that
>>>>>> could/would be proposed.
>>>>> We're running RHEL 5.  The RPM install Cacti in /var/www/cacti but 
>>>>> we move
>>>>> it to /usr/local/cacti since the partition has more disk space.
>>>>>
>>>>>>> Data Template
>>>>>>> [success] ITWatchdogs - Builtin [new]
>>>>>>> [success] ITWatchdogs - airFlowSensor [new]
>>>>>>> [success] ITWatchdogs - TemperatureSensor [new]
>>>>>> It looks like they were successfully created, but the question is,
>>>>>> where? Or maybe it reported success when it failed...
>>>>> Cacti does show all the templates except the XML files.  I did not
>>>>> notice any
>>>>> error message in the log file.
>>>>>
>>>>>> Can you please post the URL of where you found this contributed
>>>>>> template, and I will try this at home.
>>>>> I use wget to download the template:
>>>>>
>>>>> wget
>>>>>
>>>>> http://docs.cacti.net/_media/usertemplate:host:itwatchdogs:cacti_host_template_itwatchdogs_-_goose_series.xml.gz 
>>>>>
>>>>>
>>>>>
>>>>> Thanks for testing the template.
>>>>>
>>>>>
>>>>> Steven.
>>>>>
>>>>>> Paul
>> ------------------------------------------------------------------------------ 
>>
>> Get 100% visibility into Java/.NET code with AppDynamics Lite!
>> It's a free troubleshooting tool designed for production.
>> Get down to code-level detail for bottlenecks, with <2% overhead.
>> Download for free and get started troubleshooting in minutes.
>> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk 
>>
>> _______________________________________________
>> cacti-user mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/cacti-user
>>
>


------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk