community.zabbix icon indicating copy to clipboard operation
community.zabbix copied to clipboard

Published 20 hours ago • verified publisher icon ansible-collections

define postgresql_privs due to priv deprecated in postgresql_user module | Zabbix Proxy

Open mmayabi opened this issue 10 months ago • 4 comments

SUMMARY

When installing Zabbix Proxy with PostgreSQL, due to the deprecation of the "priv" parameter in the "community.postgresql.postgresql_user" module, the required permissions for "zabbix_proxy" are not defined. As a result, the schema import to the database is not performed. For this reason, the "priv" parameter has been removed, and a new task is defined using the "community.postgresql.postgresql_privs" module.

ISSUE TYPE
  • Bugfix Pull Request
COMPONENT NAME

PostgreSQL | GRANT ALL PRIVILEGES ON SCHEMA public TO zabbix_proxy user

ADDITIONAL INFORMATION

Tested on PostgreSQL 15.5 (Delegated)

mmayabi avatar Apr 23 '24 13:04 mmayabi

Seems related to https://github.com/ansible-collections/community.zabbix/issues/928

loricvdt avatar Apr 24 '24 14:04 loricvdt

@mmayabi check your tests....they are failing.

pyrodie18 avatar Apr 30 '24 02:04 pyrodie18

Does this issue also affect the Zabbix Server role?

CompPhy avatar Jun 13 '24 11:06 CompPhy

Does this issue also affect the Zabbix Server role?

I don't think so, I widely use zabbix_server role with PostgreSQL without any problems.

BGmot avatar Jun 13 '24 12:06 BGmot

@mmayabi are you going to work further on this PR?

BGmot avatar Jul 06 '24 17:07 BGmot