Hi, I installed Zabbix-server 6.0 on CentOS Stream 9 with MariaDB 10.5 and I get the following error when starting zabbix-server:
I also had a problem with zabbix when I changed the MariaDB path from /var/lib/mysql to /home/lib/mysql. The mariadb service still runs fine, however when I restart zabbix-server it fails. If I go back to the original MariaDB path it works fine.
Does anyone have any solution?
This is my.cnf config file:
[mysqld]
datadir=/home/lib/mysql
socket=/home/lib/mysql/mysql.sock
bind-address = localhost
innodb_force_recovery = 3
key_buffer_size=128M
read_buffer_size=128M
read_rnd_buffer_size=256M
innodb_log_buffer_size=256M
innodb_buffer_pool_size=1G
query_cache_type=2
max_allowed_packet=1G
max_connections=1500
net_read_timeout=3600
net_write_timeout=3600
net_buffer_length=1000000
thread_cache_size=256
log_error = /var/log/mariadb/error.log
general_log_file = /var/log/mariadb/mysql.log
[client]
port=3306
socket=/home/lib/mysql/mysql.sock
[mysqldump]
max_allowed_packet=1024M
#
[client-server]
And
/etc/my.cnf.d/mariadb-server.cnf
[mysqld]
datadir=/home/lib/mysql
socket=/home/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
pid-file=/run/mariadb/mariadb.pid
And
/etc/zabbix/zabbix_server.conf
I also had a problem with zabbix when I changed the MariaDB path from /var/lib/mysql to /home/lib/mysql. The mariadb service still runs fine, however when I restart zabbix-server it fails. If I go back to the original MariaDB path it works fine.
Does anyone have any solution?
This is my.cnf config file:
[mysqld]
datadir=/home/lib/mysql
socket=/home/lib/mysql/mysql.sock
bind-address = localhost
innodb_force_recovery = 3
key_buffer_size=128M
read_buffer_size=128M
read_rnd_buffer_size=256M
innodb_log_buffer_size=256M
innodb_buffer_pool_size=1G
query_cache_type=2
max_allowed_packet=1G
max_connections=1500
net_read_timeout=3600
net_write_timeout=3600
net_buffer_length=1000000
thread_cache_size=256
log_error = /var/log/mariadb/error.log
general_log_file = /var/log/mariadb/mysql.log
[client]
port=3306
socket=/home/lib/mysql/mysql.sock
[mysqldump]
max_allowed_packet=1024M
#
[client-server]
And
/etc/my.cnf.d/mariadb-server.cnf
[mysqld]
datadir=/home/lib/mysql
socket=/home/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
pid-file=/run/mariadb/mariadb.pid
And
/etc/zabbix/zabbix_server.conf
Comment