When using the query for REST API (note you need to have curl installed:
The result is:
- when used locally (VM Ubuntu Focal, MariaDB 10.6) , the result is:
Query OK, 0 rows affected, 1 warning (0.140 sec)
- in Docker is an error
The first thing CONNECT is doing is to create the file (in above example cusers.json, and from it is doing table discovery.
In Docker file is created in data directory - /var/lib/mysql/web_users , directory that has file permissions of mysql:mysql.
My testing involved different tests regarding curl versions (Ubuntu bionic default 7.58 and Focal default 7.68), hoping to get different types of files, but no, it is not curl related.
I tested locally on Focal VM and it works, so my conclusion is that has something to do with Docker permissions.
- Docker container is started with:
where the config file in my_container_files/ dir is:
Haven't tested in other images but expecting to have the same behavior.