pre installation checks

[robertkwild]

hi all,

so i have installed cacti but getting some errors/warnings on the pre installation checks

date.timezone >= Error A valid timezone that matches MySQL and the system

ERROR: Your MySQL TimeZone database is not populated. Please populate this database before proceeding.

collation_server utf8mb4_general_ci =

max_heap_table_size 16 M >= 46.69 M

tmp_table_size 16 M >= 46.69 M

join_buffer_size 0.25 M >= 93.37 M

and loads of innodb errors, mostly because im using an SSD thats wht the note says

thanks,
rob

[macan]

https://docs.cacti.net/Install-Under-CentOS_LAMP.md

populate timezone article

[robertkwild]

ok lol, im installing this on a debian LAMP and on that how to its not there

thanks

[robertkwild]

trying to do that command

root@cacti01:/var/www/html/cacti/include# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -ppassword cacti
ERROR 1146 (42S02) at line 10: Table 'cacti.time_zone' doesn't exist

[robertkwild]

job done

for timezone

grant select on mysql.time_zone_name to cacti@localhost;

for mysql settings
/etc/mysql/mariadb.conf.d/50-server.cnf

max_heap_table_size = 47M
tmp_table_size = 47M
join_buffer_size = 94M
innodb_file_format = Barracuda
innodb_large_prefix = 1
innodb_buffer_pool_size = 730M
innodb_doublewrite = OFF
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16
innodb_io_capacity = 5000
innodb_io_capacity_max = 10000
collation-server = utf8mb4_unicode_ci

for php stuff
/etc/php/7.4/cli/php.ini
/etc/php/7.4/fpm/php.ini
/etc/php/7.4/apache2/php.ini

date.timezone = Europe/London

[ikhsanuus]

https://docs.cacti.net/Install-Under-CentOS_LAMP.md

populate timezone article

thanks man, i halft day fir this problem, i have set for Asia/Jakarta time