This orta do it (for future reference)
USE observium;
SELECT location_lat, location_lon FROM devices;
UPDATE devices SET location_lat = NULL WHERE location_lat IS NOT NULL;
UPDATE devices SET location_lon = NULL WHERE location_lon IS NOT NULL;
Thanks,
Scott Brawner
-----Original Message-----
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam
Armstrong
Sent: Tuesday, February 11, 2014 8:37 PM
To: Observium Network Observation System
Subject: Re: [Observium] Geocoding
Modify the database and set the lat/lon to NULL for all devices and they'll
be re-set when they're re-polled, it's the quickest way.
We should include something in the UI to do this (and do a real-time lookup,
perhaps).
adam.
On 2014-02-11 08:52, Scott Brawner wrote:
OK I'll admit I was goofing around, in config.php I changed the
geocoding API setting from google to mapquest for like ten seconds.
Most of my sites are now clumped in the island off Portugal now. I've
tried editing the sysLocations and rediscovering/polling to no avail.
Halp!
Now what?
Best regards,
Scott Brawner
IS Manager - Infrastructure
Kratos Defense and Security Solutions, Inc.
o. 843-308-2364
m. 843-814-3912
_For every complex problem, there is a solution that is simple, neat,
and wrong. -- H. L. Mencken_
_______________________________________________
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
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium