Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Wed Aug 16, 2017 10:31 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Understanding CACTI Database Schema
PostPosted: Fri Oct 21, 2016 2:45 pm 
Offline

Joined: Fri Oct 21, 2016 2:31 pm
Posts: 2
Hi everyone,

I am building a portal to integrate the output of several monitoring tools, one of them is CACTI.

I need to export data from cacti and insert that data in a MySQL database. later on I will use that data to define monitoring KPIs and paint their evolution in visualization charts.

Is there any documentation that explains CACTI database schema? I've found the schema but no explanation about it and how CACTI stores data there. For instance I would like to identify the different counters and their associated polling data.

I really appreciate your help.


Top
 Profile  
 
 Post subject: Re: Understanding CACTI Database Schema
PostPosted: Sat Oct 22, 2016 10:09 am 
Offline
Developer

Joined: Thu Apr 07, 2005 3:29 pm
Posts: 2604
Location: B/CS Texas
If your looking for the data thats in the graph, then its not in the database. Each data source is stored in an RRD file inside the RRA directory.

_________________
CactiEZ CD


Top
 Profile  
 
 Post subject: Re: Understanding CACTI Database Schema
PostPosted: Sun Oct 23, 2016 5:33 am 
Offline

Joined: Fri Oct 21, 2016 2:31 pm
Posts: 2
Thanks a lot, I know the data is in the rrd files but do I have to use the database to gather some other information such as the chart names or the counter names and properties?


Top
 Profile  
 
 Post subject: Re: Understanding CACTI Database Schema
PostPosted: Sun Oct 23, 2016 3:38 pm 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2598
Location: Kressbronn, Germany
Yes, you need the database for that information.

Have a look at the database schema here: http://docs.cacti.net/_media/manual:087 ... 0.8.7i.pdf

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group