Jack Bates | 7 Jun 2012 21:13

Re: poller_item table in cacti.sql missing rows for default, localhost device?

On 28/05/12 11:47 AM, Jack Bates wrote:
> I'm having some trouble creating RRD files for the default, localhost
> graphs included in cacti.sql
>
> I extracted Cacti 0.8.8a, created a database, and populated it with "$
> mysql -u cacti -p cacti<  cacti.sql". Then I visited my Cacti URL and
> walked through the web based installer, which completed successfully
>
> At this point I notice there is a default, localhost device that I guess
> is included in cacti.sql? I added a bunch of additional devices and
> graphs, then I checked the Cacti "rra" directory and notice that it is
> still empty, no RRD files are created yet for either the default,
> localhost graphs or the graphs added by me
>
> Finally I run poller.php and notice that the Cacti "rra" directory is
> now full of RRD files for all the graphs added by me, but *not* for
> default, localhost graphs. When I visit the default, localhost device
> with the web interface, I see a list of graphs by no images
>
> I repeated this procedure a couple times, even on a couple different
> servers, with identical results. I assume that poller.php should create
> RRD files for the default, localhost graphs, in addition to the graphs
> added by me? Or is there another installation step that I'm missing
> where the default, localhost RRD files are created? What's the
> difference between the default, localhost graphs and the graphs added by
> me, such that poller.php creates RRD files for the latter, but not the
> former? Can I provide any more information?

After further investigation I think this problem is due to the 
poller_item table in cacti.sql missing rows corresponding to the 
default, localhost device, in cacti.sql. Running 
cli/rebuild_poller_cache.php resolves the problem. Is this an 
installation step I missed?

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

Gmane