Blank Graphs for sql server template
Moderators: Developers, Moderators
Blank Graphs for sql server template
Hi,
Can somebody help me why my graphs are not showing any data fro sql server template.
I`m running Cacti on a Windows installation, i have performed the following:
Run the query on the SQL server being monitored
Imported the templates,
Copied the script to the scripts folder
Installed php extensions in c:\php\ext\
Added to device, created graphs but they are showing blank graphs.
Can somebody help me why my graphs are not showing any data fro sql server template.
I`m running Cacti on a Windows installation, i have performed the following:
Run the query on the SQL server being monitored
Imported the templates,
Copied the script to the scripts folder
Installed php extensions in c:\php\ext\
Added to device, created graphs but they are showing blank graphs.
Re: Blank Graphs for sql server template
followed the steps in http://forums.cacti.net/viewtopic.php?f=3&t=11747 ?
| 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: Blank Graphs for sql server template
ok...Installed windows through cacti installer.
Operating System:Windows 7
Webserver: Apache
Cacti:0.8.8
MySQL:5.5
PHP:5.3.17
RRDTool :1.4.7
Net-SNMP:5.5
i have configured few graphs of windows host which are working fine. Now i have imported the SQL template made the necessary changes as changing the user name and password and updating ss_win_mssql.php and uploading to ./scripts. Even made changes as mentioned in the forums , still no luck all are empty graphs.
Operating System:Windows 7
Webserver: Apache
Cacti:0.8.8
MySQL:5.5
PHP:5.3.17
RRDTool :1.4.7
Net-SNMP:5.5
i have configured few graphs of windows host which are working fine. Now i have imported the SQL template made the necessary changes as changing the user name and password and updating ss_win_mssql.php and uploading to ./scripts. Even made changes as mentioned in the forums , still no luck all are empty graphs.
- Attachments
-
- graph.JPG (97.64 KiB) Viewed 3473 times
-
- pic.JPG (11.48 KiB) Viewed 3473 times
-
- Data Input Method.JPG (75.97 KiB) Viewed 3473 times
-
- poller.JPG (139.22 KiB) Viewed 3473 times
Re: Blank Graphs for sql server template
did you follow the debugging guide (linked in the first post)?
what happens when you manually run those script server scripts as you show in the poller cache?
what happens when you manually run those script server scripts as you show in the poller cache?
| 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: Blank Graphs for sql server template
As i am totally new to cacti...can you please tell me where and how should i run these scripts.
Re: Blank Graphs for sql server template
Can somebody help...plz in resolving this issue.
Re: Blank Graphs for sql server template
start with reading http://docs.cacti.net/manual:088:3a_adv ... ipt_server
then take the script server command from the poller cache and manually try to run it. what error do you get?
then take the script server command from the poller cache and manually try to run it. what error do you get?
| 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: Blank Graphs for sql server template
All,
I have been having an issue with ss_win_mssql.php too. The graphs have generated but no data is being put into them. Clog says there was a partial result "U" when running, but when I run it manually it runs fine:
[root@cactiserv-1 cacti_0.8.8h]$ php /var/www/html/cacti_0.8.8h/scripts/ss_win_mssql.php 10.10.10.1:8721 connections CactiComm <password>
userconnections:5
I run it through script_server.php and get U as a result...does anyone know why this would be? The poller.log shows some "ERROR: Not enough arguments" errors, but I have no idea of seeing what checks this relates to...perhaps someone could help me there as well?
Regards,
Tom
I have been having an issue with ss_win_mssql.php too. The graphs have generated but no data is being put into them. Clog says there was a partial result "U" when running, but when I run it manually it runs fine:
[root@cactiserv-1 cacti_0.8.8h]$ php /var/www/html/cacti_0.8.8h/scripts/ss_win_mssql.php 10.10.10.1:8721 connections CactiComm <password>
userconnections:5
I run it through script_server.php and get U as a result...does anyone know why this would be? The poller.log shows some "ERROR: Not enough arguments" errors, but I have no idea of seeing what checks this relates to...perhaps someone could help me there as well?
Regards,
Tom
Who is online
Users browsing this forum: No registered users and 2 guests