Cacti SQL monitoring Problem

[desscartes]

Hi everybody,

I have a problem about my SQL graphs.
I follow all steps from doc

Code: Select all

http://docs.cacti.net/usertemplate:host:microsoft:sqlserver

,but my graphs returns value 0 like an example ımage..

How could I fix this?

Thanks!!


Here is my log result,

Code: Select all

01/20/2015 04:30:37 PM - SPINE: Poller[0] Host[1050] TH[1] DS[5511] SS[2] SERVER: /var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php ss_win_mssql 10.10.1.243:1433 connections cactistats cactisqlmon, output: U

[BSOD2600]

Likely a permission problem. When you run the script AS the user account which runs the Cacti poller.php, does it work?
Follow http://docs.cacti.net/manual:088:4_help.2_debugging

I see you're monitoring cacti stats. Do you know about http://forums.cacti.net/viewtopic.php?f=19&t=49632 ?

[desscartes]

Thanks for your reply BSOD2600,

Yeap Cacti poller.php is working.
And I want to monitor another windows sql server but I have still taking no data from my data sources.

How can I fix this?

[BSOD2600]

Likely a permission problem. When you run the sql script AS the user account which runs the Cacti poller.php, does it work?
Follow http://docs.cacti.net/manual:088:4_help.2_debugging

You havent done either of these yet.

[desscartes]

Thanks,

But poller.php permission seems ok,

Code: Select all

-rwxr-xr-x.  1      1000 users  18056 Apr 23  2012 poller.php

I follow link but ı did not find anything to solve this problem?
I did not find main problem about it..

[cigamit]

/var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php ss_win_mssql 10.10.1.243:1433 connections cactistats cactisqlmon

You need to run this manually, and figure out why it is return undefined.

[cigamit]

Thanks,

But poller.php permission seems ok,

Code: Select all

-rwxr-xr-x.  1      1000 users  18056 Apr 23  2012 poller.php

I follow link but ı did not find anything to solve this problem?
I did not find main problem about it..

I believe he was talking about permissions on the script that it is running, not on the poller.php file.

[desscartes]

Thanks for help cigamit,


I run that manually,

Code: Select all

[root@CACTI cenk.durak]# php /var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php ss_win_mssql 10.10.1.243:1433 connections cactistats cactisqlmon
PHP Warning:  Module 'ldap' already loaded in Unknown on line 0

What does it mean?I have still have U output.

Sorry about my silly questions:)

and script permission is,

Code: Select all

-rwxr-xr-x. 1 cenk.durak cenk.durak  6417 Jan 19 12:07 ss_win_mssql.php

Thanks

[cigamit]

Your PHP seems to be misconfigured. Seems that you are trying to load the ldap module twice. Probably once inside php.ini and another time as a separate ini file.

If you google

PHP Warning: Module 'ldap' already loaded in Unknown on line 0

multiple articles come up to point you in the right direction.

[desscartes]

thanks,

I will google it,

But it is just warning isn't it? My Other .php script has same error but they are working.
Is this warning main problem for Sql monitoring?

My log result about datasource;

Code: Select all

01/23/2015 02:26:42 AM - SPINE: Poller[0] Host[1050] TH[1] DS[5524] SS[0] SERVER: /var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php ss_win_mssql 10.10.1.243: memory  , output: U

Thanks again for your help

[cigamit]

Yes, that is most like the issue, as Cacti is expecting a single number as output from the script. The script is outputting the error and the number, and Cacti doesn't know what to do with it.

[desscartes]

thanks cigamit for your help,

I will google it ,
I I found another issue I will write again,

Thanks a lot:)

[desscartes]

Hi cigamit ,

I solve that problem but I have still "U" output.

I could't find problem, every thing seems ok.

Whe could I have to look?

Thanks,

[desscartes]

any idea?

Here my datasource debug results;

Code: Select all

/usr/bin/rrdtool create \
/var/www/html/cacti-0.8.8a/rra/emssddb01_mssql_bckrst_bytes_5568.rrd \
--step 300  \
DS:mssql_bckrst_bytes:COUNTER:600:0:U \
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:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

[BSOD2600]

Until the following command spits out a number instead of U, the graph will be empty.

/var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php ss_win_mssql 10.10.1.243: memory