관리 메뉴

공부공부 공부공부내용

0610 워드프로세스 db 구성 본문

IT 기초, 네트워크, 리눅스/리눅스 번외_ 기초 활용 및 심화실습

0610 워드프로세스 db 구성

wkdth04 2020. 6. 10. 19:01

[storage]

[root@storage user]# history
    1  id user
    2  yum -y install bash-completion
    3  vim
    4  yum -y install vim
    5  ls
    6  source /etc/bashrc 
    7  ip a s
    8  source /etc/bash_completion.d/*
    9  bash
   10  nmcli connection 
   11  ip a s 
   12  poweroff 
   

   18  mkdir -p /exports/web
   31  fdisk /dev/vdb
   32  lsblk -f
   33  mkfs.xfs /dev/vdb1
   34  lsblk -f
   35  vi /etc/fstab
   36  lsblk -f
   37  reboot
   39  vi /etc/exports
   41  vi /etc/selinux/config
   42  yum install -y rpcbind
   43  yum install -y nfs-utils
   44  systemctl start nfs
   45  systemctl enable nfs
   46  systemctl start rpc-bind
   47  systemctl start rpcbind
   48  systemctl enable rpcbind
   49  firewall-cmd --permanent --add-service=nfs
   50  firewall-cmd --reload
   51  exportfs -v
   52  chomd 777 /exports/web
   54  df -Th
   55  lsblk -f
   56  vi /etc/fstab
   57  exportfs -v
   58  vi /etc/exports
   59  exportfs -v
   60  systemctl restart nfs
   61  systemctl restart nfs-server
   62  systemctl restart rpcbind
   63  systemctl restart rpc-statd
   64  exportfs -v
   65  firewall-cmd --list-all
   66  firewall-cmd --add-service=mountd --permanent
   67  firewall-cmd --reload
   68  exportfs -v
   69  vi /etc/exports
   70  systemctl restart rpc-statd
   71  systemctl restart rpcbind
   72  systemctl restart nfs-server
   73  systemctl restart nfs
   74  exportfs -v

[web]

[root@web ~]# history
   13  mkdir -p /var/www
   14  df -Th
   15  lsblk -f
   16  yum install httpd
   17  ls -l /var/www/
   18  vi /etc/selinux/config
   19  systemctl start httpd
   20  systemctl enable httpd
   21  firewall-cmd --permanent --add-service=http
   22  firewall-cmd --reload
   23  yum install -y rpcbind
   24  yum install -y nfs-utils.x86_64 
   25  showmount -e 192.168.122.10
   26  mount -o rw,sync,sec=sys 192.168.123.10:/expots/web /var/www/
   27  firewall-cmd --list-all
   28  vi /etc/fstab
   29  systemctl start http
   30  systemctl start httpd
   31  systemctl enable httpd
   32  showmount -e 192.168.122.10
   33  umount /var/www
   34  mount /var/www
   35  mount -o rw,sync,sec=sys 192.168.123.10:/expots/web /var/www/
   36  cd /var/www/
   37  ls
   38  mount -o rw,sync,sec=sys 192.168.123.10:/expots/web /var/www/
   39  systemctl start rpcbind
   40  systemctl start httpd
   48  mount -o rw,sync,sec=sys 192.168.123.10:/expots/web /var/www/
   49  showmount -e 192.168.122.10
   50  vi /etc/fstab
   51  systemctl start rpcbind
   52  systemctl enable rpcbind
   53  systemctl start httpd
   54  systemctl enable rpcbind
   57  vi /etc/fstab
   59  mount -a
   61  showmount -e 192.168.122.10
   62  mount -o rw,sync,sec=sys 192.168.123.10:/expots/web /var/www/
   63  lsblk -f
   66  df -Th
   67  yum -y install httpd
   68  systemctl start httpd
   69  systemctl enable httpd
   70  firewall-cmd --add-service=http
   71  firewall-cmd --add-service=http --permanent
   72  yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
   73  yum install -y https://rpms.remirepo.net/enterprise/remi-release-7.rpm
   74  yum install -y yum-utils
   75  yum-config-manager --enable remi-php74
   76  yum install -y php php-mysql
   77  systemctl restart httpd
   78  journal -xe
   79  yum install bash-completion
   80  yum install bash-completion*
   81  systemctl status httpd
   82  firewall-cmd --permanent --add-service=http
   83  systemctl start http
   84  systemctl start httpd
   85  systemctl enable httpd
   86  systemctl start httpd
   87  journalctl -xe
   88  systemctl restart httpd
   89  firewall-cmd --list-all
   90  systemctl restart httpd
   91  systemctl start httpd
   92  systemctl start http
   93  systemctl start httpd.service
   94  systemctl start httpd
   95  journalctl -xe
   96  cd
   97  systemctl start httpd
   98  getenforce
   99  vi /etc/selinux/config
  100  setenforce 0
  101  getenforce 
  102  systemctl start httpd
  103  systemctl status -L httpd
  104  systemctl status -l httpd
  105  vi /etc/httpd/conf/httpd.conf 
  106  systemctl status -l httpd
  107  curl -o latest.tar.gz https://wordpress.org/latest.tar.gz
  108  cd
  109  tar xzf latest.tar.gz
  110  cp -r wordpress/* /var/www/html/
  111  cd /var/www/
  112  yum install -y httpd
  113  yum install -y http
  114  yum install -y http*
  115  systemctl status http
  116  systemctl status httpd
  117  systemctl start httpd
  118  journalctl -xe
  119  ls
  120  getenforce 
  121  firewall-cmd --permanent --add-service=http
  122  systemctl start httpd
  123  journalctl -xe
  124  /var/log/httpd/error-log
  125  cd /var/log/httpd/error-log
  126  cd /etc/httpd/conf.d/
  127  vi /etc/httpd/conf.d/
  128  cd /etc/httpd/
  129  ls
  130  cd conf.d
  131  ls
  132  yum install httpd
  133  vi /etc/httpd/conf/httpd.conf 
  134  systemctl stop php
  135  systemctl stop http
  136  systemctl stop httpd
  137  systemctl start httpd
  138  vi /etc/httpd/conf/httpd.conf 
  139  systemctl start httpd
  140  journalctl -xe
  141  systectl start httpd
  142  systemctl start httpd
  143  journal -xe
  144  joournalctl -xe
  145  journalctl -xe
  146  vi /var/www/html
  147  vi /var/www/
  148  vi /etc/httpd/conf/httpd.conf 
  149  systemctl start httpd
  150  vi /etc/httpd/conf/httpd.conf 
  151  mkdir -p /var/www/html
  152  cd
  153  cd /var/www/
  154  ls
  155  mkdir html
  156  sudo mkdir html
  157  vi /etc/httpd/conf/httpd.conf 
  158  chmod 777 /var/www/html
  159  chmod 777 /var/www/
  160  mkdir html
  161  ls -ald /var/www
  162  mkdir -p /var/www/html
  163  df -Th
  164  mkdir -p /var/www/html
  165  systemctl start httpd
  166  cp -r wordpress/* /var/www/html/
  167  tar xzf latest.tar.gz
  168  curl -o latest.tar.gz https://wordpress.org/latest.tar.gz
  169  tar xzf latest.tar.gz
  170  ls
  171  rm -rf latest.tar.gz 

  174  curl -o latest.tar.gz https://wordpress.org/latest.tar.gz
  175  cp -r wordpress/* /var/www/html/
  176  ls
  177  tar xzf latest.tar.gz
  178  ls
  179  cp -r wordpress/* /var/www/html/
  180  cp -r* wordpress/* /var/www/html/
  181  cp -r wordpress/* /var/www/html/
  182  cp -r wordpress/* /var/www/html/*
  183  ls
  184  cp -r wordpress/* /var/www/html/*
  185  cp *-r wordpress/* /var/www/html/*
  186  ls
  187  cd wordpress/
  188  ls
  189  cd ..
  190  ls
  191  tar xzf latest.tar.gz /var/www/html
  192  cd /var/www/html/

  199  tar xzf latest.tar.gz /var/www/html/
  203  mv wordpress/ wordpress1/
  204  ls
  205  tar xzf latest.tar.gz
  206  ls
  207  cp -r wordpress/* /var/www/html/
  208  ls 
  209  rm -rf wordpress1
  210  ls
  211  setfacl -Rm u:apache:rwX /var/www/html
  212  mysql
  213  mysql -u root -p 192.168.123.12
  214  chmod 777 /var/www/html/
  215  systemctl restart httpd
  216  systemctl enable httpd
  217  history

[db]

[root@db user]# history
    1  id user
    2  yum -y install bash-completion
    3  vim
    4  yum -y install vim
    5  ls
    6  source /etc/bashrc 
    7  ip a s
    8  source /etc/bash_completion.d/*
    9  bash
   10  nmcli connection 
   11  ip a s 
   12  poweroff 
   13  vi /etc/selinux/config
   14  lsblk -f
   15  fdisk /dev/vdb
   16  lsblk 0f
   17  lsblk -f
   18  partprobe
   19  pvcreate db_vg /dev/vdb1
   20  lsblk -f
   21  fdisk /dev/vdb1
   22  lsblk -f
   23  fdisk /dev/vdb1
   24  lsblk -f
   25  fdisk /dev/vdb
   26  lsblk -f
   27  fdisk /dev/vdb
   28  lsblk -f
   29  pvcreate /dev/vdb1
   30  lsblk -f
   31  vgcreate db_vg /dev/vdb1
   32  lsblk -f
   33  lvcreate -n db_lv -L 3G db_vg
   34  lsblk -f
   35  mkfs.xfs /dev/db_vg/db_lv 
   36  lsblk -f
   37  vi /etc/fstab
   38  mkdir -p /var/lib/mysql
   39  vi /etc/fstab
   40  mount -a
   41  lsblk -f
   42  vi /etc/yum.repos.d/mariadb.repo
   43  yum install -y MariaDB-server
   44  yum install -y maria-server
   45  yum install -y mariadb-server
   46  yum install -y MariaDB-server
   47  vi /etc/yum.repos.d/mariadb.repo
   48  yum install -y MariaDB-server
   49  systemctl start mariadb
   50  systemctl enable mariadb
   51  firewall-cmd --permanent --add-service=mysql
   52  mysql_secure_installation 
   53  mysql -u root -p
   54  mysql -u root -p 192.168.123.12
   55  mysql -u root -p 
   56  mysql -u wordpress -p 
   57  mysql -u root -p 
   58  ip a
   59  vi /etc/yum.repos.d/mariadb.repo
   60  systemctl start mariadb
   61* 
   62  firewall-cmd --add-service=mysql
   63  firewall-cmd --add-service=mysql --permanent 
   64  setenforce 0
   65  systemctl start mariadb
   66  systemctl restart mariadb
   67  firewall-cmd --add-service=mysql --permanent 
   68  mysql -u root -p 
   69  mysql -u wordpress -p ;
   70  mysql -u root -p 
   71  history