Hello all, i have got an issue trying to run mysql...
# getting-started
s
Hello all, i have got an issue trying to run mysql docker for datahub but I got this. I have tried to grant permissions to
/var/run/mysqlId
but it does seem to help. Anyone has idea how I can fix this? Thanks in advance.
b
Could you provide a bit more info to help us debug, e.g. the OS you're on, command ran etc?
s
@bumpy-keyboard-50565 Thanks for replying, I am running it on Linux Server, command I ran is docker run --name mysql --hostname mysql -e "MYSQL_DATABASE=datahub" -e "MYSQL_USER=datahub" -e "MYSQL_PASSWORD=datahub" -e "MYSQL_ROOT_PASSWORD=datahub" -v mysql:/docker-entrypoint-initdb.d -v mysqldata:/var/lib/mysql --publish 3306:3306 --tmpfs /tmp:rw --tmpfs /run:rw --tmpfs /var/run:rw --network geotab_docker_bridge --read-only --security-opt=no-new-privileges -d gcr.io/data-infrastructure-test-env/myql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
b
Can you try to drop the
--tmpfs
args and see if it makes a difference? We also provided an example docker-compose file here: https://github.com/linkedin/datahub/blob/master/docker/mysql/docker-compose.mysql.yml
s
@bumpy-keyboard-50565 I have resolve this issue by adding
v mysql:/var/run/mysqld:rw
. This grant access to read and write to the lock folder, just in case any one else runs into the same issue.
Thanks for you help @bumpy-keyboard-50565
b
Great to know!