ZABBIX BUGS AND ISSUES
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-4097

case insensitive hostname search upon graph import

    Details

      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

          • Assignee:
            Pavels Jelisejevs
            Reporter:
            richlv
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: