[ZBX-4097] case insensitive hostname search upon graph import Created: 2011 Sep 01  Updated: 2017 May 30  Resolved: 2012 Sep 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.15
Fix Version/s: 1.8.16rc1, 2.0.4rc1, 2.1.0

Type: Incident report Priority: Minor
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: xml
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 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



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2012 Sep 06 ]

(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.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Sep 06 ]

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

Comment by Alexey Fukalov [ 2012 Sep 10 ]

(1)
zbx_strtoupper function calls should be removed too.

<pavels> RESOLVED.

<Vedmak> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Sep 11 ]

Fixed in 1.8.16rc1 in r30185.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Sep 11 ]

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

Comment by Pavels Jelisejevs (Inactive) [ 2012 Oct 04 ]

Fixed in 2.0.4rc1 r30604 and 2.1.0 r30605.

CLOSED.

Generated at Fri Mar 29 09:47:48 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.