Hello world
I started to realize that it might be better to have a zabbix-proxy at each location that relays all data back home to the main server so i can use passive agents in a better way instead of active agents from each client over a vpn tunnel
Each off-site location basically has Qnap NASes.
Good, then i would use the built in sql database (MariaDB) and with opkg install zabbix-proxy.
All fine, until i stumbled upon TLS issues with zabbix-proxy trying to connect to MariaDB.
(A lot of searching the web at this stage, so therefore i decided to make this post if anyone else gets into the same situation, hard to find more detailed info about this specific case)
I am also pretty new at configuring MariaDB...
Is there any way to skip TLS on zabbix-proxy for MariaDB?
DBTLSCONNECT=required or verify_full seems to be minimum defaults for MariaDB.
I do not want to mess too much with the confs on the qnaps systems with SSL and TLS in MariaDB, their autoconfigs could maybe make a mess if i do something on the front-end?
also.. the error in the log seems to be cut off? i saw the correct error in some other thread mentioning more info?
Suggestions?
I started to realize that it might be better to have a zabbix-proxy at each location that relays all data back home to the main server so i can use passive agents in a better way instead of active agents from each client over a vpn tunnel
Each off-site location basically has Qnap NASes.
Good, then i would use the built in sql database (MariaDB) and with opkg install zabbix-proxy.
All fine, until i stumbled upon TLS issues with zabbix-proxy trying to connect to MariaDB.
(A lot of searching the web at this stage, so therefore i decided to make this post if anyone else gets into the same situation, hard to find more detailed info about this specific case)
I am also pretty new at configuring MariaDB...
Is there any way to skip TLS on zabbix-proxy for MariaDB?
DBTLSCONNECT=required or verify_full seems to be minimum defaults for MariaDB.
I do not want to mess too much with the confs on the qnaps systems with SSL and TLS in MariaDB, their autoconfigs could maybe make a mess if i do something on the front-end?
also.. the error in the log seems to be cut off? i saw the correct error in some other thread mentioning more info?
Suggestions?
Code:
20599:20211124:125628.883 Starting Zabbix Proxy (active) [Zabbix-Proxy-xxxxxx]. Zabbix 5.0.7 (revision 1b3db7f980). 20599:20211124:125628.883 **** Enabled features **** 20599:20211124:125628.883 SNMP monitoring: NO 20599:20211124:125628.883 IPMI monitoring: NO 20599:20211124:125628.883 Web monitoring: NO 20599:20211124:125628.883 VMware monitoring: NO 20599:20211124:125628.883 ODBC: NO 20599:20211124:125628.883 SSH support: NO 20599:20211124:125628.883 IPv6 support: YES 20599:20211124:125628.883 TLS support: YES 20599:20211124:125628.883 ************************** 20599:20211124:125628.883 using configuration file: /opt/etc/zabbix_proxy.conf 20599:20211124:125628.884 [Z3001] connection to database 'zabbix_proxy' failed: [0] sslmode value "require" invalid when SSL support is not compiled in 20599:20211124:125628.885 database is down: reconnecting in 10 seconds 20599:20211124:125633.570 Got signal [signal:2(SIGINT),sender_pid:0,sender_uid:0,reason: 128]. Exiting ... 20599:20211124:125633.570 [Z3001] connection to database 'zabbix_proxy' failed: [0] sslmode value "require" invalid when SSL support is not compiled in 20599:20211124:125633.570 Cannot connect to the database. Exiting...
Comment