Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jun 22, 2017 5:08 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 20 posts ]  Go to page Previous  1, 2
Author Message
 Post subject: Re: Indexed query issue
PostPosted: Thu Oct 06, 2011 1:19 am 
Offline
Cacti Guru User

Joined: Thu Aug 05, 2010 2:04 am
Posts: 1573
Location: Japan
GLR wrote:
This way, it seems to work !
I will confirm later and provide screenshots, but it seems to be a success. Thanks so much !!!

Wow, cheers! :)

GLR wrote:
Do you want to test again one of the previous syntax for <fwIfStatsIndex> ?

Using this?
Code:
        <fwIfStatsIndex>
            <name>Index</name>
            <source>index</source>
            <direction>input</direction>
        </fwIfStatsIndex>

If you would kindly do that, I'd be happy..


Top
 Profile  
 
 Post subject: Re: Indexed query issue
PostPosted: Thu Oct 06, 2011 3:34 am 
Offline
Cacti User
User avatar

Joined: Mon Jul 21, 2008 5:45 am
Posts: 55
Location: Paris suburbs, France
So, yes, this way, it works too :

Code:
<interface>
    <name>StoneSoft fwIfTable</name>
    <description>StoneGate firewall interface table stats</description>
    <oid_index>.1.3.6.1.4.1.1369.5.2.1.10.1.2</oid_index>
    <oid_index_parse>OID/REGEXP:.*\.([0-9]*)$</oid_index_parse>
    <index_order>fwIfStatsIndex</index_order>
    <index_order_type>numeric</index_order_type>
    <fields>
        <fwIfStatsIndex>
            <name>Index</name>
            <source>index</source>
            <direction>input</direction>
        </fwIfStatsIndex>

Code:
+ Running data query [44].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.1369.5.2.1.10.1.2'
+ Index found at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.1' value: 'eth0_0'
+ Index found at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.2' value: 'eth0_1'
+ Index found at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.3' value: 'eth0_2'
+ Index found at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.4' value: 'eth0_3'
+ Index found at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.5' value: 'eth0_4'
+ Index found at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.6' value: ''
+ index_parse at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.1' results: '1'
+ index_parse at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.2' results: '2'
+ index_parse at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.3' results: '3'
+ index_parse at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.4' results: '4'
+ index_parse at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.5' results: '5'
+ index_parse at OID: '1.3.6.1.4.1.1369.5.2.1.10.1.2.6' results: '6'
+ Inserting index data for field 'fwIfStatsIndex' [value='1']
+ Inserting index data for field 'fwIfStatsIndex' [value='2']
+ Inserting index data for field 'fwIfStatsIndex' [value='3']
+ Inserting index data for field 'fwIfStatsIndex' [value='4']
+ Inserting index data for field 'fwIfStatsIndex' [value='5']
+ Inserting index data for field 'fwIfStatsIndex' [value='6']
+ Located input field 'fwIfName' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.1369.5.2.1.10.1.2'
+ Found item [fwIfName='eth0_0'] index: 1 [from value]
+ Found item [fwIfName='eth0_1'] index: 2 [from value]
+ Found item [fwIfName='eth0_2'] index: 3 [from value]
+ Found item [fwIfName='eth0_3'] index: 4 [from value]
+ Found item [fwIfName='eth0_4'] index: 5 [from value]
+ Found item [fwIfName=''] index: 6 [from value]
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/StoneSoft_fwIfTable.xml'

Here is the resulting datasource :

Image

And finally the so longingly awaited graph :

Image

Thanks again.

I will update the host template and release it.

_________________
Cacti 0.8.8b + spine 0.8.8b
on Debian / Apache 2.2 / PHP 5.2 / MySQL 5.0


Top
 Profile  
 
 Post subject: Re: Indexed query issue
PostPosted: Thu Oct 06, 2011 3:42 am 
Offline
Cacti Guru User

Joined: Thu Aug 05, 2010 2:04 am
Posts: 1573
Location: Japan
GLR wrote:
So, yes, this way, it works too :

Code:
<interface>
    <name>StoneSoft fwIfTable</name>
    <description>StoneGate firewall interface table stats</description>
    <oid_index>.1.3.6.1.4.1.1369.5.2.1.10.1.2</oid_index>
    <oid_index_parse>OID/REGEXP:.*\.([0-9]*)$</oid_index_parse>
    <index_order>fwIfStatsIndex</index_order>
    <index_order_type>numeric</index_order_type>
    <fields>
        <fwIfStatsIndex>
            <name>Index</name>
            <source>index</source>
            <direction>input</direction>
        </fwIfStatsIndex>

Wow thanks, I'm very glad to hear that..
What a relief! :)


Top
 Profile  
 
 Post subject: Re: [Solved] Indexed query issue / StoneGate 5.3 template
PostPosted: Thu Oct 06, 2011 3:53 am 
Offline
Cacti User
User avatar

Joined: Mon Jul 21, 2008 5:45 am
Posts: 55
Location: Paris suburbs, France
The last version of this template can be found here : http://blog.glrnet.fr/index.php?2011/10/06/66-stonegate-53-cacti-host-template.

Image
Image
Image
Image
Image
Image
Image
Image
Image
Image

_________________
Cacti 0.8.8b + spine 0.8.8b
on Debian / Apache 2.2 / PHP 5.2 / MySQL 5.0


Top
 Profile  
 
 Post subject: Re: [Solved] Indexed query issue / StoneGate 5.3 template
PostPosted: Sat Jun 15, 2013 8:47 am 
Offline

Joined: Sun Jan 08, 2012 4:45 am
Posts: 14
i face almost the same problem several days agao.
i resolved it in a different way.
i found the "sort_field" in table "host_snmp_query" is empty for that query.
i manual modify it and resoved.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 20 posts ]  Go to page Previous  1, 2

All times are UTC - 5 hours


Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 9 guests


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 post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group