Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jul 20, 2017 5:44 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Blank Graphs for sql server template
PostPosted: Mon Nov 18, 2013 5:00 am 
Offline

Joined: Mon Nov 18, 2013 4:52 am
Posts: 4
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.


Top
 Profile  
 
 Post subject: Re: Blank Graphs for sql server template
PostPosted: Mon Nov 18, 2013 12:53 pm 
Offline
Cacti Moderator
User avatar

Joined: Sat May 08, 2004 12:44 pm
Posts: 12125
Location: USA
followed the steps in ** README BEFORE POSTING ** ?

_________________

| 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 |


Top
 Profile  
 
 Post subject: Re: Blank Graphs for sql server template
PostPosted: Tue Nov 19, 2013 3:59 am 
Offline

Joined: Mon Nov 18, 2013 4:52 am
Posts: 4
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.


Attachments:
graph.JPG
graph.JPG [ 97.64 KiB | Viewed 1747 times ]
pic.JPG
pic.JPG [ 11.48 KiB | Viewed 1747 times ]
Data Input Method.JPG
Data Input Method.JPG [ 75.97 KiB | Viewed 1747 times ]
poller.JPG
poller.JPG [ 139.22 KiB | Viewed 1747 times ]
Top
 Profile  
 
 Post subject: Re: Blank Graphs for sql server template
PostPosted: Tue Nov 19, 2013 7:05 pm 
Offline
Cacti Moderator
User avatar

Joined: Sat May 08, 2004 12:44 pm
Posts: 12125
Location: USA
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?

_________________

| 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 |


Top
 Profile  
 
 Post subject: Re: Blank Graphs for sql server template
PostPosted: Fri Nov 22, 2013 5:55 am 
Offline

Joined: Mon Nov 18, 2013 4:52 am
Posts: 4
As i am totally new to cacti...can you please tell me where and how should i run these scripts.


Top
 Profile  
 
 Post subject: Re: Blank Graphs for sql server template
PostPosted: Mon Nov 25, 2013 12:55 am 
Offline

Joined: Mon Nov 18, 2013 4:52 am
Posts: 4
Can somebody help...plz in resolving this issue.


Top
 Profile  
 
 Post subject: Re: Blank Graphs for sql server template
PostPosted: Mon Nov 25, 2013 4:35 pm 
Offline
Cacti Moderator
User avatar

Joined: Sat May 08, 2004 12:44 pm
Posts: 12125
Location: USA
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?

_________________

| 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 |


Top
 Profile  
 
 Post subject: Re: Blank Graphs for sql server template
PostPosted: Mon Jun 12, 2017 6:00 am 
Offline

Joined: Fri Nov 07, 2014 8:55 am
Posts: 15
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group