Hello community 
I noticed following problem (it's a major problem for me)
Maps created as super admin, works just fine for super admin user. They work for admin and user as well, as long as it contains only images. If I link new element to host or map it's not even seen on drop down list in maps tab. (I try give to user RW rigrhts to ALL hostgroups to eliminate permision problem). For some reason, I see single map created in 1.6.6 in drop-down list, but if I choose it, i get the error:
Error in query [SELECT * FROM images WHERE imageid=] [You have an error in your SQL syntax; check the manual corresponds to your MySQL server version for the right syntax to use near '' at line 1] <-- could not copy&paste, its rewritten
We got the same error in production and test enviroment.
We fight with this problem 2 stright days, today we finished installing fresh 1.8 version (not an upgrade from 1.6.6) the same problem occurs
Steps we made:
Install 1.8
1)
Create group TESTGR with RW permision to ALL!!!! host groups
Create user "test" and put it in TESTGR group, set test as "user".
Login on test, dashbord OK, latest data ok, maps--> open LocalNetwor (only zabbix server as agent) and we have error;
Error in query [SELECT * FROM images WHERE imageid=] [You have an error in your SQL syntax; check the manual corresponds to your MySQL server version for the right syntax to use near '' at line 1]
2)
Log to super user "admin", add map "test" with only images
Log to user "test" checking the maps: Map "local network" with error, map test OK
3)
Log to super user "admin", link one of elements of map "test" to zabbix agent on Zabbix Server (the sam that is in default map "local network"
Log to user "test" checking the maps: Map "local network" with error, map test NOT EVEN on drop down list!!!
From database side:
In table rights all "permisons" are 3 (R/W) for all id (groups of hosts) for groupid equal id of TESTGR. All is ok!!!
The user test can see maps only when set in super admin.
Maps are very importentd for us, its the main reason that we decided to upgrade from 1.6.6 to 1.8.
Thanks to drag&drop of elements we created 15 very advanced maps, and when we try to give access to zabbix for the first time, user can't see any!!! Please help!
We use:
Prod:
Centos 5.4
Zabbix 1.6.6 -->1.8
mysql Server version: 5.0.77
PHP 5.2.9
Test:
Centos 5.4
Zabbix 1.6.6 -->1.8
mysql Server version: 5.1.41
PHP 5.3.1
I noticed following problem (it's a major problem for me)
Maps created as super admin, works just fine for super admin user. They work for admin and user as well, as long as it contains only images. If I link new element to host or map it's not even seen on drop down list in maps tab. (I try give to user RW rigrhts to ALL hostgroups to eliminate permision problem). For some reason, I see single map created in 1.6.6 in drop-down list, but if I choose it, i get the error:
Error in query [SELECT * FROM images WHERE imageid=] [You have an error in your SQL syntax; check the manual corresponds to your MySQL server version for the right syntax to use near '' at line 1] <-- could not copy&paste, its rewritten
We got the same error in production and test enviroment.
We fight with this problem 2 stright days, today we finished installing fresh 1.8 version (not an upgrade from 1.6.6) the same problem occurs
Steps we made:
Install 1.8
1)
Create group TESTGR with RW permision to ALL!!!! host groups
Create user "test" and put it in TESTGR group, set test as "user".
Login on test, dashbord OK, latest data ok, maps--> open LocalNetwor (only zabbix server as agent) and we have error;
Error in query [SELECT * FROM images WHERE imageid=] [You have an error in your SQL syntax; check the manual corresponds to your MySQL server version for the right syntax to use near '' at line 1]
2)
Log to super user "admin", add map "test" with only images
Log to user "test" checking the maps: Map "local network" with error, map test OK
3)
Log to super user "admin", link one of elements of map "test" to zabbix agent on Zabbix Server (the sam that is in default map "local network"
Log to user "test" checking the maps: Map "local network" with error, map test NOT EVEN on drop down list!!!
From database side:
In table rights all "permisons" are 3 (R/W) for all id (groups of hosts) for groupid equal id of TESTGR. All is ok!!!
The user test can see maps only when set in super admin.
Maps are very importentd for us, its the main reason that we decided to upgrade from 1.6.6 to 1.8.
Thanks to drag&drop of elements we created 15 very advanced maps, and when we try to give access to zabbix for the first time, user can't see any!!! Please help!
We use:
Prod:
Centos 5.4
Zabbix 1.6.6 -->1.8
mysql Server version: 5.0.77
PHP 5.2.9
Test:
Centos 5.4
Zabbix 1.6.6 -->1.8
mysql Server version: 5.1.41
PHP 5.3.1
Comment