PHP cli myql support missing

  • Resolved ardio

    (@ardio)


    1 year, 3 months ago

    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 help
    Best regards and thanks a lot
    ardio

    Here the copy of the the diagnosis message:

                  # Errors
    • Error PHP cli Version: (Your PHP cli version is not compatible with the 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)
    • 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 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)
    • 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. 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 to see the link]

Viewing 11 replies - 1 through 11 (of 11 total)
  • Thread Starter ardio

    (@ardio)

    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 1 year, 3 months ago by ardio.
    Plugin Support emermatomo

    (@emermatomo)

    Hello @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/

    Thread Starter ardio

    (@ardio)

    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

    (@emermatomo)

    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

    (@ardio)

    It’s just the same, I’ve pasted above ….

    Plugin Support emermatomo

    (@emermatomo)

    Hello @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 which you can install it on your own hosting server.

    Thread Starter ardio

    (@ardio)

    emermatomo Thanks for help ! I will try both advices and write to you wether it helps.

    The providers are world4you.at and hosttech.at

    Heartly regards
    ardio

    Plugin Support emermatomo

    (@emermatomo)

    Your welcome @ardio. Looking forward to your response on how it goes.

    Plugin Support emermatomo

    (@emermatomo)

    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

    (@ardio)

    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

    (@emermatomo)

    Hello @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.