Struggling to install Proxy 7.4 on Raspbian 12

[jetro]

Hello everyone,
for 2 days I tried everything to install a Zabbix Proxy 7.4 on a Raspberry Pi 3B+ with, as suggested, Raspbian 12 Bookworm (arm64).

The simplest and best way seem to be with SQLite3, but I get this error on the log when trying to start the service:

732:20251106:011321.040 using configuration file: /etc/zabbix/zabbix_proxy.conf
732:20251106:011321.042 cannot open database file "zabbix_proxy": [2] No such file or directory
732:20251106:011321.042 creating database ...
732:20251106:011321.043 [Z3001] connection to database 'zabbix_proxy' failed: [0] unable to open database file
732:20251106:011321.043 cannot initialize database: cannot open database
736:20251106:011333.283 Starting Zabbix Proxy (active) [Test_Raspi]. Zabbix 7.4.5 (revision c525822dce0).
736:20251106:011333.283 **** Enabled features ****
736:20251106:011333.283 SNMP monitoring: YES
736:20251106:011333.283 IPMI monitoring: YES
736:20251106:011333.284 Web monitoring: YES
736:20251106:011333.284 VMware monitoring: YES
736:20251106:011333.284 ODBC: YES
736:20251106:011333.284 SSH support: YES
736:20251106:011333.284 IPv6 support: YES
736:20251106:011333.284 TLS support: YES
736:20251106:011333.284 **************************
736:20251106:011333.284 using configuration file: /etc/zabbix/zabbix_proxy.conf
736:20251106:011333.286 cannot open database file "zabbix_proxy": [2] No such file or directory
736:20251106:011333.286 creating database ...
736:20251106:011333.288[Z3001] connection to database 'zabbix_proxy' failed: [0] unable to open database file
736:20251106:011333.288 cannot initialize database: cannot open database

Searching it on the web there are some comments asking to try manually creating the db with commands like

sqlite3 /var/lib/zabbix/proxy.db < /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql

but the file seem not existing on my system, neither with the official documentation there is anything similar on my system

cat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.dbcat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.db

Also tried with MySQL but there is an other bunch of problems and I don't think it's the best solution on a Pi.

Thank you so much

Jetro

[troffasky]

cat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.dbcat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.db

Have you created a file called 'zabbix.dbcat' by mistake?

[cyber]

Have you created a file called 'zabbix.dbcat' by mistake?

I gues its just a "double paste" ..

sqlite does not require schema creation beforehand.. as your log also says "Cannot open database file -> creating database". question is, where does it want to create it and whats the access restrictions there...:P

[jetro]

Confirm it's a double paste!
That's a good assumption... May be an idea reinstalling raspbian with "zabbix" as default user?

[jetro]

Tried installing with user "zabbix" on a fresh Raspbian 12 and while trying to restart the service, again:

Job for zabbix-proxy.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status zabbix-proxy.service" and "journalctl -xeu zabbix-proxy.service" for details.

And the same error in the log.

[mariusl]

What is your configured DBName? Make sure that the zabbix user has access to read and write the directory and that it exists. The database file itself is created automatically.

[jetro]

I never configured a DBName, do I have to? I assumed it was automated too