Details
-
Bug
-
Resolution: Fixed
-
Minor
-
None
-
Professional Edition
-
Version Information
Observium 18.7.9334 (10th July 2018)
OS Linux 4.13.0-45-generic [amd64] (Ubuntu 16.04)
Apache 2.4.18 (Ubuntu)
PHP 7.0.30-0ubuntu0.16.04.1 (OPcache: ENABLED)
Python 2.7.12
MySQL 5.7.22-0ubuntu0.16.04.1 (extension: mysqli 5.0.12-dev)
SNMP NET-SNMP 5.7.3
RRDtool 1.5.5
Fping 3.13 (IPv4 and IPv6)Version Information Observium 18.7.9334 (10th July 2018) OS Linux 4.13.0-45-generic [amd64] (Ubuntu 16.04) Apache 2.4.18 (Ubuntu) PHP 7.0.30-0ubuntu0.16.04.1 (OPcache: ENABLED) Python 2.7.12 MySQL 5.7.22-0ubuntu0.16.04.1 (extension: mysqli 5.0.12-dev) SNMP NET-SNMP 5.7.3 RRDtool 1.5.5 Fping 3.13 (IPv4 and IPv6)
Description
We have a port group with association ruleset "port.ignore equals 0" that is returning 0 ports in the group. Previously this group contained ~600 ports.
Tried inverting the association to "port.ignore equals 1", and also had 0 ports.
/opt/observium/db.log has several messages:
[2018/07/20 12:50:05 -0400] discovery.php(32553): Failed dbQuery (#1052 - Column 'ignore' in where clause is ambiguous), Query: SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE( ``.`ignore` = '0') AND `ports`.`deleted` != '1'
We tried running the query shown in the log in the observium DB directly. If we modify the query like this, it seems to work: "SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE( `ports`.`ignore` = '0') AND `ports`.`deleted` != '1'"
Unsure if related, but when we try to rebuild the group, it doesn't appear to work. We end up at http://observium.nepacil.local/groups_regenerate/action=update/ with message "Building Group Memberships"
Attachments
Issue Links
- is duplicated by
-
OBS-2733 Alert Creation Wizard (Port disabled entity)
- Closed