{"action":"closed","issue":{"url":"https://api.github.com/repos/strapi/strapi/issues/1714","repository_url":"https://api.github.com/repos/strapi/strapi","labels_url":"https://api.github.com/repos/strapi/strapi/issues/1714/labels{/name}","comments_url":"https://api.github.com/repos/strapi/strapi/issues/1714/comments","events_url":"https://api.github.com/repos/strapi/strapi/issues/1714/events","html_url":"https://github.com/strapi/strapi/issues/1714","id":348634935,"node_id":"MDU6SXNzdWUzNDg2MzQ5MzU=","number":1714,"title":"Support for mysql over unix socket","user":{"login":"adamquaile","id":69929,"node_id":"MDQ6VXNlcjY5OTI5","avatar_url":"https://avatars2.githubusercontent.com/u/69929?v=4","gravatar_id":"","url":"https://api.github.com/users/adamquaile","html_url":"https://github.com/adamquaile","followers_url":"https://api.github.com/users/adamquaile/followers","following_url":"https://api.github.com/users/adamquaile/following{/other_user}","gists_url":"https://api.github.com/users/adamquaile/gists{/gist_id}","starred_url":"https://api.github.com/users/adamquaile/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adamquaile/subscriptions","organizations_url":"https://api.github.com/users/adamquaile/orgs","repos_url":"https://api.github.com/users/adamquaile/repos","events_url":"https://api.github.com/users/adamquaile/events{/privacy}","received_events_url":"https://api.github.com/users/adamquaile/received_events","type":"User","site_admin":false},"labels":[{"id":749109179,"node_id":"MDU6TGFiZWw3NDkxMDkxNzk=","url":"https://api.github.com/repos/strapi/strapi/labels/priority:%20low","name":"priority: low","color":"028d01","default":false},{"id":269636166,"node_id":"MDU6TGFiZWwyNjk2MzYxNjY=","url":"https://api.github.com/repos/strapi/strapi/labels/type:%20feature%20request%20%F0%9F%99%8F","name":"type: feature request 🙏","color":"fbca04","default":false}],"state":"closed","locked":false,"assignee":{"login":"Aurelsicoko","id":4144726,"node_id":"MDQ6VXNlcjQxNDQ3MjY=","avatar_url":"https://avatars0.githubusercontent.com/u/4144726?v=4","gravatar_id":"","url":"https://api.github.com/users/Aurelsicoko","html_url":"https://github.com/Aurelsicoko","followers_url":"https://api.github.com/users/Aurelsicoko/followers","following_url":"https://api.github.com/users/Aurelsicoko/following{/other_user}","gists_url":"https://api.github.com/users/Aurelsicoko/gists{/gist_id}","starred_url":"https://api.github.com/users/Aurelsicoko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Aurelsicoko/subscriptions","organizations_url":"https://api.github.com/users/Aurelsicoko/orgs","repos_url":"https://api.github.com/users/Aurelsicoko/repos","events_url":"https://api.github.com/users/Aurelsicoko/events{/privacy}","received_events_url":"https://api.github.com/users/Aurelsicoko/received_events","type":"User","site_admin":false},"assignees":[{"login":"Aurelsicoko","id":4144726,"node_id":"MDQ6VXNlcjQxNDQ3MjY=","avatar_url":"https://avatars0.githubusercontent.com/u/4144726?v=4","gravatar_id":"","url":"https://api.github.com/users/Aurelsicoko","html_url":"https://github.com/Aurelsicoko","followers_url":"https://api.github.com/users/Aurelsicoko/followers","following_url":"https://api.github.com/users/Aurelsicoko/following{/other_user}","gists_url":"https://api.github.com/users/Aurelsicoko/gists{/gist_id}","starred_url":"https://api.github.com/users/Aurelsicoko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Aurelsicoko/subscriptions","organizations_url":"https://api.github.com/users/Aurelsicoko/orgs","repos_url":"https://api.github.com/users/Aurelsicoko/repos","events_url":"https://api.github.com/users/Aurelsicoko/events{/privacy}","received_events_url":"https://api.github.com/users/Aurelsicoko/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-08-08T08:56:48Z","updated_at":"2018-09-07T08:52:45Z","closed_at":"2018-09-07T08:52:45Z","author_association":"NONE","body":"I've marked this as a feature request, because I don't _think_ this functionality exists. If it does, this is either me doing something wrong, or a lack of documentation, or both. \r\n<!-- ⚠️ If you do not respect this template your issue will be closed. -->\r\n\r\n**What is the expected behavior?**\r\nIt'd be great to be able to use a mysql database connecting via a unix socket instead of the host/port combination. \r\n\r\nIdeally this would be an option in the `strapi new` command and the admin ui, but support via the environment config file would suffice, too. \r\n\r\nPer some suggestions in slack I tried the following, with no luck:\r\n\r\n```\r\n{\r\n  \"defaultConnection\": \"default\",\r\n  \"connections\": {\r\n    \"default\": {\r\n      \"connector\": \"strapi-hook-bookshelf\",\r\n      \"settings\": {\r\n        \"client\": \"mysql\",\r\n        \"host\": \"${process.env.DATABASE_HOST || '127.0.0.1'}\",\r\n        \"port\": \"${process.env.DATABASE_PORT || 3306}\",\r\n        \"user\": \"${process.env.DATABASE_USERNAME || ''}\",\r\n        \"password\": \"${process.env.DATABASE_PASSWORD || ''}\",\r\n        \"database\": \"${process.env.DATABASE_NAME || 'strapi-production'}\",\r\n        \"socketPath\": \"/var/run/mysqld/mysqld.sock\"\r\n      },\r\n      \"options\": {\r\n        \"ssl\": false\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n\r\nand \r\n\r\n```\r\n{\r\n  \"defaultConnection\": \"default\",\r\n  \"connections\": {\r\n    \"default\": {\r\n      \"connector\": \"strapi-hook-bookshelf\",\r\n      \"settings\": {\r\n        \"client\": \"mysql\",\r\n        \"host\": \"${process.env.DATABASE_HOST || '127.0.0.1'}\",\r\n        \"port\": \"${process.env.DATABASE_PORT || 3306}\",\r\n        \"user\": \"${process.env.DATABASE_USERNAME || ''}\",\r\n        \"password\": \"${process.env.DATABASE_PASSWORD || ''}\",\r\n        \"database\": \"${process.env.DATABASE_NAME || 'strapi-production'}\"\r\n        \r\n      },\r\n      \"options\": {\r\n        \"ssl\": false,\r\n        \"socketPath\": \"/var/run/mysqld/mysqld.sock\"\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n<!-- ⚠️ Make sure to browse the opened and closed issues before submitting your issue. -->\r\n"}}
{"actor":{"display_login":"Aurelsicoko"}}