Cacti Mysql Update

[faizxn]

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.

[netniV]

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]

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]

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]

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]

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]

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

[netniV]

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]

this is the error of log when i added the line..

[netniV]

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

Code: Select all

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

[Osiris]

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.