Poller not polling

[strombrg]

Hi folks.

I have a deadline to get cacti working by the end of the week, and while I've got mysql going in some sense, and the web interface in some sense, the poller doesn't want to poll.

The instructions I was setting up cacti from told me to set up a cron job for poller.php, but that file doesn't seem to be on my system.

If I instead run poll.sh or php cmd.php, I get:

www-data@sand:/usr/share/cacti$ ./poll.sh
/usr/share/cacti/cmd.php
There are no items in your poller cache. Make sure you have at least one data source created. If you do, go to 'Utilities', and select 'Clear Poller Cache'.
time: 0
www-data@sand:/usr/share/cacti$ php cmd.php
There are no items in your poller cache. Make sure you have at least one data source created. If you do, go to 'Utilities', and select 'Clear Poller Cache'.
time: 0
www-data@sand:/usr/share/cacti$

I have 8 data sources defined at least in some sense.

Any suggestions? They'd be greatly appreciated!

PS: Yes, I googled, but I just found some stuff about data sources not being defined, and corrupted MySQL tables with the CVS version of Cacti.

[rony]

Have you "Cleared" you poller cache.

It really doesn't clear it, it really rebuilds it and shows you the results. Please post the results.

FYI, System Utitlies in the web interface.

[strombrg]

Yes, I've cleared the cache many times, though I just get:

View Poller Cache [0 Item]

...as a result, and the poll.sh and cmd.php scripts still give the same message.

Does it matter that I went to just "Utilities" and not "System" / "Utilities"?

Thanks!

[rony]

Ok, nothing in your poller cache, well that's bad....

Are your Data sources disabled?

[strombrg]

I don't know where to check if my data sources are disabled, but as I was looking around to see if they were, I ran across this "pathname" to an RRD file:

<path_rra>/cs1_optiputer_router_5min_cpu_10.rrd

...where am I supposed to specify this <path_rra> value, so I don't have to file it in again and again as I create data sources? Or am I?

Thanks!

[strombrg]

I went through and changed all the <path_rra>'s to /usr/local/cacti, and created a /usr/local/cacti directory that is writable by our web server's UID, but I'm still getting:

www-data@sand:~/html/cacti$ ./poll.sh
/usr/share/cacti/cmd.php
There are no items in your poller cache. Make sure you have at least one data source created. If you do, go to 'Utilities', and select 'Clear Poller Cache'.
time: 0
www-data@sand:~/html/cacti$

Also, I'm now noticing that I have no SNMP-related stuff for the host I added.

On the <path_rra> stuff, I went through and verified that I have a base_path defined, but maybe it's not being used?

Thanks!

[strombrg]

Is this a clue? It's from when I strace poll.sh:

[pid 6450] write(3, "$\0\0\0\3select * from data_input_data_cache", 40) = 40
[pid 6450] read(3, "4\0\0\1", 4) = 4
[pid 6450] read(3, "\377z\4Table \'cacti.data_input_data_cache\' doesn\'t exist", 52) = 52
[pid 6450] fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 12), ...}) = 0
[pid 6450] mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a9807f000
[pid 6450] write(1, "There are no items in your poller cache. Make sure you have at least one data source created. If you do, go to \'Utilities\', and select \'Clear Poller Cache\'.\n", 157There are no items in your poller cache. Make sure you have at least one data source created. If you do, go to 'Utilities', and select 'Clear Poller Cache'.
) = 157

...and I checked my list of tables under cacti within MySQL, and sure enough, no such table exists.

What should create it?

Thanks!

[strombrg]

This turned out to be because I was using the kubuntu version of cacti with the cacti.sql from the current stable version on the web downloads.

[rony]

kubuntu version of cacti

What is that?

[strombrg]

Kubuntu is an Ubuntu-based distribution with a KDE focus. I'd've chosen Ubuntu or Fedora Core, but it wasn't up to me.

Kubuntu appears to have Cacti 0.8.5a prepackaged and available via synaptic, but when I tried to combine that version with the cacti.sql from the version I downloaded from the Cacti website (0.8.6g), Cacti was Not Happy with me at al.

[rony]

Yah, 0.8.6a is very old..... Very old....

I would say manually install it.

[strombrg]

Thanks for the advice, and if I had it to do over again, I'd follow it. But my management (3 levels up!) wants this wrapped up very soon, so I think I'd better continue with the version that is part of Kubuntu for the time being.