Cacti Mysql Update

Support for the Plugin Architecture

Moderators: Moderators, Developers

Post Reply
Author
Message
faizxn
Posts: 7
Joined: Tue Jan 02, 2018 8:33 am

Cacti Mysql Update

#1 Post by faizxn » Tue Jan 02, 2018 10:19 am

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 1060 times

netniV
Cacti Guru User
Posts: 2782
Joined: Sun Aug 27, 2017 12:05 am

Re: Cacti Mysql Update

#2 Post by netniV » Tue Jan 02, 2018 3:23 pm

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

faizxn
Posts: 7
Joined: Tue Jan 02, 2018 8:33 am

Re: Cacti Mysql Update

#3 Post by faizxn » Wed Jan 03, 2018 7:56 am

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???????

netniV
Cacti Guru User
Posts: 2782
Joined: Sun Aug 27, 2017 12:05 am

Re: Cacti Mysql Update

#4 Post by netniV » Wed Jan 03, 2018 8:20 am

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?

faizxn
Posts: 7
Joined: Tue Jan 02, 2018 8:33 am

Re: Cacti Mysql Update

#5 Post by faizxn » Thu Jan 04, 2018 12:46 pm

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.

netniV
Cacti Guru User
Posts: 2782
Joined: Sun Aug 27, 2017 12:05 am

Re: Cacti Mysql Update

#6 Post by netniV » Thu Jan 04, 2018 4:17 pm

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?

faizxn
Posts: 7
Joined: Tue Jan 02, 2018 8:33 am

Re: Cacti Mysql Update

#7 Post by faizxn » Sat Jan 06, 2018 8:11 am

did it also.. but no effects has changed..

netniV
Cacti Guru User
Posts: 2782
Joined: Sun Aug 27, 2017 12:05 am

Re: Cacti Mysql Update

#8 Post by netniV » Sat Jan 06, 2018 9:37 am

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.

faizxn
Posts: 7
Joined: Tue Jan 02, 2018 8:33 am

Re: Cacti Mysql Update

#9 Post by faizxn » Tue Jan 09, 2018 6:48 am

this is the error of log when i added the line..
Attachments
re.139.png
re.139.png (81.09 KiB) Viewed 975 times

netniV
Cacti Guru User
Posts: 2782
Joined: Sun Aug 27, 2017 12:05 am

Re: Cacti Mysql Update

#10 Post by netniV » Tue Jan 09, 2018 7:20 am

Try using grep to filter out the parts that don't really matter:

Code: Select all

grep -v "\[Note\]" error.log

User avatar
Osiris
Cacti Pro User
Posts: 841
Joined: Mon Jan 05, 2015 10:10 am

Re: Cacti Mysql Update

#11 Post by Osiris » Thu Feb 08, 2018 9:46 pm

You will find a fatal error in the log file, it's generally associated with InnoDB settings. Just be patient and read the settings. Get to know how the /etc/my.cnf.d directory works. These settings belong in the server.cnf section under the [mysqld] section.
Before history, there was a paradise, now dust.

Post Reply