problem with verbose query

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
itobald
Posts: 13
Joined: Sun Oct 11, 2009 5:49 am

problem with verbose query

Post by itobald »

Hi guys,

I wrote a script XML for F5 LTM rate filters. It works but i have a problem with the verbose query. When I try to see it, i got this:

Code: Select all

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 203

Notice: Undefined index: oid in /usr/share/cacti/lib/data_query.php on line 234

Notice: Undefined index: oid in /usr/share/cacti/lib/data_query.php on line 239

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 241

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 268

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 292

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/cacti/lib/data_query.php:203) in /usr/share/cacti/host.php on line 77
Do you have any ideas?

Thanks.

Ito.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Pleae provide your script to help debugging. And note the cacti version in question
R.
itobald
Posts: 13
Joined: Sun Oct 11, 2009 5:49 am

Post by itobald »

I use cacti 8.7e with cmd.php.
Attachments
F5statsratefilters.xml
(3.85 KiB) Downloaded 111 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

A guess:
<oid_index>.1.3.6.1.4.1.3375.2.2.7.1.2.1</oid_index>
<oid_index_parse>OID/REGEXP:^.*.3375.2.2.7.1.2.1.(.*)$</oid_index_parse>
Counting the OID elements may fail. Sometimes OIDs start with ".", sometimes they don't, resulting in an index being off by 1.
R.
itobald
Posts: 13
Joined: Sun Oct 11, 2009 5:49 am

Post by itobald »

I tried it but i always have the same problem. And it seems that the index doesn't match like before.

I link two screenshots to show you these problems. I test your solution on the data querie "test", it is a copy of F5statsratefilters.
Attachments
verbosequeryproblem02.jpg
verbosequeryproblem02.jpg (91.63 KiB) Viewed 2147 times
verbosequeryproblem01.jpg
verbosequeryproblem01.jpg (47.39 KiB) Viewed 2147 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please provide both output from Verbose Query and a related snmpwalk of the table
R.
itobald
Posts: 13
Joined: Sun Oct 11, 2009 5:49 am

Post by itobald »

verbose query output:

Code: Select all

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 203

Notice: Undefined index: oid in /usr/share/cacti/lib/data_query.php on line 234

Notice: Undefined index: oid in /usr/share/cacti/lib/data_query.php on line 239

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 241

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 268

Notice: Undefined index: source in /usr/share/cacti/lib/data_query.php on line 292

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/cacti/lib/data_query.php:203) in /usr/share/cacti/host.php on line 77
snmpwalk output:

Code: Select all

SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.1.11.116.101.115.116.95.103.111.111.103.108.101 = STRING: "test_google"
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.1.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = STRING: "shape_client1"
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.1.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = STRING: "shape_client2"
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.1.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = STRING: "test_debian_ftp"
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.2.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 775396
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.2.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 937654912
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.2.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 157428670
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.2.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 188841844
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.3.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 216488
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.3.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 686353888
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.3.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 97884046
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.3.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 16745717
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.4.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.4.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.4.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.4.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.5.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.5.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 355
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.5.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.5.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.6.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.6.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 7865
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.6.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 5276
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.6.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 23899
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.7.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.7.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 11779511
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.7.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 7526689
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.7.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 33936580
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.8.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.8.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.8.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.8.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.9.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.9.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.9.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.9.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.10.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.10.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 7865
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.10.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 5276
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.10.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 23899
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.11.11.116.101.115.116.95.103.111.111.103.108.101 = Counter64: 0
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.11.13.115.104.97.112.101.95.99.108.105.101.110.116.49 = Counter64: 11779511
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.11.13.115.104.97.112.101.95.99.108.105.101.110.116.50 = Counter64: 7526689
SNMPv2-SMI::enterprises.3375.2.2.7.2.3.1.11.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112 = Counter64: 33936580
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Thatnks. Please use the snmpcmd option -n to suppress the mnemonics. Then, please count the length of the OID used. There has been an issue with very long OIDs that may apply here.
R.
itobald
Posts: 13
Joined: Sun Oct 11, 2009 5:49 am

Post by itobald »

I didn't find that issue on the forum. Have you a link ?
I count the length, the max size is 91 characters.

Code: Select all

.1.3.6.1.4.1.3375.2.2.7.2.3.1.11.15.116.101.115.116.95.100.101.98.105.97.110.95.102.116.112
itobald
Posts: 13
Joined: Sun Oct 11, 2009 5:49 am

Post by itobald »

ok, i solved my problem. I just add source and oid in Index

Code: Select all

                <ifIndex>
                        <name>Index</name>
                        <method>walk</method>
                        <source>OID/REGEXP:^.{31}(.*)$</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.3375.2.2.7.1.2.1</oid>
                </ifIndex>
The verbose query works fine but is there a solution to not see index in the table to create graph
Attachments
verbosequeryproblem03.jpg
verbosequeryproblem03.jpg (52.53 KiB) Viewed 2043 times
itobald
Posts: 13
Joined: Sun Oct 11, 2009 5:49 am

Post by itobald »

Ok just need to remove the fields ifIndex.

thanks for your help.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests