Orta?!

On 02/12/2014 04:58 PM, Scott Brawner wrote:
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