Currently trying to track down an issue because of unexpected database growth for Zabbix, (5.0, postgres 12.9) and I can see the audit log even of a value being changed in the housekeeper, but the notes are truncated in the web ui and the API, so I went digging in the database, and it appears to be because that column has an arbitrary 128 char length limit.
So instead of being able to see the entire committed changes, all I see is:
So this seems like an obvious oversight into the database schema creation, and I feel like this should probably be extended to something that can fully encapsulate the data, or find another way to store the data so that it is accessible in the audit logs.
I would think that Zabbix wants the audit logs to be truly useful for actually auditing what changed, not just a breadcrumb you can point to that shows something changed, but not what changed.
I'm not sure if this same limitation exists for MySQL, or even if this change was made in 5.2 or 5.4, but that doesn't really help someone using 5.0 LTS at this point.
So instead of being able to see the entire committed changes, all I see is:
Code:
note ---------------------------------------------------------------------------------------------------------------------------------- Trigger event and alert data storage period "180d".; Internal event and alert data storage period "1d".; Network discovery ev...
So this seems like an obvious oversight into the database schema creation, and I feel like this should probably be extended to something that can fully encapsulate the data, or find another way to store the data so that it is accessible in the audit logs.
I would think that Zabbix wants the audit logs to be truly useful for actually auditing what changed, not just a breadcrumb you can point to that shows something changed, but not what changed.
I'm not sure if this same limitation exists for MySQL, or even if this change was made in 5.2 or 5.4, but that doesn't really help someone using 5.0 LTS at this point.
Comment