Mariadb

mariadb-server

• https://stackoverflow.com/questions/64320136/error-2002-hy000-cant-connect-to-mysql-server-on-192-168-1-15-115
  ERROR 2002 (HY000): Can't connect to MySQL server on '172.20.0.2' (115)

• https://java119.tistory.com/61
  ERROR 1130 (HY000): Host '89aa99052798.backend' is not allowed to connect to this MariaDB server

wp

• wp user list
  

Nginx

• https://www.youtube.com/watch?v=hA0cxENGBQQ&t=839s
• 서버 관리 패키지

OPENSSL

• https://devopscube.com/create-self-signed-certificates-openssl/
• https://stackoverflow.com/questions/10175812/how-to-generate-a-self-signed-ssl-certificate-using-openssl

fpm

• https://m.blog.naver.com/dudwo567890/130169637747

www.conf

• https://stackoverflow.com/questions/39481276/how-to-use-copy-command-in-docker-build

Wordpress

• https://www.youtube.com/watch?v=RbMGPExmZc8
  워드프레스는 CMS contents manager system

• https://yorublog.tistory.com/110
  wordpress (nginx + mariadb + php) 설치 방법

• https://itexpert.tips/ko/wordpress-ko/ubuntu-linux에-nginx로-wordpress-설치하기/

• https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-with-lemp-nginx-mariadb-and-php-on-debian-10

• https://www.digitalocean.com/community/tutorials/php-fpm-nginx

AUTH_KEY

• https://www.wpbeginner.com/glossary/security-keys/

tls

• https://nginx.org/en/docs/http/ngx_http_ssl_module.html
• https://nginx.tutorials24x7.com/blog/how-to-enable-tls-1-2-and-tls-1-3-in-nginx
• https://www.sslcert.co.kr/guides/NGINX-SSL-Certificate-Install
• https://m.blog.naver.com/tosemfaos/221508327481
• https://stackoverflow.com/questions/44047315/generate-a-self-signed-certificate-in-docker

wp cli

• https://nolboo.kim/blog/2016/05/16/ultimate-wordpress-development-environment-wp-cli/

php

ERROR: Another FPM instance seems to already listen on /run/php/php7.3-fpm.sock

• https://jicjjang.github.io/posts/php-fastcgi

[20-Oct-2022 09:25:34] ERROR: Another FPM instance seems to already listen on /run/php/php7.3-fpm.sock
[20-Oct-2022 09:25:34] ERROR: FPM initialization failed

• --> 아 바보 system php7.3-fpm stop 하고 저거 해야 함. stop된 상태에서 foreground로 돌려야함.

wordpress  | [20-Oct-2022 10:01:32] ERROR: Unable to create the PID file (/run/php/php7.3-fpm.pid).: No such file or directory (2)

• https://stackoverflow.com/questions/45540492/cannot-start-php-because-it-is-unable-to-create-pid-file

php8.1-fpm

워드프로세스 설정파일 가보니까 php7.3은 업그레이드 해야된다고 나옴.

• 현재 latest version은 8.1. 이왕하는 거 8.1로 다시 설치함
• 대신 debian:10에서 설치하려면 apt update 필요함
• https://www.cloudbooklet.com/how-to-install-or-upgrade-php-8-1-on-debian/

docker 포트포워딩

• https://tttsss77.tistory.com/155
• https://unpasoadelante.tistory.com/198

shell script

• What does set -e and exec "$@" do for docker entrypoint scripts? https://stackoverflow.com/questions/39082768/what-does-set-e-and-exec-do-for-docker-entrypoint-scripts
• https://almostgeneral.tistory.com/m/4

docker compose

volumes

• https://docs.docker.com/compose/compose-file/compose-file-v3/#volume-configuration-reference
• https://docs.docker.com/storage/volumes/#create-a-volume-using-a-volume-driver
• https://docs.docker.com/storage/
• volume, bind, tmpfs 가 있음.
• volume: dockerarea, bind: anywhrer on host filesystem, tmpfs: only host memory! filesystem아니고 메모리에 기록됨
• https://stackoverflow.com/questions/35841241/docker-compose-named-mounted-volume
  뭐임 공식문서에 없음;; driver_opts 지정해서 bind mounts 할 수 있는 거 같긴 한데.... 더 찾아보기
