Mautic stops fetching GeoLite2 data

Product Support
1

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.

2

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

Example: memory_limit = ???M

3

That worked. thanks for tip.

4

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)|

5

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…

6

Is this solution still working in 2022?

7

Please read the official documentation: