I realised my Maxmind database file wasn’t updating. After adding in my license key, I can now download the maxmind database file no problem. But I’m left wondering - is there a way to update the Location (country/city) of existing contacts in my system?
There doesn’t seem to be a cron method available for this. But I have over 8000 contacts with the city/country fields missing. Now maxmind is properly set up, I’d like to populate these fields.
My Mautic version is: 3.2.4
My PHP version is: v7.3.27
My Database type and version is: Ver 15.1 Distrib 10.3.27-MariaDB
I just looked into the ip_addresses and lead_ips_xref tables. I thought I could use your script idea to replace the ip_details content in the ip_addresses table, but the majority of the IPs seem to be set at 127.0.0.1. Strange (I don’t have ‘IP anonymization’ set up):
MariaDB> select count(*) from ip_addresses where ip_details = "N;";
| count(*) |
| 7615 |
MariaDB> select count(*) from ip_addresses where ip_details = "N;" and ip_address != "127.0.0.1";
| count(*) |
| 249 |
So while I thought the initial problem was that my IP addresses weren’t getting geo-populated, it seems like a bigger issue is that a large majority of IPs are set to 127.0.0.1. I thought it might be because of an nginx front end acting as reverse proxy (see this) but I don’t think so (although I have changed servers in the past 6 months, and things appear to be working now).