ZABBIX BUGS AND ISSUES

case insensitive hostname search upon graph import

Details

  • Zabbix ID:
    RTF

Description

when importing graphs, frontend does something like :

SELECT DISTINCT i.itemid FROM items i,hosts h WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND ( (i.key_ IN ('network[3]')) ) AND h.hostid=i.hostid AND (h.host IN ('Template_Windows2')) LIMIT 1 OFFSET 0
SELECT DISTINCT i.*,h.host FROM items i,hosts h WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND ( (i.key_ IN ('network[3]')) ) AND h.hostid=i.hostid AND UPPER(h.host)='TEMPLATE_WINDOWS2'

the second query seems useless given that host names are supposed to be case sensitive

Activity

Hide
Pavels Jelisejevs added a comment - - edited

(1) Another import related issue in 1.8: I've created a host with an items and a graph and exported it. When I try to import it back, I receive an error:

Added new item "graph-host-clone1:item1"
Missing item [:] for host [graph-host-clone1]

<pavels> It seems I have a corrupt item. I can't reproduce it with a new one. CLOSED.

Show
Pavels Jelisejevs added a comment - - edited (1) Another import related issue in 1.8: I've created a host with an items and a graph and exported it. When I try to import it back, I receive an error: Added new item "graph-host-clone1:item1" Missing item [:] for host [graph-host-clone1] <pavels> It seems I have a corrupt item. I can't reproduce it with a new one. CLOSED.
Hide
Pavels Jelisejevs added a comment - - edited

RESOLVED for 1.8 in svn://svn.zabbix.com/branches/dev/ZBX-4097.

Show
Pavels Jelisejevs added a comment - - edited RESOLVED for 1.8 in svn://svn.zabbix.com/branches/dev/ZBX-4097.
Hide
Alexey Fukalov added a comment - - edited

(1)
zbx_strtoupper function calls should be removed too.

<pavels> RESOLVED.

<Vedmak> CLOSED

Show
Alexey Fukalov added a comment - - edited (1) zbx_strtoupper function calls should be removed too. <pavels> RESOLVED. <Vedmak> CLOSED
Hide
Pavels Jelisejevs added a comment -

Fixed in 1.8.16rc1 in r30185.

Show
Pavels Jelisejevs added a comment - Fixed in 1.8.16rc1 in r30185.
Hide
Pavels Jelisejevs added a comment -

RESOLVED for 2.0 in svn://svn.zabbix.com/branches/dev/ZBX-4097.

Show
Pavels Jelisejevs added a comment - RESOLVED for 2.0 in svn://svn.zabbix.com/branches/dev/ZBX-4097.
Hide
Pavels Jelisejevs added a comment -

Fixed in 2.0.4rc1 r30604 and 2.1.0 r30605.

CLOSED.

Show
Pavels Jelisejevs added a comment - Fixed in 2.0.4rc1 r30604 and 2.1.0 r30605. CLOSED.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: