{"id":449,"date":"2019-02-11T09:23:14","date_gmt":"2019-02-11T00:23:14","guid":{"rendered":"http:\/\/www.tkn.jp\/tknsys\/wordpress\/?p=449"},"modified":"2019-02-11T09:23:14","modified_gmt":"2019-02-11T00:23:14","slug":"rancheros%e4%b8%8a%e3%81%ab%e4%bd%9c%e3%81%a3%e3%81%9flaradock%e7%92%b0%e5%a2%83%e3%81%ablaravel-admin%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%83%a1%e3%83%a2","status":"publish","type":"post","link":"https:\/\/www.tkn.jp\/?p=449","title":{"rendered":"RancherOS\u4e0a\u306b\u4f5c\u3063\u305fLaradock\u74b0\u5883\u306bLaravel-Admin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30e1\u30e2"},"content":{"rendered":"<ul>\n<li>Composer\u3067Laravel-Admin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<br \/>\n<blockquote><p>laradock\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5\u3057\u3066<br \/>\n.\/docker-compose exec workspace bash<br \/>\ncomposer require encore\/laravel-admin<br \/>\nphp artisan vendor:publish &#8211;provider=&#8221;Encore\\Admin\\AdminServiceProvider&#8221;<br \/>\nphp artisan admin:install<\/p><\/blockquote>\n<\/li>\n<li>php artisan admin:install\u3067\u3001\u4e0b\u8a18\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u306e\u3067\u8abf\u67fb<br \/>\n<blockquote><p>Illuminate\\Database\\QueryException : SQLSTATE[HY000] [2002] Connection refused<\/p><\/blockquote>\n<\/li>\n<li>MySQL\u306e\u63a5\u7d9a\u60c5\u5831\uff08.env\uff09\u3092\u4fee\u6b63\uff08https:\/\/nobuhiroharada.com\/2018\/07\/21\/laravel-laradock-mysql-refused\/\uff09<br \/>\n<blockquote><p>DB_HOST=127.0.0.1<br \/>\n\u2193<br \/>\nDB_HOST=mysql<\/p><\/blockquote>\n<\/li>\n<li>\u4e0b\u8a18\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u306e\u3067\u8abf\u67fb<br \/>\n<blockquote><p>Illuminate\\Database\\QueryException : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client<\/p><\/blockquote>\n<\/li>\n<li>MySQL\u306e\u8a8d\u8a3c\u65b9\u5f0f\u306e\u5909\u66f4\uff08https:\/\/qiita.com\/shunichi_com\/items\/9b09c5949233b88b9a4a\uff09<br \/>\n<blockquote><p>.\/docker-compose exec mysql bash<br \/>\n# mysql -u root -p<br \/>\n\u30d1\u30b9\u30ef\u30fc\u30c9\uff1aroot<br \/>\nmysql&gt; SELECT user, host, plugin FROM mysql.user;<br \/>\n\u8a8d\u8a3c\u65b9\u5f0f\u3092caching_sha2_password\u304b\u3089mysql_native_password\u306b\u5909\u66f4<br \/>\nmysql&gt; ALTER USER &#8216;default&#8217;@&#8217;%&#8217; IDENTIFIED WITH mysql_native_password BY &#8216;secret&#8217;;<br \/>\nmysql&gt; \\q<br \/>\n# exit<br \/>\nsudo vi mysql\/my.cnf<br \/>\n[mysqld]\u5185\u306b\u4e0b\u8a18\u3092\u8ffd\u52a0<br \/>\ndefault_authentication_plugin= mysql_native_password<\/p><\/blockquote>\n<\/li>\n<li>\u518d\u5ea6\u3001php artisan admin:install\u3092\u5b9f\u884c<br \/>\n<blockquote><p>php artisan admin:install<\/p>\n<p>Nothing to migrate.<br \/>\nDatabase seeding completed successfully.<br \/>\nAdmin directory was created: \/app\/Admin<br \/>\nHomeController file was created: \/app\/Admin\/Controllers\/HomeController.php<br \/>\nAuthController file was created: \/app\/Admin\/Controllers\/AuthController.php<br \/>\nExampleController file was created: \/app\/Admin\/Controllers\/ExampleController.php<br \/>\nBootstrap file was created: \/app\/Admin\/bootstrap.php<br \/>\nRoutes file was created: \/app\/Admin\/routes.php<\/p><\/blockquote>\n<\/li>\n<li>\u3053\u3046\u306a\u308c\u3070OK\u3002<\/li>\n<li>\u3055\u3089\u306bLaravel-Admin\u306e\u52d5\u4f5c\u78ba\u8a8d\u3002\u4e0b\u8a18\u3092\u958b\u3044\u3066\u3001admin\/admin\u3067\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u308c\u3070OK\u3002<br \/>\n<blockquote><p>http:\/\/192.168.23.3\/admin\/auth\/login<\/p><\/blockquote>\n<\/li>\n<li>\u4ee5\u4e0a<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p> Composer\u3067Laravel-Admin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb <\/p>\n<p>laradock\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5\u3057\u3066 .\/docker-compose exec workspace bash composer require encore\/laravel-admin php artisan vendor:publish &#8211;provider=&#8221;Encore\\Admin\\AdminServiceProvider&#8221; php artisan admin:install<\/p>\n<p> php artisan admin:install\u3067\u3001\u4e0b\u8a18\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u306e\u3067\u8abf\u67fb <\/p>\n<p>Illuminate\\Database\\QueryException : SQLSTATE[HY000] [2002] Connection refused<\/p>\n<p> MySQL\u306e\u63a5\u7d9a\u60c5\u5831\uff08.env\uff09\u3092\u4fee\u6b63\uff08https:\/\/nobuhiroharada.com\/2018\/07\/21\/laravel-laradock-mysql-refused\/\uff09 <\/p>\n<p>DB_HOST=127.0.0.1 \u2193 DB_HOST=mysql<\/p>\n<p> \u4e0b\u8a18\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u306e\u3067\u8abf\u67fb <\/p>\n<p>Illuminate\\Database\\QueryException : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client<\/p>\n<p> MySQL\u306e\u8a8d\u8a3c\u65b9\u5f0f\u306e\u5909\u66f4\uff08https:\/\/qiita.com\/shunichi_com\/items\/9b09c5949233b88b9a4a\uff09 <\/p>\n<p>.\/docker-compose exec mysql bash # mysql -u root -p \u30d1\u30b9\u30ef\u30fc\u30c9\uff1aroot [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-449","post","type-post","status-publish","format-standard","hentry","category-centos","odd"],"_links":{"self":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts\/449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=449"}],"version-history":[{"count":2,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts\/449\/revisions"}],"predecessor-version":[{"id":451,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts\/449\/revisions\/451"}],"wp:attachment":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}