cannot update custom location
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?
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
hhm... got a lot of historical data I really do not wish to lose.
Other missing fields were :-
`bgpPeers` . `local_as` int(10) unsigned DEFAULT NULL, `status`. `status_map` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL
I have added the fields with no apparent ill effects and can now update custom locations.
-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: den 11 juni 2018 16:47 To: Observium Subject: Re: [Observium] cannot update custom location
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
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Adam Armstrong -
Rowlands Mark