Re: data query XML file

We see that the MiniGoose device status has changed from 'unknown' to 
'up'.  However,
we still not able to generate graph for this device.  I'm not able to 
find any error in all
the logs that were searched.

What really trigger the device to be inserted to the poller cache and 
then generate the graph?

Please provide hints on where to look for solutions.

Should we just remove the device and re-create it again?

Thanks.

Steven.


On 08/12/2013 04:29 PM, Steven Lo wrote:
> 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
> _______________________________________________
> 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