Graphs not showing in Red Hat 9 installation

[tovythomas]

Unfortunanently, my screenshots were too big for the post. Either way, I use the root user in crontab and all the directories have root ownership including the files that are in the rra directory.

[rony]

Either add a password for root, or prefered, add a user and password for the cacti database per the install instructions.

I don't know what effect a blank password would have, but security wise, you shouldn't run the poller as root.

[tovythomas]

I had initially tried setting up a user for this, but I have problems with the new user syntax in mysql.


shell> mysql --user=root mysql
mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'somepassword';
mysql> flush privileges;

When I type in the flush privileges, it brings me to another prompt with a > sign.

On the second line of this are you supposed to replace cactiuser with a user and somepassword with a password or is that just done in the include/config.php

Either way, I may work on setting up another user once I get this to record data.

[rony]

mysql> flush privileges;

Should say something about 0 records updated and bring you back to the mysql> prompt.

What version of mysql are you running?

[tovythomas]

I am using 3.23.58-1.9 version of mysql. That is the version I found when using synaptic in red hat.

So in regards to my previous post, can you give me an example of that syntax with a user if you were to create a new user. I would appreciate it. that way i can see what should be changed in the below code.


shell> mysql --user=root mysql
mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'somepassword';
mysql> flush privileges;

[tovythomas]

I have done a complete reinstall and the graphs are appearing. My main problem now is that my crontab will not run every 5 minutes as it is scheduled. If i run the poller manually, I am collecting data without a problem.

I have tried 2 different crontab entries.

1st I tried

*/5 * * * * root php /var/www/html/cacti/poller.php > /dev/null 2>&1 which I got from the installation notes.

I also tried the following

0,5,10,15,20,25,30,35,40,45,50,55 * * * * root php /var/www/html/cacti/poller.php > dev/null 2>&1 and this doesnt appear to work either.

[rony]

Use the full path to php.

[tovythomas]

I have tried this without success.

I have the syntax

*/5 * * * * root /usr/bin/php /var/www/html/cacti/poller.php > /dev/null 2>&1

Any other ideas or is my syntax wrong.

[TheWitness]

Try the following and then review the output file for errors.

TheWitness

Code: Select all

*/5 * * * * root /usr/bin/php /var/www/html/cacti/poller.php > /var/www/html/cacti/log/cactiout.txt 2>&1 

[tovythomas]

I tried this and it told me /bin/sh: line 1: root: command not found
I have modified the crontab entry so as to leave out the root user in the entry.
It now looks like this.

*/5 * * * * /usr/bin/php /var/www/html/cacti/poller.php

My modified cactiout.txt file now shows this

OK u:1.00 s:0.00 r:12.95
OK u:0.00 s:0.00 r:12.95
OK u:0.00 s:0.00 r:12.95
OK u:0.00 s:0.00 r:12.95
OK u:0.00 s:0.00 r:12.95
OK u:0.00 s:0.00 r:12.95
OK u:0.01 s:0.00 r:12.95
OK u:0.01 s:0.00 r:12.95
OK u:0.01 s:0.00 r:12.95
OK u:0.01 s:0.00 r:12.95
OK u:0.01 s:0.00 r:12.95
OK u:0.01 s:0.00 r:13.97
OK u:0.01 s:0.00 r:13.97
X-Powered-By: PHP/4.2.2^M
Content-type: text/html^M
^M
02/22/2005 12:05:32 PM - SYSTEM STATS: Time: 17.2866 s, Method: cmd.php, Processes: 1, Threads: N/A, Hosts: 6, Hosts/Process: 6

I am going to leave it run during lunch and see if it will update now.

[rony]

How are you editing the cron?

[tovythomas]

crontab -e

that is the only way i have ever done it.

[rony]

Ah yes, then the user entry is not needed. You only need that entry when you are editing /etc/crontab, to indicate what user to run it as. When you do a crontab -e, you editing the current user you are logged in as crontab.

[tovythomas]

Everything is working now. For some reason that syntax of having the root user in crontab wasnt neccessary in my redhat installation. My crontab already has root rights to it, so I it seems to be working.

Thanks to everyone who gave me advice. I appreciate it.