How to monitor Exchange 2003 with a Windows cacti

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
wijs2
Posts: 21
Joined: Fri Jun 08, 2007 5:35 am
Location: The Netherlands
Contact:
Contact wijs2

Post by wijs2 »

mcutting wrote:What happens if you change "E:/wwwroot/" to "<path_cacti>" in your data source, clear the poller cache, and try again ? May not make any difference, but I cannot see any reason as to why this will not work.
No difference :-(
mcutting wrote:Does your poller account have access to WMI ?
Should be good. Is there a way to check this from the cacti server, not on the exchange server?
mcutting wrote:s the output above from the same account used to run the poller ?
Yes
mcutting wrote:Do any PERL scripts run properly under CACTID ?
These Exchange PERL scripts are the first one's!
[size=75]Cacti: [color=darkred]0.8.6j[/color][/size]
[size=75]Cactid: [color=darkred]cactid-086preJ-cygwin-1.5.24-2[/color][/size]
[size=75]Cygwin (cygwin1.dll version): [color=darkred]1.5.24-2[/color][/size]
[size=75]MySQL: [color=darkred]mysql-5.0.41-win32[/color][/size]
[size=75]Net-SNMP: [color=darkred]net-snmp-5.4.0-1.win32[/color][/size]
[size=75]Operating System: [color=darkred]MS WS 2003 Ent. SP2 [Version 5.2.3790][/color][/size]
[size=75]PHP: [color=darkred]php-5.2.3-win32[/color][/size]
[size=75]RRDTool: [color=darkred]rrdtool-1.2.15-cygwin-1.5.20[/color][/size]
[size=75]Perl: [color=darkred]ActivePerl-5.8.8.820[/color][/size]
[size=75]Webserver: [color=darkred]IIS V6.0[/color][/size]
[size=75]*** Plugins ***[/size]
[size=75][color=darkred]thold-0.3.4[/color][/size]
Top
wijs2
Posts: 21
Joined: Fri Jun 08, 2007 5:35 am
Location: The Netherlands
Contact:
Contact wijs2

Post by wijs2 »

I overlooked these lines in the log:

06/18/2007 11:35:27 AM - POLLER: Poller[0] CACTI2RRD: E:/rrdtool/rrdtool.exe create E:/wwwroot/rra/<MAILSERVER>_logwritessec_197.rrd --step 300 DS:LogReadsSec:GAUGE:600:0:U DS:DatabaseWritesSec:GAUGE:600:0:U DS:DatabaseReadsSec:GAUGE:600:0:U DS:LogWritesSec:GAUGE:600:0:U RRA:AVERAGE:0.5:24:2160 RRA:AVERAGE:0.5:1:51840 RRA:AVERAGE:0.5:6:8736 RRA:AVERAGE:0.5:288:797 RRA:MIN:0.5:24:2160 RRA:MIN:0.5:1:51840 RRA:MIN:0.5:6:8736 RRA:MIN:0.5:288:797 RRA:MAX:0.5:24:2160 RRA:MAX:0.5:1:51840 RRA:MAX:0.5:6:8736 RRA:MAX:0.5:288:797 RRA:LAST:0.5:1:51840 RRA:LAST:0.5:24:2160 RRA:LAST:0.5:6:8736 RRA:LAST:0.5:288:797

06/18/2007 11:35:27 AM - POLLER: Poller[0] CACTI2RRD: E:/rrdtool/rrdtool.exe update E:\wwwroot\rra\<MAILSERVER>_logwritessec_197.rrd --template N:U

Notice that there is a difference between E:/wwwroot/rra/<MAILSERVER> and E:\wwwroot\rra\<MAILSERVER>

How come? All others are set correct? :o

Also can somebody explain this one?
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] ERROR: Empty result [<MAILSERVER>]: 'E:/Perl/bin/perl.exe E:/wwwroot/scripts/windows_exchangedb.pl <MAILSERVER>'
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[197] WARNING: Result from SCRIPT not valid. Partial Result: ...
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[197] SCRIPT: E:/Perl/bin/perl.exe E:/wwwroot/scripts/windows_exchangedb.pl <MAILSERVER>, output: U
06/18/2007 11:35:26 AM - PHPSVR: Poller[0] DEBUG: INC: 'E:\wwwroot\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '<MAILSERVER> 25 1:161:500:public:::MD5::[None] get total 1'
06/18/2007 11:35:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=25 and field_name='hrStorageAllocationUnits' and snmp_index='1'"
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[95] SS[0] SERVER: E:\wwwroot\scripts\ss_host_disk.php ss_host_disk <MAILSERVER> 25 1:161:500:public:::MD5::[None] get total 1, output: 10742198784
06/18/2007 11:35:26 AM - PHPSVR: Poller[0] DEBUG: INC: 'E:\wwwroot\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '<MAILSERVER> 25 1:161:500:public:::MD5::[None] get total 2'
06/18/2007 11:35:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=25 and field_name='hrStorageAllocationUnits' and snmp_index='2'"
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[96] SS[0] SERVER: E:\wwwroot\scripts\ss_host_disk.php ss_host_disk <MAILSERVER> 25 1:161:500:public:::MD5::[None] get total 2, output: 25662869504
06/18/2007 11:35:26 AM - PHPSVR: Poller[0] DEBUG: INC: 'E:\wwwroot\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '<MAILSERVER> 25 1:161:500:public:::MD5::[None] get total 3'
06/18/2007 11:35:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=25 and field_name='hrStorageAllocationUnits' and snmp_index='3'"
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[97] SS[0] SERVER: E:\wwwroot\scripts\ss_host_disk.php ss_host_disk <MAILSERVER> 25 1:161:500:public:::MD5::[None] get total 3, output: 145663160320
06/18/2007 11:35:26 AM - PHPSVR: Poller[0] DEBUG: INC: 'E:\wwwroot\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '<MAILSERVER> 25 1:161:500:public:::MD5::[None] get used 1'
06/18/2007 11:35:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=25 and field_name='hrStorageAllocationUnits' and snmp_index='1'"
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[95] SS[0] SERVER: E:\wwwroot\scripts\ss_host_disk.php ss_host_disk <MAILSERVER> 25 1:161:500:public:::MD5::[None] get used 1, output: 7562447360
06/18/2007 11:35:26 AM - PHPSVR: Poller[0] DEBUG: INC: 'E:\wwwroot\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '<MAILSERVER> 25 1:161:500:public:::MD5::[None] get used 2'
06/18/2007 11:35:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=25 and field_name='hrStorageAllocationUnits' and snmp_index='2'"
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[96] SS[0] SERVER: E:\wwwroot\scripts\ss_host_disk.php ss_host_disk <MAILSERVER> 25 1:161:500:public:::MD5::[None] get used 2, output: 5595815936
06/18/2007 11:35:26 AM - PHPSVR: Poller[0] DEBUG: INC: 'E:\wwwroot\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '<MAILSERVER> 25 1:161:500:public:::MD5::[None] get used 3'
06/18/2007 11:35:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=25 and field_name='hrStorageAllocationUnits' and snmp_index='3'"
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[97] SS[0] SERVER: E:\wwwroot\scripts\ss_host_disk.php ss_host_disk <MAILSERVER> 25 1:161:500:public:::MD5::[None] get used 3, output: 34015899648
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[98] SNMP: v1: <MAILSERVER>, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.65539, value: 1826467894
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[98] SNMP: v1: <MAILSERVER>, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.65539, value: 659202170
06/18/2007 11:35:26 AM - CACTID: Poller[0] Host[25] DS[94] SNMP: v1: <MAILSERVER>, dsname: users, oid: .1.3.6.1.2.1.25.1.5.0, value: 39
06/18/2007 11:35:26 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '80': 'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (98,'traffic_in','2007-06-18 11:35:26','1826467894'),(98,'traffic_out','2007-06-18 11:35:26','659202170'),(94,'users','2007-06-18 11:35:26','39'),(197,'','2007-06-18 11:35:26','U'),(95,'hdd_total','2007-06-18 11:35:26','10742198784'),(96,'hdd_total','2007-06-18 11:35:26','25662869504'),(97,'hdd_total','2007-06-18 11:35:26','145663160320'),(95,'hdd_used','2007-06-18 11:35:26','7562447360'),(96,'hdd_used','2007-06-18 11:35:26','5595815936'),(97,'hdd_used','2007-06-18 11:35:26','34015899648')'


