Lost access to templates after upgrade

[Tod Sandman]

I am upgrading from Zabbix 4.0 LTS to the latest 6.4 (Red Hat Enterprise Linux: 7.9 -> 9.2; Postgresql 12 -> 15; nginx; Zabbix RPMs from Zabbix repo; 3700 Hosts).

After fresh installation I pg_dump'ed the Zabbix database from the old to new server, fired up Zabbix, and the database was successfully upgraded with no error messages.

The only issue I have seen so far appears to be with Template permissions and most likely involves the new "Template Group" functionality introduced in version 6.2. I can view all my hosts, look at latest data, etc. However:

* No templates show up under Data collection->Templates;

* No templates show up the in a host's configuration;

* under items and triggers, "Inaccessible template" is shown where a template belongs.

I assume I need to update each User group's "Template permissions" to provide access to the required templates. However, I can't find a way to view the list of available templates.

To debug further I have created a "Super Admins" group, added the "Admin" user, and given this group read-write access to all Template groups and all Host groups. And while I have created a template group named "Templates-4.0", I can find no way to add any templates to this group (since I cannot gain access to the templates in the first place).

How can I gain access to the existing templates?

[Tod Sandman]

I have resolved my issue. After importing the production database to the new server, I set the "status" of all hosts to 1 (unmonitored host). My intention was to disable my ~4000 hosts before firing up the zabbix-server. The closest to database schema documentation I can find is the Zabbix API documentation, which mentions 0 for monitored hosts, 1 for unmonitored host. Now I realize that the "hosts" table contains hosts and templates, and a template apparently is determined with a status of 3.

[danil_]

I have resolved my issue. After importing the production database to the new server, I set the "status" of all hosts to 1 (unmonitored host). My intention was to disable my ~4000 hosts before firing up the zabbix-server. The closest to database schema documentation I can find is the Zabbix API documentation, which mentions 0 for monitored hosts, 1 for unmonitored host. Now I realize that the "hosts" table contains hosts and templates, and a template apparently is determined with a status of 3.

Thanks a lot for you note! I acted the same way during upgrade and got the same issue. I easily fixed it when I read this.