Mautic stops fetching GeoLite2 data

Your software
My Mautic version is: 2.15.3
My PHP version is: 7.2.24

Your problem
My problem is:
Mautic has stopped fetching GeoLite2 data. Whenever I request an update on the configuration settings page, the wheel just keeps turning and turning.

POSSIBLE CULPRIT: This install of Mautic was a new install in a new directory and the old install was completely deleted. However, I see in the logs that mautic is somehow referencing the old install and the clue was the “joomla” reference. Somehow, the new install is still referencing a single old directory path. However, those directories are now gone and where gone when I installed the new install.

Additionally, I can’t find information anywhere on the location on my server where these files are stored so I could attempt some troubleshooting. It would be nice to have a readily available tech note somewhere on where these files are stored, how a user might manually download and troubleshoot.
Thank you.

These errors are showing in the log: most recent after request for GeoLite2:

DON’T KNOW WHY JOOMLA IS LISTED IN THE ERROR LOGS BELOW - THERE ARE OTHER JOOMLA DIRECTORIES BUT NOT WHERE MAUTIC IS INSTALLED:

[2019-11-12 09:57:07] mautic.ERROR: PHP Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 29353872 bytes) - in file /home/xxxx/public_html/XXXXXX.com/vendor/joomla/http/src/Transport/Curl.php - at line 222
[2019-11-12 09:57:07] mautic.ERROR: Symfony\Component\Debug\Exception\OutOfMemoryException: Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 29353872 bytes) - in file /home/xxxx/public_html/xxxxxx.com/vendor/joomla/http/src/Transport/Curl.php - at line 222
[2019-11-12 09:57:07] mautic.CRITICAL: Uncaught PHP Exception Symfony\Component\Debug\Exception\OutOfMemoryException: “Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 29353872 bytes)” at /home/xxxx/public_html/xxxxx.com/vendor/joomla/http/src/Transport/Curl.php line 222 {“exception”:"[object] (Symfony\Component\Debug\Exception\OutOfMemoryException(code: 0): Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 29353872 bytes) at /home/xxxxx/public_html/xxxx.com/vendor/joomla/http/src/Transport/Curl.php:222)"}

Steps I have tried to fix the problem: attempt to locate geolite data and troubleshoot and examine logs.

Increase PHP’s memory limit. You’re running out of memory.

Example: memory_limit = ???M

That worked. thanks for tip.

I setup account at Maxmind for the geoip database geolite2-city; got License key and account/user ID

This is where Mautic says I should get the file:
http://geolite.maxmind.com/download/geoip/database/geolite2-city.mmdb.gz

Below are the databases Maxmind lists to download. So Which of these database do I download?

|GeoLite2-ASN|GeoLite2 ASN|GeoIP2 Binary (APIs)|2020-02-04|GZIP (MD5)|
|GeoLite2-ASN-CSV|GeoLite2 ASN: CSV Format|GeoIP2 CSV (docs)|2020-02-04|ZIP (MD5)|
|GeoLite2-City|GeoLite2 City|GeoIP2 Binary (APIs)|2020-02-04|GZIP (MD5)|
|GeoLite2-City-CSV|GeoLite2 City: CSV Format|GeoIP2 CSV (docs)|2020-02-04|ZIP (MD5)|
|GeoLite2-Country|GeoLite2 Country|GeoIP2 Binary (APIs)|2020-02-04|GZIP (MD5)|
|GeoLite2-Country-CSV|GeoLite2 Country: CSV Format|GeoIP2 CSV (docs)|2020-02-04|ZIP (MD5)|

I have recently created a step by step guide to help Mautic users with the Madmind GeoIP and Geolite2 automated database updates.

Hope it helps…

Is this solution still working in 2022?

Please read the official documentation: