Support of MySQL MEDIUM TEXT data type

[[email protected]]

Is there a reason that history_log and history_text value column is limited to the TEXT data type in MySQL (65535 bytes). I have a need to store data that is longer than that for an item. Is it possible to modify the source code, and if so how/where? Is this possible for a future release? My C programming skills are limited so any help would be appreciated. I'm attempting to use Zabbix to support a feature that Solar Winds has, router config backup and real time config change detection. However I have router configs that far exceed 65535 bytes in length.

[kloczek]

If you only want to detect the change storing whole cfg is really bad approach.
Just calculate md5 or sha-256 or bigger hash key and store this hash key as string.
Something like:

$ cat /etc/passwd | md5sum | cut -d" " -f1
68adf6005daa06cb521dbdf3d478a82e
$ cat /etc/passwd | sha256sum | cut -d" " -f1
8262ea4c06132822de2d5c7137559981c60f05b304a10cdacd8893df75da9176

Any changes in hash key value will mean that cfg has been changed.

[[email protected]]

Possibly but I need to satisfy a couple of other requirements. A daily backup (if needed), and also capture the config after a change is detected to run a diff against to generate a diff report.

[kloczek]

I think that using zabbix as cfg backup tool is a bit bizarre .

[[email protected]]

how so? if you're already monitoring that something changed, why not capture what changed. why go reinvent the wheel with another tool when this one will do it (if it supported > 65535 bytes of char data). It's no different than running an external script item to capture some data to regex against...or ssh command against a device to get some info and inspect. just happens to be a router config, which i'm already monitoring every other thing on that router. like i said, i'm trying to get zabbix to do something solar winds does quite well, i'd rather use zabbix to do it.

[ashf]

I need this support too please -

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/429946-history-value-truncated

[[email protected]]

I answered in your link to other thread...