Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jun 20, 2019 8:14 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 32 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: templates for Win32/Citrix/MSSQL
PostPosted: Mon Apr 16, 2007 7:53 am 
Offline

Joined: Mon Apr 16, 2007 5:51 am
Posts: 17
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:
File comment: cacti templates
cacti windows templates.zip [262.37 KiB]
Downloaded 2964 times


Last edited by jbiberian on Fri Apr 20, 2007 3:33 am, edited 2 times in total.
Top
 Profile  
 
 Post subject:
PostPosted: Thu Apr 19, 2007 6:31 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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 ?

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject: missing files
PostPosted: Fri Apr 20, 2007 3:34 am 
Offline

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

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

Sorry for that!

Jonas


Top
 Profile  
 
 Post subject:
PostPosted: Fri Apr 20, 2007 8:45 am 
Offline
Cacti Guru User

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

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Fri Apr 20, 2007 9:32 am 
Offline

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


Top
 Profile  
 
 Post subject:
PostPosted: Fri Apr 20, 2007 1:02 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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 ?

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Fri Apr 20, 2007 3:16 pm 
Offline

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


Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 22, 2007 1:59 am 
Offline

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


Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 22, 2007 5:01 am 
Offline

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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 24, 2007 1:14 am 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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 ?

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 24, 2007 1:54 am 
Offline

Joined: Mon Apr 16, 2007 5:51 am
Posts: 17
The problem with runas is entering the password. Yo have to emulate keystrokes.

The runas.vbs found on https://lists.cs.wisc.edu/archive/condor-users/pre-2004-June/msg00734.shtml should help you doing what you want!

Jonas


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 24, 2007 2:16 am 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
Do I really need "run as" ? I am testing this with a domain admin account ?

Thanks

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 24, 2007 2:33 am 
Offline

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

Quote:
get_disk_space.pl localhost index
C:

get_disk_space.pl localhost get Size C:
36405071872


- services :

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

get_service_script.pl localhost get State Apache2
1


Jonas


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 24, 2007 2:42 am 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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.

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 24, 2007 3:06 am 
Offline

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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 32 posts ]  Go to page 1, 2, 3  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group