[Solved] Indexed query issue / Stonesoft 5.3 template

[noname]

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! :)

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

Using this?

Code: Select all

        <fwIfStatsIndex>
            <name>Index</name>
            <source>index</source>
            <direction>input</direction>
        </fwIfStatsIndex>

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

[GLR]

So, yes, this way, it works too :

Code: Select all

<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: Select all

+ 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 :



And finally the so longingly awaited graph :



Thanks again.

I will update the host template and release it.

[noname]

So, yes, this way, it works too :

Code: Select all

<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! :)

[GLR]

The last version of this template can be found here : http://blog.glrnet.fr/index.php?2011/10 ... t-template.

[wavysong]

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.