Cacti SQL monitoring Problem

[desscartes]

Thanks for your answer,

I didn't understand what you mean, sorry I am newbie about cacti.

I try the command but I have error below,

Code: Select all

]# /var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php ss_win_mssql 10.10.1.243: memory
: No such file or directoryscripts/ss_win_mssql.php: line 1: ?php
/var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php: line 2: /': Permission denied
/var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php: line 3: syntax error near unexpected token `$_SERVER["argv"][0]'
/var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php: line 3: `if (!isset($_SERVER["argv"][0]) || isset($_SERVER['REQUEST_METHOD'])  || isset($_SERVER['REMOTE_ADDR'])' {

any idea?

Thanks again,

[cigamit]

put the path to your php binary in front of that before you run it.

[desscartes]

Upps!
Sorry about it,



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

but there is no otput.

[cigamit]

Ya, not output means you are going to get a proper graph. I haven't ever seen that script before, but looking at
10.10.1.243:
makes me think you are missing a port number somewhere.

[desscartes]

Thanks for your answer cigamit,

I checked port (which is using 1433 ) it is open

Code: Select all

# telnet 10.10.1.243 1433
Trying 10.10.1.243...
Connected to 10.10.1.243.

And I try this command with port number but problem continue..there is nothing output..

# /usr/bin/php /var/www/html/cacti-0.8.8a/scripts/ss_win_mssql.php ss_win_mssql 10.10.1.243:1433 memory
#



Actually I want to monitor my SQL server performans on cacti . I try two solution, this way and WMI. But I couldn success have a graph with two solution:(

[cigamit]

From this point, you need to figure out why you aren't getting any information from the remote host. We can't really do that for you. It could be something as simple as a firewall on the remote host (or between cacti and the host) or it could be the user account, etc...

[desscartes]

Thanks again cigamit for your help,

I will control again host and firewall

I will focus there:)

If I have an issue about it I will write again,

Thankss