Cacti Mysql Update
Moderators: Developers, Moderators
Cacti Mysql Update
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 (107.89 KiB) Viewed 14773 times
Re: Cacti Mysql Update
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 Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Re: Cacti Mysql Update
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???????
Re: Cacti Mysql Update
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?
What is the error you are using?
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Re: Cacti Mysql Update
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.
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.
Re: Cacti Mysql Update
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 Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Re: Cacti Mysql Update
did it also.. but no effects has changed..
Re: Cacti Mysql Update
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.
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 Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Re: Cacti Mysql Update
this is the error of log when i added the line..
- Attachments
-
- re.139.png (81.09 KiB) Viewed 14688 times
Re: Cacti Mysql Update
Try using grep to filter out the parts that don't really matter:
Code: Select all
grep -v "\[Note\]" error.log
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Re: Cacti Mysql Update
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.
Who is online
Users browsing this forum: No registered users and 0 guests