{"id":1482,"date":"2022-09-04T23:15:16","date_gmt":"2022-09-04T15:15:16","guid":{"rendered":"https:\/\/yowlab.idv.tw\/wordpress\/?p=1482"},"modified":"2022-09-04T23:36:18","modified_gmt":"2022-09-04T15:36:18","slug":"%e3%80%8c%e9%bb%9e%e6%95%b8%e9%8a%80%e8%a1%8c%e3%80%8d%e5%8d%87%e7%b4%9a%e8%a8%98%e9%8c%84","status":"publish","type":"post","link":"https:\/\/yowlab.idv.tw\/wordpress\/?p=1482","title":{"rendered":"\u300c\u9ede\u6578\u9280\u884c\u300d\u5347\u7d1a\u8a18\u9304"},"content":{"rendered":"<p>\u300c<a href=\"https:\/\/ebank.ceag.kh.edu.tw\/\" rel=\"noopener\" target=\"_blank\">\u9ede\u6578\u9280\u884c<\/a>\u300d\u662f\u76ee\u524d\u4efb\u8077\u670d\u52d9\u65bc\u9ad8\u96c4\u5e02\u93ae\u660c\u570b\u5c0f\u9673\u61b2\u5b8f\u8001\u5e2b\u8207\u9ad8\u96c4\u5e02\u56db\u7dad\u570b\u5c0f\u9673\u60e0\u5982\u8001\u5e2b\u5169\u4eba\u5408\u4f5c\u958b\u767c\u800c\u6210\u7cfb\u7d71\u3002N\u5e74\u524d\uff08N >10\uff09\u4fbf\u5df2\u4e0a\u7dda\u670d\u52d9\uff0c\u53ea\u4e0d\u904e\u7576\u6642\u597d\u50cf\u53ea\u670d\u52d9\u4e86\u5169\u500b\u73ed\u7d1a\uff0c\u7576\u5e74\u5728\u6211\u539a\u81c9\u76ae\u7684\u904a\u8aaa\u4e0b\uff0c\u7d04\u83ab\u5728 2012 \u5e74\u9593\u5c07\u6574\u500b\u7cfb\u7d71\u4e3b\u6a5f\u653e\u7f6e\u5230\u9ad8\u96c4\u5e02\u8cc7\u8a0a\u6559\u80b2\u4e2d\u5fc3\uff0c\u958b\u59cb\u7121\u511f\u670d\u52d9\u63d0\u4f9b\u7d66\u66f4\u591a\u6709\u8208\u8da3\u4f7f\u7528\u7684\u8001\u5e2b\u4f7f\u7528\u3002<\/p>\n<style type=\"text\/css\">\n    li.present01 {line-height:1.5em; background-color:#F5E5C9; padding:5px; border-radius:10px; font-weight:bold; margin:5px;}\n    li.present02 {line-height:1.5em; background-color:#D1EC87; padding:5px; border-radius:10px; font-weight:bold; margin:5px;}\n    li.present03 {line-height:1.5em; background-color:#b3dffa; padding:5px; border-radius:10px; font-weight:bold; margin:5px;}\n    li.present04 {line-height:1.5em; background-color:#FDF6FF; padding:10px; border-radius:10px; font-weight:bold; margin:5px;}\n    ol.lower-alpha {list-style-type:lower-alpha;}\n    ol.lower-roman {list-style-type:lower-roman;}\n    ul.none {list-style-type:none;line-height:1.5em; padding:10px;}\n    ul.note {line-height:1.5em; padding:10px;}\n    .highlight01 {font-weight:bold; line-height:1.5em; background-color:#e7f49c; padding:0px 2px; border:1px; border-radius:10px;}\n    .highlight02 {font-weight:bold; line-height:1.5em; background-color:#F2F26B; padding:1px 1px; border:1px;}\n    .highlight03 {font-weight:bold; line-height:1.5em; background-color:#F9BF72; padding:3px 10px; border:2px; border-radius:10px;}\n   .box01 {margin: 5px; border:1px #19130B solid; border-radius:5px; padding:10px;}\n    .box02 {margin: 5px; font-weight:bold; line-height:1.5em; padding:10px; border:1px #19130B solid; border-radius:5px; float: left;}\n    h3 {border:2px #000 solid; border-width:0px 0px 1px 0px; padding-width:0px 0px 3px 0px;}\n<\/style>\n<p>\u5f8c\u4f86\uff0c\u4e00\u65b9\u9762\u7531\u65bc\u7cfb\u7d71\u7a69\u5b9a\uff0c\u6240\u4ee5\u6839\u672c\u4e0d\u9700\u8981\u6211\u53bb\u7279\u5225\u95dc\u7167\uff1b\u4e8c\u65b9\u9762\u6211\u500b\u4eba\u4e5f\u96e2\u958b\u4e86\u76f8\u95dc\u8077\u4f4d\uff0c\u6240\u4ee5\u66f4\u4e0d\u9808\u8981\u53bb\u8aaa\u4e09\u9053\u56db\uff0c\u4ee5\u514d\u9020\u6210\u5225\u4eba\u7684\u56f0\u64fe\u3002\u6240\u4ee5\u8a72\u7cfb\u7d71\u4e5f\u5c31\u9010\u6f38\u6de1\u51fa\u6211\u7684\u5927\u8166\u3002<\/p>\n<p>\u4e00\u76f4\u5230\u6700\u8fd1\u7a81\u7136\u6536\u5230\u67d0\u6d88\u606f\uff0c\u5927\u610f\u4fbf\u662f\u56e0\u70ba\u8a72\u7cfb\u7d71\u5df2\u7d93\u5f88\u8001\u820a\uff0c\u8a31\u591a\u8a72\u505a\u7684\u7cfb\u7d71\u6f0f\u6d1e\u5b8c\u5168\u6c92\u6709\u4fee\u88dc\u3002\u800c\u82e5\u4e0d\u8655\u7406\uff0c\u70ba\u907f\u514d\u8a72\u6a5f\u5668\u6210\u70ba\u6574\u500b\u55ae\u4f4d\u7684\u8cc7\u5b89\u6f0f\u6d1e\uff0c\u300c\u95dc\u7ad9\u300d\u5c07\u662f\u552f\u4e00\u4e4b\u8def\u3002<\/p>\n<p>\u6536\u5230\u6b64\u8a0a\u606f\u4e4b\u5f8c\uff0c\u600e\u9ebc\u8fa6\uff1f<span class=\"highlight01\">\u5f88\u7c21\u55ae\uff0c\u6c92\u6709\u7b2c\u4e8c\u689d\u8def\uff0c\u7db2\u7ad9\u5168\u9762\u5347\u7d1a\u3002<\/span><\/p>\n<ol>\n<li class=\"present01\">\u4f5c\u696d\u7cfb\u7d71\u7531 Ubuntu 9.04 (Jaunty Jackalope ) \u63db\u6210 Rocky Linux release 8.6 (Green Obsidian)\u3002<\/li>\n<p>          \u7cfb\u7d71\u525b\u5b89\u88dd\u5b8c\u6210\u4e4b\u5f8c\uff0c\u9700\u8981\u8a2d\u5b9a\u6642\u5340\uff0c\u4ee5\u53ca\u81ea\u52d5\u5c0d\u6642\u3002<br \/>\n          \u6642\u5340\u8a2d\u5b9a\uff1a<span class=\"highlight01\"> sudo timedatectl set-timezone Asia\/Taipei <\/span><\/p>\n<p>          \u555f\u52d5 ntp \u670d\u52d9\uff1a<span class=\"highlight01\"> sudo timedatectl set-ntp on <\/span><\/p>\n<p>          Rocky Linux \u7528 chrony \u4f86\u53d6\u4ee3 ntpdate\uff0c\u4e14\u7a0b\u5f0f\u7d44\u4e5f\u5df2\u5167\u5efa\uff0c\u6240\u4ee5\u53ea\u8981\u8a2d\u5b9a\u300c\u6821\u6642\u4f3a\u670d\u5668\u300d\u4f4d\u5740\u4fbf\u53ef\u3002<br \/>\n          <span class=\"highlight01\">sudo vim \/etc\/chrony.conf <\/span><\/p>\n<div class=\"box01\">\n           # Use public servers from the pool.ntp.org project.<br \/>\n           # Please consider joining the pool (http:\/\/www.pool.ntp.org\/join.html).<br \/>\n           #pool 2.pool.ntp.org iburst<br \/>\n           <span class=\"highlight01\">server time.stdtime.gov.tw <\/span><br \/>\n           <span class=\"highlight01\">server time.kh.edu.tw <\/span>\n           <\/div>\n<p>           \u555f\u52d5 \u7db2\u8def\u6821\u6642\u670d\u52d9\uff1a<span class=\"highlight01\"> sudo systemctl restart chronyd  <\/span><\/p>\n<li class=\"present01\">\u7db2\u9801\u7cfb\u7d71\uff0cApache httpd 2.4.37\u3002<\/li>\n<li class=\"present01\">\u914d\u5408\u76ee\u524d\u8cc7\u5b89\u6f6e\u6d41\uff0c\u70ba\u7db2\u7ad9\u7533\u8acb\u6191\u8b49\uff0c\u9023\u7dda\u65b9\u5f0f\u6210\u70ba https \u4e2d\u4e00\u54e1\u3002 <\/li>\n<li class=\"present01\">PHP \u4f7f\u7528 php56 (\u8003\u91cf\u7576\u6642 \u9ede\u6578\u9280\u884c\u958b\u767c\u7684\u7a0b\u5f0f\u78bc \u76f8\u5bb9\u6027\u554f\u984c)<\/li>\n<li class=\"present01\">\u8cc7\u6599\u5eab\u5347\u7d1a\u81f3 mariadb-server-10.3.32-2<\/li>\n<p>            \u56e0\u70ba\u9ede\u6578\u9280\u884c\u7cfb\u7d71\u958b\u767c\u7576\u6642\u662f\u4f7f\u7528 mysql5.xxx\uff0c\u4ee5\u7576\u6642\u6709\u4e9b\u5beb\u6cd5\u5c0d\u76ee\u524d\u7684\u8cc7\u6599\u5eab\u4f86\u8aaa\u6703\u986f\u5f97\u6bd4\u8f03\u300c\u96a8\u6027\uff08\u7c97\u66b4\uff09\u300d\uff0c\u800c\u76ee\u524d\u7684\u8cc7\u6599\u5eab\u7cfb\u7d71\u9810\u8a2d\u90fd\u5df2\u6709\u81ea\u6211\u4fdd\u8b77\u6a5f\u5236\uff0c\u6240\u4ee5\u6703\u9020\u6210\u7a0b\u5f0f\u57f7\u884c\u932f\u8aa4\uff0c\u4f8b\u5982\u51fa\u73fe\u300cField &#8216;id&#8217; doesn&#8217;t have a default value\u300d\u7b49\u932f\u8aa4\u3002<\/p>\n<p>             \u89e3\u6c7a\u65b9\u5f0f\uff1a\u5728<span class=\"highlight01\"> \/etc\/my.cnf.d\/mariadb-server.cnf <\/span>\u4e2d\u52a0\u5165 <span class=\"highlight01\">sql_mode=&#8221;ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&#8221;<\/span><br \/>\n             \u610f\u601d\u70ba\u63a1\u7528\u975e\u56b4\u683c\u6a21\u5f0f\uff0c\u8b93\u6c92\u6709\u8a2d\u5b9a\u9810\u8a2d\u503c\u7684\u975enull\u6b04\u4f4d\u53ef\u4ee5\u6709\u9810\u8a2d\u503c\u3002<\/p>\n<p>             \u800c mariadb server \u7684\u9810\u8a2d\u503c\u70ba <span class=\"highlight01\">STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION <\/span><\/p>\n<li class=\"present01\">\u7a0b\u5f0f\u90e8\u4efd\uff0c\u8a9e\u7cfb\u7de8\u78bc\u7531 Big5 \u5168\u9762\u66f4\u6539\u6210 UTF8<\/li>\n<p>             \u4f7f\u7528 iconv \u8ca0\u8cac\u9032\u884c\u8a9e\u7cfb\u8f49\u78bc\u3002 sed \/ awk \u53ef\u4ee5\u5f88\u5feb\u7684\u9032\u884c\u6a94\u6848\u5b57\u4e32\u7f6e\u63db\u8207\u6a94\u6848\u8f49\u63db\u7684\u5de5\u4f5c\u3002 <\/p>\n<li class=\"present01\">\u4f9d\u820a\u6bcf\u665a\u56fa\u5b9a\u6642\u9593\u5c0d\u300c\u8cc7\u6599\u5eab\u300d\u8207\u300c\u7db2\u7ad9\u7cfb\u7d71\u300d\u9032\u884c\u5099\u4efd\u3002<\/li>\n<\/ol>\n<p>\u5728\u7cfb\u7d71\u5347\u7d1a\u5b8c\u6210\u4e4b\u5f8c\uff0c\u624d\u8d6b\u7136\u767c\u73fe\uff0c\u539f\u4f86\u9019\u500b\u4e3b\u6a5f\u7cfb\u7d71\u5df2\u6d3b\u904e 10 \u5e74\uff0c\u96e3\u602a\u61b2\u5b8f\u8001\u5e2b\u8ddf\u6211\u8aaa\uff0c\u518d\u4f86 10 \u5e74\u7684\u8a71\u8a9e\u3002<\/p>\n<p><span class=\"highlight01\">\u8877\u5fc3\u611f\u8b1d\u6210\u5c31\u9019\u4e00\u5207\u7684\u6a5f\u7de3\uff0c\u4ee5\u53ca\u5176\u4e2d\u7684\u9ed8\u9ed8\u4ed8\u51fa\u52aa\u529b\u7684\u5404\u4f4d\u91cd\u8981\u95dc\u4fc2\u4eba\u3002<\/span><\/p>\n<h3>\u53c3\u8003\u8cc7\u6e90\uff1a<\/h3>\n<ol>\n<li>Rocky Linux \u5b89\u88dd Apache, PHP, MariaDB (LAMP) <\/li>\n<p><a href=\"https:\/\/www.ltsplus.com\/linux\/rocky-linux-install-apache-php-mariadb-lamp\" rel=\"noopener\" target=\"_blank\">https:\/\/www.ltsplus.com\/linux\/rocky-linux-install-apache-php-mariadb-lamp<\/a><\/p>\n<li>How to Disable or Turn Off SELinux on Rocky Linux 8<\/li>\n<p><a href=\"https:\/\/www.how2shout.com\/linux\/how-to-disable-or-turn-off-selinux-on-rocky-linux-8\/\" rel=\"noopener\" target=\"_blank\">https:\/\/www.how2shout.com\/linux\/how-to-disable-or-turn-off-selinux-on-rocky-linux-8\/<\/a><\/p>\n<li>\u7f51\u7edc\u914d\u7f6e<br \/>\n<a href=\"https:\/\/docs.rockylinux.org\/zh\/guides\/network\/basic_network_configuration\/\" rel=\"noopener\" target=\"_blank\">https:\/\/docs.rockylinux.org\/zh\/guides\/network\/basic_network_configuration\/<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u300c\u9ede\u6578\u9280\u884c\u300d\u662f\u76ee\u524d\u4efb\u8077\u670d\u52d9\u65bc\u9ad8\u96c4\u5e02\u93ae\u660c\u570b\u5c0f\u9673\u61b2\u5b8f\u8001\u5e2b\u8207\u9ad8\u96c4\u5e02\u56db\u7dad\u570b\u5c0f\u9673\u60e0\u5982\u8001\u5e2b\u5169\u4eba <a class=\"more-link\" href=\"https:\/\/yowlab.idv.tw\/wordpress\/?p=1482\">Continue reading <span class=\"screen-reader-text\">  \u300c\u9ede\u6578\u9280\u884c\u300d\u5347\u7d1a\u8a18\u9304<\/span><span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,2],"tags":[64],"class_list":["post-1482","post","type-post","status-publish","format-standard","hentry","category-3","category-2","tag-64"],"_links":{"self":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1482"}],"version-history":[{"count":13,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1482\/revisions"}],"predecessor-version":[{"id":1495,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1482\/revisions\/1495"}],"wp:attachment":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}