templates for Win32/Citrix/MSSQL

jbiberian · Post by **jbiberian** » Mon Apr 16, 2007 7:53 am

Hi everyone,

Here are some useful templates. These are meant to graph win32 servers from a win32 cacti host. They were tested on windows 2K3 Server SP1

Screenshots are included in the zip.

The following templates are included:

citrix - load - one server
citrix licences - whole farm
citrix load average - whole farm
citrix sessions - whole farm
citrix users - one server
Disk space using wmi
MSSql jobs in error
Windows pagefile usage
Windows physical memory usage
Windows Service State

N.B. : Citrix templates require the citrix SDK on the cacti host.

The Service State and Disk space are data queries. Disk space includes freespace to be monitored through theshold plugin. Service state is only used for tracking windows services falling down.

If you find these useful, need help to install them,... just tell me

------
New version with missing ressources uploaded!
------

Jonas

mcutting · Post by **mcutting** » Thu Apr 19, 2007 6:31 pm

Hi Jonas,

Thanks for the templates. I can't seem to locate

win32_service_list.xml
win32_disk_space.xm

Or the relevant Graph Templates for the above

Could you post these as well ?

jbiberian · Post by **jbiberian** » Fri Apr 20, 2007 3:34 am

Hi,

I've just updated the zip file. You can now find the missing files in the template directory.

Sorry for that!

Jonas

mcutting · Post by **mcutting** » Fri Apr 20, 2007 8:45 am

Hi Jonas,

I can't seem to get these XML files to return any data. A verbose query gives no output. I changed the paths on the PERL scripts to reflect where CACTI is installed, but still no joy.

Running the PERL script from a command line also does not give any results - any ideas ?

Thanks

jbiberian · Post by **jbiberian** » Fri Apr 20, 2007 9:32 am

Could you just tell me which scripts you are trying to run, and which one doesn't give you an answer?

In all cases, remember that the user running IIS or Apache and the cmd.php must have the windows rights to get the information from the server. To change it on IIS 6.0 you have to go to the pool used by your application on the identity tab.

Jonas

mcutting · Post by **mcutting** » Fri Apr 20, 2007 1:02 pm

I am using APACHE for the web server (WAMP under Windows). I am trying to run the disk space and services PERL scripts if this helps ?

jbiberian · Post by **jbiberian** » Fri Apr 20, 2007 3:16 pm

For Apache you have to change the account which launches the service. Try with an domain administrator first.
Remember that the disk space plugin is a data query, so you have to launch it with correct arguments (I'm no longer at work so I can't tell you the exact one, but I think it is perl check_disk_space.pl <hostname> query list), I'll post later the correct command, I don't have much time now. Try running command "diskperf -y" on the server and "wmiadap /f" to activate the disk counters.

Jonas

nick_strunc · Post by **nick_strunc** » Sun Apr 22, 2007 1:59 am

For security purposes I will not be running a web server as a domain admin account. Do you have updated scripts or know how to modify them so they connect as a specific user? I would prefer to setup a user on each machine and then provide them rights to a specific area needed to collect the stats.

jbiberian · Post by **jbiberian** » Sun Apr 22, 2007 5:01 am

I would not recommand that too.... Even if I do that! It was only for testing if it was his problem.
My solution was to run as a domain admin, but to isolate this web server so it can only be accessed by a few trusted admins and a few managers. without beeing domain administrator, you can't monitor domain controllers....... I didn't had a choice

To answer your question : you have ton change the data source template (where you'll find the command line to run the script) and change it to launch the command with runas (or set up an intermediate script which will do this job). This should work, but will disclose the password to anyone accessing the console.

Jonas

mcutting · Post by **mcutting** » Tue Apr 24, 2007 1:14 am

Jonas,

Thanks for the ideas. However, i have already tried all these options with no success. I'd like to use your templates - any other suggestions ?

jbiberian · Post by **jbiberian** » Tue Apr 24, 2007 1:54 am

The problem with runas is entering the password. Yo have to emulate keystrokes.

The runas.vbs found on https://lists.cs.wisc.edu/archive/condo ... 0734.shtml should help you doing what you want!

Jonas

mcutting · Post by **mcutting** » Tue Apr 24, 2007 2:16 am

Do I really need "run as" ? I am testing this with a domain admin account ?

Thanks

jbiberian · Post by **jbiberian** » Tue Apr 24, 2007 2:33 am

ok! So you don't have to change anything but the paths in perl script, sorry! (I though you were nick_strunc, i didn't pat attention)

could you just run the command "by hands", and tell me the Windows version you are using?

The commands to launch are :

- disk space :

get_disk_space.pl localhost index
C:

get_disk_space.pl localhost get Size C:
36405071872

- services :

get_service_script.pl localhost index
AClient
AeLookupSvc
Alerter
ALG
Apache2
AppMgmt
AudioSrv
BITS
.....

get_service_script.pl localhost get State Apache2
1

Jonas

mcutting · Post by **mcutting** » Tue Apr 24, 2007 2:42 am

Hi Jonas,

These seem to work ok (for XP and Windows 2003). However, if I want to run these using the data query, and they don't return any values, then how would this fit in with CACTI ? Is there anything I need to change ?

Thanks for your help.

jbiberian · Post by **jbiberian** » Tue Apr 24, 2007 3:06 am

I presume you have copied the XML files in <path_cacti>/resource/script_queries/ dir.

Could you check the account launching the apache service, and the account launching the cmd.php? If this works by hand, then the only problem I see is a right missing when launched through apache.

Jonas

Cacti

templates for Win32/Citrix/MSSQL

templates for Win32/Citrix/MSSQL

missing files

Who is online