Loop / Permanent Restart about binarydoc-docker HOT 4 CLOSED

Hi Jörg,

Root Cause Analysis

The error ERROR 1418 (HY000) at line 206: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) should have been fixed by https://github.com/fuiny/binarydoc-docker/blob/master/etc/mysql/conf.d/mysql.cnf#L89 on MySQL 8

• etc/mysql/conf.d/mysql.cnf#L89

# https://stackoverflow.com/questions/26015160/
log_bin_trust_function_creators = 1

If not, my best guess for now could be the config mapping at https://github.com/fuiny/binarydoc-docker/blob/master/docker-compose.yml#L22 is not working on Windows docker ? so the mysql.cnf may not take effect right now.

• docker-compose.yml#L22

      - ./etc/mysql/conf.d:/etc/mysql/conf.d

To validate this guess, what you may try is:

• Make sure the MySQL docker is already running
• Open the url in browser http://127.0.0.1:10190/ and login as
  • Server: binarydoc-db
  • Username: root
  • Password: 123456, or the password you set in .env file
• Click the link Variables at the top right
• Validate log_bin_trust_function_creators is ON or OFF
  • We expect it should be ON - which means the mysql.cnf#L89 take effect
  • If it is OFF, it means its a mapping issue at docker-compose.yml#L22 and mysql.cnf#L89 did not take effect

We will try to find a Windows Server to test it (to be honest we need to buy a windows license first since the current testing is on Linux right now)

Other Way Out

Well you don't have to run rebuild.sh to rebuild the docker images, it has been built at https://hub.docker.com/r/fuiny/binarydoc . The script rebuild.sh is designed for the local Dev/QA Linux machines.

So all you need to do is pull the image and run it:

• docker-compose up -d

@joerg-rade

from binarydoc-docker.

Hi there & thanks for the fast response!

• log_bin_trust_function_creators is OFF
• mysql.cnf#L89 -> log_bin_trust_function_creators = 1

-j

from binarydoc-docker.

HI @joerg-rade

Thanks for the feedback, so it means the docker-compose.yml#L22 mapping is not taking effect for MySQL 8 Windows Docker image.

    ./etc/mysql/conf.d:/etc/mysql/conf.d

We will investigate a more reliable method to map the mysql.cnf into MySQL 8 docker.

from binarydoc-docker.

Appears to have been a case of PEBKAC ...

my Docker Desktop for Windows setup was not correct. I had to

• un-check Settings -> General -> Use WSL 2 based engine (which enabled Settings -> Resources -> File Sharing) and
• grant access to the FS with Settings -> Resources -> File Sharing

Thanks for your support!

from binarydoc-docker.