Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Recording Historical Data Possible??

 
Post new topic   Reply to topic    Cacti Forum Index -> Help: General
Author Message
pgb205



Joined: 10 Nov 2008
Posts: 17

PostPosted: Tue Nov 11, 2008 8:29 pm    Post subject: Recording Historical Data Possible?? Reply with quote

so that every time poller polls devices on my network all the information retrieved would be recorded to mysql database. So for example if I'm monitoring interface for traffic, every time the OID is polled, that informaiton would be inserted into a table in mysql with time stamp and UID of the interface. This way I can retrieve this information later for graphing purposes etc. Is this possible? Or maybe it's already done in cacti, but I can't find the table which has this data.

thanks
Back to top
gandalf
Developer


Joined: 02 Dec 2004
Posts: 12642
Location: Muenster, Germany

PostPosted: Wed Nov 12, 2008 3:53 pm    Post subject: Reply with quote

This is done using table poller_output. On each polling circle, this table is filled with data. Then, the data is updated into rrd files (that's why cacti is an rrdtool frontend) and deleted from that table.
You may want to intercept this step, but this is definitively a user mod.
You may want to consult 1st link of my sig to understand cacti's principles of operation
Reinhard
Back to top
pgb205



Joined: 10 Nov 2008
Posts: 17

PostPosted: Thu Nov 13, 2008 9:50 am    Post subject: Reply with quote

yep thats what i did. created a new table called historical. and every time cmd.php writes to pollet_output i also modified it to db_execute to historical.

now a simple matter of manipulating this information with sql.

thanks
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Help: General All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group