Template SQL Server : Graphs empty

[MonsieurF]

Hello,

I try to set the SQL 2005 Plugin but my graph doesn't work.
I install the bundle EyeOfNetwork

Operating System: Linux 2.6.18-194.26.1.el5
Webserver: I don't know
Cacti:cacti-0.8.7g
Spine: I don't know
MySQL: I don't know
PHP: Apache
RRDTool (Cygwin or Win32 build): V2 min
Net-SNMP: I don't know
Cygwin (cygwin1.dll version):I don't know


I downloaded on http://docs.cacti.net/usertemplate:host ... :sqlserver the sqlserver template.
I followed all instructions.
1- Un-tar the archive
2- Go to the server SQL, add the user cactistat with the sql script.
3- Update the ss_win_mssql.php file with the information "username" and "password"
4- Upload this one on the scripts folder
5- Import the cacti_host_template_windows_-_sql_server.xml via the console
6- Assign the Windows - SQL Server host template to a device
7- Create the graphs

But, my graphs are empty.

EDIT : I have other graphics that work. (I.E. network graphs switch)

[MonsieurF]

Nobody ? :'(

[MonsieurF]

I am reading more topics and I try that command :

First, I comment the line

Code: Select all

error_reporting(0);

After, I run that command :

Code: Select all

 /usr/bin/php -q ./ss_win_mssql.php 1P_SERVSQL:1433 connections cactistats motDePasse

The error message :

Code: Select all

 Call to undefined function mssql_connect() in /srv/eyesofnetwork/cacti-0.8.7g/scripts/ss_win_mssql.php on line 33

The line 33 :

Code: Select all

if (! $link = mssql_connect($host.':'.$port, $username, $password) )

[MonsieurF]

nobody ?

[Khue]

I am getting ready to implement the 2005 template myself.

From just looking at what you've posted, I would say there may be something wrong with the connection string the php file is using and that it may be specifically related to login information. I would look at the connection string inside the PHP and also make sure that the user that you created for monitoring statistics has the correct password and login info. Also... this wouldn't happen to be an instanced version of SQL would it? I know if you are running in an instanced version of SQL your connection port is actually udp 1434 and then dynamically arbitrated from like 42539-42732 or something like that. That may significantly effect your connection string.

[MonsieurF]

It's work at home?
I try :

To delete the user sql.
To delete the ss_win_mssql.php.

Lunch the script sql 2005-2008 on the sql server with changing password (I let the same username).
I upload the file in the scripts cacti folder.

I do a "chown" command with the same user/group.

I create my graph...
Doesn't work..

[Khue]

Hey just wanted to write you back. I was able to get my templates to work appropriately. Here is an idea, try to query some info from that database using that login.

Connect to the database using SQL Server Management Studio and the username you've specified for the connection. Once you are connected run a simple select statement against dbo.sys.dm_os_performance_counters and see what you get. Maybe you can try something like:

Code: Select all

select top n rows from sys.dm_os_performance_counters

See if that returns something.

[MonsieurF]

THe request

select top n rows from sys.dm_os_performance_counters

give the message following :

Msg 102, Niveau 15, État 1, Ligne 1
Syntaxe incorrecte vers 'n'. (Transaltion : Incorrect syntax to 'n')

If i try

select rows from sys.dm_os_performance_counters

I have

Msg 207, Niveau 16, État 1, Ligne 1
Nom de colonne non valide : 'rows'. translation (Column name not valid)

but the command

select * from sys.dm_os_performance_counters

work fine.
I have the list TotalPages, FreePages, ...

I open the ss_win_mssql.php, and I translate the request following on sql :

SELECT [counter_name], [cntr_value] FROM sys.dm_os_performance_counters WHERE ([instance_name] = '' OR [instance_name] = '_Total') AND ([object_name] LIKE ('%Plan Cache%') AND [counter_name] IN ('Cache Hit Ratio', 'Cache Hit Ratio Base') OR ([object_name] LIKE ('%Buffer Manager%') AND [counter_name] IN ('Buffer Cache Hit Ratio', 'Buffer Cache Hit Ratio Base', 'Page reads/sec', 'Page writes/sec')) OR ([object_name] LIKE ('%General Statistics%') AND [counter_name] IN ('Active Temp Tables', 'User Connections')) OR ([object_name] LIKE ('%Databases%') AND [counter_name] IN ('Transactions/sec', 'Log Cache Hit Ratio', 'Log Cache Hit Ratio Base', 'Log Flushes/sec', 'Log Bytes Flushed/sec', 'Backup/Restore Throughput/sec')) OR ([object_name] LIKE ('%Access Methods%') AND [counter_name] IN ('Full Scans/sec', 'Range Scans/sec', 'Probe Scans/sec', 'Index Searches/sec', 'Page Splits/sec')) OR ([object_name] LIKE ('%Memory Manager%') AND [counter_name] IN ('Target Server Memory (KB)', 'Target Server Memory(KB)', 'Total Server Memory (KB)') OR ([object_name] LIKE ('%SQL Statistics%') AND [counter_name] IN ('SQL Compilations/sec', 'SQL Re-Compilations/sec'))))

I only change the red text. It's work on SQL Server...

[MonsieurF]

... I read again the turo and I retry the yum install php-mssql..
But I never read that :

Error: php53-common conflicts with php-common
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest

I try "You could try using --skip-broken to work around the problem" but it doesn't work... so I think my probleme is here...

[Khue]

That could be it.

Si c'est plus facile je parle un peu de francais.

[MonsieurF]

I am searching the library php54-mssql

EDIT : I try to use an other depot 'EPEL'. But I have any diffculties to "install" this depot.

When I run the command following yum install php-mssql , I have

Trying other mirror.
epel/primary_db | 3.8 MB 00:10
http://mirror.karneval.cz/pub/linux/fed ... sqlite.bz2: [Errno -3] Error performing checksum
Trying other mirror.

[MonsieurF]

I try this command :

/usr/bin/php -q /srv/eyesofnetwork/cacti/scripts/ss_win_mssql.php ss_win_mssql 192.168.XX.XX:1433 connections cactistats motdepasse

==>
PHP Fatal error: Call to undefined function mssql_connect() in /srv/eyesofnetwork/cacti-0.8.8a/scripts/ss_win_mssql.php on line 25