The first two lines give an error but it returns values anyway?

Hopefully this new info houses the cause of my issue's :-)
[size=75]Cacti: [color=darkred]0.8.6j[/color][/size]
[size=75]Cactid: [color=darkred]cactid-086preJ-cygwin-1.5.24-2[/color][/size]
[size=75]Cygwin (cygwin1.dll version): [color=darkred]1.5.24-2[/color][/size]
[size=75]MySQL: [color=darkred]mysql-5.0.41-win32[/color][/size]
[size=75]Net-SNMP: [color=darkred]net-snmp-5.4.0-1.win32[/color][/size]
[size=75]Operating System: [color=darkred]MS WS 2003 Ent. SP2 [Version 5.2.3790][/color][/size]
[size=75]PHP: [color=darkred]php-5.2.3-win32[/color][/size]
[size=75]RRDTool: [color=darkred]rrdtool-1.2.15-cygwin-1.5.20[/color][/size]
[size=75]Perl: [color=darkred]ActivePerl-5.8.8.820[/color][/size]
[size=75]Webserver: [color=darkred]IIS V6.0[/color][/size]
[size=75]*** Plugins ***[/size]
[size=75][color=darkred]thold-0.3.4[/color][/size]
Top
mcutting
Cacti Guru User
Posts: 1884
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:
Contact mcutting

