https://kb.rvmgroup.it/index.php?action=history&feed=atom&title=Upgrade_di_Zabbix_4.x_a_6.2 2026-06-20T06:47:53Z Revision history for this page on the wiki MediaWiki 1.44.2 https://kb.rvmgroup.it/index.php?title=Upgrade_di_Zabbix_4.x_a_6.2&diff=10892&oldid=prev 2023-02-02T16:55:09Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:55, 2 February 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>{{<del style="font-weight: bold; text-decoration: none;">sTUB</del>}}</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>{{<ins style="font-weight: bold; text-decoration: none;">Stub</ins>}}</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[https://www.zabbix.com/forum/zabbix-help/443739-help-restoring-a-zabbix-server-without-the-history-trend-tables Help Restoring a Zabbix Server without the History &amp; Trend Tables - ZABBIX Forums]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[https://www.zabbix.com/forum/zabbix-help/443739-help-restoring-a-zabbix-server-without-the-history-trend-tables Help Restoring a Zabbix Server without the History &amp; Trend Tables - ZABBIX Forums]</div></td></tr> </table>

Gabriele.vivinetto https://kb.rvmgroup.it/index.php?title=Upgrade_di_Zabbix_4.x_a_6.2&diff=10891&oldid=prev 2023-02-02T16:54:51Z

<p>Created page with &quot;{{sTUB}} *[https://www.zabbix.com/forum/zabbix-help/443739-help-restoring-a-zabbix-server-without-the-history-trend-tables Help Restoring a Zabbix Server without the History...&quot;</p> <p><b>New page</b></p><div>{{sTUB}}<br /> <br /> *[https://www.zabbix.com/forum/zabbix-help/443739-help-restoring-a-zabbix-server-without-the-history-trend-tables Help Restoring a Zabbix Server without the History &amp; Trend Tables - ZABBIX Forums]<br /> <br /> <br /> mysqldump --no-data zabbix &gt; zabbix_backup.sql<br /> <br /> mysqldump --no-create-info --ignore-table=zabbix.history --ignore-table=zabbix.history_uint --ignore-table=zabbix.history_text --ignore-table=zabbix.history_log --ignore-table=zabbix.history_str --ignore-table=zabbix.trends --ignore-table=zabbix.trends_uint zabbix &gt;&gt; zabbix_backup.sql<br /> <br /> <br /> docker compose exec mysql-server /bin/bash<br /> <br /> password root_pwd<br /> <br /> * import DB<br /> <br /> *[https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/447359-unable-to-initialize-mysql-database-in-6-2-per-documentation Unable to initialize mysql database in 6.2 per documentation - ZABBIX Forums]<br /> <br /> <br /> UPDATE mysql.user SET Super_Priv=&#039;Y&#039; WHERE user=&#039;zabbix1&#039; AND host=&#039;%&#039;;<br /> <br /> <br /> <br /> 7:20230126:110733.090 [Z3005] query failed: [1<br /> 419] You do not have the SUPER privilege and binary logging is enabled (you *might* wan<br /> t to use the less safe log_bin_trust_function_creators variable) [create trigger hosts_<br /> insert after insert on hosts<br /> zabbix-zabbix-server-1 | for each row<br /> zabbix-zabbix-server-1 | insert into changelog (object,objectid,operation,clock)<br /> zabbix-zabbix-server-1 | values (1,new.hostid,1,unix_timestamp())]<br /> zabbix-zabbix-server-1 | 7:20230126:110733.091 database upgrade failed<br /> zabbix-zabbix-server-1 | 7:20230126:110733.103 database could be upgraded to use primary keys in history tables<br /> <br /> *[https://hub.docker.com/r/zabbix/zabbix-server-mysql/ zabbix/zabbix-server-mysql - Docker Image | Docker Hub]<br /> <br /> vi env_vars/.env_srv <br /> ZBX_CACHESIZE=2G<br /> <br /> <br /> <br /> *[https://www.zabbix.com/documentation/current/en/manual/installation/upgrade_notes_620#secure-password-hashing 10 Upgrade notes for 6.2.0]<br /> <br /> <br /> UPDATE users SET passwd = &#039;$2a$10$ZXIvHAEP2ZM.dLXTm6uPHOMVlARXX7cqjbhM6Fn0cANzkCQBWpMrS&#039; WHERE username = &#039;Admin&#039;;<br /> <br /> After running this query, the user&#039;s password will be set to zabbix. Make sure to change the default password on the first login.<br /> <br /> PROXY<br /> <br /> Installare 6.2<br /> <br /> pfsense<br /> *[https://www.zabbix.com/forum/zabbix-help/399461-zabbix-troubles-on-pfsense Zabbix troubles on PFsense - ZABBIX Forums]<br /> rm /var/db/zabbix-proxy/zabbix.db</div>

Gabriele.vivinetto