[Solved] Cacti 1.2.22 Update MySQL Issues

[skywalker89]

I am trying to update cacti from 1.2.10 to 1.2.22 on Ubuntu 20.04.5 LTS. I am at the installation wizard and am having trouble getting the recommended MySQL System Variable settings to be set correctly.

So far, I have most of them corrected, except for the collation_server. It is set at latin1_swedish_ci and if I change this to the following (/etc/mysql/conf.d/mysql.cnf )

Code: Select all

[mysqld]
collation_server = utf8mb4_unicode_ci
innodb_file_per_table=ON
innodb_doublewrite=OFF
innodb_flush_log_at_timeout=3
innodb_read_io_threads=32
innodb_write_io_threads=16
innodb_buffer_pool_instances=2
innodb_io_capacity = 5000
innodb_io_capacity_max=10000

When I add the

collation_server = utf8mb4_unicode_ci line and restart the mysql service with

Code: Select all

sudo service mysql restart

Job for mysql.service failed because the control process exited with error code

systemctl status mysql.service

mysql.service: Control process exited, code=exited, status=1/F


I'm not sure how to get this updated to collation_server = utf8mb4_unicode_ci

[skywalker89]

It looks like I was able to figure this one out finally.

I added character-set-server=utf8mb4 and restarted mysql and it worked.

Code: Select all

character-set-server=utf8mb4
collation-server=utf8mb4_unicode