Post by mcutting »

Should be good. Is there a way to check this from the cacti server, not on the exchange server?
Does the CACTI server have PERL installed ? If so, then yes. Logon as the poller account, run a command prompt, and browse to the SCRIPTS directory. Run the script manually, and see if any results are returned.

It is also possible that this is a CACTID issue. You need to specify the path to your CYGWIN binaries. Are the required DLL's in C:\CYGWIN\BIN ? Try placing a copy of the dll's (NOT cygwin1.dll) into the CACTID directory (the one that houses the CACTID binary), along with a copy of sh.exe, and try the poller again.

Sometimes, CACTID cannot process PERL scripts if it can't locate the required dll files from Cygwin. If your path statement is correct, then this should work. What happens if you change the poller to cmd.php - do you get any graphs ?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
Top
wijs2
Posts: 21
Joined: Fri Jun 08, 2007 5:35 am
Location: The Netherlands
Contact:
Contact wijs2

Post by wijs2 »

Perl was and is installed. Running a script manually gives me this result:
perl windows_exchangedb.pl <MAILSERVER>
DatabaseReadsSec:0 DatabaseWritesSec:0 LogReadsSec:0 LogWritesSec:0

Switched from CACTID to CMD.PHP as suggested.

Now I have 4 out of 5 graphs showing data.

These are showing:
- windows_exchangedb.pl
- windows_exchangemessages.pl
- windows_exchangequeues.pl
- windows_memory.pl

This one showing anything:
- windows_exchangelatency.pl
perl windows_exchangelatency.pl <MAILSERVER>
ClientLatency10secRPCs:0 ClientLatency2secRPCs:4 ClientLatency5secRPCs:1 ClientTotalreportedlatency:156
Unfortunatly the file is created (<MAILSERVER>_clientlatency5sec_198.rrd) but not showed. Will investigate!

