Data Query problem with indexed script

[prune]

Hi,

I created a data query script and XML to get the number of listeners of an Icecast server per stream (mount).
The script is working fine with the index, query and get command line.
When adding the "data query" to a host (running it verbose) show me evey mounted stream, which is good.
Creating graphs also show me everything I need.

As no numerical index is given by the Icecast server, my index is the name of the mountpoint (something like : goa-1-44-96)

When the graph is created, If I check in the "data source", I got empty "custom data".
See the attached jpeg file for exemple.

It is like if some data were not registered from the index returned bu the script and the data-template/graph-template.

I tripple-checked with other scripts like unix_partition, and I have exactly the same config...

Where does this problem comes from ?
Thanks.

[gandalf]

Please have a read at http://docs.cacti.net/node/284
HTH
Reinhard

[prune]

Hi,

Thanks for the answer but this is exactly the instruction I followed to create my graphs.
The only difference is my index beeing text instead of numbers and of course my php script which is more complex, but return the same format when queried.

Maybe someone knows why and when this kind of error happen ?

Thanks !

[gandalf]

I was referring this very doc especially because it holds a step-by-step procedure, that should help on narrowing down the root cause of this failure.
ad 1) A string as an index is allowed and should not cause any problem
ad 2) The screenshot you've posted shows a clearly insane data source (as you already have noticed) It looks very much like index generation for this data query has failed. So please start at "Verbose Query" to track it down.
You may run

Code: Select all

SELECT * FROM `host_snmp_cache` ;

from mysql command line to investigate the index query results for that very data query
Reinhard

[prune]

Hi,

Thanks again for your answer. Reading it all over again after the weekend I found the error.
My fault !

Be careful when you write the XML file, the <index_order> have to be set to the filed name and not the query_name.

In my example :

<index_order>iceMount</index_order>

For a field like :
<fields>
<iceMount>
<name>Mount Point</name>
<direction>input</direction>
<query_name>mountpoint</query_name>
</iceMount>
...


I will release my script as soon as I have a pretty interface to set the login/password to the query script, as it is not using SNMP (so I can't use things like |host_snmp_username| and stuffs like that).

Thanks again for your help man!