Hi - I am self-hosting Matomo and for months I have had this problem where I can add websites but when I try to “manage” websites (in particular - delete a website) I get this hanging issue on the management page see here:
Hi Lukas - thanks for responding - in my Firefox browser this is what was generated from the javascript console / network tab Screenshot by Lightshot
Sorry - this stuff is getting a little beyond me - so best I just show you and you read it. There were a few more entries below the sight line of the screen but they all showed message status as 200 which I’m guessing is fine??
Without taking a closer look (I’m on my phone) the line with a 403 response looks like the error.
Your Webserver returns 403 if you aren’t allowed to access that url. Can you maybe check the Webserver error log to find out the reason? Are you using something like mod_security that blocks requests based on keywords?
Also … I did a Matomo “system check” and discovered this database issue - not sure if it’s relevant but I will need to repair it in due course when I work out how to do it:
LOAD DATA INFILE
Using LOAD DATA INFILE will greatly speed Matomo’s archiving process up. To make it available to Matomo, try updating your PHP & MySQL software and make sure your database user has the FILE privilege.
If your Matomo server tracks high traffic websites (eg. > 100,000 pages per month), we recommend to try fix this problem.
Error: LOAD DATA INFILE failed… Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user ‘wiz2_analytics’@‘localhost’ (using password: YES)[28000]
Troubleshooting: FAQ on matomo.org
I unfortunately only know little about Apache, so I can’t help much there.
The LOAD DATA INFILE has nothing to do with it. It’s not really an error, but Matomo could work much faster if it was allowed. But if you don’t have full access to your MySQL server it’s quite possible that the feature was intentionally blocked
OK I understand Lukas - thanks for taking an interest nonetheless - I’ll maybe hire someone on Fiverr to sort this issue for me - to the trained apache eye it is probably something easily solved. But too complicated for me. Cheers