RRD files never created

bobbers · Post by **bobbers** » Thu Aug 16, 2007 8:28 pm

Good evening all,

So i am out of my element on this install, as ive never installed Cacti on a windows box... And man i miss my linux =(. To get to the point, i installed the latest versions of cacti, apache, mysql, rrdtool onto a winxp sp2 box... Graphs are never generated...

*rrd files are never created... looking into it closer and turning debug on and running for a single cycle i see 'Waiting on 1/1 pollers,' for quite awhile...

Logs show this repeating indef... I looked into the DB and bolded items are the returned value:

Code: Select all

08/16/2007 09:17:30 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"   [b]3[/b]
08/16/2007 09:17:30 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"  [b]0.8.6j[/b]
08/16/2007 09:17:09 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"  [b]1[/b]
08/16/2007 09:17:09 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"  [b]admin[/b]
08/16/2007 09:17:09 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"

Any one have any suggestions on how to resolve this... I tried searching and googling but... Honestly a little stuck on what to search for lol... Maybe tomorrow when i wake up, it wlil come to me.

bobbers · Post by **bobbers** » Thu Aug 16, 2007 8:37 pm

A friend of mine who is a bit more awake than i pointed out the last log as having no output... all the others i used phpmyadmin to manually check the results... once i get back to that PCs location i will run it and see what the output is........

BSOD2600 · Post by **BSOD2600** » Thu Aug 16, 2007 9:01 pm

1) read the installation guide in my signature
2) manually run: php cmd.php once, to check for errors. I bet it complains about a php path issue -- look in my FAQ how to fix.

bobbers · Post by **bobbers** » Thu Aug 16, 2007 9:07 pm

will go over your howto guide tomorrow morning... However i am running it from command line and only error message im getting is that its timing out at 292 or was it 295 seconds. thanks for the suggestions will see if i find something i missed via your install guide.

bobbers · Post by **bobbers** » Mon Aug 20, 2007 1:58 pm

Wiped out my install after confirming it was correct.. Just incase i may have missed something in the guide. Went through the guide you link to. Still getting this message. Looks like i may have done the exact same mistake twice? Or maybe should downgrade my install of PHP or MySQL...

Apache 2.2.4
PHP 5.2.3
cacti 0.8.6j
MySQL 5.0.45

Poller still times out after looping 'Waiting on 1/1 pollers.

Code: Select all

C:\>php c:\inetpub\wwwroot\cacti\poller.php
08/20/2007 02:44:36 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 2]
Waiting on 1/1 pollers.
~~~~~~~~~~~~~~~~~~~~~~~
Waiting on 1/1 pollers.
PHP Fatal error:  Maximum execution time of 293 seconds exceeded in C:\inetpub\wwwroot\cacti\poller.php on line 238

SQL statements still looping

Code: Select all

08/20/2007 02:52:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1" 08/20/2007 02:52:38 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"  
08/20/2007 02:52:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"  
08/20/2007 02:52:38 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"  
08/20/2007 02:52:38 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"

BSOD2600 · Post by **BSOD2600** » Mon Aug 20, 2007 2:19 pm

2) manually run: php cmd.php once, to check for errors. I bet it complains about a php path case issue -- look in my FAQ how to fix.

bobbers · Post by **bobbers** » Wed Aug 22, 2007 2:43 pm

So after noticing that i was doing poller.php and not CMD.php i got the error... However scanning through your install guide i never saw your note on how to resolve the issue... I went through the forums via the search function and found a previous post by you.... Prior to posting a "hey you didnt have that in your FAQ!" i did a quick search. And indeed found it.

If you are open to suggestions, could you do another bold item with the PHP path/lower case error message? Just trying to help others reading the guide.

Got my install working, thanks for your assistance.

BSOD2600 · Post by **BSOD2600** » Wed Aug 22, 2007 10:57 pm

bobbers wrote:If you are open to suggestions, could you do another bold item with the PHP path/lower case error message? Just trying to help others reading the guide.

Do you mean to change the following entry in my FAQ? or something else?

Q: When attempting to run poller.php you get, This script is only meant to run at the command line.
A: Most likely caused by a misconfiguration in your php.ini file. Make sure the following is set in it:register_argc_argv = On
safe_mode = Off
Another possibility is a logic bug in cmd.php only present in Cacti 0.8.6j and PHP 5.2. Open cmd.php and go to line 49. Change it to:if (version_compare("5.2.0", PHP_VERSION, ">=")) {

bobbers · Post by **bobbers** » Thu Aug 23, 2007 7:25 am

Correct, adding an additional Q. with the A. being "Open cmd.php and go to line 49. Change it to:if ....."

RRD files never created

RRD files never created

Who is online