Title: PHP cli myql support missing
Last modified: August 30, 2023

---

# PHP cli myql support missing

 *  Resolved [ardio](https://wordpress.org/support/users/ardio/)
 * (@ardio)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/)
 * Hello,
   I’m using Matomo for 11 clients with different hosters. Since the last
   update of WordPress and Matomo it appeared errors. We use PHP 8. … and regularly
   Maria DB. The hosters all tell me, that all Matomo requirements are fullfilled.
   I hope for helpBest regards and thanks a lotardio Here the copy of the the diagnosis
   message:
 *     ```wp-block-code
                     # Errors
       ```
   
    - Error PHP cli Version: (Your PHP cli version is not compatible with the [Matomo requirements](https://matomo.org/faq/on-premise/matomo-requirements/).
      Please upgrade your PHP cli version, otherwise, you might have some archiving
      errors)
    - Error 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)
 * Matomo
    - Matomo-Plugin-Version: 4.15.0
    - Config existiert und ist schreibbar.: Ja (“$abs_path/wp-content/uploads/matomo/
      config/config.ini.php” )
    - JS Tracker existiert und ist schreibbar.: Ja (“$abs_path/wp-content/uploads/
      matomo/matomo.js” )
    - Plugin-Verzeichnisse: Yes ([{“pluginsPathAbsolute”:”$abs_path\/wp-content\/
      plugins\/matomo\/plugins”,”webrootDirRelativeToMatomo”:”..\/”}])
    - Tmp-Verzeichnis schreibbar: Yes ($abs_path/wp-content/cache/matomo)
    - Matomo-Version: 4.15.0
    - Matomo Blog idSite: 1
    - Installierte Matomo-Version: 4.11.0 (Install date: 2022-09-15 14:21:28)
    - Upgrades outstanding: No
    - Upgrade in progress: No
 * 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-Zeit: 2023-08-30 11:54:03
    - Blog-Zeit: 2023-08-30 11:54:03 (Die nachfolgenden Daten werden in der Blog-
      Zeitzone angezeigt)
    - Sync users & sites: Next run: 2023-08-30 14:24:01 (2 Stunden 29 Minuten) (
      Last started: 2023-08-29 14:55:52 (-20 Stunden 58 Minuten). Last ended: 2023-
      08-29 14:55:52 (-20 Stunden 58 Minuten). Interval: daily)
    - Archive: Next run: 2023-08-30 12:21:40 (27 Minuten 37s) ( Last started: 2023-
      08-30 11:42:37 (-11 Minuten 26s). Last ended: 2023-08-30 11:42:53 (-11 Minuten
      10s). Interval: hourly)
    - Update GeoIP DB: Next run: 2023-09-10 14:24:00 (11 Tage 2 Stunden) ( Last 
      started: 2023-08-11 15:19:14 (-18 Tage 20 Stunden). Last ended: 2023-08-11
      15:19:21 (-18 Tage 20 Stunden). Interval: matomo_monthly)
 * Vorgeschriebene Prüfungen
    - PHP-Version >= 7.2.5: ok
    - PDO Erweiterung: ok
    - PDO\MYSQL Erweiterung: ok
    - MYSQLI Erweiterung: ok
    - Weitere erforderliche Anforderungen: ok
    - Erforderliche Funktionen: ok
    - Benötigte PHP Konfiguration (php.ini): ok
    - Verzeichnisse mit Schreibzugriff: ok
    - Verzeichnisse mit Schreibzugriff auf Tag Manager: ok
 * Optionale Prüfungen
    - 64-bit PHP Binär: ok
    - Tracker-Status: ok
    - Speicherlimit: ok
    - Zeitzone: ok
    - Öffnen einer URL: ok
    - GD > 2.x + FreeType (Grafiken): ok
    - Andere Erweiterungen: ok
    - Andere Funktionen: ok
    - Dateisystem: ok
    - Letzter erfolgreicher Abschluss der Archivierung: ok
    - Datenbankfähigkeiten: ok
    - Warning Maximale Packetgröße: warning (Es wird empfohlen die ‘max_allowed_packet’
      Größe in Ihrer MySQL Datenbank auf mindestens 64MB zu erhöhen. Aktuell ist
      32MB eingestellt. )
    - Standorterkennung: ok
    - Update über HTTPS: ok
    - Supports Async Archiving: No
    - Location provider ID: geoip2php
    - Location provider available: Yes
    - Location provider working: Yes
    - Warning Proxy header: HTTP_X_REAL_IP (A proxy header is set which means you
      maybe need to configure a proxy header in the Advanced settings to make location
      reporting work. If the location in your reports is detected correctly, you
      can ignore this warning. [Mehr erfahren](https://matomo.org/faq/wordpress/how-do-i-fix-the-proxy-header-warning-in-the-matomo-for-wordpress-system-report/))
    - Had visit in last 5 days: Yes
    - Matomo URL: Yes ($site_url/wp-content/plugins/matomo/app/)
 * Matomo Settings
    - Track mode: default
    - Track codeposition: footer
    - Track api endpoint: default
    - Track js endpoint: default
    - Version history: 4.15.0, 4.14.2, 4.14.1, 4.13.5, 4.13.4
    - Core version: 4.15.0
    - Last tracking settings update: 1663251841
    - Last settings update: 1663251841
    - Mail history: 2023-08-01 22:23:00, 2023-07-02 00:02:25, 2023-06-01 23:57:32
 * Logs
    - Keine:
 * WordPress
    - Home URL: $site_url
    - Site URL: $site_url
    - WordPress Version: 6.3.1
    - Number of blogs: 1
    - Multisite Enabled: No
    - Network Enabled: No
    - WP_DEBUG: No
    - WP_DEBUG_DISPLAY: No
    - WP_DEBUG_LOG: No
    - DISABLE_WP_CRON: –
    - FORCE_SSL_ADMIN: Yes
    - WP_CACHE: Yes
    - CONCATENATE_SCRIPTS: No
    - 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_TRIGGER_BROWSER_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/2023/08
    - Custom upload_path:
    - Custom upload_url_path:
    - Compatible content directory: Yes
 * WordPress Plugins
    - Advanced Database Cleaner: 3.1.2
    - All In One WP Security: 5.2.4 (Network enabled)
    - Autoptimize: 3.1.8.1
    - Converter for Media: 5.9.6 (Network enabled)
    - Divi Accessibility: 1.2.5
    - Easy Table of Contents: 2.0.54.1
    - Easy WP SMTP: 2.1.2
    - Headers Security Advanced & HSTS WP: 5.0.28
    - Imagify: 2.1.1
    - Matomo Analytics – Ethical Stats. Powerful Insights.: 4.15.0
    - Rank Math SEO: 1.0.122
    - Security Ninja: 5.159
    - UpdraftPlus – Backup/Restore: 2.23.9.26
    - WP Armour – Honeypot Anti Spam: 2.1.5
    - WP Rocket: 3.14.4.2
    - Active Plugins: 15 (accessible-divi advanced-database-cleaner all-in-one-wp-
      security-and-firewall autoptimize easy-table-of-contents easy-wp-smtp headers-
      security-advanced-hsts-wp honeypot imagify matomo security-ninja seo-by-rank-
      math updraftplus webp-converter-for-media wp-rocket)
    - Warning Nicht kompatible Plugins: 1 (wp-rocket Matomo may work fine when using
      these plugins but there may be some issues. For more information See [this FAQ](https://matomo.org/faq/wordpress/which-plugins-is-matomo-for-wordpress-known-to-be-not-compatible-with/)
      WP-Rocket is incompatible from version 3.12. Until fixes, please reinstall
      version 3.11.5 if you have a newer version. For more information please visit
      [How to downgrade Wp-rocket to be compatible with Matomo](https://github.com/matomo-org/matomo-for-wordpress/wiki/Downgrade-wp-rocket-to-a-version-compatible-with-the-Matomo-plugin))
    - Theme: Divi (Childtheme)
 * Server
    - Server Info: Apache
    - Apache AddHandler support: Supported
    - PHP OS: Linux
    - PHP Version: 8.2.8
    - PHP SAPI: fpm-fcgi
    - PHP Binary Name: /opt/plesk/php/8.2/sbin/php-fpm
    - PHP Maxmind DB extension: Not loaded
    - PHP Error Reporting: After bootstrap: 4437
    - Timezone: UTC
    - WP timezone: +00:00
    - Locale: de_DE
    - User Locale: de_DE
    - Memory Limit: 256M (At least 128MB recommended. Depending on your traffic 
      256MB or more may be needed.)
    - WP Memory Limit: 40M
    - WP Max Memory Limit: 256M
    - Timezone version: 0.system
    - Time: 1693396446
    - Max Execution Time: 600
    - Max Post Size: 256M
    - Max Upload Size: 268435456
    - Max Input Vars: 7200
    - Disabled PHP functions: Yes (opcache_get_status)
    - zlib.output_compression is off: Yes
    - Curl Version: 7.29.0, NSS/3.53.1
    - Suhosin installed: No
 * PHP cli
    - Error PHP cli Version: (Your PHP cli version is not compatible with the [Matomo requirements](https://matomo.org/faq/on-premise/matomo-requirements/).
      Please upgrade your PHP cli version, otherwise, you might have some archiving
      errors)
    - Error 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: 10.4.30
    - Mysqli Connect: Yes
    - Force MySQL over Mysqli: No
    - DB Prefix: TWejGGNz_
    - DB CHARSET: utf8
    - DB COLLATE:
    - SHOW ERRORS: No
    - SUPPRESS ERRORS: No
    - Uses Socket: No
    - Uses IPv6: No
    - Matomo tables found: 83
    - DB tables exist: Yes
    - Matomo users found: 2
    - Matomo sites found: 1
    - Erforderliche Berechtigungen: OK
 * Browser
    - Browser: (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
      like Gecko) Chrome/116.0.0.0 Safari/537.36)
    - Language: de-de,de,en-us,en
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fphp-cli-myql-support-missing%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 11 replies - 1 through 11 (of 11 total)

 *  Thread Starter [ardio](https://wordpress.org/support/users/ardio/)
 * (@ardio)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17012997)
 * **WP Rocket Version is 3.14.4.2 – WP Rocket tells no problems with Matomo ! 
   
   Rolling Back to version 3.11.5 didn’t help.
    -  This reply was modified 2 years, 9 months ago by [ardio](https://wordpress.org/support/users/ardio/).
 *  Plugin Support [emermatomo](https://wordpress.org/support/users/emermatomo/)
 * (@emermatomo)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17029012)
 * Hello [@ardio](https://wordpress.org/support/users/ardio/) Sorry to hear you 
   are having issue with Matomo for WordPress. To help you with the error you are
   getting, please review this guide on how to fix it: [https://matomo.org/faq/how-to-solve-the-error-message-your-php-cli-version-is-not-compatible-with-the-matomo-requirements/](https://matomo.org/faq/how-to-solve-the-error-message-your-php-cli-version-is-not-compatible-with-the-matomo-requirements/)
 *  Thread Starter [ardio](https://wordpress.org/support/users/ardio/)
 * (@ardio)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17030040)
 * Thanks a lot for your answer. I proceeded with regard to config.ini.php as described
   in the manual. But unfortunately without success.
   I also tried to use _php\_binary\
   _path=”/usr/bin/php80-cli” _which was advised to me by a provider where 2 of 
   my website are hosted. With this provider, Matomo now works without an error 
   message. But unfortunately with the 9 others that are with other hosters, the
   error persists.I’m looking forward to further help.Best regards
 *  Plugin Support [emermatomo](https://wordpress.org/support/users/emermatomo/)
 * (@emermatomo)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17031733)
 * Sorry to hear that the solution provided didn’t work. Could you please send us
   a copy of the PHP error log? There might be something in there that can help 
   us identify the issue.
 *  Thread Starter [ardio](https://wordpress.org/support/users/ardio/)
 * (@ardio)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17033659)
 * It’s just the same, I’ve pasted above ….
 *  Plugin Support [emermatomo](https://wordpress.org/support/users/emermatomo/)
 * (@emermatomo)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17039941)
 * Hello [@ardio](https://wordpress.org/support/users/ardio/) Upon further review,
   it looks like your hosting provider is using php 8.2. Your hosting provider can
   put the file anywhere it wants. They might be able to use the `PHP Binary Name`
   system report field to narrow it down though.
   Another workaround is if you could
   set `define('MATOMO_SUPPORT_ASYNC_ARCHIVING', false);` in wp-config.php to bypass
   the problem entirely, but I think the warning message will still exist in the
   system report and might make archiving a little bit slower.If you could share
   to us who your web server/ hosting provider is, we’ll try to check their docs.
   If the 2nd option doesn’t work for you, I would recommend to use [Matomo On-Premise](https://matomo.org/matomo-on-premise/)
   which you can install it on your own hosting server.
 *  Thread Starter [ardio](https://wordpress.org/support/users/ardio/)
 * (@ardio)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17041465)
 * [emermatomo](https://wordpress.org/support/users/emermatomo/) Thanks for help!
   I will try both advices and write to you wether it helps.
   The providers are world4you.
   at and hosttech.atHeartly regardsardio
 *  Plugin Support [emermatomo](https://wordpress.org/support/users/emermatomo/)
 * (@emermatomo)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17042834)
 * Your welcome [@ardio](https://wordpress.org/support/users/ardio/). Looking forward
   to your response on how it goes.
 *  Plugin Support [emermatomo](https://wordpress.org/support/users/emermatomo/)
 * (@emermatomo)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17057686)
 * Hi @ardio As we didn’t receive a response after 1 week, we’re marking this issue
   as resolved. If something is not working, feel free to leave a comment and we’d
   be happy to assist.
 *  Thread Starter [ardio](https://wordpress.org/support/users/ardio/)
 * (@ardio)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17058271)
 * Oh, where’s my answer gone ?? Sorry. Perhaps I had two windows open with this
   post, than it happens, that the messages disappear …
   The work arounds didn’t 
   eliminate the error messages. My providers both don’t react. So it’ all the same…
   What could I clearly write to the supports of world4you.at and hosttech.at ?
 *  Plugin Support [emermatomo](https://wordpress.org/support/users/emermatomo/)
 * (@emermatomo)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17064350)
 * Hello [@ardio](https://wordpress.org/support/users/ardio/). We tried to check
   but  couldn’t find anything. I would recommend to reach out to your your hosting
   provider’s support. Or you can disable async archiving.

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘PHP cli myql support missing’ is closed to new replies.

 * ![](https://ps.w.org/matomo/assets/icon-256x256.png?rev=3531741)
 * [Matomo Analytics - Powerful, Privacy-First Insights for WordPress](https://wordpress.org/plugins/matomo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/matomo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/matomo/)
 * [Active Topics](https://wordpress.org/support/plugin/matomo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/matomo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/matomo/reviews/)

 * 11 replies
 * 2 participants
 * Last reply from: [emermatomo](https://wordpress.org/support/users/emermatomo/)
 * Last activity: [2 years, 8 months ago](https://wordpress.org/support/topic/php-cli-myql-support-missing/#post-17064350)
 * Status: resolved