Zabbix on Raspberry pi 4

[dade]

Hello guys,

I'm trying to deploy Zabbix on my Raspberry Pi 4, but i can't import zabbix schemas to MariaDB. I used the command "zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p'zabbixDBpass' zabbix" and it never finish. I waited for 9 hours and nothing, it just processing yet.

How i can solve this ?

notes:

Raspberry pi 4, 4g ram
32gb Sd card
Zabbix-server and MariaDB are installed on same raspberry


i have this configuration on my /etc/mysql/mariadb.conf.d/10_my_tweaks.cnf:


[mysqld]
max_connections = 454
innodb_buffer_pool_size = 1G (ps. i have already tested with 400m too )

innodb-log-file-size = 128M
innodb-log-buffer-size = 128M
innodb-file-per-table = 1
innodb_buffer_pool_instances = 8
innodb_old_blocks_time = 1000
innodb_stats_on_metadata = off
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-flush-log-at-trx-commit = 2

tmp-table-size = 96M
max-heap-table-size = 96M
open_files_limit = 65535
max_connect_errors = 1000000
connect_timeout = 60
wait_timeout = 28800

thanks!

[Hamardaban]

Unpack the «create.sql.gz» file. The «create.sql» text file contains SQL commands. Connect to your database (mysql -uzabbix -p'zabbixDBpass' zabbix) and try to execute these commands sequentially.

[dade]

Thanks for your reply, i ll test it

[Imelda]

I’m trying to figure out if there is a way to use macros for the SNMP context and both passwords? I know I can setup some global macros or template specific macros, What I’m trying to accomplish is to auto populate the SNMPv3 values with the macros I created? I hope this makes sense and I don’t even know if it’s possible Prepaid Card Status

[dade]

So, Hamardaban, i tried what you said but it didnt work. =(

[Ondricka]

To follow this article, you will need the following things to set up your Raspberry Pi 4 in headless mode:

1. A Raspberry Pi 4 single-board computer
2. A USB Type-C power adapter
3. A 16 GB or higher capacity microSD card with Raspberry Pi OS flashed
4. Network connectivity on the Raspberry Pi 4
5. A laptop or a desktop computer for VNC remote desktop access to the Raspberry Pi 4

If you don’t want to set up your Raspberry Pi 4 in headless mode, you will also need:

1. A monitor
2. An HDMI or micro-HDMI cable
3. A keyboard
4. A mouse
5. KrogerFeed

[markfree]

dade , are you following the official guide?
Did you check the "database creation" contents?

My suggestion is to start over following those docs and tweek DB only after a successful installation.

[dade]

The problem was i trying to create DB on SD Card and it's a bad idea. I created a db on usb drive and worked. Ty all!