Observium 8.6.9263 (10th June 2018) OS Linux 4.4.0-116-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 10.1.25-MariaDB-1~xenial (extension: mysqli 5.0.12-dev) SNMP NET-SNMP 5.7.3 RRDtool 1.5.5 (rrdcached 1.5.5: unix:/var/run/rrdcached.sock) Fping 3.13 (IPv4 and IPv6)
Don't know how long the problem has existed but I do not seem to be able to update custom locations. I select custom location, slide the switch to "on" and enter in a custom location and hist "save changes" I get a confirmation that this change will not be visible until the poller cycle has run.
I have enabled sql logging and see :-
Query INSERT INTO `entity_attribs` (`device_id`,`entity_type`,`entity_id`,`attrib_type`,`attrib_value`) VALUES ('606','device','606','override_sysLocation_string','kungsbron 21, stockholm')
But
MariaDB [observium]> describe entity_attribs; +--------------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+-----------------------------+ | attrib_id | int(11) | NO | PRI | NULL | auto_increment | | entity_type | varchar(32) | NO | MUL | NULL | | | entity_id | int(11) | NO | MUL | NULL | | | attrib_type | varchar(128) | NO | | NULL | | | attrib_value | text | NO | | NULL | | | updated | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------+--------------+------+-----+-------------------+-----------------------------+
No device_id
So I downloaded a fresh instance of observium
+--------------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+-----------------------------+ | attrib_id | int(11) | NO | PRI | NULL | auto_increment | | device_id | int(11) | YES | MUL | NULL | | | entity_type | varchar(32) | NO | MUL | NULL | | | entity_id | int(11) | NO | | NULL | | | attrib_type | varchar(128) | NO | | NULL | | | attrib_value | text | NO | | NULL | | | updated | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------+--------------+------+-----+-------------------+-----------------------------+
But
root@papp01-mon:/opt/observium# ./discovery.php -u
Observium Professional 18.6.9264 http://www.observium.org -- Database is up to date.
So how do I fix this?