Trying to graph Exchange 2003 but keep getting error

[MMO]

I am trying to graph exchange things with the WMI templates from this forum but I can't get it to work.
In the Graph debug mode I get: RRDTool Says:
ERROR: opening 'c:\Inetpub\wwwroot\cacti/rra/amexch1_count_active_users_171.rrd': No such file or directory
I have to admit I am new to this so any help is welcome.

[DevilSun]

First go under Data Sources and make sure you have a data source there and everything looks right.

Second go under Graph Management and make sure you have all the data sources set.

Third, have you had any luck creating any graphs?

[MMO]

DevilSun, thanks for your reply,
If I go to Data Sources, I get the screen as shown in the first screenshot, it looks ok to me. The Exchange Server is Exchange 2003 on Windows 2003 the Servername is AMEXCH1 and WMI is working.
If I go to Graph Management I get the screen as shown in de second sreenshot, with the error, but the values look right to me. Maybe you can tell me where I am missing the point. I am new at this but eager to learn.
And yes I can do all kinds of graphing but mostly SNMP to switches and our PIX.

[MMO]

I did some further investigation, and as mentioned in an other post, I copied the Data Source command from debugmode in an cmd line, and now the rrd file is being created. Thus I may be should have mentioned that the rrd file was never created at all. I now wait to see if it gets updated.

[MMO]

No it is not getting updated, ??? Any help would be nice.

[DevilSun]

I assume you have put the perl script in the scripts directory and have setup the data query then.

Can you manually run the query against the machine?

From command prompt : perl w32_exch_is.pl amexch1

Or whatever the perl script is? Also, under "devices", what's that status of the server according to cacti?

[that_kid]

That is the part I'm stuck at. I get a graph but no graph data and I can run the command vrom the command line but for some reason it doesn't work in cactil. I must be missing something somewhere.

[TheWitness]

If running cactid, please be sure to download a minimal version of cygwin and remove any dll files from the c:\cactid directory.

TheWitness

[MMO]

@ DevilSun, I had a typo in my scriptname in de scripts dir, now if I run the script from the commandline I type C:\>perl C:\inetpub\wwwroot\cacti\scripts\w32_exch_query_isstats.pl amexc
h1 get ActiveUserCount,UserCount I get the correct usercounts back.

But I have not setup anything under Data Query, do I have to set it up there? I have created some other graphs and there is nothing new setup at data queries.

The status of the server shows as down in cacti, but I have not enabled SNMP on it because all I want is WMI data. But it is ping' able and the script runs from the commandline.

@ TheWitness, I am not running cactid at the moment.

[jmjones]

What user account does your web server run on. You may need to create a domain user account for the web server to run as. This would explain why the script works for you but not your webserver. The default IUSR_computername account has no network access at all. There is a web page dealing with NT permissions and WMI that you can find here http://redmondmag.com/columns/article.a ... ialsID=703

Hope this helps

[MMO]

Isn't it the useraccount wat is running the scheduled poller that is used for the script?

[DevilSun]

Interesting, have you turned up the level of logging yet and checked the log? If so, what does it say, if not do it

[MMO]

These are the first lines from the log with debug enabled, it looks like the exchange stuff comes so much later than the regular stuff 09:11:35 for exchange and 09:09:15 for the last line.

03/23/2005 09:11:35 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1111522295 --end=1111608695 --title="AMEXCH1 - Exchange Connections" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2005/03/22 21:11:35 To 2005/03/23 21:11:35\c" COMMENT:"\n" --vertical-label="Connections" DEF:a="c\:\Inetpub\wwwroot\cacti/rra/amexch1_count_active_users_171.rrd":count_users:AVERAGE DEF:b="c\:\Inetpub\wwwroot\cacti/rra/amexch1_count_active_users_171.rrd":count_active_users:AVERAGE AREA:a#005199:"Users" GPRINTLAST:" Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf\n" LINE2:b#FF4105:"Active Users" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
03/23/2005 09:09:15 PM - SYSTEM STATS: Time: 14.8750 s, Method: cmd.php, Processes: 1, Threads: N/A, Hosts: 12, Hosts/Process: 12
03/23/2005 09:09:15 PM - CMDPHP: Poller[0] Time: 13.8312 s, Theads: N/A, Hosts: 11
03/23/2005 09:09:15 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
03/23/2005 09:09:15 PM - CMDPHP: Poller[0] Host[29] SNMP: Host did not respond to SNMP
03/23/2005 09:09:13 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\amspare1_users_144.rrd --template users 1111608541:2

[MMO]

If I check with explorer in the rra dir I can see the file is created at the time I tried it from the commandline (to see if the command was ok) and it is not updated at all, all the other files are ok. The time and date should change with every poll?

[DevilSun]

Your 9:11 entry is you actually viewing the graph I believe.

Do you have anything before the 9:09:13 PM entry of the RRDTOOL Update, like of the query itself and data returned? I usually only turn my logging level up to Medium to see the results of my queries. I just turned my logging level to debug and where's how mines looks.

03/24/2005 09:10:06 AM - CMDPHP: Poller[0] Host[5] CMD: perl c:\inetpub\wwwroot\cacti/scripts/w32_exch_query_isstats.pl mailserver get ActiveUserCount,UserCount, output: ActiveUserCount:19 UserCount:22