Seems to be a CACTID issue :-( the fact that the NaN's were appearing.
[size=75]Cacti: [color=darkred]0.8.6j[/color][/size]
[size=75]Cactid: [color=darkred]cactid-086preJ-cygwin-1.5.24-2[/color][/size]
[size=75]Cygwin (cygwin1.dll version): [color=darkred]1.5.24-2[/color][/size]
[size=75]MySQL: [color=darkred]mysql-5.0.41-win32[/color][/size]
[size=75]Net-SNMP: [color=darkred]net-snmp-5.4.0-1.win32[/color][/size]
[size=75]Operating System: [color=darkred]MS WS 2003 Ent. SP2 [Version 5.2.3790][/color][/size]
[size=75]PHP: [color=darkred]php-5.2.3-win32[/color][/size]
[size=75]RRDTool: [color=darkred]rrdtool-1.2.15-cygwin-1.5.20[/color][/size]
[size=75]Perl: [color=darkred]ActivePerl-5.8.8.820[/color][/size]
[size=75]Webserver: [color=darkred]IIS V6.0[/color][/size]
[size=75]*** Plugins ***[/size]
[size=75][color=darkred]thold-0.3.4[/color][/size]
Top
mcutting
Cacti Guru User
Posts: 1884
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:
Contact mcutting

Post by mcutting »

Copy the following dll's from the Cygwin\Bin directory to the directory where CACTI is located

cygcrypto-0.9.8.dll
cygfreetype-6.dll
cygiconv-2.dll
cygintl-3.dll
cygintl-8.dll
cygncurses-8.dll
cygpng12.dll
cygreadline6.dll
cygz.dll

Try to use CACTID again, and see if this resolves the issue. At the moment, leave sh.exe where it is. Could you also post your PATH environment variable ?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
Top
wijs2
Posts: 21
Joined: Fri Jun 08, 2007 5:35 am
Location: The Netherlands
Contact:
Contact wijs2

Post by wijs2 »

cygcrypto-0.9.8.dll - was already present in the cacti dir
cygfreetype-6.dll - was already present in the cacti dir
cygiconv-2.dll - was already present in the cacti dir
cygintl-3.dll - was already present in the cacti dir
cygintl-8.dll - was already present in the cacti dir
cygncurses-8.dll - was already present in the cacti dir
cygreadline6.dll - was already present in the cacti dir
cygz.dll - was already present in the cacti dir

cygpng12.dll - don't you mean cygpng2.dll? Otherwise I don't have this dll in Cygwin\Bin. Even better! I have lost my Cygwin\Bin directory completely!!! How the F%$# :evil: this happend?!? I'll get back to you!

PATH environment variable:
E:\cygwin\bin;E:\Perl\site\bin;E:\Perl\bin;E:\PHP\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;E:\usr\bin

For now the graphs, except one, are showing data. I'm gonnan fix my Cywin. Get back to you asap!!!
[size=75]Cacti: [color=darkred]0.8.6j[/color][/size]
[size=75]Cactid: [color=darkred]cactid-086preJ-cygwin-1.5.24-2[/color][/size]
[size=75]Cygwin (cygwin1.dll version): [color=darkred]1.5.24-2[/color][/size]
[size=75]MySQL: [color=darkred]mysql-5.0.41-win32[/color][/size]
[size=75]Net-SNMP: [color=darkred]net-snmp-5.4.0-1.win32[/color][/size]
[size=75]Operating System: [color=darkred]MS WS 2003 Ent. SP2 [Version 5.2.3790][/color][/size]
[size=75]PHP: [color=darkred]php-5.2.3-win32[/color][/size]
[size=75]RRDTool: [color=darkred]rrdtool-1.2.15-cygwin-1.5.20[/color][/size]
[size=75]Perl: [color=darkred]ActivePerl-5.8.8.820[/color][/size]
[size=75]Webserver: [color=darkred]IIS V6.0[/color][/size]
[size=75]*** Plugins ***[/size]
[size=75][color=darkred]thold-0.3.4[/color][/size]
Top
mcutting
Cacti Guru User
Posts: 1884
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:
Contact mcutting

Post by mcutting »

Ok - you also need to append your path to reflect the location of the cygwin\bin directory...
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
Top
wijs2
Posts: 21
Joined: Fri Jun 08, 2007 5:35 am
Location: The Netherlands
Contact:
Contact wijs2

Post by wijs2 »

After reinstall of Cygwin and a reboot, CACTID is working again. No more warnings in the log and the graphs are updating (4 of 5).

My initial problem was the cause by the disappeared Cygwin\Bin directory!?!? strange, but true....

Only one graph is not displayed at this moment. It is created. The file is being updated with every poller cycle, bu no image. Any idea's? Will investigate again!
[size=75]Cacti: [color=darkred]0.8.6j[/color][/size]
[size=75]Cactid: [color=darkred]cactid-086preJ-cygwin-1.5.24-2[/color][/size]
[size=75]Cygwin (cygwin1.dll version): [color=darkred]1.5.24-2[/color][/size]
[size=75]MySQL: [color=darkred]mysql-5.0.41-win32[/color][/size]
[size=75]Net-SNMP: [color=darkred]net-snmp-5.4.0-1.win32[/color][/size]
[size=75]Operating System: [color=darkred]MS WS 2003 Ent. SP2 [Version 5.2.3790][/color][/size]
[size=75]PHP: [color=darkred]php-5.2.3-win32[/color][/size]
[size=75]RRDTool: [color=darkred]rrdtool-1.2.15-cygwin-1.5.20[/color][/size]
[size=75]Perl: [color=darkred]ActivePerl-5.8.8.820[/color][/size]
[size=75]Webserver: [color=darkred]IIS V6.0[/color][/size]
[size=75]*** Plugins ***[/size]
[size=75][color=darkred]thold-0.3.4[/color][/size]
Top
mcutting
Cacti Guru User
Posts: 1884
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:
Contact mcutting

Post by mcutting »

Post a debug of the affected graph - the problem may lie here.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
Top
wijs2
Posts: 21
Joined: Fri Jun 08, 2007 5:35 am
Location: The Netherlands
Contact:
Contact wijs2

Post by wijs2 »

There was no "Data Source Item" for the "ClientLatency2sec". I made a copy of this from the 5sec version. The outcome is a graph!

Thanks for all the support!

Might be smart to look at the templates and check if the Data Source Item" for the "ClientLatency2sec" is present.
[size=75]Cacti: [color=darkred]0.8.6j[/color][/size]
[size=75]Cactid: [color=darkred]cactid-086preJ-cygwin-1.5.24-2[/color][/size]
[size=75]Cygwin (cygwin1.dll version): [color=darkred]1.5.24-2[/color][/size]
[size=75]MySQL: [color=darkred]mysql-5.0.41-win32[/color][/size]
[size=75]Net-SNMP: [color=darkred]net-snmp-5.4.0-1.win32[/color][/size]
[size=75]Operating System: [color=darkred]MS WS 2003 Ent. SP2 [Version 5.2.3790][/color][/size]
[size=75]PHP: [color=darkred]php-5.2.3-win32[/color][/size]
[size=75]RRDTool: [color=darkred]rrdtool-1.2.15-cygwin-1.5.20[/color][/size]
[size=75]Perl: [color=darkred]ActivePerl-5.8.8.820[/color][/size]
[size=75]Webserver: [color=darkred]IIS V6.0[/color][/size]
[size=75]*** Plugins ***[/size]
[size=75][color=darkred]thold-0.3.4[/color][/size]
Top
mcutting
Cacti Guru User
Posts: 1884
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:
Contact mcutting

Post by mcutting »

One for the author, I think.....glad you have it working, and to be of service !
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b
Top
spg_
Posts: 1
Joined: Sat Aug 04, 2007 6:30 pm

Post by spg_ »

Given up :(

WMI all ok, IUSR permissiosn fine , CActi working just fine...

perl scripts run fine from CMD, scheduler set to run local admin and domain admin ...

cactid just bombs with random characters sometimes, cant find any mib files they rest (yes, tried them in /usr /etc usr/local, the works) filemon shows no obvious scanning for them....

running poller reports everything you would expect apart from the perl files.... ERROR Not enough arguements...

I rewrote them in vbscript, same...
Top
Post Reply

Return to “Help: Windows Specific”

Who is online

Users browsing this forum: No registered users and 0 guests