a2enmod userdir
(Apache2에서 사용자별로 웹 디렉토리를 제공)
systemctl restart apache2
su word
mkdir public_html
cd public_html
mkdir includes
mkdir auth
mkdir logs
touch index.html
touch index.php
apt -y install unzip
unzip word.zip
su
mysql
CREATE DATABASE word;
CREATE USER 'word'@'localhost' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON word.* TO 'word'@'localhost';
FLUSH PRIVILEGES;
#외부접속허용(엄청 위험한 행위)
CREATE USER 'word'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON word.* TO 'word'@'%';
FLUSH PRIVILEGES;
#외부접속허용(본인의 IP만 추가)
CREATE DATABASE word;
CREATE USER 'word'@'192.168.0.214' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON word.* TO 'word'@'192.168.0.214';
FLUSH PRIVILEGES;
Bootstrap Example
word.st.kr 설정
su word
cd /home/public_html
cp wp-config-sample.php wp-config.php
nano wp-config.php
    word/word/123456
=> word.st.kr 가보면 설치하기 누를 수 있음
    st/admin/123456/check/word@word.st.kr/check
Bootstrap Example
dvwa.st.kr 설정
su dvwa
cd /home/public_html
cp config.inc.php.dist config.inc.php
nano config.inc.php
    dvwa/dvwa/123456
=> dvwa.st.kr 가보면 로그인할 수 있음(dvwa/123456)
    빨간 글씨는 설치해야 사용할 수 있음
su
find / -name php.ini
    /etc/php/8.3/fpm/php.ini
nano /etc/php/8.3/fpm/php.ini
    To allow Remote File Inclusion (RF):
    allow_url_fopen = On
    allow_url_include = On
    (http://php.net/allow-url-includes)
    (http://php.net/display-startup-errors)
    To make sure PHP shows all error messages:
    display_errors = On (2번째 Ctrl w)
    display_startup_errors = On
mysql
use Syslog;
desc SystemEvents;
select * from SystemEvents;
select FromHost, Message from SystemEvents where FromHost='IP004';
*Rsync 설정
apt -y install rsync
su
nano /etc/rsyncd.conf
    # create new
    # any name you like
    [backup]
    # target directory to copy
    path = /backup
    # hosts you allow to access
    hosts allow = 10.0.2.15
    hosts deny = *
    list = true
    uid = root
    gid = root
    read only = false
systemctl start rsync
systemctl enable rsync
[3server]
rsync -avz --delete --exclude-form=/etc/rsync_exclude.lst /backup log.st.kr::backup
(데이터가 전송되기 때문에 /backup 디렉토리는 저장공간이 많이 필요하다. 따라서 하드디스크를 추가해 준다!)
1. LVM
(3G, 1G vmdk 생성하기)
2. RAID
(2G, 2G vmdk 생성하기)
SELK > 설정> 저장소> 하드디스크 추가> 만들기> vmdk (3g,1g,2g,2g)
완료 후
GNS에 SELK 추가하기
Bootstrap Example
3대 서버에 데이터 백업하기
[3server]
데이터 백업을 위해 cron을 사용해보자!
cd /root (backup 디렉토리 생성)
mkdir backup
ls -al
chmod 777 backup
*경로
server > cd /backup
log > cd /root/backup
su word
cd /home/word
nano backup.sh (backup.sh 생성)
    #!/bin/sh
    set $(date)
    fname="backup-*word*-$1$2$3.tar.gz"
    tar cvzf /backup/$fname /home/word/public_html