SQL Server 2005 Templates

[dcox]

I recently deployed this on a Windows install of Cacti and it's not working...

I suspect there's a comms issue with SQL server. I can't telnet to 1433 (that is the correct port) from the cacti box. I can rlogon via that port... Seems odd to me.

Here is what debug shows:

C:/rrdtool/rrdtool.exe create \
C:/inetpub/wwwroot/cacti/rra/13/109.rrd \
--step 60 \
DS:mssql_conns:GAUGE:120:0:10000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

I am about to give up on this feature...

Any help is appreciated.

[zetoo]

Could anyone help me ?
I am trying to use it on SQL Server 2012.

Cacti - 1.jpg (59 KiB) Viewed 670 times

[phalek]

Did you install the php mssql module at all ? check with "php -m"

[zetoo]

Yeah, I need to install php_mssql first.
Looks like PHP 5.5 did not include those in standard build.

PS: seems like i will upgrade PHP to 7 for better option to get this graph to works

Is there any firewall monitoring template?

Seems like cigamit services is working for me after few set up.