Matomo diagnostic reports Error: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290

[Ravid824]

Hello I am running Matomo from the docker container retrieved from Docker Hub I also run the MySQL 5.8 container in parallel. docker run --name david_mysql -e MYSQL_ROOT_PASSWORD= MyPassword -d mysql:latest docker run -p 80:80 --link david_mysql:db matomo:latest

The Matomo web server is connecting and I am able to run the configuration wizard. One done I am able to see the dashboard. However the dashboard doesn't display any data (visitors for example) I run the Matomo diagnostic > system check , and it shows error in the database section: the error is Error: LOAD DATA INFILE failed... Error was: Try matomo-org/matomo#1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,

Is this error related to the fact that I don't see any information in the dashboard? Do I run the images properly (I couldn't find good information on running Matomo from containers) Not sure if this is a bug, can you please advice?

Thx

[sgiehl]

Hi @Ravid824 Did you check this FAQ: https://matomo.org/faq/troubleshooting/faq_194/ ? load data infile is not required. If you can't use it for certain reasons you can disable it in config.

[Ravid824]

Thank you, the link is helpful and helped to resolve my problem.

[Ravid824]

The question is why it is not working as expected. When there is be another release and I will pull a new container the problem will show again. I wish that the issue can be resolved premanetly.

[sgiehl]

I guess you use the official image. I'll move the issue to the docker repo. As it's more likely an issue there and not within Matomo itself.

[sgiehl]

Hm. Seems I don't have sufficient permissions to do that. @tsteur could you give me access to matomo-org/docker or move this issue there?

[Ravid824]

Yes, I am using the official image from DockerHub BTW, I noticed that some visitors that I asked to login to the tracked web site do not show in Matomo dashboard reports. What can be the reason, where I should start to investigate? It is possible that the tracked web site filter some visitors and do not report to Mateo? it is a WordPress web site.

thanks again for your assistant

[snapsnapsnap]

I also have this problem, hope someone have a good solution

[jotremb]

It seems to be a configuration issue in the docker image itself. Access the in-container file "/usr/local/etc/php/conf.d/php-matomo.ini and add the following line:

mysqli.allow_local_infile=On

Then restart the container instance... This should be added directly tin the docker image.

[masterwishx]

Also have same issue but only LOAD DATA INFILE i didnt have this in versions befor , also checked Matomo FAQ. Have in MariaDB