{"action":"created","issue":{"url":"https://api.github.com/repos/laradock/laradock/issues/1392","repository_url":"https://api.github.com/repos/laradock/laradock","labels_url":"https://api.github.com/repos/laradock/laradock/issues/1392/labels{/name}","comments_url":"https://api.github.com/repos/laradock/laradock/issues/1392/comments","events_url":"https://api.github.com/repos/laradock/laradock/issues/1392/events","html_url":"https://github.com/laradock/laradock/issues/1392","id":299835431,"number":1392,"title":"SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client","user":{"login":"MaximilianCoutuer","id":25639206,"avatar_url":"https://avatars1.githubusercontent.com/u/25639206?v=4","gravatar_id":"","url":"https://api.github.com/users/MaximilianCoutuer","html_url":"https://github.com/MaximilianCoutuer","followers_url":"https://api.github.com/users/MaximilianCoutuer/followers","following_url":"https://api.github.com/users/MaximilianCoutuer/following{/other_user}","gists_url":"https://api.github.com/users/MaximilianCoutuer/gists{/gist_id}","starred_url":"https://api.github.com/users/MaximilianCoutuer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaximilianCoutuer/subscriptions","organizations_url":"https://api.github.com/users/MaximilianCoutuer/orgs","repos_url":"https://api.github.com/users/MaximilianCoutuer/repos","events_url":"https://api.github.com/users/MaximilianCoutuer/events{/privacy}","received_events_url":"https://api.github.com/users/MaximilianCoutuer/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-02-23T20:09:51Z","updated_at":"2018-02-26T04:06:19Z","closed_at":null,"author_association":"NONE","body":"### Info:\r\n- Docker version (`$ docker --version`): Docker version 17.12.0-ce, build c97c6d6\r\n- Laradock commit (`$ git rev-parse HEAD`): 8323c659ed588ad2d2b02a13dfab651c051302e8\r\n- System info (Mac, PC, Linux): MacOS Sierra 10.12.6\r\n- System info disto/version: \r\n\r\n### Issue:\r\nUsing the mysql and nginx containers, running a migration yields the following error: The server requested authentication method unknown to the client [caching_sha2_password].\r\n\r\nThis _seems_ to be due to mysql 8.x forcing a new password format. Attempting to force old_passwords=1 from inside the mysql container yields ERROR 1231 (42000): Variable 'old_passwords' can't be set to the value of '1'.\r\n\r\nThis does occur when trying to run a migration from inside the workspace - where both the version of php and mysql should be controlled by Laradock.\r\n_____\r\n\r\n### Expected behavior:\r\nLaravel should be able to login to the database and do its thing.\r\n_____\r\n\r\n### Reproduce:\r\nPull clean copy of Laradock, set DB_HOST=127.0.0.1 in .env (for reasons unknown to me, DB_HOST=mysql yields SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known), start the mysql and nginx containers, enter the workspace container and run php artisan migrate.\r\n_____"},"comment":{"url":"https://api.github.com/repos/laradock/laradock/issues/comments/368384550","html_url":"https://github.com/laradock/laradock/issues/1392#issuecomment-368384550","issue_url":"https://api.github.com/repos/laradock/laradock/issues/1392","id":368384550,"user":{"login":"adammparker","id":5186174,"avatar_url":"https://avatars0.githubusercontent.com/u/5186174?v=4","gravatar_id":"","url":"https://api.github.com/users/adammparker","html_url":"https://github.com/adammparker","followers_url":"https://api.github.com/users/adammparker/followers","following_url":"https://api.github.com/users/adammparker/following{/other_user}","gists_url":"https://api.github.com/users/adammparker/gists{/gist_id}","starred_url":"https://api.github.com/users/adammparker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adammparker/subscriptions","organizations_url":"https://api.github.com/users/adammparker/orgs","repos_url":"https://api.github.com/users/adammparker/repos","events_url":"https://api.github.com/users/adammparker/events{/privacy}","received_events_url":"https://api.github.com/users/adammparker/received_events","type":"User","site_admin":false},"created_at":"2018-02-26T04:06:18Z","updated_at":"2018-02-26T04:06:18Z","author_association":"NONE","body":"@danaia I think I may have experienced something similar. Rather than debugging I just nuked all of my Docker settings, containers, and images and just started from scratch (with the older [and more stable] version of MySQL)."}}
{"actor":{"display_login":"adammparker"}}