Blank Graphs for sql server template

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
ccuser
Posts: 4
Joined: Mon Nov 18, 2013 4:52 am

Blank Graphs for sql server template

Post by ccuser »

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

Re: Blank Graphs for sql server template

Post by ccuser »

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 3473 times
pic.JPG
pic.JPG (11.48 KiB) Viewed 3473 times
Data Input Method.JPG
Data Input Method.JPG (75.97 KiB) Viewed 3473 times
poller.JPG
poller.JPG (139.22 KiB) Viewed 3473 times
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Blank Graphs for sql server template

Post by BSOD2600 »

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

Re: Blank Graphs for sql server template

Post by ccuser »

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

Re: Blank Graphs for sql server template

Post by ccuser »

Can somebody help...plz in resolving this issue.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Blank Graphs for sql server template

Post by BSOD2600 »

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

Re: Blank Graphs for sql server template

Post by flooreus »

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

Who is online

Users browsing this forum: No registered users and 2 guests