0.8.8c - Data query does not return output
Moderators: Developers, Moderators
0.8.8c - Data query does not return output
Dear all,
I'm trying to migrate my custom data query template from my old server to new server.
But somehow the data query does not return any output when run in new server. It is working fine in old server. FYI. Following are versions of the software that I'm using..
New Server
-OS : Windows Server 2012 Std R2
-Web server : IIS 8
-Cacti 0.8.8c
-Spine 0.8.8c
-MySQL 5.6.20.0
-PHP 5.6.3
-Net-SNMP 5.7.0
-RRDTool 1.4.5
Old Server
-OS : Windows Server 2003 Std R2
-Web server : IIS 6
-Cacti 0.8.7b
-Spine 0.8.7b
-MySQL 5.0.51a
-PHP 5.2.5
-Net-SNMP 5.4.1.3
-RRDTool 1.2.26
Any idea what can cause this ? Could it be there have syntax change on the php between version 5.6.3 and 5.2.5 ?
Any help would be much appreciated.
I'm trying to migrate my custom data query template from my old server to new server.
But somehow the data query does not return any output when run in new server. It is working fine in old server. FYI. Following are versions of the software that I'm using..
New Server
-OS : Windows Server 2012 Std R2
-Web server : IIS 8
-Cacti 0.8.8c
-Spine 0.8.8c
-MySQL 5.6.20.0
-PHP 5.6.3
-Net-SNMP 5.7.0
-RRDTool 1.4.5
Old Server
-OS : Windows Server 2003 Std R2
-Web server : IIS 6
-Cacti 0.8.7b
-Spine 0.8.7b
-MySQL 5.0.51a
-PHP 5.2.5
-Net-SNMP 5.4.1.3
-RRDTool 1.2.26
Any idea what can cause this ? Could it be there have syntax change on the php between version 5.6.3 and 5.2.5 ?
Any help would be much appreciated.
Last edited by normal on Fri May 15, 2015 12:00 pm, edited 5 times in total.
Re: 0.8.8c - Data query does not return output
Assuming that query example is targeting the same device...
1) rules/firewalls which prevent new server from connecting to device?
2) if you manually run that same php query from the PHP Script Server on the new server, does it work?
3) if yes to #2, then likely the web server doesnt have permissions to read/execute the script.
1) rules/firewalls which prevent new server from connecting to device?
2) if you manually run that same php query from the PHP Script Server on the new server, does it work?
3) if yes to #2, then likely the web server doesnt have permissions to read/execute the script.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Re: 0.8.8c - Data query does not return output
Hi BSOD2600,
Thanks for your reply.
Following is output of the php script
Seems extension for ssh2 function is not installed in my new server with php 5.6.3. I'm still searching around for how to get the php extension install in my new server.
Thanks for your reply.
Following is output of the php script
Seems extension for ssh2 function is not installed in my new server with php 5.6.3. I'm still searching around for how to get the php extension install in my new server.
Last edited by normal on Fri May 15, 2015 11:50 am, edited 1 time in total.
Re: 0.8.8c - Data query does not return output
Update :
I managed to resolve the ssh2 function issue by install phpseclib as suggestion in this thread : http://stackoverflow.com/questions/2481 ... also-enabl
However, I hit another issue when created graph with the related template...
somehow, no data show in the graph.. Found Cacti log start showing following warnings after I created the graph.. But I try run snmp query from the Cacti server to the client host, it looks ok... But there have one thing that I think is abnormal. Somehow, the php query from the PHP Script Server doesn't return any output but if query not through the PHP Script Server, it able to return the output.. In my old server, both type of query are able to return output.
Not sure what is the root cause actually ??
Would appreciate if you can enlighten me..
I managed to resolve the ssh2 function issue by install phpseclib as suggestion in this thread : http://stackoverflow.com/questions/2481 ... also-enabl
However, I hit another issue when created graph with the related template...
somehow, no data show in the graph.. Found Cacti log start showing following warnings after I created the graph.. But I try run snmp query from the Cacti server to the client host, it looks ok... But there have one thing that I think is abnormal. Somehow, the php query from the PHP Script Server doesn't return any output but if query not through the PHP Script Server, it able to return the output.. In my old server, both type of query are able to return output.
Not sure what is the root cause actually ??
Would appreciate if you can enlighten me..
Last edited by normal on Fri May 15, 2015 8:06 pm, edited 1 time in total.
Re: 0.8.8c - Data query does not return output
If you snmpwalk that specific OID which times out, does it also fail? If cacti thinks a device is down, it wont run any scripts against it.normal wrote:Found Cacti log start showing following warnings after I created the graph..
Try using the full path to the scriptnormal wrote:But there have one thing that I think is abnormal. Somehow, the php query from the PHP Script Server doesn't return any output
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Re: 0.8.8c - Data query does not return output
Hi BSOD2600,
Here is the outcome
snmpwalk out for OID .1.3.6.1.2.1.1.3.0 php query from the PHP Script Server with full path to the script Note:
a) To install phpseclib, I created 'c:\php\includes' folder manually and uncommented "include_path='.;c:\php\includes" in c:\php\php.ini
b) I included output of php query that not through PHP Script Server for comparison.
For the permission denied errror, I tried grant full permission to everyone for following folders and restart the Cacti server, but didn't help.
C:\inetpub\wwwroot\cacti\scripts
C:\php\includes
Here is the outcome
snmpwalk out for OID .1.3.6.1.2.1.1.3.0 php query from the PHP Script Server with full path to the script Note:
a) To install phpseclib, I created 'c:\php\includes' folder manually and uncommented "include_path='.;c:\php\includes" in c:\php\php.ini
b) I included output of php query that not through PHP Script Server for comparison.
For the permission denied errror, I tried grant full permission to everyone for following folders and restart the Cacti server, but didn't help.
C:\inetpub\wwwroot\cacti\scripts
C:\php\includes
Re: 0.8.8c - Data query does not return output
ah-ha, permission denied errors finally!
What about trying to grant IUSR and IIS_USRS read/execute rights to that folder referenced?
another option is to use sysinternal process monitor and examine exactly what/where the denied error is occurring. Link in my signature for a walkthrough.
What about trying to grant IUSR and IIS_USRS read/execute rights to that folder referenced?
another option is to use sysinternal process monitor and examine exactly what/where the denied error is occurring. Link in my signature for a walkthrough.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Re: 0.8.8c - Data query does not return output
Hi BSOD2600,
Thanks for your suggestion.
I tried both of the options you suggested. But still no luck
The sysinternal process monitor can't find any denied error
Thanks for your suggestion.
I tried both of the options you suggested. But still no luck
The sysinternal process monitor can't find any denied error
Re: 0.8.8c - Data query does not return output
Sorry, BSOD2600. My bad, I misled you in my previous post.
It should be nothing wrong with the folder or file permission.
The reason why I got the 'Permission Denied' error is because there have an extra 'scripts' wording in the query -_-" After take out the 'scripts' from the query, no more permission denied error. However, the no result return issue still persist
It should be nothing wrong with the folder or file permission.
The reason why I got the 'Permission Denied' error is because there have an extra 'scripts' wording in the query -_-" After take out the 'scripts' from the query, no more permission denied error. However, the no result return issue still persist
Re: 0.8.8c - Data query does not return output
I try to compare the output of verbose query for both of my old and new server.
Found following differences
Difference# 1 - quantity of running data query
Old server New server Difference# 2 - More Found data query XML file in old server
Old server New server and attached are the verbose query output for both of the old and new server in details. Not sure if something to do with the xml file configuration ? There have format change for the xml file in old and new Cacti ?
Any help would be much appreciated.
Found following differences
Difference# 1 - quantity of running data query
Old server New server Difference# 2 - More Found data query XML file in old server
Old server New server and attached are the verbose query output for both of the old and new server in details. Not sure if something to do with the xml file configuration ? There have format change for the xml file in old and new Cacti ?
Any help would be much appreciated.
Re: 0.8.8c - Data query does not return output
The script files are compatible between the old and new version of Cacti, nothing really has changed in that regard.
Are the php.ini configs the same between the severs? A tool like WinMerge to easily compare is ideal.
If php settings are the same, I think it's time to debug the ss_seagatedqlinuxhit.php script. Did you write it or find it on the forum? If the latter, I'd ask for assistance on troubleshooting in the thread you got it. If the former, you've got some work to do...
Are the php.ini configs the same between the severs? A tool like WinMerge to easily compare is ideal.
If php settings are the same, I think it's time to debug the ss_seagatedqlinuxhit.php script. Did you write it or find it on the forum? If the latter, I'd ask for assistance on troubleshooting in the thread you got it. If the former, you've got some work to do...
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Who is online
Users browsing this forum: No registered users and 3 guests