Result from Server not valid error on a script server data

[aude]

I am creating a template with cacti but I have the following error during the polling:
CMDPHP: Poller[0] Host[62] DS[3569] SERVER: / the var/www /cacti / scripts / ss_vc_cpu.php ss_vc_cpu Common 62 1::[ None ] get usage 1, output: U
CMDPHP: Poller[0] Host[62] DS[3569] WARNING: Result from SERVER not valid. Partial Result:

Here are the stages of the construction of my template:
-- I use one data query which has data input method= get script server data (Indexed). My xml file looks like this :
<interface>
<name>Get VMware ESX virtual machine CPU's</name>
<script_path>|path_cacti|/scripts/ss_vc_cpu.php</script_path>
<script_function>ss_vc_cpu</script_function>
<script_server>php</script_server>
<arg_prepend>|host_hostname| |host_id| |host_snmp_version|:|host_snmp_port|:|host_snmp_timeout|:|host_snmp_community|:|host_snmp_username|:|host_snmp_password|:MD5::[None]</arg_prepend>
<arg_index>index</arg_index>
<arg_query>query</arg_query>
<arg_get>get</arg_get>
<output_delimeter>!</output_delimeter>
<index_order>vmDisplayName:vmID:vmIndex</index_order>
<index_order_type>numeric</index_order_type>
<index_title_format>|chosen_order_field|</index_title_format>

<fields>
<vmIndex>
<name>Index</name>
<direction>input</direction>
<query_name>index</query_name>
</vmIndex>
<vmDisplayName>
<name>Name</name>
<direction>input</direction>
<query_name>displayname</query_name>
</vmDisplayName>
<vmID>
<name>VM ID</name>
<direction>input</direction>
<query_name>vmid</query_name>
</vmID>
<vmGuestState>
<name>Guest OS status</name>
<direction>input</direction>
<query_name>gueststate</query_name>
</vmGuestState>
<vmState>
<name>VM status</name>
<direction>input</direction>
<query_name>vmstate</query_name>
</vmState>
<cpuUtil>
<name>Processor Usage</name>
<direction>output</direction>
<query_name>usage</query_name>
</cpuUtil>
</fields>
</interface>

-- I have created a data template with data input method = get script server dated ( Indexed)
-- The Data Input Method has input type= Script query-script server
-- I also have created a graph template connected with the previous data template and a host template connected with the previous data query.

I have finally create a device "Common" connected with the data query and with the host template! Host_id = 62.
When I click on the device I indeed have all my data and the xml file works correctly:
+ Running data query [22].
+ Found type = '6 '[script query].
+ Found data query XML file at '/var/www/cacti/resource/script_server/vmware_cpu2.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /var/www/cacti/scripts/ss_vc_cpu.php Commun 62 1:161:500:public:::MD5::[None] index'
+ Executing script query '/usr/bin/php -q /var/www/cacti/scripts/ss_vc_cpu.php Commun 62 1:161:500:public:::MD5::[None] query index'
+ Found item [vmIndex='19'] index: 19
+ Found item [vmIndex='35'] index: 35
+ Found item [vmIndex='28'] index: 28
+ Found item [vmIndex='14'] index: 14
+ Executing script query '/usr/bin/php -q /var/www/cacti/scripts/ss_vc_cpu.php Commun 62 1:161:500:public:::MD5::[None] query displayname'
+ Found item [vmDisplayName='C2C-Rebond'] index: 19
+ Found item [vmDisplayName='TOU-Rebond'] index: 35
+ Found item [vmDisplayName='AnalyseOB-Rebond'] index: 28
+ Found item [vmDisplayName='SOA Rebond'] index: 14
+ Executing script query '/usr/bin/php -q /var/www/cacti/scripts/ss_vc_cpu.php Commun 62 1:161:500:public:::MD5::[None] query vmid'
+ Found item [vmID='vm-103793'] index: 19
+ Found item [vmID='vm-103795'] index: 35
+ Found item [vmID='vm-114198'] index: 28
+ Found item [vmID='vm-116473'] index: 14
... ect

But when I create a graph, I see the graph but it is empty!!
I have tried to execute my script in command line(shell):
php <path_cacti>/script_serveur.php
> /var/www/cacti/scripts/ss_vc_cpu.php ss_vc_cpu Commun 62 1:161:500:public:::MD5::[None] get usage 2
I obtain the good result.
In the same way, I have executed it with cmd.php and I have the good result.

Did I make an error? Could someone help me to resolve this issue?
Thanks

[aude]

J'ai trouvé mon erreur! Dans mon script ss_vc_cpu.php j'utilise des sous programmes et cela provoque une erreur de syntaxe sous cacti! En effet, il faut nommer tous les sous programmes avec en préfixe le nom de la fonction (ici ss_vc_cpu_...).

[gurulee]

I am getting the following from data query: VMware ESX - Get VM CPU usage, and the graphs are empty;

Code: Select all

+ Running data query [8].
+ Found type = '6' [Script Query - Script Server].
+ Found data query XML file at '/var/www/html/resource/script_server/vmware_cpu.xml'
+ XML file parsed ok.
+ Invalid field <index_order>vmDisplayName:vmID:vmIndex</index_order>
+ Must contain <direction>input</direction> fields only

Is there anyone in this quiet community that can be of help?

[victimist]

I am getting the following from data query: VMware ESX - Get VM CPU usage, and the graphs are empty;

Code: Select all

+ Running data query [8].
+ Found type = '6' [Script Query - Script Server].
+ Found data query XML file at '/var/www/html/resource/script_server/vmware_cpu.xml'
+ XML file parsed ok.
+ Invalid field <index_order>vmDisplayName:vmID:vmIndex</index_order>
+ Must contain <direction>input</direction> fields only

Is there anyone in this quiet community that can be of help?

Hi Gurulee

Just started lookin into getting Cacti to graph our ESX's and Im having the same issue ... Have you found any solutions yet? Im running ESX 5 and all the queries have invalid fields when i run verbose query. ** CRY **

Cheers V

[gurulee]

I am getting the following from data query: VMware ESX - Get VM CPU usage, and the graphs are empty;

Code: Select all

+ Running data query [8].
+ Found type = '6' [Script Query - Script Server].
+ Found data query XML file at '/var/www/html/resource/script_server/vmware_cpu.xml'
+ XML file parsed ok.
+ Invalid field <index_order>vmDisplayName:vmID:vmIndex</index_order>
+ Must contain <direction>input</direction> fields only

Is there anyone in this quiet community that can be of help?

Hi Gurulee

Just started lookin into getting Cacti to graph our ESX's and Im having the same issue ... Have you found any solutions yet? Im running ESX 5 and all the queries have invalid fields when i run verbose query. ** CRY **

Cheers V

Good to see an active community member! Right now I am only graphing upTime, Storage and Bandwidth. I have not been able to find a fix for the VMware templates yet...

How is your Syslog working, I cannot seem to get mine to log/show anything other than the localhost messages?... I have several posts about this...

[victimist]

Not got as far as looking at Syslog yet ... But when i get there, ill let you know

Found something else with regards to Cacti Graphs from ESX ... http://forums.cacti.net/viewtopic.php?u ... 79&start=0 (kinda kept me busy all day and still not got a workign solution!)

[sriramdas]

Hi All,

I was able to get the cpu stats and everything from ESXI host. wasnt able to get the VM level insight but was able to get enough stats on the ESXI server.