This change was made in update/354.sql
You can apply these manually, but likely if you've managed to have this not work, there are others that haven't worked, so I'd be inclined to nuke the whole lot and start again.
adam.
On 2018-06-11 15:20, Rowlands Mark wrote:
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? _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium