Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Tue Jan 23, 2018 10:36 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Cacti Mysql Update
PostPosted: Tue Jan 02, 2018 10:19 am 
Offline

Joined: Tue Jan 02, 2018 8:33 am
Posts: 5
I am getting following error at cacti 1.1.29 version. but when i try to update mysql.cnf .. then mysql shows an error and does not restart the mysql server.


Attachments:
cacti_error.png
cacti_error.png [ 107.89 KiB | Viewed 157 times ]
Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Tue Jan 02, 2018 3:23 pm 
Offline
Cacti User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 349
If you are using MySQL, then it is usually better to create a new configuration file such as zzz_cacti.cnf with the changes that you need in the /etc/mysql/mysql.conf.d folder

_________________
Cacti Resources:
Cacti Website
Cacti Issues
Cacti Releases

My resources:
How to submit Pull Requests
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Wed Jan 03, 2018 7:56 am 
Offline

Joined: Tue Jan 02, 2018 8:33 am
Posts: 5
thank you for ur kind reply. i did change the configuration as per ur suggestion. but error still did not update. and another thing would it possible to add WeatherMap at this latest version???????


Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Wed Jan 03, 2018 8:20 am 
Offline
Cacti User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 349
Howard Jones is working on weathermap but I'm not sure it's 100% ready. You can get the latest version from his repo

What is the error you are using?

_________________
Cacti Resources:
Cacti Website
Cacti Issues
Cacti Releases

My resources:
How to submit Pull Requests
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Thu Jan 04, 2018 12:46 pm 
Offline

Joined: Tue Jan 02, 2018 8:33 am
Posts: 5
when I try to add this configuration

max_heap_table_size = 98M
tmp_table_size = 64M
join_buffer_size = 64M
innodb_buffer_pool_size = 485M
innodb_doublewrite = off
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16

then mysql does not restart. it shows an error that mysqld.sock not found.


Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Thu Jan 04, 2018 4:17 pm 
Offline
Cacti User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 349
That configuration should have a section header such as [mysqld]. The error about the socket would suggest that mysql is already running. Have you checked your process list?

_________________
Cacti Resources:
Cacti Website
Cacti Issues
Cacti Releases

My resources:
How to submit Pull Requests
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Sat Jan 06, 2018 8:11 am 
Offline

Joined: Tue Jan 02, 2018 8:33 am
Posts: 5
did it also.. but no effects has changed..


Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Sat Jan 06, 2018 9:37 am 
Offline
Cacti User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 349
Have you seeing any errors then? Check your /var/logs/messages

Do you have anything else using MySQL on the system? If not we could force a package removal and reinstall to get to defaults. You would need to move your configuration file away to ensure that doesn’t cause any issues.

_________________
Cacti Resources:
Cacti Website
Cacti Issues
Cacti Releases

My resources:
How to submit Pull Requests
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Tue Jan 09, 2018 6:48 am 
Offline

Joined: Tue Jan 02, 2018 8:33 am
Posts: 5
this is the error of log when i added the line..


Attachments:
re.139.png
re.139.png [ 81.09 KiB | Viewed 72 times ]
Top
 Profile  
 
 Post subject: Re: Cacti Mysql Update
PostPosted: Tue Jan 09, 2018 7:20 am 
Offline
Cacti User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 349
Try using grep to filter out the parts that don't really matter:
Code:
grep -v "\[Note\]" error.log

_________________
Cacti Resources:
Cacti Website
Cacti Issues
Cacti Releases

My resources:
How to submit Pull Requests
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  [ 10 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


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