{"id":4959,"date":"2024-03-22T18:39:09","date_gmt":"2024-03-22T09:39:09","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=4959"},"modified":"2024-03-22T18:42:28","modified_gmt":"2024-03-22T09:42:28","slug":"post-4959","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/4959","title":{"rendered":"CentOS7\u7cfb\u304b\u3089AlmaLinux8\u7cfb\u306b\u79fb\u884c(\u30b5\u30fc\u30d0\u3082\u79fb\u884c)\u3057\u305f\u969b\u306b\u8a70\u307e\u3063\u305f\u70b9\u3068\u5909\u66f4\u70b9"},"content":{"rendered":"

\u524d\u65e5CentOS7\u7cfb\u304b\u3089AlmaLinux8\u7cfb\u306b\u79fb\u884c\u3057\u305f(\u30b5\u30fc\u30d0\u306f\u3069\u3061\u3089\u3082\u540c\u3058VPS)\u3002LAMP\u74b0\u5883\u69cb\u7bc9<\/a>\u3084Let\u2019s_Encrypt\u306eDNS\u8a8d\u8a3c<\/a>\u7b49\u3001\u4e8b\u524d\u306b\u4e88\u884c\u6f14\u7fd2\u3057\u3066\u3044\u305f\u3082\u306e\u306e\u3084\u3063\u3071\u308a\u8e93\u304f\u70b9\u3082\u3042\u3063\u305f\u3002\u4eca\u5f8c\u306e\u79fb\u884c\u6642\u306b\u3082\u5f79\u7acb\u3064\u304b\u3082\u3057\u308c\u306a\u3044\u306e\u3067\u30cf\u30de\u3063\u305f\u70b9\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5\u3001\u305d\u308c\u3068CentOS\u74b0\u5883\u304b\u3089\u5909\u66f4\u3057\u305f\u70b9\u3092\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

\u8a70\u307e\u3063\u305f\u70b9<\/h2>\n

MySQL\u306e\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u30a4\u30f3\u30dd\u30fc\u30c8\u6642\u306b\u300cAccess to system table 'mysql.innodb_index_stats' is rejected.\u300d\u30a8\u30e9\u30fc<\/h3>\n

MySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u3069\u3063\u3061\u3082Ver 8.0.32\u306e\u7b48\u306a\u306e\u306b\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u300cAccess to system table 'mysql.innodb_index_stats' is rejected.\u300d\u3068\u3044\u3046\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u305f\u3002<\/p>\n

\u3053\u3061\u3089\u306e\u30b5\u30a4\u30c8<\/a>\u306b\u3088\u308b\u3068\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210\u6642\u306b\u7279\u5b9a\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u9664\u5916\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3089\u3057\u3044(DDL\u304c\u4e91\u3005\u3068\u3044\u3046\u306e\u306f\u3088\u304f\u308f\u304b\u3089\u306a\u304b\u3063\u305f)\u3002<\/p>\n

\u5177\u4f53\u7684\u306b\u306f\u30b5\u30fc\u30d0\u306bSSH\u63a5\u7d9a\u3057\u4ee5\u4e0b\u30b3\u30de\u30f3\u30c9\u3067\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u51fa\u529b\u3055\u305b\u308b\u3002<\/p>\n

mysqldump --all-databases --ignore-table=mysql.innodb_index_stats --ignore-table=mysql.innodb_table_stats  > \/var\/www\/hoge\/backup.sql\r\n<\/pre>\n
\u4e0a\u8a18\u306e\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u3067\u3042\u308c\u3070Adminer\u304b\u3089\u6b63\u5e38\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3067\u304d\u305f\u3002<\/p>\n
Basic\u8a8d\u8a3c\u304c\u52b9\u304b\u306a\u3044<\/h3>\n
\u7279\u5b9a\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306bBasic\u8a8d\u8a3c\u3092\u304b\u3051\u3066\u3044\u308b\u7b48\u304c\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u306a\u304b\u3063\u305f\u3002<\/p>\n
\u3053\u3061\u3089\u306f\u904e\u53bb\u8a18\u4e8b<\/a>\u3092\u53c2\u8003\u306e\u4e0a\u3067\u4ee5\u4e0b\u306e\u901a\u308a\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n
#\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u66f4\r\nvim \/etc\/httpd\/conf\/httpd.conf\r\n\r\n#AllowOverride NONE\r\n#\u4ee5\u4e0b\u306b\u306b\u66f8\u304d\u63db\u3048(\u8907\u6570\u3042\u308a)\r\nAllowOverride All\r\n\r\n#apache\u306e\u518d\u8d77\u52d5\r\nsystemctl restart apache<\/pre>\n
\u30b5\u30fc\u30d0\u3078\u306eSSH\u63a5\u7d9a\u6642\u306b\u300cActivate the web console with: systemctl enable --now cockpit.socket\u300d\u3068\u30e1\u30c3\u30bb\u30fc\u30b8\u8868\u793a<\/h3>\n
\u3053\u3061\u3089\u306f\u8a70\u307e\u3063\u305f\u70b9\u3067\u306f\u7121\u304f\u6c17\u306b\u306a\u3063\u305f\u70b9\u3060\u304c\u3001\u30b5\u30fc\u30d0\u3078SSL\u63a5\u7d9a\u3057\u305f\u969b\u306b\u300cActivate the web console with: systemctl enable --now cockpit.socket\u300d\u3068\u30e1\u30c3\u30bb\u30fc\u30b8\u8868\u793a\u3055\u308c\u3001\u3053\u308c\u304c\u3046\u3063\u3068\u304a\u3057\u3044\u306a\u3041\u3068\u601d\u3063\u305f\u3002<\/p>\n
\u3053\u3061\u3089\u306e\u30b5\u30a4\u30c8<\/a>\u3092\u53c2\u8003\u306b\u4ee5\u4e0b\u30b3\u30de\u30f3\u30c9\u3067\u975e\u8868\u793a\u306b\u3057\u305f\u3002<\/p>\n
rm \/etc\/motd.d\/cockpit\r\n<\/pre>\n
WordPress\u3067\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u306a\u3044<\/h3>\n
\u5f53\u30b5\u30a4\u30c8\u3068\u306f\u5225\u306bWP\u3092\u5165\u308c\u3066\u304a\u308a\u3001\u305d\u3061\u3089\u306e\u30d5\u30ed\u30f3\u30c8\u5074\u3068\u7ba1\u7406\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u306a\u304b\u3063\u305f(\u771f\u3063\u767d\u306a\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b)\u3002<\/p>\n
\u300c\/wp-includes\/version.php\u300d\u3092\u78ba\u8a8d\u3059\u308b\u3068\u30d0\u30fc\u30b8\u30e7\u30f35.0.20\u3068\u304b\u306a\u308a\u53e4\u3044\u3082\u306e\u3060\u3063\u305f\u3002<\/p>\n
\u7ba1\u7406\u753b\u9762\u304b\u3089\u306f\u30d0\u30fc\u30b8\u30e7\u30f3\u66f4\u65b0\u304c\u3067\u304d\u306a\u3044\u306e\u3067\u516c\u5f0f\u30b5\u30a4\u30c8<\/a>\u3088\u308a\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3001\u8af8\u3005\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3057\u305f\u3002<\/p>\n
 <\/p>\n
\u5909\u66f4\u70b9<\/h2>\n
vim\u306e\u5c0e\u5165<\/h3>\n
SSH\u63a5\u7d9a\u6642\u306e\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u306f\u305a\u3063\u3068vi\u3092\u4f7f\u3063\u3066\u3044\u305f\u304cvim\u306b\u5909\u66f4\u3057\u3066\u307f\u305f\u3002\u4ee5\u4e0b\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u308b\u3002<\/p>\n
dnf -y install vim<\/pre>\n
\u30a8\u30c7\u30a3\u30bf\u3092\u8d77\u52d5\u3059\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u306b\u306a\u308b\u3002<\/p>\n
vim xxxxx.txt<\/pre>\n
\u5c1a\u3001\u4ee5\u4e0b\u30b3\u30de\u30f3\u30c9\u3067\u5225\u540d(\u30a8\u30a4\u30ea\u30a2\u30b9)\u767b\u9332\u3057\u3066\u304a\u3051\u3070vi\u30b3\u30de\u30f3\u30c9\u3067vim\u304c\u8d77\u52d5\u3059\u308b\u3088\u3046\u306b\u306a\u308b\u3002<\/p>\n
#vi\u3067vim\u304c\u8d77\u52d5\u3059\u308b\u3088\u3046\u306b\u8a2d\u5b9a\r\nalias vi='vim'\r\n\r\n#alias\u78ba\u8a8d\r\nalias cp='cp -i'\r\nalias egrep='egrep --color=auto'\r\nalias fgrep='fgrep --color=auto'\r\nalias grep='grep --color=auto'\r\nalias l.='ls -d .* --color=auto'\r\nalias ll='ls -l --color=auto'\r\nalias ls='ls --color=auto'\r\nalias mv='mv -i'\r\nalias rm='rm -i'\r\nalias vi='vim'\r\nalias xzegrep='xzegrep --color=auto'\r\nalias xzfgrep='xzfgrep --color=auto'\r\nalias xzgrep='xzgrep --color=auto'\r\nalias zegrep='zegrep --color=auto'\r\nalias zfgrep='zfgrep --color=auto'\r\nalias zgrep='zgrep --color=auto'<\/pre>\n
\u30c6\u30ad\u30b9\u30c8\u304c\u8272\u4ed8\u3051\u3055\u308c\u308b\u3060\u3051\u3067\u3082\u898b\u3084\u3059\u3055\u304c\u3060\u3044\u3076\u9055\u3063\u305f\u3002\u3082\u3063\u3068\u65e9\u304f\u5c0e\u5165\u3057\u3066\u304a\u3051\u3070\u3088\u304b\u3063\u305f\u3002<\/p>\n
\u5c1a\u3001\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3002<\/p>\n
https:\/\/vim-jp.org\/vimdoc-ja\/<\/a><\/p>\n
DMARC\u30ec\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a<\/h3>\n
\u3053\u308c\u306f\u30b5\u30fc\u30d0\u79fb\u884c\u3068\u306f\u95a2\u4fc2\u306a\u304f\u30cd\u30fc\u30e0\u30b5\u30fc\u30d0\u5074\u306e\u8a2d\u5b9a\u306b\u306a\u308b\u3093\u3060\u3051\u3069\u3001\u30e1\u30fc\u30eb\u95a2\u9023\u306e\u8a2d\u5b9a\u306fSPF\u30ec\u30b3\u30fc\u30c9\u306e\u307f\u767b\u9332<\/a>\u3057\u3066\u3044\u305f\u3002<\/p>\n
\u3053\u3061\u3089\u3092\u516c\u5f0f\u30b5\u30a4\u30c8<\/a>\u3092\u53c2\u8003\u306b\u4ee5\u4e0b\u306e\u901a\u308a\u8a2d\u5b9a\u3057\u305f(\u30e0\u30fc\u30e0\u30fc\u30c9\u30e1\u30a4\u30f3\u306e\u5834\u5408)\u3002<\/p>\n