{"action":"opened","issue":{"url":"https://api.github.com/repos/QuantumObject/docker-zoneminder/issues/22","repository_url":"https://api.github.com/repos/QuantumObject/docker-zoneminder","labels_url":"https://api.github.com/repos/QuantumObject/docker-zoneminder/issues/22/labels{/name}","comments_url":"https://api.github.com/repos/QuantumObject/docker-zoneminder/issues/22/comments","events_url":"https://api.github.com/repos/QuantumObject/docker-zoneminder/issues/22/events","html_url":"https://github.com/QuantumObject/docker-zoneminder/issues/22","id":174953036,"number":22,"title":"2 Issues - MySQL sql_mode incorrect and /dev/shm not writeable by www-data","user":{"login":"mikebski","id":4280588,"avatar_url":"https://avatars.githubusercontent.com/u/4280588?v=3","gravatar_id":"","url":"https://api.github.com/users/mikebski","html_url":"https://github.com/mikebski","followers_url":"https://api.github.com/users/mikebski/followers","following_url":"https://api.github.com/users/mikebski/following{/other_user}","gists_url":"https://api.github.com/users/mikebski/gists{/gist_id}","starred_url":"https://api.github.com/users/mikebski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikebski/subscriptions","organizations_url":"https://api.github.com/users/mikebski/orgs","repos_url":"https://api.github.com/users/mikebski/repos","events_url":"https://api.github.com/users/mikebski/events{/privacy}","received_events_url":"https://api.github.com/users/mikebski/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-04T15:01:56Z","updated_at":"2016-09-04T15:01:56Z","closed_at":null,"body":"# Problem 1\r\n\r\nsql_mode is incorrect in MySQL.  Need to update the correct my.cnf file to have:\r\n\r\n`sql_mode = NO_ENGINE_SUBSTITUTION`\r\n\r\nTo fix in a running container, replace `cid` below with the container id from `docker ps` and run the follwing:\r\n\r\n`docker exec -it cid /bin/bash`\r\n`mysql -uroot -pmysqlpsswd -e 'set GLOBAL sql_mode = NO_ENGINE_SUBSTITUTION'`\r\n\r\nThis is lost at restart, so it needs to be fixed in the container image.\r\n\r\n# Problem 2\r\n\r\nIn the container, `/dev/shm` is not writable by user `www-data`.  Can be fixed by:\r\n\r\n`docker exec -it cid /bin/bash`\r\n`chown www-data /dev/shm`\r\n\r\nThere are several ways to fix this in the image, which needs to be done.  This is causing error: `Memory map file '/dev/shm/zm.mmap.1' does not exist. zmc might not be running.` in the log."}}
{"actor":{"display_login":"mikebski"}}