{"id":7250,"date":"2022-06-13T09:54:27","date_gmt":"2022-06-13T00:54:27","guid":{"rendered":"https:\/\/gri.jp\/media\/?p=7250"},"modified":"2022-06-13T09:54:27","modified_gmt":"2022-06-13T00:54:27","slug":"%e3%80%90matillion%e3%80%91https%e5%8c%96%e5%a5%ae%e9%97%98%e8%a8%98","status":"publish","type":"post","link":"https:\/\/gri.jp\/media\/entry\/7250","title":{"rendered":"\u3010Matillion\u3011https\u5316\u596e\u95d8\u8a18"},"content":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\uff01<br \/>\n\u5206\u6790\u5b98\u306e\u671b\u6708\u3067\u3059\u3002<\/p>\n<p>\u6700\u8fd1\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5148\u3067\u30c8\u30e9\u30a4\u30a2\u30eb\u5229\u7528\u3057\u3066\u3044\u308b<a href=\"https:\/\/www.matillion.com\/products\/etl-software\/\" target=\"_blank\" rel=\"noopener\">Matillion<\/a>(ELT\u30c4\u30fc\u30eb)\u3092https\u5316\u3057\u307e\u3057\u305f\u3002\u672c\u8a18\u4e8b\u3067\u306f\u305d\u306e\u969b\u306e\u624b\u9806\u3092\u5099\u5fd8\u9332\u7684\u306b\u307e\u3068\u3081\u3066\u3044\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u30de\u30cb\u30a2\u30c3\u30af\u306a\u30c6\u30fc\u30de\u306b\u306f\u306a\u308a\u307e\u3059\u304c\u3001\u3053\u308c\u304b\u3089https\u5316\u3059\u308b\u4eba\u306e\u53c2\u8003\u306b\u306a\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n<h5><span style=\"color: #ff0000;\">\u6ce8\u610f\uff01<\/span><\/h5>\n<p>\u4e0b\u8a18\u306b\u8a18\u8f09\u3057\u3066\u3044\u308b\u624b\u9806\u3088\u308a\u3082\u30b9\u30de\u30fc\u30c8\u306a\u3084\u308a\u65b9\u304c\u3042\u308b\u3068\u601d\u3063\u3066\u307e\u3059\u3002<br \/>\n\u3054\u5b58\u3058\u306e\u65b9\u3001\u5171\u6709\u3057\u3066\u3044\u305f\u3060\u3051\u307e\u3059\u3068\u5e78\u3044\u3067\u3059\u3002<\/p>\n<h3>https\u5316\u306e\u5fc5\u8981\u6027<\/h3>\n<ul>\n<li>Matillion\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3060\u3068http\u901a\u4fe1\u3057\u304b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044<\/li>\n<li>\n<p data-renderer-start-pos=\"7\">\u30d6\u30e9\u30a6\u30b6\u7d4c\u7531\u3067\u5b89\u5168\u306b\u60c5\u5831\u3092\u3084\u308a\u53d6\u308a\u3059\u308b\u305f\u3081\u306bhttp\u3067\u884c\u308f\u308c\u308bweb\u901a\u4fe1\u306b\u3001SSL\/TLS\u3092\u52a0\u3048\u3066https\u5316\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b<\/p>\n<\/li>\n<\/ul>\n<h3>Matillion\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u60c5\u5831<\/h3>\n<ul>\n<li>\u30af\u30e9\u30a6\u30c9\uff1aGCP<\/li>\n<li>OS\uff1aCentOS 7<\/li>\n<\/ul>\n<h3>\u5229\u7528\u3057\u305f\u30b5\u30fc\u30d3\u30b9<\/h3>\n<ul>\n<li>\u30c9\u30e1\u30a4\u30f3\u53d6\u5f97\uff06DNS\u8a2d\u5b9a\uff1a<a href=\"https:\/\/www.onamae.com\/\" target=\"_blank\" rel=\"noopener\">\u304a\u540d\u524d.com<\/a><\/li>\n<li>SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u767a\u884c\uff1a<a href=\"https:\/\/letsencrypt.org\/ja\/\" target=\"_blank\" rel=\"noopener\">Let&#8217;s Encrypt<\/a><\/li>\n<\/ul>\n<h3>\u4e0a\u8a18\u30b5\u30fc\u30d3\u30b9\u5229\u7528\u8cbb<\/h3>\n<ul>\n<li>\u304a\u540d\u524d.com\uff1a1\u5186\/\u5e74<br \/>\n\u203b1 \u6709\u52b9\u671f\u9650\u306f1\u5e74\u9593\uff082\u5e74\u76ee\u4ee5\u964d\u306f1,408\u5186\uff09<br \/>\n\u203b2 \u30c9\u30e1\u30a4\u30f3\u306fcom\u3092\u9078\u629e<\/li>\n<li>Let&#8217;s Encrypt\uff1a\u7121\u6599<br \/>\n\u203b\u00a0\u6709\u52b9\u671f\u9650\u306f90\u65e5\u9593<\/li>\n<\/ul>\n<h3>\u624b\u9806<\/h3>\n<h4>1. Matillion\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u5916\u90e8IP\u3092\u56fa\u5b9a\uff06\u304a\u540d\u524d.com\u3067\u30c9\u30e1\u30a4\u30f3\u53d6\u5f97\u30fbDNS\u8a2d\u5b9a<\/h4>\n<p><a href=\"https:\/\/1e100.4watcher365.dev\/google-cloud\/google-cloud-platform\/google-domains-dns_static-ip-address\/\" target=\"_blank\" rel=\"noopener\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u304c\u53c2\u8003\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<h4 id=\"2.-Let's-Encrypt\u3092\u5229\u7528\u3057\u3066SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u53d6\u5f97\" data-renderer-start-pos=\"560\">2. Let&#8217;s Encrypt\u3092\u5229\u7528\u3057\u3066SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u53d6\u5f97<\/h4>\n<h5><span class=\"fabric-text-color-mark\" style=\"color: #ff0000;\" data-renderer-mark=\"true\" data-text-custom-color=\"#ff5630\">\u6ce8\u610f\uff01<\/span><\/h5>\n<p>\u30c6\u30ad\u30c8\u30fc\u306b\u3044\u3058\u3063\u3066Matillion\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u74b0\u5883\u3092\u58ca\u3057\u305f\u304f\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u521d\u5fc3\u8005\u306e\u671b\u6708\u306f\u308f\u3056\u308f\u3056\u8a3c\u660e\u66f8\u767a\u884c\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\uff08CentOS 7\uff09\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\u3000\u2190\u591a\u5206\u3053\u3093\u306a\u3053\u3068\u3059\u308b\u5fc5\u8981\u306f\u306a\u3055\u305d\u3046&#8230;<\/p>\n<h5>2-1. \u8a3c\u660e\u66f8\u767a\u884c\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306bssh\u63a5\u7d9a<\/h5>\n<h5>2-2. snapd\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\uff08certbot\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u306e\u306b\u5fc5\u8981\uff09<\/h5>\n<pre class=\"language-markup\"><code># snapd\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\nsudo yum install snapd\r\n# \u30b5\u30fc\u30d3\u30b9\u81ea\u52d5\u8d77\u52d5\u3092\u6709\u52b9\u5316\r\nsudo systemctl enable --now snapd.socket\r\n# \u30b7\u30f3\u30dc\u30ea\u30c3\u30af\u30ea\u30f3\u30af\u306e\u8a2d\u5b9a\r\nsudo ln -s \/var\/lib\/snapd\/snap \/snap<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h5 data-renderer-start-pos=\"907\">2-3. snapd\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u6700\u65b0\u3067\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d<\/h5>\n<pre class=\"language-markup\"><code>sudo snap install core; sudo snap refresh core<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h5 data-renderer-start-pos=\"984\">2-4. certbot\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\uff08SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u767a\u884c\u3059\u308b\u306e\u306b\u5fc5\u8981\uff09<\/h5>\n<pre class=\"language-markup\"><code># certbot\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\nsudo snap install --classic certbot\r\n# \u30b7\u30f3\u30dc\u30ea\u30c3\u30af\u30ea\u30f3\u30af\u306e\u8a2d\u5b9a\r\nsudo ln -s \/snap\/bin\/certbot \/usr\/bin\/certbot<\/code><\/pre>\n<p data-renderer-start-pos=\"1140\">\u203b\u3059\u3067\u306bapt, dnf, yum\u7b49\u3067certbot\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3042\u3089\u304b\u3058\u3081\u524a\u9664\u3057\u3066\u304a\u304f<\/p>\n<h5 id=\"2-5.-SSL\u30b5\u30fc\u30d0\u30fc\u8a3c\u660e\u66f8\u3092\u767a\u884c\" data-renderer-start-pos=\"1193\">2-5. SSL\u30b5\u30fc\u30d0\u30fc\u8a3c\u660e\u66f8\u3092\u767a\u884c<\/h5>\n<pre class=\"language-markup\"><code># manual\u8a2d\u5b9a\u306e\u5834\u5408\r\nsudo certbot certonly --manual --preferred-challenges dns -d *.[\u4efb\u610f\u306e\u30c9\u30e1\u30a4\u30f3\u540d(\u4f8b:hogehoge.com)]<\/code><\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>\u4e0a\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u2192\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u767b\u9332, \u8af8\u3005\u306e\u5185\u5bb9\u78ba\u8a8d<\/li>\n<li>\u6700\u5f8c\u306b\u8868\u793a\u3055\u308c\u308b\u30c6\u30ad\u30b9\u30c8\u30ec\u30b3\u30fc\u30c9\u306e\u60c5\u5831\u3092DNS\u30b5\u30fc\u30d0\u306b\u767b\u9332<\/li>\n<li>Enter\u3092\u62bc\u3059\u3068\/etc\/letsencrypt\/live\/[\u30c9\u30e1\u30a4\u30f3\u540d]\u76f4\u4e0b\u306b\u8a3c\u660e\u66f8\u304c\u683c\u7d0d\u3055\u308c\u308b\n<ul>\n<li>README<\/li>\n<li>cert.pem<\/li>\n<li>chain.pem<\/li>\n<li>fullchain.pem<\/li>\n<li>privkey.pem<\/li>\n<\/ul>\n<\/li>\n<li>\u53c2\u8003\uff1a<a href=\"https:\/\/hawksnowlog.blogspot.com\/2018\/08\/certbot-dns-challenge-on-mac.html\" target=\"_blank\" rel=\"noopener\">https:\/\/hawksnowlog.blogspot.com\/2018\/08\/certbot-dns-challenge-on-mac.html<\/a><\/li>\n<\/ul>\n<h4 id=\"3.-Matillion\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306bSSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u683c\u7d0d\" data-renderer-start-pos=\"1542\">3. Matillion\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306bSSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u683c\u7d0d<\/h4>\n<h5 data-renderer-start-pos=\"1542\">3-1. Matillion\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306bSSH\u63a5\u7d9a<\/h5>\n<h5 data-renderer-start-pos=\"1542\">3-2. \u65e2\u5b58\u306e\u8a3c\u660e\u66f8\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u5f97<\/h5>\n<pre class=\"language-markup\"><code>sudo -i\r\ncd \/etc\/tomcat8\/\r\ncp localhost.crt localhost.crt.bak\r\ncp localhost.key localhost.key.bak<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h5 id=\"3-3.-SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u683c\u7d0d\" data-renderer-start-pos=\"1724\">3-3. SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u683c\u7d0d<\/h5>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=4nL3-ZVzGmQ\" target=\"_blank\" rel=\"noopener\">\u3053\u3061\u3089\u306e\u52d5\u753b<\/a>\u304c\u53c2\u8003\u306b\u306a\u308a\u307e\u3057\u305f\u3002<br \/>\n\u203b\u4e0a\u8a18\u52d5\u753b\u3067\u7d39\u4ecb\u3055\u308c\u3066\u3044\u308b\u65b9\u6cd5\u3067\u683c\u7d0d\u3059\u308b\u5834\u5408\u3001\u3042\u3089\u304b\u3058\u3081SSL\u8a3c\u660e\u66f8\u3092\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u306b\u843d\u3068\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<h3 data-renderer-start-pos=\"1812\">\u632f\u308a\u8fd4\u308a<\/h3>\n<p>\u308f\u3056\u308f\u3056\u8a3c\u660e\u66f8\u767a\u884c\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u3059\u308b\u5fc5\u8981\u306f\u306a\u3055\u305d\u3046\u3067\u3059\u3002\uff08Matillion\u7528\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3067certbot\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u2192SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u3092\u767a\u884c\u3059\u308c\u3070\u826f\u3044\u304b\u3082\uff09<\/p>\n<h3 id=\"\u6b8b\u8ab2\u984c\" data-renderer-start-pos=\"1958\">\u6b8b\u8ab2\u984c<\/h3>\n<p>\u624b\u52d5\u3067ssl\u8a3c\u660e\u66f8\u3092\u683c\u7d0d\u3057\u3066\u3044\u308b\u306e\u306790\u65e5\u306b1\u56de\u3001SSL\u30b5\u30fc\u30d0\u8a3c\u660e\u66f8\u518d\u767a\u884c\u306e\u624b\u4f5c\u696d\u304c\u767a\u751f\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002\uff08<a href=\"https:\/\/it-jog.com\/khow\/serv\/renewletsencrypt#auto\" target=\"_blank\" rel=\"noopener\">\u3053\u3053\u3089\u3078\u3093<\/a>\u304c\u53c2\u8003\u306b\u306a\u308a\u305d\u3046\uff09<\/p>\n<h3>\u305d\u306e\u4ed6\u53c2\u8003<\/h3>\n<p data-renderer-start-pos=\"2045\">certbot\u3068\u306f\uff1f\uff1a<span data-inline-card=\"true\" data-card-url=\"https:\/\/certbot.eff.org\/pages\/about\"><span class=\"loader-wrapper\"><a class=\"css-19qw24g eeajecn0\" role=\"button\" href=\"https:\/\/certbot.eff.org\/pages\/about\" target=\"_blank\" rel=\"noopener\" data-testid=\"inline-card-resolved-view\"><span class=\"css-1p7ax5 e158gagu2\"><span class=\"smart-link-title-wrapper css-0 e158gagu8\">About Certbot<\/span><\/span><\/a><br \/>\n<\/span><\/span>certbot\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5\uff08CentOS 7\uff09\uff1a<span data-inline-card=\"true\" data-card-url=\"https:\/\/certbot.eff.org\/instructions?ws=other&amp;os=centosrhel7\"><span class=\"loader-wrapper\"><a class=\"css-19qw24g eeajecn0\" role=\"button\" href=\"https:\/\/certbot.eff.org\/instructions?ws=other&amp;os=centosrhel7\" target=\"_blank\" rel=\"noopener\" data-testid=\"inline-card-resolved-view\"><span class=\"css-1p7ax5 e158gagu2\"><span class=\"smart-link-title-wrapper css-0 e158gagu8\">Certbot Instructions<\/span><\/span><\/a><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\uff01 \u5206\u6790\u5b98\u306e\u671b\u6708\u3067\u3059\u3002 \u6700\u8fd1\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5148\u3067\u30c8\u30e9\u30a4\u30a2\u30eb\u5229\u7528\u3057\u3066\u3044\u308bMatillion(ELT\u30c4\u30fc\u30eb)\u3092https\u5316\u3057\u307e\u3057\u305f\u3002\u672c\u8a18\u4e8b\u3067\u306f\u305d\u306e\u969b\u306e\u624b\u9806\u3092\u5099\u5fd8\u9332\u7684\u306b\u307e\u3068\u3081\u3066\u3044\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u30de\u30cb\u30a2\u30c3\u30af\u306a\u30c6\u30fc\u30de\u306b\u306f\u306a\u308a<\/p>\n","protected":false},"author":10,"featured_media":2178,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[131],"tags":[],"class_list":["post-7250","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-matillion"],"acf":[],"meta_field":{"_edit_lock":["1669802002:10"],"_edit_last":["42"],"_thumbnail_id":["2178"],"hidden_toppage":["0"],"_hidden_toppage":["field_61933136630d2"],"note_url":[""],"_note_url":["field_61243c8278b90"],"_oembed_55c7d5a62cfb3719c3e41f679bb3d06e":["{{unknown}}"],"_wp_old_date":["2022-05-26"],"_pv_count":["a:24:{i:9;i:57;i:10;i:48;i:11;i:67;i:12;i:33;i:22;i:19;i:16;i:48;i:13;i:51;i:15;i:52;i:19;i:29;i:6;i:21;i:3;i:60;i:17;i:52;i:14;i:63;i:18;i:36;i:8;i:31;i:0;i:21;i:2;i:115;i:1;i:171;i:7;i:11;i:20;i:21;i:5;i:20;i:4;i:29;i:23;i:22;i:21;i:9;}"],"pv_count":["1086"]},"_links":{"self":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/7250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/comments?post=7250"}],"version-history":[{"count":44,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/7250\/revisions"}],"predecessor-version":[{"id":7641,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/7250\/revisions\/7641"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/media\/2178"}],"wp:attachment":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/media?parent=7250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/categories?post=7250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/tags?post=7250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}