[Solved] Geolocation with Google API not working

I notice there seem to be a number of posts on this subject that have been closed off without resolution, however I have hit the same problem and have discovered what the issue is.

The "config" table in MySQL is supposed to contain two entries for "direct_url" and "reverse_url", except it doesn't, so the API calls fail. I only discovered this after switching from the default Geolocation to Google, so I'm not sure if these entries were never there or blown away when I changed to Google.

I added the correct API Endpoint URLs to "config" table and now Google API works. I don't really want to change things now its working, so not sure if the issue would occur again if I change the API provider.

Needs investigation by the developers as to why the API Endpoints are missing when you install a vanilla Observium CE or change API provider in the GUI.

I can't see anything in any documentation to say I should have to do anything other than change the API provider in the GUI, so I would expect the code to be setting the correct API Endpoint URLs for me.