• https://stackoverflow.com/questions/59836742/docker-driver-opts-type-none

How To Install Linux, Nginx, MariaDB, PHP (LEMP stack) on Debian 10

• https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mariadb-php-lemp-stack-on-debian-10

• https://geekrewind.com/install-wordpress-on-ubuntu-16-04-lts-with-lighttpd-mariadb-and-php-7-1-support/

• https://www.rosehosting.com/blog/how-to-install-wordpress-with-nginx-on-debian-10/
  이거랑 섞어서 wordpress(nginx, mariadb) 설치하기

• https://www.cyberciti.biz/faq/configure-nginx-to-use-only-tls-1-2-and-1-3/

docker compose

depends_on

• container 시작만 보장해주는 거고 서비스가 제대로 작동하는지를 기다려 주진 않음. 때문에 service startup order를 정확하게 맞추기 위해선 따로 작업이 필요함 (ex. wordpress에서 mariadb 컨테이너를 기다려야 하기 때문에 entrypoint.sh 에서 mariadb -h host .. 로 연결될 때까지 sleep 걸어주는 것)

메모

• service mariadb 대신 mysql로 하면 실행 됨🥲
• mariadb-server install 이후 service mysql restart 하고 mysql_secure_installation 실행하면 root 패스워드 공백입력 됨
• nginx 설치 이후에 터미널에서 로컬호스트 접속 잘 되는지 확인하려면 curl 명령어 설치 후 해당 주소로 요청 보내보면 됨. service nginx start로 nginx 켜고 확인하기

redis

• https://www.wp-vps.com/wordpress-apply-redis-cache.html

• https://www.digitalocean.com/community/tutorials/how-to-configure-redis-caching-to-speed-up-wordpress-on-ubuntu-14-04

• https://github.com/rhubarbgroup/redis-cache/wiki

• https://ko.wordpress.org/plugins/redis-cache/

daemonize no

• https://stackoverflow.com/questions/50790197/why-redis-in-docker-need-set-daemonize-to-no

ftp

• https://shiftedbits.org/2012/01/29/enable-wordpress-automatic-updates-on-a-debian-server/
• https://www.digitalocean.com/community/tutorials/how-to-set-up-vsftpd-for-a-user-s-directory-on-debian-10

passwd, chpasswd

• https://stackoverflow.com/questions/714915/using-the-passwd-command-from-within-a-shell-script

background no

• https://github.com/fauria/docker-vsftpd/blob/master/vsftpd.conf

adminer

• https://www.howtoforge.com/how-to-install-adminer-on-alma-linux-8/
• https://www.php.net/manual/en/features.commandline.webserver.php

goaccess

• https://svrforum.com/svr/279476

• https://stackoverflow.com/questions/56946742/how-can-i-get-goaccess-running-under-nginx

• https://hub.docker.com/r/allinurl/goaccess/

• https://ansonvandoren.com/posts/goaccess-nginx-auth/

• https://di-marco.net/blog/it/2020-01-02-real_time_goaccess_dashboard_with_nginx/

• https://joypinkgom.tistory.com/34

• https://wordpress.lapw.org/it/linux/goaccess/

php-fpm .html

• https://xenophon.tistory.com/86

nginx websocket proxy

• https://shinwusub.tistory.com/111

realtime ssl

nginx에서 proxy로 https->http로 오면 자동으로 ssl 사용. 대신 ws-uri를 wss:// ~ 로 바꿔줘야 했음

• https://github.com/allinurl/goaccess/issues/1328#issuecomment-445069749

simple static website

• https://html5up.net/stellar
• https://html5up.net/highlights
• https://html5up.net/read-only

node.js, express

• https://selosele.github.io/2020/11/23/nodejs-create-webserver/