openSUSE Build Service

Overview Repositories Revisions Requests Users Attributes Meta

File README-DB.SUSE of Package zabbix

c. Create initial database
Documentation

Make sure you have database server up and running.

Run the following on your database host.
# mysql -uroot -p
password
mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin;
mysql> create user zabbix@localhost identified by 'password';
mysql> grant all privileges on zabbix.* to zabbix@localhost;
mysql> set global log_bin_trust_function_creators = 1;
mysql> quit;

On Zabbix server host import initial schema and data. You will be prompted to enter your newly created password.
# zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

Under openSUSE:
cat /usr/share/doc/packages/zabbix-server/mysql/schema.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
cat /usr/share/doc/packages/zabbix-server/mysql/images.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
cat /usr/share/doc/packages/zabbix-server/mysql/data.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

Disable log_bin_trust_function_creators option after importing database schema.
# mysql -uroot -p
password
mysql> set global log_bin_trust_function_creators = 0;
mysql> quit;
d. Configure the database for Zabbix server

Edit file /etc/zabbix/zabbix_server.conf
DBPassword=password
e. Start Zabbix server and agent processes

Start Zabbix server and agent processes and make it start at system boot.
# systemctl restart zabbix-server zabbix-agent httpd php-fpm
# systemctl enable zabbix-server zabbix-agent httpd php-fpm
f. Open Zabbix UI web page

The default URL for Zabbix UI when using Apache web server is http://host/zabbix

Places

File README-DB.SUSE of Package zabbix

Places