[solved] problems with graphics (/cacti/rra/*.rrd not found)

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

Moderators: Developers, Moderators

Post Reply
Mymoon
Posts: 8
Joined: Fri Aug 08, 2008 7:15 am

[solved] problems with graphics (/cacti/rra/*.rrd not found)

Post by Mymoon »

i use rrdtool-1.2.15 (without dlls - cygwin), apache 2.2.*, php-5.2.0, mysql-5.0.27. i can't see graphics.

i've checked some topics about ntfs permissions and tried to find in this key the decision:

that's my pollerlog.log:

Code: Select all

08/12/2008 10:32:47 AM - SYSTEM STATS: Time:1.2143 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:41 RRDsProcessed:0
that's my cmdlog.log:

Code: Select all

08/12/2008 10:36:28 AM - CMDPHP: Poller[0] ERROR: The PHP Script: CMD.PHP Must be started using the full path to the file and in lower case.  This is a PHP Bug!!!
-1
this is debug information:

Code: Select all

RRDTool Command:

c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Cisco 2811 VPN-Router - Logged in Users" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="users" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="C\:/Apache2/htdocs/cacti/rra/cisco_2811_vpn-router__users_20.rrd":users:AVERAGE \
AREA:a#4668E4FF:"Users"  \
GPRINT:a:LAST:"Current\:%8.0lf"  \
GPRINT:a:AVERAGE:"Average\:%8.0lf"  \
GPRINT:a:MAX:"Maximum\:%8.0lf" 
RRDTool Says:

ERROR: opening 'C:/Apache2/htdocs/cacti/rra/cisco_2811_vpn-router__users_20.rrd': No such file or directory
Yout article is written for IIS, but i use apache2. Is there any dedicated system user for it in Windows (created on install) like for IIS? I permit all rights for "Everybody" on /rrdtool, /spine and /rra.

Nothing has happened.
mac_fly
Posts: 11
Joined: Wed Jul 30, 2008 2:47 am

Post by mac_fly »

Hello,
You have to create your file manualy.
Just copy and execute the command displaying in your debug.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

mac_fly wrote:You have to create your file manualy.
No, you should not. If cacti / system is properly configured, it'll do this automatically. The fact it is not, is a sign of some misconfiguration.

Mymoon:

1) Update rrdtool to 1.2.26 or better, Win32 build (native 2 download site on the rrdtool site).

2) What version of cacti? if not running 0.8.7b + patches, I strongly suggest you upgrade. If you didn't invoke poller.php with upper case letters, then you are possibly experiancing an old cacti bug (which has already been fixed in newer versions).

3) There is a section in my installation guide which instructs on the installation/configuration of Apache. The account which Apache runs under, will need the appropiate granted rights on all the various files/folders which are required for IIS.
Mymoon
Posts: 8
Joined: Fri Aug 08, 2008 7:15 am

Post by Mymoon »

I've copied from downloaded zip-archive new RRDtool 1.2.28 to RRDtool folder (after deleting old one).
I use 0.8.7b version and today i've patched it in the same way:

1) downloaded files from 0.8.7b folder in patches section
2) copied them saving their folder structure in cacti folder
3) some samenamed files were replaced
4) made "patch" command with success result on 1 file and "they are already new" on 2 others

Then I reread manual and began creating task in task manager that would be running under my user.

Then I rechecked and changed permissions according to the table of folders and permissions in the end of manual (permitted all needed to "my user").

But I have no user IUSR_ in my system and don't know what to write instead (I think it's for IIS?).

Now I have working logs. And If I use cmd.php I get such errors:

Code: Select all

08/13/2008 03:39:01 PM - SYSTEM STATS: Time:1.1525 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:48 RRDsProcessed:0  
08/13/2008 03:39:01 PM - CMDPHP: Poller[0] ERROR: The PHP Script: CMD.PHP Must be started using the full path to the file and in lower case. This is a PHP Bug!!!  
If I use Spine - nothing happens. I have no graphs yet.(

And rra folder still contains only .placeholder file.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

1) Yes, IUSR_ and IIS_WPG accounts are for IIS installations. Apply the security for these user accounts to the account which runs your Apache service (it IS running under a non-system account for security, right?).

2) Don't forget to apply the needed security to things which your scheduled task user will run under too.

3) For the Poller[0] ERROR, do either of the messages apply to you?

4) Don't bother using spine until cmd.php and your cacti installation is fully functional.

5) Did you follow the all the troubleshooting steps in the ** README BEFORE POSTING ** Sticky ?
Mymoon
Posts: 8
Joined: Fri Aug 08, 2008 7:15 am

Post by Mymoon »

I've checked permissions once again, changed Apache service runner to "my user". Now I'm continuing reading of manuals in search of something helpful, but i've found such code in cmd.php:

Code: Select all

if ($config["cacti_server_os"] == "win32") {
	/* check PHP versions first, we know 5.2.0 and above is fixed */
	if (version_compare("5.2.0", PHP_VERSION, ">=")) {
		$guess = substr(__FILE__,0,2);
		if ($guess == strtoupper($guess)) {
			$response = "ERROR: The PHP Script: CMD.PHP Must be started using the full path to the file and in lower case.  This is a PHP Bug!!!";
			print "\n";
			cacti_log($response,true);

			record_cmdphp_done();
			exit("-1");
		}
	}
}
i've got error because of it? script supposes that i have some file named with upper cased letters? why it checks 5.2.0 and higher if comment talks that for those versions all is clear. Is it nevermind?
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Mymoon wrote:i've got error because of it? script supposes that i have some file named with upper cased letters? why it checks 5.2.0 and higher if comment talks that for those versions all is clear. Is it nevermind?
Well just go ahead and upgrade php to something higher than 5.2.0, the error should go away if its simply a logic bug. If not, then you do have some other issue which is stated in the error message.
Mymoon
Posts: 8
Joined: Fri Aug 08, 2008 7:15 am

Post by Mymoon »

Yes. The reason was PHP version.
After I upgraded to 5.2.6 - rrd files were created and error with PHP bug disapeared.

I can finally see graphs) But they are blank.

I'll continue my research in manuals, but what is:

Code: Select all

08/14/2008 02:34:13 PM - CMDPHP: Poller[0] Host[4] DS[20] WARNING: Result from SNMP not valid. Partial Result: 
?
Mymoon
Posts: 8
Joined: Fri Aug 08, 2008 7:15 am

Post by Mymoon »

Graphs are working :) They are not blank, i was wrong.
So, everybody, don't use 5.2.0 and earlier PHP.
And if your graphs are without letters and names - don't forget to fill rrdtool fonts for them in Settings -> Visual.

Thanks BSOD2600 :)
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests