diff options
author | Aaron Andersen <aaron@fosslib.net> | 2020-08-17 10:07:53 -0400 |
---|---|---|
committer | Aaron Andersen <aaron@fosslib.net> | 2020-08-18 10:30:23 -0400 |
commit | 5e630bf5d391d4b61db6914991f1488f7ee20aff (patch) | |
tree | 5fe38428bf7260c924899269ebdc9d32c9927191 /nixos | |
parent | 927bd3e66553ffd1dfb19b11c464ff7664dfd0d5 (diff) | |
download | nixpkgs-5e630bf5d391d4b61db6914991f1488f7ee20aff.tar nixpkgs-5e630bf5d391d4b61db6914991f1488f7ee20aff.tar.gz nixpkgs-5e630bf5d391d4b61db6914991f1488f7ee20aff.tar.bz2 nixpkgs-5e630bf5d391d4b61db6914991f1488f7ee20aff.tar.lz nixpkgs-5e630bf5d391d4b61db6914991f1488f7ee20aff.tar.xz nixpkgs-5e630bf5d391d4b61db6914991f1488f7ee20aff.tar.zst nixpkgs-5e630bf5d391d4b61db6914991f1488f7ee20aff.zip |
zabbix: 4.4.8 -> 5.0.2
Diffstat (limited to 'nixos')
-rw-r--r-- | nixos/doc/manual/release-notes/rl-2009.xml | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/nixos/doc/manual/release-notes/rl-2009.xml b/nixos/doc/manual/release-notes/rl-2009.xml index 7a06c06fed1..0ba0ec8f89a 100644 --- a/nixos/doc/manual/release-notes/rl-2009.xml +++ b/nixos/doc/manual/release-notes/rl-2009.xml @@ -156,6 +156,40 @@ GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'localhost' WITH GRANT OPTION; Support for built-in LCDs in various pieces of Logitech hardware (keyboards and USB speakers). <varname>hardware.logitech.lcd.enable</varname> enables support for all hardware supported by the g15daemon project. </para> </listitem> + <listitem> + <para> + Zabbix now defaults to 5.0, updated from 4.4. Please carefully read through + <link xlink:href="https://www.zabbix.com/documentation/current/manual/installation/upgrade/sources">the upgrade guide</link> + and apply any changes required. Be sure to take special note of the section on + <link xlink:href="https://www.zabbix.com/documentation/current/manual/installation/upgrade_notes_500#enabling_extended_range_of_numeric_float_values">enabling extended range of numeric (float) values</link> + as you will need to apply this database migration manually. + </para> + <para> + If you are using Zabbix Server with a MySQL or MariaDB database you should note that using a character set of <literal>utf8</literal> and a collate of <literal>utf8_bin</literal> has become mandatory with + this release. See the upstream <link xlink:href="https://support.zabbix.com/browse/ZBX-17357">issue</link> for further discussion. Before upgrading you should check the character set and collation used by + your database and ensure they are correct: +<programlisting> + SELECT + default_character_set_name, + default_collation_name + FROM + information_schema.schemata + WHERE + schema_name = 'zabbix'; +</programlisting> + If these values are not correct you should take a backup of your database and convert the character set and collation as required. Here is an + <link xlink:href="https://www.zabbix.com/forum/zabbix-help/396573-reinstall-after-upgrade?p=396891#post396891">example</link> of how to do so, taken from + the Zabbix forums: +<programlisting> + ALTER DATABASE `zabbix` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; + + -- the following will produce a list of SQL commands you should subsequently execute + SELECT CONCAT("ALTER TABLE ", TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;") AS ExecuteTheString + FROM information_schema.`COLUMNS` + WHERE table_schema = "zabbix" AND COLLATION_NAME = "utf8_general_ci"; +</programlisting> + </para> + </listitem> </itemizedlist> </section> |