Hosts missing in configuration screens - 1.4.5

[mindas]

I have recently upgraded ZABBIX from 1.4.1 to 1.4.5 (package from Debian/sid). As I couldn't find whether any database upgrade scripts were needed, I assume there were none.

The server runs fine, however I cannot configure some parameters for hosts any more.

Example: if I go to Monitoring->Web, I can select group "Zabbix Servers" and host "Zabbix Server", which shows web checks configured. However, if I go to Configuration->Web, there are only two groups ("all" and "Templates") while none of these contain "Zabbix Server". This is also the case for Configuration->Hosts, Configuration->Items, Configuration->Triggers but not for Configuration->Graphs (this screen shows all hosts correctly). What gives?

Can anyone give a clue? I'm using "Admin" user which is a member of "Zabbix administrators" group. Can provide any other data if needed.

Thanks in advance.

Regards,
Mindaugas

[mindas]

Any ideas, anyone? This is quite urgent...
I'm trying to convince people to use Zabbix and problems like this doesn't really help

[mindas]

Replying to my own post...

If I go to Administration->Users and click on "Show rights" I see most of my hosts being read only. This could be the root of the problem.

But this is quite strange as I'm logged in with Admin user which is "ZABBIX Super Admin" and belongs to all possible groups in the system (isn't it supposed to access everything?). I have also tried to create another user with the same credentials, but the results are the same.

Regards,
Mindaugas

[mindas]

Still no replies

I've done some troubleshooting by myself, here are my findings:
- when I login with Admin user or any other user with all possible rights, I see most of host groups and hosts as read-only (!!!). I can't change those groups nor their relationships.
- I've set the mysql server to log the SQL statements, and monitored what queries are executed when viewing users.php. It is clear that get_accessible_groups_by_rights PHP function is executed which retrieves all the permission stuff. Here are the queries:

select n.nodeid as nodeid,n.name as node_name, g.*, 0 as permission from groups g left join nodes n on (g.groupid div 100000000000000)=n.nodeid where (g.groupid div 100000000000000) in (0) order by n.name, g.name

select n.*, 0 as permission from nodes n where n.nodeid in (0) order by n.name

select n.nodeid as nodeid,n.name as node_name,hg.groupid as groupid,h.* from hosts h left join hosts_groups hg on hg.hostid=h.hostid left join nodes n on n.nodeid=(h.hostid div 100000000000000) where (h.hostid div 100000000000000) in (0) order by n.name,h.host

select n.*, 0 as permission from nodes n where n.nodeid in (0) order by n.name

Not sure if this is correct or not, but my rights table only contains four records, and none of them is associated to the Admin user or another user having admin rights.

CAN anyone tell me at least a workaround how to get over this? I can't administer the system at all. Is there a setting in any php file so I could set a flag, etc?

[Aly]

Try to remove Super Admin user from any group!

[mindas]

That helped, thank you very much!!!

This also worked out for another user who had all groups assigned, not only Zabbix admin group.