Access all the locations in LibreNMS by clicking on “Devices > Geo Locations > All Locations”
This will bring up all the locations in LibreNMS. To remove a unused location, hit delete. Note: to be able to delete a device, there must be no devices using that location.
The locations are stored in the LibreNMS locations table
mysql -u librenms -p librenms
To list all the locations
select * from locations;
Set the specific coordinates for a location using the following command.
Replace the lat and lng, also the id should match the line your wanting to update.
update locations set lat = "33.5140",lng = "-86.8178" where id=25;