Hello,
I'm trying to do a three tiered zabbix setup with
- Zabbix server(Redhat 8 VM)
- Zabbix frontend(web server)(Redhat 8 VM) and
- Azure Database for PostgreSQL as a DBaaS
This idea of mine was, unfortunately, of a short life. Namely, it turned out that that Zabbix doesn't like Azure Database for PostgreSQL so i had to go with a VM((Redhat 8)with postgreSQL 12 on it). This worked very nice but I'd like to come to the resolution orf my initial intention.
I've configured a private endpoint for the DB managed service and allowed connection to it from Zabbix server and frontend side but i kept on getting following error msgs. The final one was [Z3001]
[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: permission denied for table users [select userid from users limit 1] cannot use database "zabbix": database is not a Zabbix database
[Z3001] connection to database zabbix failed: [0] could not connect to server: Connection refused Is the server running on host <IP> and accepting TCP/IP connections on port 5432?
Anybody out here tried such a setup and what are your experiences/recommendations?
Thanks in advance!!!
\w/
I'm trying to do a three tiered zabbix setup with
- Zabbix server(Redhat 8 VM)
- Zabbix frontend(web server)(Redhat 8 VM) and
- Azure Database for PostgreSQL as a DBaaS
This idea of mine was, unfortunately, of a short life. Namely, it turned out that that Zabbix doesn't like Azure Database for PostgreSQL so i had to go with a VM((Redhat 8)with postgreSQL 12 on it). This worked very nice but I'd like to come to the resolution orf my initial intention.
I've configured a private endpoint for the DB managed service and allowed connection to it from Zabbix server and frontend side but i kept on getting following error msgs. The final one was [Z3001]
[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: permission denied for table users [select userid from users limit 1] cannot use database "zabbix": database is not a Zabbix database
[Z3001] connection to database zabbix failed: [0] could not connect to server: Connection refused Is the server running on host <IP> and accepting TCP/IP connections on port 5432?
Anybody out here tried such a setup and what are your experiences/recommendations?
Thanks in advance!!!
\w/