Unable to associate XML fields to Data Query graph template

[flooreus]

Hi,

I am trying to implement a new Data Query, which I have done successfully for some data I am pulling from an Oracle database. I have created the XML file, configured a new Data Query, Data Source Template, Graph Template and then associated the Graph Template with the Data Query, but when associating the XML fields to the inputs, I get a blank dropdown. By this I mean the dropdown doesn't even drop down, not just that it's got no values.

See the attached screenshot, and below is my XML file:

Code: Select all

<interface>
        <name>Oracle Tablespace Usage</name>
        <description>Fetches a list of monitorable tablespaces from /tmp/cacti/tbs_usage.lst</description>
        <script_path>/bin/bash |path_cacti|/scripts/query_oracle.sh</script_path>
        <arg_prepend>|host_hostname| TBS</arg_prepend>
        <arg_index>index</arg_index>
        <arg_query>query</arg_query>
        <arg_get>get</arg_get>
        <arg_num_indexes>num_indexes</arg_num_indexes>
        <output_delimeter>:</output_delimeter>
        <index_order>tbsName</index_order>
        <index_order_type>numeric</index_order_type>
        <index_title_format>|chosen_order_field|</index_title_format>

        <fields>
                <tbsName>
                        <name>Device Name</name>
                        <direction>input</direction>
                        <query_name>tbsname</query_name>
                </tbsName>

                <tbsMax>
                        <name>Max MB</name>
                        <direction>output</direction>
                        <query_name>max_mb</query_name>
                </tbsMax>
                <tbsTotal>
                        <name>Size MB</name>
                        <direction>output</direction>
                        <query_name>size_mb</query_name>
                </tbsTotal>
                <tbsUsed>
                        <name>Used MB</name>
                        <direction>output</direction>
                        <query_name>used_mb</query_name>
                </tbsUsed>
                <tbsFree>
                        <name>Free MB</name>
                        <direction>output</direction>
                        <query_name>free_mb</query_name>
                </tbsFree>
                <tbsUsedPct>
                        <name>Percent Used</name>
                        <direction>output</direction>
                        <query_name>pct_used</query_name>
                </tbsUsedPct>
                <tbsFreePct>
                        <name>Percent Free</name>
                        <direction>output</direction>
                        <query_name>pct_free</query_name>
                <tbsFreePct>
        </fields>
</interface>

Does anyone have any idea what the causes of this are? I have been pulling my hair out for hours trying to figure out what's going on. I've compared it to my working Data Query, but it is identical save for a couple of extra fields in the XML and different names.

Help!!

Cacti version is 1.2.10

[flooreus]

By way of an update, I have just upgraded to 1.2.12 but no dice. I removed the graph template from the data query and re-added it but that didn't work either.

I have also completely removed the data query, graph template, data template and started again, but I get the same result. The dropdowns don't populate.

[rancini1999]

Hi everyone,
I created these four charts for an external user.
The problem is that charts are not populated.
What is the solution? Do I need to do some additional configuration?
If yes, where and how?
Cacti version: 1.1.10

[flooreus]

Please don't hijack my thread, your request is not relevant to my issue.

Please start a new thread or search the forums. There is lots of information to be found on here regarding graphs not populating.