Hello,
I have downloaded the MaxMind GeoIP files, extracted them, and uploaded the following files (not folders) directly into:
wp-content/plugins/matomo/
The files are:
GeoLite2-ASN.mmdbGeoLite2-Country.mmdbGeoLite2-City.mmdb
I have also made sure that the MaxMind License Key has been entered correctly. I am using the free MaxMind GeoLite2 database.
Matomo Cron Error: An error occurred while updating the geolocation database. See error details in the Diagnostics page.
Regarding PHP CLI and MySQLi, I have reverted the settings back to their default configuration. Could you please provide me with step-by-step instructions on exactly which settings/extensions I need to enable, including the recommended configuration for my setup?
For caching, I am only using LiteSpeed Cache. I am not using any security plugins such as Wordfence.
For your reference, my server is running DirectAdmin Control Panel with PHP 8.5. My current PHP CLI version is:
PHP 8.5.6 (cli) (built: May 9 2026 00:00:00) (NTS)
Zend Engine v4.5.6
with the ionCube PHP Loader v15.5.0
with Zend OPcache v8.5.6
I have also included the latest Diagnostics System Report below, together with the relevant screenshots, for your reference.
Please review the diagnostics and screenshots and let me know if there are any additional PHP extensions, PHP CLI settings, MySQLi settings, permissions, or server configurations that I should enable or adjust.
# Matomo
* Matomo Plugin Version: 5.12.1
* Config exists and is writable.: Yes ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" )
* JS Tracker exists and is writable.: Yes ("$abs_path/wp-content/uploads/matomo/matomo.js" )
* Plugin directories: Yes ([{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins\/matomo\/plugins","webrootDirRelativeToMatomo":"..\/plugins"}])
* Tmp directory writable: Yes ($abs_path/wp-content/uploads/matomo/tmp)
* Matomo Version: 5.12.0
* Matomo Blog idSite: 1
* Matomo Install Version: 5.12.1 (Install date: 2026-08-09 14:04:14)
* Upgrades outstanding: No
* Upgrade in progress: No
* Current Matomo User Language: en
* Current Matomo Language Cookie Value: None
## Endpoints
* Matomo JavaScript Tracker URL: ($site_url/wp-content/uploads/matomo/matomo.js)
* Matomo JavaScript Tracker - WP Rest API: ($site_url/wp-json/matomo/v1/hit/)
* Matomo HTTP Tracking API: ($site_url/wp-content/plugins/matomo/app/matomo.php)
* Matomo HTTP Tracking API - WP Rest API: ($site_url/wp-json/matomo/v1/hit/)
## Crons
* Server time: 2026-08-21 09:45:43
* Blog time: 2026-08-21 09:45:43 (Below dates are shown in blog timezone)
* Sync users & sites: Next run: 2026-08-21 14:05:10 (4 hours 19 min) ( Last started: 2026-08-21 08:53:39 (-52 min 4s). Last ended: 2026-08-21 08:53:42 (-52 min 1s). Interval: daily)
* Archive: Next run: 2026-08-21 10:04:26 (18 min 43s) ( Last started: 2026-08-21 09:04:32 (-41 min 11s). Last ended: 2026-08-21 09:04:33 (-41 min 10s). Interval: hourly)
* Update GeoIP DB: Next run: 2026-08-22 09:00:15 (23 hours 14 min) ( Last started: 2026-08-21 09:00:13 (-45 min 30s). Last ended: 2026-08-21 09:00:15 (-45 min 28s). Interval: matomo_monthly)
## Mandatory checks
* PHP version >= 7.2.5: ok
* PDO extension: ok
* PDO\MYSQL extension: ok
* MYSQLI extension: ok
* Other required extensions: ok
* Required functions: ok
* Required PHP configuration (php.ini): ok
* Directories with write access: ok
## Optional checks
* 64-bit PHP Binary: ok
* Tracker status: ok
* Memory limit: ok
* Time zone: ok
* Open URL: ok
* GD > 2.x + FreeType (graphics): ok
* Other extensions: ok
* Other functions: ok
* Filesystem: ok
* Last Successful Archiving Completion: ok
* Database abilities: ok
* Max Packet Size: ok
* Geolocation: ok
* Update over HTTPS: ok
* Mobile Messaging SMS Provider: ok
* Supports Async Archiving: No
* Async Archiving Disabled in Setting: No
* Location provider ID: geoip2php
* Location provider available: Yes
* Location provider working: Yes
* Had visit in last 5 days: Yes
* Matomo URL: Yes ($site_url/wp-content/plugins/matomo/app/)
## Matomo Settings
* Track mode: default
* Track ecommerce: Yes
* Track codeposition: footer
* Track api endpoint: default
* Track js endpoint: default
* Version history: 5.12.1
* Core version: 5.12.0
* Last settings update: 1787305537
* Last tracking settings update: 1787250123
* Track noscript: Yes
* Track content: all
* Track search: Yes
* Track 404: Yes
* Track ai bots: Yes
* Track ai bots using esi: Yes
* Track across: Yes
* Track crossdomain linking: Yes
* Track feed: Yes
* Track feed addcampaign: Yes
* Track user id: username
* Track jserrors: Yes
* Delete all data uninstall: No
* Show get started page: 0
## Logs
* update_geoip2: 2026-08-16 07:11:37 (GeoIP2AutoUpdater: failed to unzip '$abs_path/wp-content/uploads/matomo/tmp/latest/GeoIP2-City.mmdb.tar.gz.download' after downloading 'https://download.maxmind.com/app/geoip_download?edition_id=GeoLite2-City&suffix=tar.gz&license_key=asdsdojb_mmasdsa': Couldn't list content for '$abs_path/wp-content/uploads/matomo/tmp/latest/GeoIP2-City.mmdb.tar.gz.download': Invalid block size : 20 => GeoIP2AutoUpdater.php:150; GeoIP2AutoUpdater.php:86; ScheduledTasks.php:286; class-wp-hook.php:339; class-wp-hook.php:365; plugin.php:570; wp-cron.php:191;)
* update_geoip2: 2026-08-17 12:01:31 (GeoIP2AutoUpdater: failed to unzip '$abs_path/wp-content/uploads/matomo/tmp/latest/GeoIP2-City.mmdb.tar.gz.download' after downloading 'https://download.maxmind.com/app/geoip_download?edition_id=GeoLite2-City&suffix=tar.gz&license_key=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': The downloaded file is not a valid geolocation database. Please re-check the URL or download the file manually. => GeoIP2AutoUpdater.php:150; GeoIP2AutoUpdater.php:86; ScheduledTasks.php:286; SystemReport.php:192; SystemReport.php:352; MatomoPage.php:41; class-wp-hook.php:341; class-wp-hook.php:365; plugin.php:522; admin.php:264;)
* update_geoip2: 2026-08-21 09:00:15 (GeoIP2AutoUpdater: failed to unzip '$abs_path/wp-content/uploads/matomo/tmp/latest/GeoIP2-City.mmdb.tar.gz.download' after downloading 'https://download.maxmind.com/app/geoip_download?edition_id=GeoLite2-City&suffix=tar.gz&license_key=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': Couldn't list content for '$abs_path/wp-content/uploads/matomo/tmp/latest/GeoIP2-City.mmdb.tar.gz.download': Invalid block size : 20 => GeoIP2AutoUpdater.php:150; GeoIP2AutoUpdater.php:86; ScheduledTasks.php:286; class-wp-hook.php:351; class-wp-hook.php:377; plugin.php:571; wp-cron.php:191;)
# WordPress
* Home URL: $site_url
* Site URL: $site_url
* WordPress Version: 7.1
* Number of blogs: 13
* Multisite Enabled: Yes
* Network Enabled: Yes
* WP_DEBUG: No
* WP_DEBUG_DISPLAY: Yes
* WP_DEBUG_LOG: No
* DISABLE_WP_CRON: -
* FORCE_SSL_ADMIN: Yes
* WP_CACHE: Yes
* CONCATENATE_SCRIPTS: -
* COMPRESS_SCRIPTS: -
* COMPRESS_CSS: -
* ENFORCE_GZIP: -
* WP_LOCAL_DEV: -
* WP_CONTENT_URL: $site_url/wp-content
* WP_CONTENT_DIR: $abs_path/wp-content
* UPLOADS: -
* BLOGUPLOADDIR: -
* DIEONDBERROR: -
* WPLANG: -
* ALTERNATE_WP_CRON: -
* WP_CRON_LOCK_TIMEOUT: 60
* WP_DISABLE_FATAL_ERROR_HANDLER: -
* MATOMO_SUPPORT_ASYNC_ARCHIVING: -
* MATOMO_ENABLE_TAG_MANAGER: -
* MATOMO_SUPPRESS_DB_ERRORS: -
* MATOMO_ENABLE_AUTO_UPGRADE: -
* MATOMO_DEBUG: -
* MATOMO_SAFE_MODE: -
* MATOMO_GLOBAL_UPLOAD_DIR: -
* MATOMO_LOGIN_REDIRECT: -
* Permalink Structure: /%postname%/
* Possibly uses symlink: No
* Upload base url: $site_url/wp-content/uploads
* Upload base dir: $abs_path/wp-content/uploads
* Upload url: $site_url/wp-content/uploads/2026/08
* Custom upload_path:
* Custom upload_url_path:
* Compatible content directory: Yes
* WP_Filesystem Initialized: Yes
* Warning System Cron Set Up: No (Warning: Your WordPress site does not appear to have a system cron job set up to run the WordPress cron. Matomo uses the WordPress cron to generate reports and to delete temporary data to provide compliance with various privacy regulations (e.g., GDPR). Without a system cron job set up, these tasks may be run irregularly or infrequently, which could lead to personal data being retained longer than allowed. To avoid this, we recommend setting up a system cron job to run the WordPress cron regularly. Contact your hosting provider if you require help with this.)
* Current User Locale: en_US
# WordPress Plugins
* Akismet Anti-spam: Spam Protection: 5.7.2
* Contact Form 7: 6.1.7
* Flamingo: 2.6.4
* hCaptcha for WP: 5.2.0
* IndexNow: 1.0.4
* JetBackup: 3.1.23.3
* LiteSpeed Cache: 7.9
* Matomo Analytics - Ethical Stats. Powerful Insights.: 5.12.1
* Matomo Marketplace for WordPress: 1.2.1
* Slim SEO: 4.9.11
* SureCookie: 1.3.1
* WordPress Automatic Plugin: 3.137.1
* WordPress Importer: 0.9.5
* Active Plugins: 7 (backup:3.1.23.3 contact-form-7:6.1.7 flamingo:2.6.4 hcaptcha-for-forms-and-more:5.2.0 indexnow:1.0.4 slim-seo:4.9.11 surecookie:1.3.1)
* Theme: the-box (the-box)
# Server
* Server Info: LiteSpeed
* PHP OS: Linux
* PHP Version: 8.5.6
* PHP SAPI: litespeed
* PHP Binary Name: /opt/alt/php85/usr/bin/lsphp
* PHP Maxmind DB extension: Not loaded
* PHP Error Reporting: 4437 After bootstrap: 4437
* Timezone: UTC
* WP timezone: +00:00
* Locale: en_US
* User Locale: en_US
* Memory Limit: 2G (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
* WP Memory Limit: 64M
* WP Max Memory Limit: 2G
* Timezone version: 2026.1
* Time: 1787305543
* Max Execution Time: 300
* Max Post Size: 256M
* Max Upload Size: 1536000
* Max Input Vars: 4000
* Disabled PHP functions: No
* zlib.output_compression is off: Yes
* Curl Version: 8.19.0, OpenSSL/3.5.5
* Suhosin installed: No
# PHP cli
* PHP CLI Version: (The detected PHP CLI version does not match the PHP web version. To avoid archiving errors, <a href="$site_url/wp-admin/admin.php?page=matomo-settings&tab=advanced#matomo[disable_async_archiving]">enable archiving via HTTP requests</a>, or <a href="https://matomo.org/faq/how-to-solve-the-error-message-your-php-cli-version-is-not-compatible-with-the-matomo-requirements/" target="_blank" rel="noreferrer noopener">manually set the path to your PHP CLI executable</a> to the one for PHP version 8.5.6.)
* MySQLi support: missing (Your PHP cli does not load the MySQLi extension. You might have archiving problems in Matomo but also others problems in your WordPress cron tasks. You should enable this extension)
# Database
* MySQL Version: 8.4.11
* Mysqli Connect: Yes
* Force MySQL over Mysqli: No
* DB Prefix: wpbn_
* DB CHARSET: utf8mb4
* DB COLLATE:
* SHOW ERRORS: No
* SUPPRESS ERRORS: No
* Uses Socket: No
* Uses IPv6: No
* Matomo tables found: 40
* DB tables exist: Yes
* Matomo users found: 1
* Matomo sites found: 1
* Required permissions: OK
# Browser
* Browser: (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36)
* Language: en-us,en
Also, could you please clarify what the GeoIP.conf file from MaxMind is used for and where exactly it should be placed within the WordPress installation directory?
