templates for Win32/Citrix/MSSQL

Templates, scripts for templates, scripts and requests for templates.

Moderators: Moderators, Developers

Author
Message
jbiberian
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

templates for Win32/Citrix/MSSQL

#1 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
Attachments
cacti windows templates.zip
cacti templates
(262.37 KiB) Downloaded 2985 times
Last edited by jbiberian on Fri Apr 20, 2007 3:33 am, edited 2 times in total.

mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#2 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 ?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

jbiberian
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

missing files

#3 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
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#4 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
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

jbiberian
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

#5 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
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#6 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 ?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

jbiberian
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

#7 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
Posts: 8
Joined: Fri Apr 20, 2007 10:15 pm

#8 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
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

#9 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
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#10 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 ?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

jbiberian
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

#11 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
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#12 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
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

jbiberian
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

#13 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
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#14 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.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

jbiberian
Posts: 17
Joined: Mon Apr 16, 2007 5:51 am

#15 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

Post Reply