Hi,
Thank you for your reply.
For information, I updated Piwik / Matomo on 06/Feb/2021, I think around 5:45 p.m.
I have looked at the www/logs/error.php file. I only saw two failed login attempts. One thursday and the other yesterday morning. The IP addresses are from Vietnam and Russia.
In yesterday’s OVH log error file:
[Thu Feb 11 17:13:54 2021] [error] [client 91.134.248.253] [host piwik.piwik.mydomain.fr] AH10131: FastCGI: server “/homez.40/base name/piwik/piwik.php” stderr: PHP message: Error in Matomo (tracker): Error query: preparing query failed: Unknown column ‘config_client_type’ in ‘field list’ : SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_seconds_since_first, visitor_seconds_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, idsite, profilable, visit_entry_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, referer_url, config_browser_name, config_client_type, config_device_brand, config_device_model, config_device_type, visit_total_events, visit_total_time, location_ip, location_browser_lang, last_idlink_va, custom_dimension_1, custom_dimension_2, custom_dimension_3, custom_dimension_4, custom_dimension_5, custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3…
In the log error file of 06/Feb/2021 at OVH:
[Sat Feb 06 17:51:04 2021] [error] [client 91.134.248.253] [host piwik.mydomain.fr] AH10131: FastCGI: server “/homez.40/base name/piwik/piwik.php” stderr: PHP message: Error in Matomo (tracker): Error query: preparing query failed: Table ‘base name.piwik_tracking_failure’ doesn’t exist : SELECT idsite FROM piwik_tracking_failure WHERE idsite = ? and idfailure = ?
[Sat Feb 06 18:08:29 2021] [error] [client 91.134.248.253] [host piwik.mydomain.fr] AH10131: FastCGI: server “/homez.40/base name/piwik/piwik.php” stderr: PHP message: Error in Matomo (tracker): Error query: preparing query failed: Table ‘base name.piwik_tracking_failure’ doesn’t exist : SELECT idsite FROM piwik_tracking_failure WHERE idsite = ? and idfailure = ?
[Sat Feb 06 19:38:07 2021] [error] [client 91.134.248.253] [host piwik.mydomain.fr] AH10131: FastCGI: server “/homez.40/base name/piwik/piwik.php” stderr: PHP message: Error in Matomo (tracker): Error query: preparing query failed: Unknown column ‘config_client_type’ in ‘field list’ : SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_seconds_since_first, visitor_seconds_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, idsite, profilable, visit_entry_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, referer_url, config_browser_name, config_client_type, config_device_brand, config_device_model, config_device_type, visit_total_events, visit_total_time, location_ip, location_browser_lang, last_idlink_va, custom_dimension_1, custom_dimension_2, custom_dimension_3, custom_dimension_4, custom_dimension_5, custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3…
Dozens of times a day the IP address 91.134.248.253 generates 404 errors on my site !!!
I can’t block it permanently.
In the log web file of 06/Feb/2021 at OVH:
my ip address piwik.mydomain.fr - [06/Feb/2021:17:45:23 +0100] “GET /index.php?module=CoreUpdater&action=newVersionAvailable HTTP/1.1” 200 8863 “https://piwik.mydomain.fr/index.php?module=CoreHome&action=index&idSite=1&period=day&date=yesterday” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:45:23 +0100] “GET /index.php?module=CoreUpdater&action=getUpdaterCss&cb=d7b6818f3e82723f6d727f29f81dcf72 HTTP/1.1” 200 33518 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=newVersionAvailable” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:45:23 +0100] “GET /index.php?module=CoreUpdater&action=getUpdaterJs&cb=10452e2119039d3450de42aab0f60d18 HTTP/1.1” 200 207149 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=newVersionAvailable” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:47:43 +0100] “GET /index.php?module=CoreUpdater&action=oneClickUpdate HTTP/1.1” 200 654 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=newVersionAvailable” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:48:19 +0100] “POST /index.php?module=CoreUpdater&action=oneClickResults HTTP/1.1” 200 16041 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=oneClickUpdate” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:48:23 +0100] “GET /plugins/Morpheus/images/logo.svg?matomo HTTP/1.1” 200 12973 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=oneClickResults” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:48:23 +0100] “GET /index.php?module=CoreUpdater&action=getUpdaterCss&cb=942eb6b3d8a15f56b68930785c5493dc HTTP/1.1” 200 35350 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=oneClickResults” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:48:23 +0100] “GET /index.php?module=CoreUpdater&action=getUpdaterJs&cb=1cddf527f07369481057cd6caf12dfbc HTTP/1.1” 200 222326 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=oneClickResults” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:48:23 +0100] “GET /plugins/CoreHome/images/applogo_256.png HTTP/1.1” 200 10278 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=oneClickResults” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:48:23 +0100] “GET /plugins/CoreHome/images/applogo_256.png HTTP/1.1” 200 10278 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=oneClickResults” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [06/Feb/2021:17:48:23 +0100] “GET /plugins/Morpheus/fonts/matomo.woff2?rjeutj HTTP/1.1” 200 11048 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=getUpdaterCss&cb=942eb6b3d8a15f56b68930785c5493dc” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
New test last night at 11:10 p.m. :
I tried to access the consultation of my site’s statistics, I get a Matomo window indicating: “* Database update required…”*
I then clicked on the green button “Upgrade Matomo” and I got a blank page again in the browser.
Then I have looked at in the log web file of 11/Feb/2021 at OVH:
my ip address piwik.mydomain.fr - [11/Feb/2021:23:10:07 +0100] “GET / HTTP/1.1” 302 - “-” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [11/Feb/2021:23:10:08 +0100] “GET /index.php?module=CoreUpdater&action= HTTP/1.1” 200 18904 “-” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [11/Feb/2021:23:10:14 +0100] “GET /plugins/CoreHome/angularjs/menudropdown/menudropdown.directive.js?cb=6d7ed76ae509430ef46b0d0f3f0cc4a7 HTTP/1.1” 200 905 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [11/Feb/2021:23:10:14 +0100] “GET /plugins/LanguagesManager/angularjs/languageselector/languageselector.directive.js?cb=6d7ed76ae509430ef46b0d0f3f0cc4a7 HTTP/1.1” 200 434 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [11/Feb/2021:23:10:14 +0100] “GET /index.php?module=CoreUpdater&action=getUpdaterJs&cb=6d7ed76ae509430ef46b0d0f3f0cc4a7 HTTP/1.1” 200 111531 “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [11/Feb/2021:23:10:17 +0100] “GET /index.php?updateCorePlugins=1 HTTP/1.1” 302 - “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
my ip address piwik.mydomain.fr - [11/Feb/2021:23:10:18 +0100] “GET /index.php?updateCorePlugins=1&module=CoreUpdater&action= HTTP/1.1” 500 - “https://piwik.mydomain.fr/index.php?module=CoreUpdater&action=” “Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0”
I selected a small part of the log files.
Thanks for your help