Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Feb 15, 2019 11:11 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: cacti.data_source_stats_hourly_cache note
PostPosted: Mon Feb 11, 2019 1:14 pm 
Offline

Joined: Mon Feb 11, 2019 12:57 pm
Posts: 2
Dear All
I am new to this forums kindly help me i am dire need of help i am using cacti 8.8a i am running my system smoothly but today after power breakdown i am having trouble i can view live graphs but unable to see any other graphs
when i run this mysqlcheck --repair cacti -u root -p command
i get this message with these four tables

cacti.data_source_stats_hourly_cache
note : The storage engine for the table doesn't support repair
cacti.data_source_stats_hourly_last
note : The storage engine for the table doesn't support repair
cacti.plugin_flowview_dnscache
note : The storage engine for the table doesn't support repair
cacti.plugin_hmib_processes
note : The storage engine for the table doesn't support repair


Kindly help me in this regards i will be very grateful to you
:cry:


Top
 Profile  
 
 Post subject: Re: cacti.data_source_stats_hourly_cache note
PostPosted: Tue Feb 12, 2019 5:17 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2054
The message is really a MySQL issue, though the error that you are seeing is because of the InnoDB engine that is used for most of the tables does not need to repair it's tables because it uses the ACID compliant transactions with referential integrity. MyISAM on the other hand does need to be repaired so would not show the above errors when there are tables using that format.

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: cacti.data_source_stats_hourly_cache note
PostPosted: Wed Feb 13, 2019 10:15 am 
Offline

Joined: Mon Feb 11, 2019 12:57 pm
Posts: 2
Thanks netniV i figure that out and it is not more error message in my cacti but i am stuck in another problem that is real graph plugin showing graphs but no other are not and when i gave this rrdtool fetch <rrd file> AVERAGE it will show nan to every entry. When i use this

cd /var/www/html/rra

ls -l it shows root:root:filename.rrd
i am unable to change its ownership to cacti or apachi user
what is the exact issue how can i get my graph back without losing my historical data
Is there any way out?


Top
 Profile  
 
 Post subject: Re: cacti.data_source_stats_hourly_cache note
PostPosted: Wed Feb 13, 2019 11:20 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2054
You must use root to change the ownership/permissions of both files and the folders that they are held in.

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


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