No graph, no rrd files

[bodoe]

Recently installed cacti 0.8.6j on a RedHat ES server. Been trying to, in the easiest way possible display a graph of something, without using snmp.

I get no graph at all. Every time I try to display a graph the webserver logfile says

"ERROR: opening '/usr/share/cacti/rra/...' No such file or directory"

Not to often the Cacti log says (once today):

FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in include/config.php
ERROR: SQL Cell Failed "select cacti from version"

I have checked:

• * SELinux disabled
  * Write permission to /usr/share/cacti/rra folder
  * Execute permissions to scripts in /usr/share/cacti/scripts folder
  * Crontab file changed according to isntallation notes with username and path
  * Changed username and password in php config file

[gandalf]

When not using snmp, please leave community string of targets empty. You may want to increase max_connections of /etc/my.cnf to sth like 500 if you're running short of connections
Reinhard

[bodoe]

When not using snmp, please leave community string of targets empty.

This was already done.

You may want to increase max_connections of /etc/my.cnf to sth like 500 if you're running short of connections
Reinhard

Would this not have effect first after that I have created graphs?

Thanks for the help anyway!

When looking at what other have had to say regarding similar problems, some have solved them by reinstalling php together with mysql. Could this be the solution? What could the reason be to why no rrd-files are created?

[bodoe]

I have come closer to the solution, I think.

I followed the NaN guide and got stuck at the third step, couldn't find Host[<id>].

After some thinking I decided to run the poller by hand, and then the errors that followed the output said that the permission to write files were missing. I changed owner and permissions for the rra folder and now the cactiuser cold run the poller by hand and rrd files was created. Now I get a graph that is only updated if I run the poller by hand.
The commands in crontab file works works cactiuser, but never run automatically by crontab.

How can I check why crontab doesn't run the poller?

[bodoe]

Maybe one too many replies now, but this will perhaps be the last since I got it working now.

Things that helped: My hawk eye noticed that a space had been put in between * and /5 in the crontab file. And I realised that there is a log for crontab jobs

Another thing that could have created problems was the user name for my "cactiuser", it had a "-" like XXX-YYY. Not my choice of name, sometimes ' ' are needed around the name and sometimes not, which complicated things slightly.