행복만땅 개발자 IT 개발 메모

레지스트리 편집 화면에서 상단 주소 입력창에 아래 각 입력하여 보이는 목록 삭제

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run

레지스트리 편집 창은 윈도우 명령 창에서 regedit 입력 실행

(윈도우 로고 / 실행 / regedit)

잘못 만지면 컴퓨터가 켜지지 않을 수 있기 때문에 정확히 위에 있는 경로에서만 삭제 필요

윈도우 로그인이 잘 되다가 

윈도우 계정으로 로그인이 되어있지 않아 보안 경고가 떴고

그래서 윈도우 계정으로 로그인 했더니

이후 외부에서 원격 접속으로 해당 PC가 로그인 되지 않을 때

모두 윈도우 제조사 거지 같은 정책 때문.

윈도우 계정 로그인 시

기존 계정 로그인이 사라지고 핀번호를 만들라고 한다.

일단 만들고 PIN번호로 로그인 후

1.

명령어 창에서 로그인 입력, 로그인 옵션 실행

2.

추가 설정에서 

보안을 강화하려면 이 장치의... 어쩌구 거기 부분에서 끔 선택

3.

그리고 해당 윈도우 계정 로그아웃

4. 다시 로그인 하려고 하면

로그인 옵션이 하나 더 보이는데, 여기서 윈도우 계정 비밀번호로 로그인

(핀번호로 로그인 X)

5. 그리고 다시 원격 접속 시도

==> 정상 로그인 

●●●●●●●● Tweaker 탭메뉴 ●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●
- CPU/ RAM/ GPU  각 오버클럭 튜닝 설정

- 전문가 아니면 해당 메뉴는 기본 값으로 유지 필요

- 오버클럭 했을 때 전체적으로 온도 상승 및 부팅 문제 유발 가능

- CPU 등 각 부품 온도가 섭씨 30도 선에 있을 때 시도 가능

- 아무것도 실행하지 않은 컴퓨터 환경에서 각 부품 섭씨 온도가 50도 이상 경우 지양

●●●●●●●● Setting 탭메뉴 ●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●
- GEN5 Redriver SIPO Mode : 활성화 권한 > 해당 메뉴 없는 분들은 BIOS 업데이트
- VT-d : 개발자 경우 가상 환경을 많이 쓰는데 이 경우 활성화 권장
- Intel Platform Trust Technology(PTT) : 윈도우11 활성화 필수(윈도우 홈페이지 안내 내용)
- CPU PCie Link Speed : CPU 기반 PCI Express 슬롯 작동 모드 설정
- PCH PCie Link Speed : 칩셋 기반 PCI Express 슬롯 작동 모드 설정

- Initial Display Output
  설치된PCI Express그래픽카드또는온보드그래픽에서모니터디스플레이의최초시작을 지정
   IGFX 온보드 그래픽을 첫 번째 디스플레이로 설정합니다.
   PCIe 1 Slot PCIEX16 슬롯의 그래픽 카드를 첫 번째 디스플레이로 설정합니다.
   PCIe 2 Slot PCIEX8 슬롯의 그래픽 카드를 첫 번째 디스플레이로 설정합니다.
   PCIe 3 Slot PCIEX4 슬롯의 그래픽 카드를 첫 번째 디스플레이로 설정합니다

- Internal Graphics
  온보드 그래픽 기능을 사용 또는 사용하지 않도록 설정 기능 

- PCIE Bifurcation Support
  PCIEX16 슬롯의 대역폭 분할 방식을 결정할 수 있습니다.

- PCIE Tunneling over USB4
  PCIE Tunneling over USB4를 사용 또는 사용 안 함으로 설정합니다

- NVMe Configuration(NVMe 구성)
  설치된 경우 M.2 NVME PCIe SSD에 대한 정보

- VMD setup menu(VMD 설정 메뉴)
   · 일반적으로 쓰지 않는 기능으로 비활성.

   · RAID라는 기술로 여러 저장창지를 1개 처럼 만들어 대용량 저장장치 (논리적) 1개로 만들 사용

- Ethernet Controller / PCIe GBE Family Controller
  (이더넷 컨트롤러 / PCIe GBE 제품군 컨트롤러)
  이 하위 메뉴는 LAN 구성 옵션 관련 정보를 제공해줍니다.

- GEN5 Redriver SIPO Mode >> 활성화
  GEN5 Redriver SIPO Mode를 사용 또는 사용 안 함으로 설정합니다

- Intel Platform Trust Technology (PTT) >> 윈도우11 활성
  Intel ® PTT 기술의 사용 여부를 설정합니다.

- 3DMark01 Enhancement >> 활성
  일부 레거시 벤치마크 성능 향상


●●●●●●●● System Info 탭메뉴 ●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●
- Plug in Devices Info(플러그인 장치 정보)
 PCI Express그리고설치되어있는경우M.2장치에 대한 정보 확인

-ƒ Q-Flash
 BIOS 업데이트 및 기존 구성 백업


●●●●●●●● Boot 탭메뉴 ●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●
- Boot Option Priorities / 부팅 순서 정의
  · 부팅 가능한 USB가 꼽혀 있는 경우 "UEFI:" 접두어 항목 드라이브 보임

- CSM Support >> 활성 

- Storage Boot Option Control 
  저장장치 컨트롤러에 대해 UEFI 또는 레거시 옵션 ROM을 사용으로 설정할 것인지 여부를
  선택할 수 있습니다.
  Do not launch 옵션 ROM을 사용안함으로 설정합니다.
  UEFI UEFI 옵션 ROM만 사용하도록 설정합니다.
  Legacy 레거시 옵션 ROM만 사용하기로 설정합니다.
   이 항목은 CSM Support가 Enabled로 설정되어 있을 때만 구성할 수 있습니다.

- Other PCI devices
  LAN,저장장치및그래픽컨트롤러가아닌PCI장치컨트롤러에대해UEFI또는레거시옵션
  ROM을 사용으로 설정할 것인지 여부를 선택할 수 있습니다.
  Do not launch 옵션 ROM을 사용안함으로 설정합니다.
  UEFI UEFI 옵션 ROM만 사용하도록 설정합니다.
  Legacy 레거시 옵션 ROM만 사용하기로 설정합니다.
  이 항목은 CSM Support가 Enabled로 설정되어 있을 때만 구성할 수 있습니다.

●●●●●●●● 기타 ●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●

- 내장 디스플레이포트 to 외장 연결(디스플레이이 케이블 또는 미니 디스플레이 케이블 필요)
  이를 통해 내외부 그래픽카드 동시 사용 

- 모든 M.2 SSD 장착 시, 해당 자리 바닥에 필림 꼭 때기(다 붙어있음). 안때면 발열↑

- PCie5.0/PCie4.0/PCie3.0 저장 장치 인터페이스 사용
  ● CPU
    · M.2 커넥터 1개(소켓 3, M 키, 유형 25110/2580 PCIe 5.0 x4/x2 SSD지원) (M2C_CPU)
    · M.2 커넥터 1개(소켓 3, M 키, 유형 22110/2280 PCIe 4.0 x4/x2 SSD지원) (M2A_CPU)
  ● 칩셋
    · M.2 커넥터 1개(소켓 3, M 키, 유형 22110/2280 PCIe 4.0 x4/x2 SSD지원) (M2Q_SB)
    · M.2 커넥터 1개(소켓 3, M 키, type 2280 PCIe 4.0 x4/x2 SSD 지원) (M2P_SB)
    · M.2 커넥터 1개(소켓 3, M 키, type 2280 SATA 및 PCIe 4.0 x4/x2 SSD지원) (M2M_SB)
    · SATA 6Gb/s 커넥터 4개Š NVMe SSD 저장 장치의 경우, RAID 0, RAID 1, RAID 5 및 RAID 10 지

- M.2 SSD 장착 시 기본적으로 장착 지점에 먼지 흡착 방지 필름이 있기 때문에 때고 장착 필요

  필림을 두고 장착 시, 발열 ↑

* 참조 : 기가바이트 메뉴얼(BIOS 업데이트 파일 제공 등)

https://www.gigabyte.com/kr/Motherboard/Z790-AORUS-PRO-X/support#support-manual

윈도우 탐색기 주소창에 아래 주소 복사 붙이기

%UserProfile%\AppData\Local\Packages\Microsoft.Windows.ContentDeliveryManager_cw5n1h2txyewy\LocalState\Assets

해당 경로에 있는 것이 모두 이미지 파일. 쉽게 볼 수 없도록 이미지 파일 형태로 저장되어 있지 않은데

윈도우 > 실행 > cmd(관리자 권한으로 실행) 

해당 창에서 다음 명령어 입력

cd %UserProfile%\AppData\Local\Packages\Microsoft.Windows.ContentDeliveryManager_cw5n1h2txyewy\LocalState\Assets

그리고 아래 명령 입력 

ren *. *.png

확장자가 없는 모든 파일(파일명이 점 뒤에 아무것도 없는 파일)에 확장자 png 붙이라는 명령 실행한 결과 

이제 윈도우 탐색기에서 점(.) 뒤에 png가 붙어서 더블 클릭하여 이미지 확인 가능

여기서 보기 싫었던 파일은 삭제가 아닌, 예쁜 이미지를 보기 싫었던 파일명으로 변경하여 덮어쓰기 

마지막으로 .png 붙였던 확장자를 다시 제거(안그럼 잠금화면 이미지 다 나오지 않음)

ren *.png *.

그리고 잠금화면 실행하면 짜잔 ~ :D ㅎㅎㅎ 

바탕화면 잠금화면 이미지는 해당 경로에 없고, 찾아보려고 했으나 포기  ㅎㅎ

분명한 것은 %UserProfile%\AppData\Local\ 경로에 바탕화면 잠금화면 이미지 없음

● 파일명 길이 출력

Get-ChildItem | ForEach-Object {
       $fileName = $_.Name
       $length = $fileName.Length
       Write-Output "파일: $fileName, 길이: $length"
}

● 특정 파일명 길이 가지고 있는 텍스트 파일 찾기

Get-ChildItem *.txt -Recurse -File | Where-Object {
       $_.Name.Length -gt 63 -and $_.Name.Length -lt 65
} | Select-Object Name, Length

1. 설치 구분

1) 이미지 기반 USB 설치

2) 이미지 기반 가상 OS 설치

3) 컨테이너 기반(압축 파일) 가상 OS 설치용 이미지 통한 설치(Docker 또는 WSL)

2. 설치

1) 컨테이너 기반 경우 물어보는 것이 없으나 컨테이너 파일이 미니멀 버전이라면 리눅스 설치 후 SSH 등 동작하는 것이 대부분 없기 때문에 알아서 직접 설치 필요 

2) 컨테이너 기반이 아닌 경우는 기본값으로 대부분 설치 

3. 메뉴얼 설치 시, 파티션 설정 참조(과거 배분과 바뀜)

4. 컨테이너 설치 시, nmtui 같은 네트워크 설정 불가. 레드헷 OS 기반(CentOS)과 같은 방법으로 메뉴얼하게 설정 필요

아래, 컨테이너 기반 설치 후 설치 이력 

    1  ll
    2  sudo
    3  ls
    4  dnf update -y
    5  ll
    6  dnf install -y sudo passwd
    7  ipconfig
    8  ifconfig
    9  passwd
   10  ip
   11  ip a
   12  ./ip
   13  nmtui
   14  netconfig
   15  config
   16  ls
   17  clear
   18  dir
   19  cd Rocky
   20  cd Rocky9
   21  ll'
   22  ls
   23  l
   24  ;
   25  ls
   26  cd ..
   27  ll
   28  dir
   29  cls
   30  clear
   31  systemctl
   32  nmcli
   33  history
   34  dnf install nmcli
   35  nmcli connection show
   36  dnf install -y epel-release
   37  dnf config-manager –add-repo https://download.docker.com/linux/centos/docker-ce.repo
   38  clear
   39  dnf config-manager –add-repo https://download.docker.com/linux/centos/docker-ce.repo
   40  dnf install -y bash-completion net-tools lsof htop
   41  ifconfig
   42  clear
   43  ifconfig
   44  dnf config-manager –add-repo https://download.docker.com/linux/centos/docker-ce.repo
   45  dnf config-manager –-add-repo https://download.docker.com/linux/centos/docker-ce.repo
   46  clear
   47  dnf config-manager –-add-repo "https://download.docker.com/linux/centos/docker-ce.repo"
   48  dnf config-manager –-add-repo https://download.docker.com/linux/centos/docker-ce.repo
   49  dnf config-manager --save –-add-repo https://download.docker.com/linux/centos/docker-ce.repo
   50  dnf config-manager –-add-repo https://download.docker.com/linux/centos/docker-ce.repo
   51  dnf config-manager –add-repo https://download.docker.com/linux/centos/docker-ce.repo
   52  dnf config-manager –-add-repo https://download.docker.com/linux/centos/docker-ce.repo --set-enabled
   53  dnf config-manager –-add-repo https://download.docker.com/linux/centos/docker-ce.repo
   54  clear
   55  dnf config-manager –-add-repo https://download.docker.com/linux/centos/docker-ce.repo
   56  dnf config-manager –-add-repo
   57  dnf config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
   58  dnf -y install docker-ce docker-ce-cli containerd.io docker-compose-plugin
   59  pwd
   60  ll
   61  mkdir maildata
   62  cd maildata
   63  ll
   64  cd ..
   65  dir
   66  dm maildata
   67  rm maildata
   68  rmdir maildata
   69  dir
   70  cd Rocky9
   71  dir
   72  mkdir maildata
   73  cd maildata
   74  docker pull mailserver/docker-mailserver:latest
   75  systemctl enable -now docker
   76  systemctl
   77  systemctl enable --now docker
   78  systemctl enable -now docker
   79  systemctl enable --now docker
   80  systemctl status
   81  cd /
   82  cd etc
   83  pwd
   84  sudo
   85  vim wsl.conf
   86  dnf
   87  dnf --install vim
   88  vi wsl.conf
   89  exit
   90  cd /tmp
   91  ll
   92  ls
   93  exit
   94  systemctl
   95  systemctl status
   96  systemctl enable --now docker
   97  pwd
   98  cd maildata
   99  dir
  100  cd Rocky9/
  101  cd maildata/
  102  dir
  103  docker pull mailserver/docker-mailserver:latest
  104  ll
  105  ls
  106  curl -LO https://raw.githubusercontent.com/docker-mailserver/docker-mailserver/master/compose.yaml
  107  curl -LO https://raw.githubusercontent.com/docker-mailserver/docker-mailserver/master/mailserver.env
  108  vi compose.yaml
  109  docket compose up -d
  110  docker compose up -d
  111  docker logs -f mailserver
  112  ls
  113  cd docker-data/
  114  cd dms
  115  ls
  116  mkdir /maildata/docker-data/dms/custom-cert/demoCA
  117  mkdir custom-cert/demoCA
  118  mkdirs custom-cert/demoCA
  119  mkdir custom-cert/demoCA
  120  mkdir custom-cert
  121  cd custom-cert/
  122  mkdir demoCA
  123  curl -LO https://dl.smallstep.com/cli/docs-cli-install/latest/step-cli_amd64.rpm
  124  rpm -i step-cli_amd64.rpm
  125  step certificate create "Smallstep Root CA" "demoCA/cacert.pem" "demoCA/cakey.pem"   --no-password --insecure --profile root-ca   --not-before "2024-08-20T00:00:00+00:00"   --not-after "2034-08-20T00:00:00+00:00"   --san "biolist.com" --san "mail.biolist.com"   --kty RSA --size 2048
  126  step certificate create "Smallstep Leaf" public.crt private.key   --no-password --insecure --profile leaf   --ca "demoCA/cacert.pem" --ca-key "demoCA/cakey.pem" --not-before "2024-08-20T00:00:00+00:00"   --not-after "2034-08-20T00:00:00+00:00"   --san "biolist.com" --san "mail.biolist.com"   --kty RSA --size 2048
  127  cd ..
  128  pwd
  129  ls
  130  cd ..
  131  ls
  132  vi compose.yaml
  133  vim compose.yaml
  134  yum
  135  yum install vim
  136  vim compose.yaml
  137  cp compose.yaml compose_20241002.yaml
  138  vim compose.yaml
  139  docker compose down
  140  docker compose up -d
  141  docker exec -it mailserver setup config dkim domain 'biolist.net'
  142  docker exec -it mailserver cat /tmp/docker-mailserver/opendkim/keys/enteroa.com/mail.txt | awk -F'"' '{print $2}' | paste -s | sed 's/[ \t]//g;s/;/; /g'
  143  ll
  144  ls
  145  docker exec -it mailserver cat /tmp/docker-mailserver/opendkim/keys/enteroa.com/mail.txt | awk -F'"' '{print $2}' | paste -s | sed 's/[ \t]//g;s/;/; /g'
  146  docker exec -it mailserver setup config dkim domain 'biolist.net'
  147  docker exec -it mailserver cat /tmp/docker-mailserver/opendkim/keys/enteroa.com/mail.txt | awk -F'"' '{print $2}' | paste -s | sed 's/[ \t]//g;s/;/; /g'
  148  ~]# docker exec -it mailserver cat /tmp/docker-mailserver/opendkim/keys/enteroa.com/mail.txt | awk -F'"' '{print $2}' | paste -s | sed 's/[ \t]//g;s/;/; /g'
  149  docker exec -it mailserver cat /tmp/docker-mailserver/opendkim/keys/biolist.net/mail.txt | awk -F'"' '{print $2}' | paste -s | sed 's/[ \t]//g;s/;/; /g'
  150  find ./mailserver.*
  151  cp mailserver.env mailserver_20241002.env
  152  vim mailserver.env
  153  docker compose down mailserver
  154  docker compose up -d mailserver
  155  vim mailserver.env
  156  docker compose down mailserver
  157  docker compose up -d mailserver
  158  ll
  159  ls
  160  vim compose.yaml
  161  docker compose down mailserver
  162  vim compose.yaml
  163  vim mailserver.env
  164  docker compose up -d mailserver
  165  ifconfig
  166  passwd
  167  yum install openssh-server
  168  vi /etc/ssh
  169  vi /etc/ssh/sshd_config
  170  service ssh restart
  171  shich sshd
  172  which sshd
  173  firewall-cmd
  174  firewall -cmd
  175  service sshd start
  176  systemctl start sshd
  177  systemctl status sshd
  178  systemctl restart sshd
  179  systemctl status sshd.service
  180  systemctl start sshd
  181  systemctl start sshd
  182  pwd
  183  nmtui
  184  dul
  185  history
  186  dnf install nmtui
  187  yum install nmtui
  188  nmtui
  189  nmcli
  190  dnf install nmcli
  191  yum install nmcli
  192  nmcli
  193  setup
  194  ifconfig
  195  find / -name network-scripts
  196  cd /etc
  197  ll
  198  ls
  199  clear
  200  ls
  201  find . -name ifcfg*
  202  find . -name ifcfg*.*
  203  sudo nano
  204  systemctl restart NetworkManager
  205  NetworkManager
  206  pacman
  207  systemctl restart network
  208  systemctl restart network22
  209  systemctl restart Networkmanager
  210  service
  211  systemctl start NetworkManager
  212  ap
  213  apt
  214  systemctl enable --now NetworkManager.service
  215  yum -y install NetworkManager
  216  nmcli
  217  systemctl enable --now NetworkManager.service
  218  nmcli
  219  nmtui
  220  nmcli
  221  systemctl restart NetworkManager
  222  systemctl restart NetworkManage
  223  systemctl restdart NetworkManager
  224  systemctl restart NetworkManager
  225  systemctl status NetworkManager
  226  ip
  227  ip addr
  228  cd /etc/sysconfig/network-scripts/
  229  ll
  230  ls
  231  tail readme-ifcfg-rh.txt
  232  nmtui
  233  setup
  234  nmcli
  235  nmcli device status
  236  cd ..
  237  ll
  238  ls
  239  cd ..
  240  cd NetworkManager/
  241  ll
  242  ls
  243  cd system-connections/
  244  ls
  245  ls -lst
  246  clear
  247  nmcli connection reload
  248  nmcli device status
  249  nmcli
  250  ssh localhost
  251  ll
  252  ls
  253  cd /
  254  cd dev/
  255  ll
  256  ls
  257  cd wsl
  258  pwd
  259  cd /
  260  ll
  261  ls
  262  cd mnt
  263  cd DEV
  264  ll
  265  ls
  266  cd c
  267  cd ..
  268  cd wsl
  269  ll
  270  ls
  271  cd ..
  272  ls
  273  cd c
  274  cd DEV
  275  cd WSL
  276  ll
  277  ls
  278  cd Rocky9/
  279  ls
  280  cd maildata/
  281  ls
  282  nmtui
  283  nmcli device status
  284  ifconfig
  285  ssh
  286  sshd
  287  nmcli
  288  ifconfig
  289  clear
  290  cls
  291  ifconfig
  292  nmtui
  293  exit
  294  wsl
  295  exit
  296  ifconfig
  297  history

5. OS 설치 

1) 컨테이너 기반 설치 시 위 작업 이력과 같은 작업 필요

2) 컨테이너 기반 아닌 전통적 GUI 기반 설치 시, 설치 완료 후 "nmtui" 입력하여 네트워크 설정 필요

3) nmtui 실행되지 않을 경우 nmcli 명령어로 처리 

4) 네트워크 설정 참조

   - https://itcenter.yju.ac.kr/xe_board_tech_linux/24400

   - https://svrforum.com/os/361727

   - https://velog.io/@zero0913/%ED%87%B4%EA%B7%BC-%ED%9B%84%EC%97%90-%ED%8B%88%ED%8B%88%ED%9E%88-%EC%9E%91%EC%84%B1%ED%95%98%EB%8A%94-%EC%82%BD%EC%A7%88-%EC%9D%BC%EC%A7%80-%EB%A6%AC%EB%88%85%EC%8A%A4%EC%84%9C%EB%B2%84-1.-Rocky-Linux-9-%EC%84%A4%EC%B9%98-%EB%B0%8F-SSH-%EA%B4%80%EB%A0%A8-%EC%84%A4%EC%A0%95

   - https://tech.zinnunkebi.com/all-about-os/all-about-linux/rocky-linux-9-network-setting/

   - https://blog.naver.com/zzang7648/223498691114

   - https://gomu92.tistory.com/13

※ docker-mailserver 설치 시

- 계정 확인 방법

① docker compose exec mailserver setup debug login

② 

접속 주소가 같은데, 서버가 바뀐 경우 ssh RSA 키 충돌로 접속이 되지 않을 때 

- ssh-keygen -R [접속지 주소]

이를 통해 해결되지 않을 때 아래 폴더에 있는 파일을 백업하고 삭제하면 접속 가능

C:\Users\[사용자계정]\.ssh\known_hosts

해당 방법 사용 경우, 다른 모든 접속 키 등록 필요

● 실행 여부

sudo service cron status

"cron in not running" 메세지가 아닌 잔뜩 뭐가 뜬다면 실행되고 있는 것

● 실행

sudo ALL=NONPASSWD: /usr/sbin/service cron start

● 동작 테스트 / 아래 내용 "/tmp/test_crontab.sh"으로 저장

#!/bin/bash
today=$(date +"%Y-%m-%d %H:%M:%S")
echo "${today}" >> /tmp/crontab.log

● 배치 설정

sudo crontab -e

● 배치 입력

*/1 * * * * /tmp/test_crontab.sh

분(0-59)  시간(0-23)  일(1-31)   월(1-12)   요일(0-7)

● 배치 실행 확인

tail -f /tmp/crontab.log

● Hibernate/JPA Configuration

- https://m.blog.naver.com/magicwordcafebabe/222008545174

- https://lannstark.tistory.com/14

- https://pasudo123.tistory.com/394

※ Hibernate 버전에 따라 log 설정 옵션이 왜 없지?? 가 아닌 차이가 있다. 결국 Spring Boot 버전에 따라 셋업되는 Hibernate 버전이 달라 셋업 방법 차이가 발생한다.

#계정 원격 접속 허용

grant all privileges on *.* to '계정명'@'%';

예) grant all privileges on *.* to 'root'@'%';

#계정 로컬 전용 접속 계정 생성

grant all privileges on *.* to '계정명'@'localhost';

예) grant all privileges on *.* to '홍길동'@'localhost';

#계정 비밀번호 변경 / 계정이 하나 일 때 

alter user 계정명 identified by '비밀번호';

예) alter user 홍길동 identified by '열려라들깨';

#계정 비밀번호 변경 / 같은 계정 localhost, remote 등 접속이 다를 때

alter user '계정명'@'호스트' identified by '비밀번호';

예) alter user '홍길동'@'localhost' identified by '열려라참깨';

예) alter user '홍길동'@'%' identified by '열려라들깨';

#계정 생성

create user '계정명'@'호스트' identified by '비밀번호';

예) create user '홍길동'@'%' identified by '열려라참깨';

#생성 계정 접근 DB 설정 및 해당 DB 권한 설정

grant all privileges on DB명.* to '계정명'@'호스트';

예) grant all privileges on 테스트DB.* to '홍길동'@'%';

※ 계정 정보 생성, 수정, 권한 등 상기 작업 후 꼭 해줘야 하는 명령어

flush privileges;

#로그인 할 때 TLS/SSL 오류 발생 시 "--ssl=0" 기술

mysql -h 접속조수 -P 포트번호 -u계정아이디 -p --ssl=0

● batch(*.bat) 파일 분기 처리 참고 스크립트

@echo off
chcp 437

 :: BatchGotAdmin
 :-------------------------------------
 REM  --> Check for permissions
 >nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"

REM --> If error flag set, we do not have admin.
 if '%errorlevel%' NEQ '0' (
     echo Requesting administrative privileges...
     goto UACPrompt
 ) else ( goto gotAdmin )

:UACPrompt
     echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
     echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"

    "%temp%\getadmin.vbs"
     exit /B

:gotAdmin
     if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )
     pushd "%CD%"
     CD /D "%~dp0
	 
echo.	 
echo http://tmigod.com/
echo IP last update : 2021. 05. 23.
echo.
pause
echo.

● CLI | (Pipeline) 필터링

dir/s | find "필터 키워드"

● 대용량 USB exFAT 이 아닌 FAT32로 포멧하기 / PowerShell 실행 후

MSSQL, MariaDB/MySQL, Apache WEB, Apache Tomcat 등 운용 시

해당 서버(또는 PC) 기준 방화벽 설정 

1. 이벤트 뷰어에서 외부 공격은 "응용 프로그램" 눌러서 접속 로그 확인

2. 이벤트 뷰어에서 보안 오류도 분단위 있을 경우 조치

3. 방화벽 인바운드 규칙 > 새 규칙 > 사용자 지정 > 모든 프로그램(기본값) > 모든 프로토콜 / 모든 로컬 포트 / 모든 원격 포트(기본값) > 이 규칙이 적용되는 원격 IP 주소 / 다음 IP 주소 / 추가 > 222.222.222.1 ~ 222.222.222.255 추가 > 연결 차단 > 완료

4. 방화벽 인바운드 IP대역 차단 CLI 

netsh advfirewall firewall add rule name="DDOS 차단" dir=in action=block remoteip=61.221.207.0-61.221.207.255

5. 한국만 허용

netsh advfirewall firewall add rule name="only korean access" dir=in action=allow remoteip=101.79.136.0/21,101.79.32.0/21,14.128.128.0/17,14.129.0.0/16,14.138.0.0/16,14.192.80.0/20,45.112.88.0/21,45.112.96.0/20,45.112.112.0/21,45.112.152.0/21,45.112.160.0/21,45.112.168.0/22,43.230.0.0/22,43.224.104.0/22,43.250.152.0/22,43.251.28.0/22,43.251.68.0/22,43.251.120.0/22,14.206.0.0/16,27.0.236.0/22,27.1.0.0/16,27.35.0.0/16,45.113.44.0/22,45.113.48.0/22,43.230.76.0/22,43.230.80.0/22,43.230.216.0/22,27.160.0.0/12,27.176.0.0/13,27.232.0.0/13,27.255.64.0/19,27.255.96.0/19,36.38.0.0/15,43.246.152.0/22,43.246.180.0/22,27.100.128.0/17,27.101.0.0/16,27.102.0.0/16,45.119.144.0/22,45.120.64.0/22,45.120.68.0/22,103.141.18.0/23,43.241.104.0/22,43.241.108.0/22,43.247.104.0/22,43.247.192.0/22,27.111.96.0/19,27.112.128.0/17,27.113.0.0/17,45.115.152.0/22,1.11.0.0/16,1.16.0.0/14,43.254.244.0/22,39.4.0.0/14,39.16.0.0/12,39.112.0.0/12,42.8.0.0/13,42.16.0.0/12,42.32.0.0/12,43.227.116.0/22,43.227.120.0/22,27.115.128.0/17,27.116.64.0/18,27.116.128.0/17,27.117.0.0/18,27.117.64.0/18,27.117.128.0/18,27.117.192.0/18,27.118.64.0/18,27.118.128.0/17,27.119.0.0/17,27.119.128.0/17,27.120.0.0/18,27.122.128.0/17,43.242.112.0/22,45.117.12.0/22,1.96.0.0/12,1.176.0.0/15,1.201.0.0/16,1.208.0.0/12,1.224.0.0/11,14.0.32.0/19,14.0.64.0/18,14.4.0.0/14,14.32.0.0/11,14.64.0.0/11,43.255.248.0/22,43.255.252.0/22,45.64.140.0/22,45.64.144.0/22,45.64.152.0/22,45.64.172.0/22,42.82.0.0/16,43.228.160.0/22,27.124.128.0/17,27.125.0.0/17,27.126.0.0/18,43.243.216.0/22,103.3.36.0/22,59.186.0.0/15,61.32.0.0/13,61.40.0.0/14,101.53.64.0/19,101.55.0.0/17,103.7.32.0/22,103.7.190.0/23,103.10.216.0/22,103.11.24.0/22,103.11.44.0/22,103.11.56.0/22,103.21.200.0/22,103.25.16.0/22,45.121.164.0/22,45.125.232.0/22,45.126.148.0/22,49.1.0.0/16,49.8.0.0/14,49.16.0.0/12,49.50.0.0/22,49.50.16.0/20,49.50.32.0/19,49.56.0.0/13,49.128.192.0/19,49.142.0.0/16,49.143.0.0/17,58.120.0.0/13,58.138.192.0/18,58.140.0.0/14,58.145.0.0/17,58.146.192.0/18,58.147.176.0/21,58.148.0.0/14,58.180.0.0/16,58.181.0.0/18,58.184.0.0/16,60.196.0.0/15,61.47.192.0/18,61.72.0.0/14,61.76.0.0/15,61.78.0.0/15,61.80.0.0/14,61.84.0.0/15,101.202.0.0/16,101.235.0.0/16,101.250.0.0/16,103.4.48.0/22,103.4.148.0/22,103.4.176.0/22,103.4.180.0/22,103.7.244.0/22,103.8.100.0/22,103.11.128.0/22,103.11.248.0/22,103.22.220.0/22,49.160.0.0/12,49.236.64.0/18,49.238.64.0/18,49.238.128.0/17,49.239.128.0/18,58.224.0.0/12,59.0.0.0/11,59.86.192.0/18,59.151.192.0/18,60.253.0.0/18,60.253.64.0/19,61.4.192.0/19,61.4.224.0/19,61.5.160.0/19,103.5.128.0/22,103.5.144.0/22,103.8.230.0/24,103.9.32.0/22,103.9.128.0/22,103.19.124.0/22,103.23.80.0/21,103.27.128.0/22,103.30.108.0/22,103.30.160.0/22,103.30.204.0/22,45.248.72.0/22,49.246.0.0/18,49.246.64.0/18,49.247.0.0/16,49.254.0.0/16,58.29.0.0/16,59.152.128.0/18,61.14.208.0/22,61.245.176.0/20,61.245.224.0/19,61.247.64.0/18,61.247.128.0/19,61.247.192.0/19,101.1.8.0/21,101.1.32.0/19,103.2.76.0/22,103.2.84.0/22,103.2.92.0/22,103.6.72.0/22,103.6.80.0/22,103.6.100.0/22,103.6.172.0/22,103.10.92.0/22,103.12.248.0/22,103.12.252.0/22,103.13.52.0/22,103.13.160.0/22,103.20.116.0/22,103.24.8.0/22,103.27.148.0/22,103.28.60.0/22,103.28.64.0/22,103.31.180.0/22,45.249.64.0/22,45.249.160.0/22,58.65.64.0/18,58.72.0.0/13,58.84.44.0/22,58.87.32.0/19,58.102.0.0/15,103.62.228.0/22,103.51.168.0/21,103.51.176.0/22,103.51.184.0/21,103.51.192.0/21,103.51.200.0/22,103.51.240.0/20,103.55.188.0/22,103.59.156.0/22,103.206.74.0/23,103.194.252.0/22,103.212.244.0/22,103.212.248.0/22,103.216.202.0/23,103.226.72.0/22,103.226.76.0/22,103.226.96.0/22,103.38.24.0/22,103.49.44.0/22,103.52.200.0/22,103.53.114.0/24,103.60.120.0/22,103.60.124.0/22,103.214.24.0/22,103.214.88.0/22,103.39.36.0/22,103.42.184.0/22,103.43.64.0/24,103.50.40.0/22,103.57.60.0/22,103.215.144.0/22,103.218.156.0/22,103.218.160.0/22,103.43.120.0/22,103.55.35.0/24,103.194.108.0/22,103.212.124.0/22,103.212.220.0/22,103.244.108.0/22,103.247.220.0/22,103.247.232.0/22,103.248.104.0/22,103.251.104.0/22,114.200.0.0/13,115.0.0.0/12,115.16.0.0/13,115.31.96.0/19,115.40.0.0/15,115.68.0.0/16,115.69.96.0/19,110.93.24.0/21,110.93.112.0/20,110.165.0.0/19,110.165.64.0/18,110.172.64.0/18,110.232.96.0/20,112.72.16.0/20,112.72.32.0/19,112.72.128.0/17,112.76.0.0/15,113.60.0.0/16,113.61.0.0/19,113.61.104.0/22,113.130.64.0/19,113.130.128.0/17,113.131.0.0/16,113.192.64.0/18,113.197.80.0/20,113.198.0.0/16,113.199.0.0/17,119.192.0.0/11,119.235.192.0/20,119.235.240.0/21,120.29.128.0/20,116.68.32.0/19,116.68.232.0/21,116.84.0.0/16,116.89.160.0/19,116.90.216.0/21,116.93.160.0/19,116.93.192.0/18,117.110.0.0/15,119.17.0.0/19,119.17.64.0/18,119.18.64.0/18,120.50.64.0/18,120.50.128.0/19,103.230.88.0/22,103.230.112.0/22,103.234.4.0/22,103.241.116.0/22,103.249.28.0/22,103.252.228.0/22,106.96.0.0/13,106.240.0.0/12,111.65.128.0/18,111.67.208.0/20,111.67.224.0/19,112.106.0.0/15,112.108.0.0/16,112.109.32.0/19,112.121.0.0/19,112.121.192.0/18,112.133.0.0/17,112.133.128.0/18,112.136.128.0/17,112.137.176.0/21,112.140.64.0/18,112.140.144.0/21,113.216.0.0/15,114.29.0.0/17,114.29.128.0/18,114.30.0.0/19,114.30.48.0/20,114.30.128.0/17,114.31.32.0/19,114.31.112.0/20,115.71.0.0/16,115.84.160.0/21,115.86.0.0/16,115.88.0.0/13,115.126.192.0/18,115.136.0.0/13,115.144.0.0/16,115.145.0.0/16,116.120.0.0/13,116.193.80.0/21,116.193.88.0/21,116.199.160.0/21,116.200.0.0/15,116.212.0.0/19,117.123.0.0/16,118.32.0.0/11,118.91.0.0/18,118.91.64.0/18,118.91.144.0/20,119.30.128.0/18,119.31.240.0/21,119.31.248.0/21,119.42.160.0/19,120.136.64.0/18,120.142.0.0/16,120.143.160.0/19,120.143.192.0/18,121.0.64.0/18,121.0.128.0/17,121.1.64.0/18,103.231.128.0/22,103.235.24.0/22,103.238.248.0/22,103.239.112.0/22,103.243.20.0/22,103.246.56.0/22,103.253.56.0/22,103.253.240.0/22,110.5.128.0/17,110.8.0.0/13,110.34.64.0/18,110.35.0.0/18,110.35.96.0/19,110.35.128.0/17,110.44.32.0/19,110.44.192.0/18,110.45.0.0/17,110.45.128.0/17,110.46.0.0/15,111.91.128.0/20,111.91.144.0/20,111.91.160.0/19,111.92.188.0/22,111.118.0.0/17,112.140.152.0/21,112.140.192.0/18,112.144.0.0/12,112.160.0.0/11,112.196.192.0/19,112.212.0.0/16,112.213.0.0/19,112.214.0.0/16,112.216.0.0/13,113.10.0.0/18,114.52.0.0/15,114.70.0.0/15,114.108.0.0/17,114.108.128.0/18,114.110.24.0/21,114.110.128.0/17,114.111.32.0/20,114.111.48.0/20,114.111.192.0/18,114.129.64.0/18,114.129.192.0/18,115.160.0.0/17,115.161.0.0/16,115.165.176.0/21,115.178.32.0/20,115.178.64.0/19,115.187.80.0/21,116.255.64.0/18,118.103.192.0/19,118.107.160.0/20,118.127.192.0/18,118.128.0.0/14,118.139.192.0/18,119.56.128.0/17,119.59.0.0/18,119.63.224.0/19,119.64.0.0/13,119.75.64.0/18,119.75.128.0/18,119.77.96.0/19,119.82.32.0/19,121.50.16.0/20,121.50.64.0/18,121.50.224.0/19,121.53.0.0/16,121.54.192.0/18,121.55.64.0/18,121.55.128.0/18,103.239.236.0/22,103.239.240.0/22,103.240.28.0/22,103.240.48.0/22,103.243.200.0/22,103.244.40.0/22,103.246.236.0/22,110.68.0.0/14,110.76.64.0/18,110.76.140.0/22,110.92.128.0/17,111.171.0.0/17,111.218.0.0/15,111.221.32.0/21,113.21.0.0/19,113.29.128.0/18,113.29.192.0/20,113.30.0.0/18,113.52.136.0/21,113.52.192.0/19,113.59.128.0/18,114.141.40.0/21,114.141.224.0/19,114.199.0.0/18,114.199.128.0/17,116.32.0.0/12,116.67.0.0/17,117.16.0.0/15,117.20.80.0/20,117.20.192.0/18,117.52.0.0/16,117.53.64.0/19,117.53.96.0/19,117.53.192.0/18,117.55.128.0/18,117.58.128.0/20,118.176.0.0/16,118.216.0.0/13,118.234.0.0/15,119.148.112.0/20,119.148.128.0/19,119.149.0.0/16,119.161.0.0/19,103.229.156.0/22,103.237.20.0/22,103.241.76.0/22,152.99.0.0/16,154.10.0.0/16,134.75.0.0/16,143.248.0.0/16,144.48.40.0/22,175.192.0.0/10,180.64.0.0/13,180.80.0.0/14,180.92.64.0/18,180.92.240.0/20,158.44.0.0/16,165.213.0.0/16,165.229.0.0/16,165.243.0.0/16,165.244.0.0/16,165.246.0.0/16,166.79.0.0/16,166.103.0.0/16,166.104.0.0/16,166.125.0.0/16,168.78.0.0/16,168.115.0.0/16,168.126.0.0/16,168.131.0.0/16,168.154.0.0/16,168.188.0.0/16,168.219.0.0/16,168.248.0.0/15,169.140.0.0/16,169.208.0.0/12,180.222.220.0/22,180.224.0.0/13,180.233.192.0/18,180.236.0.0/14,182.252.0.0/18,182.255.128.0/17,183.78.128.0/19,183.78.192.0/18,183.86.192.0/18,121.127.64.0/18,121.127.128.0/18,121.128.0.0/11,121.160.0.0/11,121.200.64.0/18,121.252.0.0/15,121.254.0.0/18,121.254.128.0/17,122.0.8.0/21,122.0.32.0/19,122.32.0.0/12,122.252.64.0/18,122.252.192.0/19,122.254.128.0/17,123.0.0.0/20,123.32.0.0/12,124.28.128.0/18,124.46.0.0/17,124.46.128.0/17,124.48.0.0/12,124.66.176.0/20,124.66.208.0/20,124.80.0.0/16,125.57.0.0/16,125.60.0.0/18,125.60.64.0/18,125.61.0.0/17,125.62.216.0/21,125.128.0.0/11,125.176.0.0/12,125.208.64.0/18,125.208.192.0/19,125.208.224.0/19,125.209.0.0/18,125.209.192.0/18,137.68.0.0/16,144.48.44.0/22,144.48.92.0/22,144.48.100.0/22,150.107.68.0/22,150.107.80.0/22,150.107.84.0/22,155.230.0.0/16,156.147.0.0/16,160.202.160.0/22,160.202.172.0/22,160.202.176.0/22,163.53.156.0/22,175.28.32.0/20,175.41.0.0/20,180.131.0.0/18,180.132.0.0/14,180.148.180.0/22,182.31.0.0/16,182.50.16.0/20,182.50.32.0/19,183.90.128.0/19,183.91.192.0/18,183.96.0.0/11,192.100.2.0/24,192.104.15.0/24,192.132.15.0/24,122.49.64.0/18,122.99.128.0/17,122.100.32.0/19,122.101.0.0/16,123.98.160.0/19,123.98.192.0/19,123.99.64.0/18,123.100.160.0/19,123.108.16.0/20,123.108.160.0/19,123.109.0.0/16,123.111.0.0/16,124.111.0.0/16,124.136.0.0/14,124.146.0.0/18,124.153.128.0/17,125.240.0.0/13,125.248.0.0/14,125.252.0.0/18,139.5.224.0/22,139.150.0.0/16,146.88.84.0/22,147.6.0.0/16,147.43.0.0/16,150.129.224.0/22,150.150.0.0/16,150.183.0.0/16,150.197.0.0/16,157.119.32.0/22,157.119.36.0/22,163.152.0.0/16,163.180.0.0/16,163.213.0.0/16,163.222.0.0/16,175.45.160.0/21,180.150.192.0/19,180.150.224.0/21,180.182.0.0/16,182.161.96.0/19,182.161.128.0/17,182.162.0.0/16,182.163.128.0/17,192.5.90.0/24,192.132.247.0/24,122.128.32.0/19,122.128.64.0/20,122.128.128.0/18,122.128.192.0/18,122.129.208.0/21,122.129.240.0/21,122.129.248.0/21,123.140.0.0/14,123.199.0.0/17,123.200.64.0/18,123.212.0.0/14,123.228.0.0/15,124.194.0.0/16,124.195.160.0/19,124.195.224.0/19,124.197.128.0/18,124.197.192.0/19,124.198.0.0/17,124.199.0.0/18,124.199.128.0/17,124.216.0.0/16,128.134.0.0/16,129.254.0.0/16,141.223.0.0/16,150.242.132.0/22,150.242.144.0/22,157.197.0.0/16,161.122.0.0/16,163.229.0.0/16,163.239.0.0/16,163.255.0.0/16,164.124.0.0/16,164.125.0.0/16,165.132.0.0/16,165.133.0.0/16,165.186.0.0/16,165.194.0.0/16,175.107.64.0/18,175.111.16.0/20,175.112.0.0/12,175.158.0.0/19,175.176.128.0/20,180.189.64.0/18,180.189.176.0/20,180.210.192.0/21,180.211.0.0/18,182.172.0.0/16,182.173.80.0/20,182.173.96.0/19,182.192.0.0/13,182.208.0.0/12,182.224.0.0/13,182.237.32.0/19,182.237.64.0/18,182.237.192.0/18,121.64.0.0/14,121.78.0.0/16,121.88.0.0/16,121.100.64.0/18,121.101.192.0/20,121.101.224.0/19,121.124.0.0/15,121.126.0.0/16,122.152.96.0/19,122.153.0.0/16,122.199.64.0/18,122.199.128.0/17,122.202.32.0/19,122.202.128.0/17,122.203.0.0/16,123.248.0.0/16,123.250.0.0/15,123.254.64.0/19,123.254.128.0/17,124.0.0.0/15,124.2.0.0/16,124.3.0.0/16,124.5.0.0/16,124.28.0.0/17,124.243.0.0/17,124.254.128.0/17,125.7.128.0/18,125.7.192.0/18,125.31.128.0/18,202.150.176.0/20,202.131.24.0/21,202.133.16.0/20,192.245.249.0/24,192.245.250.0/24,192.245.251.0/24,202.20.82.0/24,202.20.83.0/24,202.20.86.0/24,202.20.99.0/24,202.20.119.0/24,202.20.128.0/17,202.21.0.0/21,202.43.48.0/21,202.43.56.0/21,202.68.224.0/19,202.93.6.0/23,202.136.112.0/20,202.136.128.0/19,202.158.144.0/20,192.195.39.0/24,192.195.40.0/24,192.249.16.0/21,192.249.24.0/23,192.249.26.0/23,192.249.28.0/22,198.148.192.0/22,202.6.95.0/24,202.22.32.0/19,202.59.216.0/21,202.86.8.0/21,202.126.112.0/21,202.128.100.0/23,202.163.128.0/19,202.165.56.0/22,192.203.138.0/24,192.203.139.0/24,192.203.140.0/22,192.203.144.0/24,192.203.145.0/24,192.203.146.0/24,202.14.90.0/23,202.14.103.0/24,202.14.165.0/24,202.47.143.0/24,202.73.132.0/22,202.89.124.0/22,202.89.248.0/22,202.3.16.0/20,202.8.160.0/19,203.17.226.0/24,103.126.234.0/23,202.171.248.0/22,202.174.88.0/22,202.179.176.0/21,202.189.128.0/24,203.207.16.0/20,203.128.160.0/19,203.128.192.0/19,203.128.236.0/22,203.129.6.0/23,203.130.64.0/19,203.130.96.0/19,203.130.176.0/20,203.152.160.0/19,203.153.144.0/20,203.175.32.0/19,203.175.188.0/22,218.101.128.0/17,210.2.32.0/19,210.4.88.0/21,210.4.216.0/21,210.57.224.0/19,210.216.0.0/16,210.218.128.0/18,210.218.192.0/19,210.218.224.0/19,210.220.64.0/19,210.220.96.0/19,210.222.0.0/15,223.222.0.0/16,220.149.0.0/16,221.138.0.0/15,221.140.0.0/14,221.144.0.0/12,221.160.0.0/13,221.168.0.0/16,223.253.0.0/16,203.82.219.0/24,203.82.220.0/23,203.82.240.0/21,203.83.128.0/19,203.100.160.0/19,203.132.160.0/19,203.133.160.0/19,203.142.160.0/19,203.142.216.0/23,203.160.140.0/22,203.210.16.0/20,203.210.32.0/19,203.212.96.0/19,203.212.160.0/19,210.16.192.0/18,210.80.96.0/20,210.80.112.0/20,210.87.192.0/19,210.89.160.0/19,210.90.0.0/15,211.32.0.0/16,211.36.192.0/19,211.36.224.0/19,211.40.0.0/16,211.42.0.0/17,211.42.128.0/19,211.42.160.0/19,211.42.192.0/19,211.42.224.0/19,211.44.0.0/16,211.45.128.0/18,211.45.192.0/18,211.50.0.0/16,211.51.0.0/16,211.53.0.0/16,211.54.0.0/15,211.60.0.0/16,211.62.0.0/17,211.62.128.0/17,211.63.0.0/19,211.63.32.0/19,211.63.128.0/17,211.116.0.0/18,218.144.0.0/12,218.209.0.0/16,218.232.0.0/15,218.234.0.0/15,218.236.0.0/14,220.230.0.0/16,222.96.0.0/12,222.112.0.0/13,222.120.0.0/15,222.122.0.0/16,203.84.240.0/20,203.109.0.0/19,203.166.208.0/21,203.169.4.0/23,210.92.0.0/18,203.190.4.0/22,203.190.26.0/23,211.116.64.0/18,203.215.192.0/19,203.216.160.0/19,203.217.192.0/18,210.92.64.0/18,210.92.128.0/17,210.96.0.0/17,210.96.128.0/17,210.97.0.0/17,210.98.128.0/18,210.99.0.0/16,210.100.0.0/16,210.101.128.0/18,210.102.0.0/19,210.102.32.0/19,210.102.128.0/17,210.103.0.0/17,210.103.128.0/18,210.103.192.0/19,210.103.224.0/19,210.104.0.0/15,210.106.128.0/18,210.106.192.0/19,210.106.224.0/19,210.107.0.0/17,210.107.128.0/17,210.108.0.0/16,210.109.0.0/16,210.120.0.0/16,210.124.0.0/16,210.178.0.0/15,210.180.0.0/19,210.180.32.0/19,210.180.128.0/18,210.180.192.0/19,210.180.224.0/19,210.182.0.0/16,210.183.0.0/16,211.117.0.0/16,211.176.0.0/14,211.192.0.0/13,211.200.0.0/16,211.201.0.0/16,211.202.0.0/15,211.204.0.0/15,211.206.0.0/16,211.207.0.0/16,211.208.0.0/14,211.212.0.0/14,211.216.0.0/16,211.217.0.0/16,211.218.0.0/15,211.220.0.0/14,211.224.0.0/15,211.226.0.0/15,211.228.0.0/14,211.234.0.0/18,211.234.64.0/19,211.234.96.0/19,211.252.0.0/15,211.254.0.0/17,211.254.128.0/18,222.231.0.0/18,222.232.0.0/13,222.251.128.0/17,223.26.128.0/17,203.77.176.0/24,203.90.32.0/19,203.123.192.0/19,203.149.112.0/20,203.170.96.0/19,203.171.160.0/19,203.173.96.0/19,203.223.96.0/19,203.223.177.0/24,203.224.0.0/16,203.225.0.0/16,203.233.0.0/17,203.248.0.0/17,203.248.128.0/17,203.252.0.0/20,203.252.32.0/19,210.0.32.0/19,210.192.64.0/19,210.210.192.0/18,210.211.0.0/20,210.211.64.0/19,218.48.0.0/15,218.50.0.0/15,218.52.0.0/14,219.240.0.0/15,220.72.0.0/13,220.80.0.0/13,220.88.0.0/14,220.92.0.0/14,220.103.0.0/16,220.116.0.0/14,220.120.0.0/13,221.132.64.0/19,221.133.128.0/18,223.28.128.0/17,223.32.0.0/11,223.130.64.0/18,223.131.0.0/16,223.165.128.0/17,223.168.0.0/13,223.194.0.0/15,203.81.8.0/22,203.81.128.0/19,202.167.208.0/22,202.167.212.0/23,202.167.214.0/24,103.105.156.0/22,103.105.160.0/22,103.182.122.0/23,103.182.126.0/23,192.40.0.0/22,103.182.250.0/23,202.167.215.0/24,202.167.216.0/21,221.133.48.0/22,221.133.52.0/23,221.133.54.0/24,221.133.55.0/24,221.133.56.0/21,120.73.0.0/17,120.73.128.0/17,103.178.34.0/23,103.178.80.0/23,103.187.34.0/23,103.188.89.0/24,103.187.108.0/23,103.149.188.0/23,103.54.72.0/22,45.114.128.0/22,103.141.190.0/23,211.237.64.0/23,211.237.66.0/24,211.237.67.0/24,211.237.68.0/22,211.237.72.0/24,211.237.73.0/24,211.237.74.0/23,211.237.76.0/23,103.71.4.0/23,103.42.60.0/23,211.237.78.0/24,211.237.79.0/24,103.90.209.0/24,103.90.244.0/22,103.77.84.0/22,103.78.132.0/23,103.79.132.0/22,103.140.12.0/23,103.66.188.0/22,103.66.192.0/22,103.87.116.0/22,103.219.124.0/22,103.219.128.0/22,45.250.204.0/22,45.250.208.0/22,45.250.220.0/22,116.204.168.0/22,103.74.0.0/22,103.60.192.0/22,103.68.96.0/22,103.68.148.0/22,103.68.152.0/22,202.90.252.0/22,91.240.89.0/24,202.148.48.0/22,103.246.172.0/22,103.254.248.0/22,103.85.80.0/22,202.179.148.0/22,103.104.176.0/24,103.104.86.0/24,210.16.116.0/22,103.114.124.0/22,103.114.62.0/24,103.122.184.0/22,43.229.0.0/22,115.187.20.0/23,101.79.144.0/20,101.79.160.0/20,101.79.176.0/20,101.79.192.0/20,101.79.208.0/20,101.79.224.0/20,101.79.240.0/20,106.10.0.0/19,106.10.32.0/19,106.10.64.0/18,110.92.20.0/23,110.92.22.0/24,110.92.23.0/24,110.93.128.0/20,110.93.144.0/20,110.93.160.0/19,115.85.160.0/20,115.85.176.0/20,118.67.128.0/19,118.67.160.0/19,175.106.112.0/20,175.106.64.0/19,175.106.96.0/20,175.45.192.0/19,175.45.224.0/19,182.173.160.0/20,182.173.176.0/22,182.173.180.0/22,182.173.184.0/21,211.233.128.0/20,211.233.144.0/20,211.56.0.0/20,211.56.16.0/20,223.130.128.0/18,223.130.192.0/20,223.130.208.0/20,223.130.224.0/20,223.130.240.0/20,223.255.208.0/20,27.96.128.0/21,27.96.136.0/21,27.96.144.0/20,27.96.160.0/19,49.143.128.0/19,49.143.160.0/20,49.143.176.0/22,49.143.180.0/22,49.143.184.0/23,49.143.186.0/24,49.143.187.0/24,49.143.188.0/22,49.143.192.0/20,49.143.208.0/20,49.236.128.0/22,49.236.132.0/22,49.236.136.0/21,49.236.144.0/20,49.236.160.0/21,49.236.168.0/21,49.236.176.0/20,49.50.128.0/20,49.50.144.0/20,49.50.160.0/20,49.50.176.0/20,103.133.240.0/23,103.139.84.0/23,103.54.60.0/22,45.114.104.0/22,101.101.128.0/19,101.101.160.0/20,101.101.176.0/20,101.101.192.0/20,101.101.208.0/20,101.101.224.0/19,103.132.32.0/22,103.132.36.0/22,103.139.118.0/23,103.124.100.0/22,103.143.78.0/23,103.139.214.0/23,103.139.216.0/23,123.253.172.0/22,103.140.220.0/23,103.127.212.0/22,167.179.212.0/22,103.125.108.0/22,210.217.0.0/17,210.217.128.0/19,210.217.160.0/19,210.217.192.0/19,210.217.224.0/19,210.218.0.0/18,210.218.64.0/19,210.218.96.0/19,210.219.0.0/19,210.219.128.0/18,210.219.192.0/18,210.219.32.0/19,210.219.64.0/18,210.220.0.0/19,210.220.128.0/19,210.220.160.0/19,210.220.192.0/18,210.220.32.0/19,210.221.0.0/17,210.221.128.0/19,210.221.160.0/19,210.221.192.0/18,210.93.0.0/17,210.93.128.0/18,210.93.192.0/19,210.93.224.0/19,210.94.0.0/19,210.94.128.0/19,210.94.160.0/19,210.94.192.0/19,210.94.224.0/19,210.94.32.0/19,210.94.64.0/18,210.95.0.0/16,210.97.128.0/19,210.97.160.0/19,210.97.192.0/22,210.97.196.0/22,210.97.200.0/21,210.97.208.0/20,210.97.224.0/20,210.97.240.0/20,210.98.0.0/18,210.98.192.0/19,210.98.224.0/19,210.98.64.0/18,211.104.0.0/14,211.108.0.0/15,211.110.0.0/17,211.110.128.0/18,211.110.192.0/19,211.110.224.0/20,211.110.240.0/20,211.111.0.0/17,211.111.128.0/19,211.111.160.0/20,211.111.176.0/20,211.111.192.0/20,211.111.208.0/20,211.111.224.0/19,211.112.0.0/18,211.112.128.0/17,211.112.64.0/19,211.112.96.0/19,211.113.0.0/17,211.113.128.0/17,211.114.0.0/16,211.115.0.0/19,211.115.128.0/18,211.115.192.0/19,211.115.224.0/19,211.115.32.0/19,211.115.64.0/18,211.116.128.0/19,211.116.160.0/20,211.116.176.0/20,211.116.192.0/19,211.116.224.0/19,211.118.0.0/15,211.168.0.0/14,211.172.0.0/19,211.172.112.0/20,211.172.128.0/20,211.172.144.0/20,211.172.160.0/20,211.172.192.0/20,211.172.208.0/20,211.172.224.0/20,211.172.240.0/20,211.172.32.0/19,211.172.64.0/20,211.172.80.0/20,211.172.96.0/20,211.173.0.0/17,211.173.128.0/19,211.173.160.0/19,211.173.192.0/18,211.174.0.0/20,211.174.128.0/17,211.174.16.0/20,211.174.32.0/20,211.174.48.0/20,211.174.64.0/19,211.174.96.0/19,211.175.0.0/16,211.180.0.0/15,211.182.0.0/16,211.183.0.0/16,211.184.0.0/15,211.186.0.0/16,211.187.0.0/17,211.187.128.0/20,211.187.144.0/20,211.187.160.0/19,211.187.192.0/18,211.188.0.0/19,211.188.128.0/17,211.188.32.0/19,211.188.64.0/19,211.189.0.0/17,211.189.128.0/19,211.189.160.0/19,211.189.192.0/19,211.189.224.0/19,211.190.0.0/19,211.190.112.0/20,211.190.128.0/20,211.190.144.0/20,211.190.160.0/19,211.190.192.0/19,211.190.224.0/19,211.190.32.0/20,211.190.48.0/20,211.190.64.0/19,211.190.96.0/20,211.191.0.0/20,211.191.112.0/20,211.191.128.0/20,211.236.192.0/19,211.236.224.0/19,211.191.144.0/20,211.191.16.0/20,211.191.160.0/19,211.191.192.0/19,211.191.224.0/20,211.191.240.0/20,211.191.32.0/20,211.191.48.0/20,211.191.64.0/19,211.191.96.0/20,211.232.0.0/17,211.232.128.0/18,211.232.192.0/18,211.233.0.0/18,211.233.160.0/19,211.233.192.0/18,211.233.64.0/19,211.233.96.0/19,211.234.128.0/18,211.234.192.0/19,211.234.224.0/20,211.234.240.0/22,211.234.244.0/22,211.234.248.0/21,211.235.0.0/19,211.235.128.0/18,211.235.192.0/19,211.235.224.0/19,211.235.32.0/19,211.235.64.0/18,211.236.0.0/18,211.236.128.0/19,211.236.160.0/19,211.236.64.0/18,211.237.0.0/20,211.237.112.0/20,211.237.128.0/20,211.237.144.0/20,211.237.16.0/20,211.237.160.0/19,211.237.192.0/20,211.237.208.0/20,211.237.224.0/20,211.237.240.0/20,211.237.32.0/20,211.237.48.0/20,211.237.80.0/20,211.237.96.0/20,211.238.0.0/19,211.238.128.0/19,211.238.160.0/20,211.238.176.0/20,211.238.192.0/20,211.238.208.0/20,211.238.224.0/20,211.238.240.0/20,211.238.32.0/19,211.238.64.0/19,211.238.96.0/19,211.239.0.0/16,211.240.0.0/17,211.240.128.0/17,211.241.0.0/17,211.241.128.0/17,211.242.0.0/16,211.243.0.0/16,211.244.0.0/15,211.246.0.0/17,211.246.128.0/17,211.247.0.0/17,211.247.128.0/17,211.248.0.0/16,211.249.0.0/16,211.250.0.0/15,211.254.192.0/19,211.254.224.0/20,211.254.240.0/21,211.254.248.0/22,211.254.252.0/22,211.255.0.0/18,211.255.160.0/19,211.255.192.0/20,211.255.208.0/20,211.255.224.0/19,211.255.64.0/18,211.33.0.0/17,211.33.128.0/17,211.34.0.0/16,211.35.0.0/18,211.35.100.0/22,211.35.104.0/21,211.35.112.0/20,211.35.128.0/17,211.35.64.0/20,211.35.80.0/20,211.35.96.0/22,211.36.0.0/18,211.36.128.0/19,211.36.160.0/19,211.36.64.0/19,211.36.96.0/19,211.37.0.0/17,211.37.128.0/18,211.37.192.0/19,211.37.224.0/19,211.38.0.0/16,211.39.0.0/18,211.39.128.0/19,211.39.160.0/19,211.39.192.0/19,211.39.224.0/19,211.39.64.0/19,211.39.96.0/19,211.41.0.0/18,211.41.128.0/19,211.41.160.0/19,211.41.192.0/20,211.41.208.0/20,211.41.224.0/19,211.41.64.0/19,211.41.96.0/19,211.43.0.0/19,211.43.128.0/20,211.43.144.0/20,211.43.160.0/19,211.43.192.0/19,211.43.224.0/19,211.43.32.0/19,211.43.64.0/18,211.45.0.0/19,211.45.32.0/19,211.45.64.0/19,211.45.96.0/19,211.46.0.0/16,211.47.0.0/18,211.47.128.0/19,211.47.160.0/22,211.47.164.0/22,211.47.168.0/21,211.47.176.0/20,211.47.192.0/19,211.47.224.0/20,211.47.240.0/20,211.47.64.0/20,211.47.80.0/20,211.47.96.0/19,211.48.0.0/16,211.49.0.0/16,211.52.0.0/18,211.52.128.0/20,211.52.144.0/20,211.52.160.0/19,211.52.192.0/18,211.52.64.0/18,211.56.128.0/18,211.56.192.0/19,211.56.224.0/19,211.56.32.0/19,211.56.64.0/18,211.57.0.0/16,211.58.0.0/15,211.61.0.0/18,211.61.112.0/20,211.61.128.0/17,211.61.64.0/19,211.61.96.0/20,211.63.64.0/19,211.63.96.0/19,218.36.0.0/17,218.36.128.0/17,218.37.0.0/17,218.37.128.0/18,218.37.192.0/18,218.38.0.0/15,219.248.0.0/14,219.252.0.0/15,219.254.0.0/15,220.64.0.0/16,220.65.0.0/16,220.66.0.0/15,220.68.0.0/15,220.70.0.0/15,61.100.0.0/17,61.100.128.0/18,61.100.192.0/19,61.100.224.0/20,61.100.240.0/21,61.100.248.0/21,61.101.0.0/17,61.101.128.0/18,61.101.192.0/19,61.101.224.0/20,61.101.240.0/22,61.101.244.0/22,61.101.248.0/21,61.102.0.0/17,61.102.128.0/17,61.103.0.0/16,61.104.0.0/16,61.105.0.0/16,61.106.0.0/19,61.106.128.0/18,61.106.192.0/19,61.106.224.0/20,61.106.240.0/20,61.106.32.0/19,61.106.64.0/20,61.106.80.0/20,61.106.96.0/19,61.107.0.0/16,61.108.0.0/16,61.109.0.0/17,61.109.128.0/17,61.110.0.0/19,61.110.128.0/22,61.110.132.0/22,61.110.136.0/21,61.110.144.0/20,61.110.160.0/19,61.110.192.0/18,61.110.32.0/20,61.110.48.0/20,61.110.64.0/18,61.111.0.0/18,61.111.112.0/20,61.111.128.0/18,61.111.192.0/19,61.111.224.0/20,61.111.240.0/20,61.111.64.0/19,61.111.96.0/20,61.248.0.0/17,61.248.128.0/19,61.248.160.0/20,61.248.176.0/20,61.248.192.0/19,61.248.224.0/22,61.248.228.0/22,61.248.232.0/21,61.248.240.0/20,61.249.0.0/18,61.249.128.0/19,61.249.160.0/19,61.249.192.0/19,61.249.224.0/19,61.249.64.0/20,61.249.80.0/21,61.249.88.0/22,61.249.92.0/22,61.249.96.0/19,61.250.0.0/18,61.250.128.0/17,61.250.64.0/18,61.251.0.0/20,61.251.112.0/20,61.251.128.0/19,61.251.16.0/20,61.251.160.0/20,61.251.176.0/20,61.251.192.0/18,61.251.32.0/19,61.251.64.0/20,61.251.80.0/20,61.251.96.0/20,61.252.0.0/20,61.252.128.0/19,61.252.16.0/20,61.252.160.0/19,61.252.192.0/18,61.252.32.0/20,61.252.48.0/20,61.252.64.0/22,61.252.68.0/22,61.252.72.0/22,61.252.76.0/22,61.252.80.0/20,61.252.96.0/19,61.253.0.0/16,61.254.0.0/17,61.254.128.0/19,61.254.160.0/19,61.254.192.0/18,61.255.0.0/16,61.96.0.0/16,61.97.0.0/20,61.97.112.0/20,61.97.128.0/19,61.97.16.0/20,61.97.160.0/20,61.97.176.0/20,61.97.192.0/19,61.97.224.0/20,61.97.240.0/20,61.97.32.0/19,61.97.64.0/20,61.97.80.0/20,61.97.96.0/20,61.98.0.0/15,110.34.56.0/21,123.108.0.0/21,147.46.0.0/15,152.149.0.0/19,152.149.128.0/17,152.149.32.0/21,152.149.40.0/21,152.149.48.0/20,152.149.64.0/18,192.132.248.0/22,202.20.84.0/24,202.20.85.0/24,202.30.0.0/19,202.30.112.0/21,202.30.120.0/22,202.30.124.0/24,202.30.125.0/24,202.30.126.0/23,202.30.128.0/17,202.30.32.0/23,202.30.34.0/24,202.30.35.0/24,202.30.36.0/23,202.30.38.0/24,202.30.39.0/24,202.30.40.0/22,202.30.44.0/24,202.30.45.0/24,202.30.46.0/23,202.30.48.0/24,202.30.49.0/24,202.30.50.0/23,202.30.52.0/23,202.30.54.0/24,202.30.55.0/24,202.30.56.0/23,202.30.58.0/24,202.30.59.0/24,202.30.60.0/22,202.30.64.0/19,202.30.96.0/20,202.31.0.0/17,202.31.128.0/20,202.31.144.0/21,202.31.152.0/24,202.31.153.0/24,202.31.154.0/24,202.31.155.0/24,202.31.156.0/22,202.31.160.0/20,202.31.176.0/22,202.31.180.0/24,202.31.181.0/24,202.31.182.0/24,202.31.183.0/24,202.31.184.0/22,103.138.228.0/23,202.31.188.0/22,202.31.192.0/20,202.31.208.0/22,202.31.212.0/22,202.31.216.0/22,202.31.220.0/22,202.31.224.0/19,203.226.0.0/18,203.226.128.0/18,203.226.192.0/19,203.226.224.0/20,203.226.240.0/21,203.226.248.0/22,203.226.252.0/24,203.226.253.0/24,203.226.254.0/23,203.226.64.0/18,203.227.0.0/16,203.228.0.0/17,203.228.128.0/17,203.229.0.0/17,203.229.128.0/17,203.230.0.0/18,203.230.112.0/22,203.230.116.0/22,203.230.120.0/21,203.230.128.0/19,203.230.160.0/19,203.230.192.0/18,203.230.64.0/20,203.230.80.0/20,203.230.96.0/20,203.231.0.0/16,203.232.0.0/17,203.232.128.0/17,203.233.128.0/24,203.233.129.0/24,203.233.130.0/23,203.233.132.0/22,203.233.136.0/21,203.233.144.0/21,203.233.152.0/23,203.233.154.0/23,203.233.156.0/24,203.233.157.0/24,203.233.158.0/23,203.233.160.0/22,203.233.164.0/24,203.233.165.0/24,203.233.166.0/23,203.233.168.0/21,203.233.176.0/20,203.233.192.0/19,203.233.224.0/20,203.233.240.0/20,203.234.0.0/18,203.234.112.0/20,203.234.128.0/17,203.234.64.0/19,203.234.96.0/20,203.235.0.0/17,203.235.128.0/18,203.235.192.0/21,203.235.200.0/23,203.235.202.0/23,203.235.204.0/22,203.235.208.0/20,203.235.224.0/19,203.236.0.0/19,203.236.128.0/18,203.236.192.0/18,203.236.32.0/21,203.236.40.0/22,203.236.44.0/22,203.236.48.0/20,203.236.64.0/18,203.237.0.0/18,203.237.128.0/17,203.237.64.0/19,203.237.96.0/19,203.238.0.0/17,203.238.128.0/19,203.238.160.0/20,203.238.176.0/20,203.238.192.0/19,203.238.224.0/19,203.239.0.0/17,203.239.128.0/18,203.239.192.0/19,203.239.224.0/19,203.240.0.0/18,203.240.100.0/22,203.240.104.0/21,203.240.112.0/20,203.240.128.0/19,203.240.160.0/20,203.240.176.0/21,203.240.184.0/22,203.240.188.0/23,203.240.190.0/24,203.240.191.0/24,203.240.192.0/18,203.240.64.0/19,203.240.96.0/23,203.240.98.0/23,203.241.0.0/19,203.241.112.0/22,203.241.116.0/22,203.241.120.0/22,203.241.124.0/22,203.241.128.0/22,203.241.132.0/22,203.241.136.0/21,203.241.144.0/20,203.241.160.0/22,203.241.164.0/23,203.241.166.0/24,203.241.167.0/24,203.241.168.0/22,203.241.172.0/23,203.241.174.0/24,203.241.175.0/24,203.241.176.0/20,203.241.192.0/20,203.241.208.0/22,203.241.212.0/23,203.241.214.0/23,203.241.216.0/22,203.241.220.0/22,203.241.224.0/19,203.241.32.0/20,203.241.48.0/22,203.241.52.0/22,203.241.56.0/21,203.241.64.0/20,203.241.80.0/22,203.241.84.0/22,203.241.88.0/21,203.241.96.0/20,203.242.0.0/19,203.242.112.0/21,203.242.120.0/21,203.242.128.0/17,203.242.32.0/20,203.242.48.0/21,203.242.56.0/22,203.242.60.0/23,203.242.62.0/24,203.242.63.0/24,203.242.64.0/19,203.242.96.0/20,203.243.0.0/18,203.243.128.0/17,203.243.64.0/18,203.244.0.0/19,203.244.128.0/18,203.244.192.0/19,203.244.224.0/20,203.244.240.0/20,203.244.32.0/19,203.244.64.0/19,203.244.96.0/19,203.245.0.0/18,203.245.128.0/17,203.245.64.0/18,203.246.0.0/17,203.246.128.0/19,203.246.160.0/20,203.246.176.0/21,203.246.184.0/22,203.246.188.0/23,203.246.190.0/23,203.246.192.0/18,203.247.0.0/19,203.247.128.0/19,203.247.160.0/19,203.247.192.0/19,203.247.224.0/19,203.247.32.0/19,203.247.64.0/18,203.249.0.0/18,203.249.128.0/19,203.249.160.0/19,203.249.192.0/19,203.249.224.0/19,203.249.64.0/19,203.249.96.0/19,203.250.0.0/19,203.250.128.0/17,203.250.32.0/19,203.250.64.0/19,203.250.96.0/19,203.251.0.0/17,203.251.128.0/18,203.251.192.0/18,203.252.128.0/18,203.252.16.0/21,203.252.192.0/20,203.252.208.0/20,203.252.224.0/19,203.252.24.0/23,203.252.26.0/24,203.252.27.0/24,203.252.28.0/22,203.252.64.0/19,203.252.96.0/19,203.253.0.0/19,203.253.112.0/20,203.253.128.0/22,203.253.132.0/22,203.253.136.0/21,203.253.144.0/20,203.253.160.0/19,203.253.192.0/19,203.253.224.0/21,203.253.232.0/24,203.253.233.0/24,203.253.234.0/23,203.253.236.0/24,203.253.237.0/24,203.253.238.0/23,203.253.240.0/21,203.253.248.0/21,203.253.32.0/20,203.253.48.0/20,203.253.64.0/19,203.253.96.0/20,203.254.0.0/21,203.254.10.0/23,203.254.12.0/22,203.254.128.0/19,203.254.16.0/20,203.254.160.0/21,203.254.168.0/23,203.254.170.0/24,203.254.171.0/24,203.254.172.0/23,203.254.174.0/24,203.254.175.0/24,103.106.140.0/22,203.254.176.0/20,203.254.192.0/18,203.254.32.0/23,203.254.34.0/23,203.254.36.0/22,203.254.40.0/24,203.254.41.0/24,203.254.42.0/23,203.254.44.0/22,203.254.48.0/23,203.254.50.0/24,203.254.51.0/24,203.254.52.0/22,203.254.56.0/24,203.254.57.0/24,203.254.58.0/23,203.254.60.0/22,203.254.64.0/19,203.254.8.0/24,203.254.9.0/24,203.254.96.0/19,203.255.0.0/18,203.255.112.0/21,203.255.120.0/22,203.255.124.0/22,203.255.128.0/19,203.255.160.0/19,203.255.192.0/20,203.255.208.0/22,203.255.212.0/22,203.255.216.0/22,203.255.220.0/23,203.255.222.0/23,203.255.224.0/21,203.255.232.0/23,203.255.234.0/24,203.255.235.0/24,203.255.236.0/22,203.255.240.0/21,203.255.248.0/21,203.255.64.0/19,203.255.96.0/20,210.101.0.0/18,210.101.192.0/19,210.101.224.0/19,210.101.64.0/18,210.102.64.0/19,210.102.96.0/19,210.106.0.0/18,210.106.64.0/19,210.106.96.0/19,210.110.0.0/17,210.110.128.0/17,210.111.0.0/18,210.111.112.0/20,210.111.128.0/19,210.111.160.0/19,210.111.192.0/19,210.111.224.0/19,210.111.64.0/20,210.111.80.0/20,210.111.96.0/20,210.112.0.0/17,210.112.128.0/19,210.112.160.0/20,210.112.176.0/20,210.112.192.0/19,210.112.224.0/19,210.113.0.0/16,210.114.0.0/18,210.114.104.0/21,210.114.112.0/20,210.114.128.0/19,210.114.160.0/19,210.114.192.0/20,210.114.208.0/20,210.114.224.0/19,210.114.64.0/20,210.114.80.0/21,210.114.88.0/21,210.114.96.0/21,210.115.0.0/19,210.115.128.0/19,210.115.160.0/19,210.115.192.0/19,210.115.224.0/19,210.115.32.0/19,210.115.64.0/19,210.115.96.0/19,210.116.0.0/18,210.116.128.0/17,210.116.64.0/18,210.117.0.0/17,210.117.128.0/18,210.117.192.0/18,210.118.0.0/19,210.118.128.0/17,210.118.32.0/19,210.118.64.0/18,210.119.0.0/17,210.119.128.0/18,210.119.192.0/19,210.119.224.0/20,210.119.240.0/20,210.121.0.0/17,210.121.128.0/17,210.122.0.0/16,210.123.0.0/16,210.125.0.0/20,210.125.128.0/17,210.125.16.0/20,210.125.32.0/19,210.125.64.0/18,210.126.0.0/17,210.126.128.0/17,210.127.0.0/19,210.127.128.0/17,210.127.32.0/19,210.127.64.0/18,210.180.64.0/19,210.180.96.0/19,210.181.0.0/19,210.181.128.0/18,210.181.192.0/19,210.181.224.0/19,210.181.32.0/19,210.181.64.0/18,210.204.0.0/16,210.205.0.0/18,210.205.112.0/20,210.205.128.0/18,210.205.192.0/19,210.205.224.0/20,210.205.240.0/20,210.205.64.0/19,210.205.96.0/20,210.206.0.0/15,103.143.176.0/23,103.186.170.0/23,64.188.32.0/20,103.131.164.0/22,165.141.0.0/18,165.141.112.0/20,165.141.128.0/17,165.141.64.0/19,165.141.96.0/20,103.144.30.0/23,103.143.32.0/23,103.140.208.0/22,103.117.0.0/22,103.129.184.0/22,103.109.64.0/22,103.21.188.0/23,103.21.190.0/23,103.37.0.0/22,43.240.236.0/22,103.127.124.0/22,103.126.64.0/22,103.199.100.0/22,103.48.132.0/22,137.59.16.0/22,43.229.112.0/22,103.175.200.0/23,206.219.0.0/18,103.167.230.0/23,103.39.16.0/22,43.243.188.0/22,103.162.180.0/23,103.161.4.0/23,180.189.52.0/22,211.172.180.0/22,124.217.192.0/20,180.210.16.0/21,180.210.24.0/22,180.210.28.0/22,211.172.176.0/22,162.222.172.0/22,211.172.184.0/21,103.159.160.0/23,103.166.222.0/23,103.157.158.0/23,103.153.44.0/23,103.164.78.0/23,103.44.88.0/22,43.225.124.0/22,103.157.208.0/23,160.20.142.0/24,103.156.22.0/23,103.86.44.0/22,203.160.130.0/23,203.191.134.0/23,103.150.62.0/23,103.162.52.0/23,103.150.204.0/23,103.150.160.0/24,103.150.162.0/23,103.146.180.0/23,211.188.104.0/21,211.188.112.0/20,211.188.96.0/21,211.255.128.0/21,211.255.136.0/21,211.255.144.0/20,223.255.192.0/21,223.255.200.0/21,103.145.214.0/23,103.122.144.0/23,180.94.4.0/24,59.150.0.0/21,59.150.100.0/22,59.150.104.0/22,59.150.108.0/23,59.150.110.0/23,59.150.112.0/21,59.150.12.0/24,59.150.120.0/23,59.150.122.0/24,59.150.123.0/24,59.150.124.0/24,59.150.125.0/24,59.150.126.0/23,59.150.128.0/22,59.150.13.0/24,59.150.132.0/23,59.150.134.0/24,59.150.135.0/24,59.150.136.0/24,59.150.137.0/24,59.150.138.0/24,59.150.139.0/24,59.150.14.0/24,59.150.140.0/24,59.150.141.0/24,59.150.142.0/23,59.150.144.0/23,59.150.146.0/23,59.150.148.0/23,59.150.15.0/24,59.150.150.0/24,59.150.151.0/24,59.150.152.0/22,59.150.156.0/24,59.150.157.0/24,59.150.158.0/23,59.150.16.0/23,59.150.160.0/22,59.150.164.0/24,59.150.165.0/24,59.150.166.0/23,59.150.168.0/23,59.150.170.0/24,59.150.171.0/24,59.150.172.0/24,59.150.173.0/24,59.150.174.0/23,59.150.176.0/20,59.150.18.0/24,59.150.19.0/24,59.150.192.0/23,59.150.194.0/24,59.150.195.0/24,59.150.196.0/23,59.150.198.0/23,59.150.20.0/23,59.150.200.0/22,59.150.204.0/23,59.150.206.0/24,59.150.207.0/24,59.150.208.0/20,59.150.22.0/23,59.150.224.0/19,59.150.24.0/21,59.150.32.0/21,59.150.40.0/23,59.150.42.0/24,59.150.43.0/24,59.150.44.0/24,59.150.45.0/24,59.150.46.0/23,59.150.48.0/22,59.150.52.0/23,59.150.54.0/23,59.150.56.0/23,59.150.58.0/23,59.150.60.0/24,59.150.61.0/24,59.150.62.0/23,59.150.64.0/22,59.150.68.0/24,59.150.69.0/24,59.150.70.0/23,59.150.72.0/24,59.150.73.0/24,59.150.74.0/23,59.150.76.0/22,59.150.8.0/22,59.150.80.0/22,59.150.84.0/22,59.150.88.0/22,59.150.92.0/23,59.150.94.0/23,59.150.96.0/23,59.150.98.0/24,59.150.99.0/24,103.67.58.0/23,101.79.0.0/19,101.79.128.0/22,101.79.132.0/22,101.79.136.0/21,101.79.32.0/21,101.79.40.0/22,101.79.44.0/22,101.79.48.0/21,101.79.56.0/22,101.79.60.0/22,101.79.64.0/18,110.4.112.0/22,110.4.116.0/22,110.4.120.0/21,110.4.64.0/19,110.4.96.0/20,113.30.104.0/22,113.30.108.0/22,113.30.112.0/20,113.30.64.0/21,113.30.72.0/21,113.30.80.0/20,113.30.96.0/21,114.141.0.0/21,114.141.12.0/22,114.141.16.0/22,114.141.20.0/22,114.141.24.0/21,114.141.8.0/22,124.217.208.0/20,180.210.0.0/21,180.210.32.0/19,180.210.64.0/18,180.210.8.0/21,182.252.128.0/20,182.252.144.0/22,182.252.148.0/22,182.252.152.0/21,182.252.160.0/21,182.252.168.0/22,182.252.172.0/22,182.252.176.0/22,182.252.180.0/22,182.252.184.0/21,182.252.192.0/18,185.130.49.0/24,103.218.172.0/23,157.66.64.0/23,

- 국가별 IP 대역 / KISA

https://xn--3e0bx5euxnjje69i70af08bea817g.xn--3e0b707e/jsp/statboard/IPAS/ovrse/natal/IPaddrBandCurrent.jsp?nationCode1=KR

- 엑셀 편집, IP 추출

- 파워쉘로 공격 당한 IP만 자동 등록 / 의미는 없음, 해당 IP 차단하면 감지하여 새로운 IP 공격 확인

$DT = [DateTime]::Now.AddDays(-1) # check only last 24 hours

$l = Get-EventLog -LogName 'Security' -InstanceId 4625 -After $DT | Select-Object @{n='IpAddress';e={$_.ReplacementStrings[-2]} } # select Ip addresses that has audit failure 
$g = $l | group-object -property IpAddress  | where {$_.Count -gt 20} | Select -property Name # get ip adresses, that have more than 20 wrong logins

$fw = New-Object -ComObject hnetcfg.fwpolicy2 # get firewall object

$ar = $fw.rules | where {$_.name -eq 'ExternalAttackBlock'} # get firewall rule named 'BlockAttackers' (must be created manually)

$arRemote = $ar.RemoteAddresses -split(',') #split the existing IPs into an array so we can easily search for existing IPs

$w = $g | where {$_.Name.Length -gt 1 -and  !($arRemote -contains $_.Name + '/255.255.255.255') } # get ip addresses that are not already in firewal rule. Include the subnet mask which is automatically added to the firewall remote IP declaration.

$w| %{$ar.remoteaddresses += ',' + $_.Name} # add IPs to firewall rule

* 라우터 또는 별도 방화벽 장비 설정 별도

* 특히 MSSQL 설치 되어 있을 경우 중국발 공격 많이 발생하며 다른 서비스 공격이 없는 것은 별도 방화벽 장비에서 막아서 로그 없을 수 있음

6. 방화벽 설정 결론 

- IP 차단은 끝이 없음

- 포트 다 차단 

- 공격 대상 포트 변경 / 레지스트리 변경은 귀찮, 파워셀 이용 변경 / DOS CLI 환경에서 powershell 입력 실행 후 아래 입력

$portvalue = 13390
Set-ItemProperty -Path 'HKLM:\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp' -name "PortNumber" -Value $portvalue 
New-NetFirewallRule -DisplayName 'RDPPORTLatest-TCP-In' -Profile 'Public' -Direction Inbound -Action Allow -Protocol TCP -LocalPort $portvalue 
New-NetFirewallRule -DisplayName 'RDPPORTLatest-UDP-In' -Profile 'Public' -Direction Inbound -Action Allow -Protocol UDP -LocalPort $portvalue

- 서비스 레지스트리 값을 알고 있으면 사용 포트 확인도 가능

Get-ItemProperty -Path 'HKLM:\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp' -name "PortNumber"

- 변경 포트만 특정 IP에서 접근 허용

① 방화벽 인바운 규칙에서 위에서 파워셀로 추가한 "RDPPORTLatest-TCP-In" 확인하여 더블 클릭

② 영역 탭 클릭

③ 원격 IP 주소에 원격에서 접속할 PC 퍼블릭 IP 입력

④ 등록한 IP 컴퓨터에서 원격 접속 테스트 / OK

tcping.exe download

https://www.elifulkerson.com/projects/tcping.php

tcping -d -s 211.***.***.*** 3389

3389 port open 글자까 뜨지 않으면 

해당 서비스가 없거나 방화벽에서 차단된 상태

-s     : automatically exit on a successful ping

-d     : include date and time on each line

● SQL 계정으로 로그인 되지 않을 때

- 윈도우 계정으로 로그인 후 SQL Query 실행하는 방법으로 "SP_ReadErrorLog" 실행 

- 계정이 잠겨서 발생하는 문제 경우 아래 실행

ALTER LOGIN sa WITH PASSWORD = '비번' UNLOCK

● Sequence 사용

CREATE SEQUENCE tempUid AS BIGINT
START WITH 1
INCREMENT BY 1
MINVALUE 1
NO MAXVALUE;

CREATE TABLE TEMP(
	uid BIGINT NOT NULL DEFAULT (NEXT VALUE FOR tempUid) PRIMARY KEY,
	name VARCHAR(100)
)

SELECT * FROM TEMP;

INSERT INTO TEMP(name) VALUES
	('최길동'),
	('박길동');

SELECT * FROM TEMP;

● 가상테이블 사용

WITH T(val1) AS(
	SELECT 1 
)
SELECT * FROM T

꽤 오랜시간 문제가 되고 있는 부분

setter & getter 동작하지 않아 코딩 시, 해당 메서드가 없다고 오류 발생

- gradle lombok 설정으로 다운로드 되어 있는 lombok*.jar 파일 확인

- 해당 파일 우측 마우스 클럭 & 실행

- 실행 후 sts 경로 선택 & 리스트업 되었을 때 체크 후 Install / Update 실행

- 1초 만에 설치 완료 확인

- 그리고 STS 재시작! 그래야 오류 사라짐 

* 결국 해당 과정을 통해 STS 설치 경로 sts.ini 자동으로 수정 / 내용은 lombok 경로 잡아 줌 

MSSQL 설치 후

SSMS(Microsoft SQL Server Management Studio)에서 로그인 할 때 아래처럼 오류가 발생할 때

쉽게 로그인 팝업에서 탭메뉴 "추가 연결 매개 변수" 클릭 후

TrustServerCertificate=True

이거 넣어주면 해결 완료

여기저기 같은 버전 10번은 설치한 거 같은데 

이런 증상이 없는 컴퓨터도 있고 

로그인 할 때 윈도우 계정으로 하면 잘되는 경우도 있고
윈도우 계정도 동일한 오류가 발생하는 경우도 있고
아무튼 위 기술해주면 모두 로그인 성공!

1. CLI(Command line interface) 환경 진입

2. 사용 포트 전체 조회에서 8081 글자가 있는 라인만 검색 

netstat -ano | findstr "8081"

해당 라인 맨마지막 5724 번호가 프로세스 번호

3. 프로세스 죽이기

taskkill /f -pid 5724

끝.

● PIN 비밀번호 초기화를 할 수 없을 때

(자동 로그인 되었는데 관리자 비밀번호는 모르겠고, 비밀번호를 바꾸고 싶을 때는 맨 아래 "비밀번호 초기화" 부분 확인, 1줄만 입력하면 끝)

- 초기화 되지 않는 원인 : 학교 또는 회사 그룹으로 윈도우 설치되었을 때

윈도우 실행, "회사" 쳐서 나오는 메뉴

이 메뉴를 선택하여 보이는 소소 조직이 있다면 해지하면 된다는 글들이 다수

해당 방법으로 해결이 되지 않을 경우

아래 폴더를 어떻게든 지우면 된다

C:\Windows\ServiceProfiles\LocalService\AppData\Local\Microsoft\Ngc

del 키 눌러지워지면 좋은데, 지우는 방법은 조금 복잡

1. 파일탐색기로 해당 폴더 속성 누르고 뜨는 창에서 "보안" 탭메뉴 선택

2. 거기서 내 로그인 아이디 보이면 선택 후 화면 하단 고급 메뉴 선택

3. 그리고 뜨는 화면에서 파란색 글씨 변경 선택

4. 이어 뜨는 화면에서 "고급" > "지금 찾기" 눌러서 아래처럼 "administrators" 누름 > 그리고 다시 확인 클릭

5. 계속 확인 누르다 보면 아까 보이지 않았던 메뉴 "하위 컨테이너 .." 선택

6. 그리고 적용 후 해당 폴더 삭제하면 PIN 관련 정보가 다 삭제 되어, PIN 누르면 아래처럼 설정할 수 있는 화면 뜸

● 비밀번호 초기화

- 명령 프롬프트라는 검정 화면을 관리자 권한으로 실행 필요

(PIN 번호로만 로그인 하고 현 설정된 관리자 비밀번호 모를 경우도 해당)

- 그 화면에서 "net user"라고 치면 사용자 목록이 뜸

- 로그인 사용자 비밀번호 초기화 대상 확인 후

- "net user J.BHAK 변경비밀번호" 입력하면 비밀번호 재설정 완료

- 비번을 까먹어 진입조차 할 수 없다면 안전모드 또는 USB 윈도우설치 도구를 이용하여 동일하게 CMD 화면 진입하여 위 명령어 치면 동일하게 비밀번호 변경 가능

Eclipse Java & WEB 버전 받으면 대부분 문제 없으나

Eclipse PHP 받는 경우 PHP용 서버만 있음

이 경우 관련 기능 설치 필요

JTS Server Adapters 라는 것을 업데이트 필요

1. Help - Install New Software

2. http://download.eclipse.org/releases/neon 입력 및 추가

3. 추가 시 아래 리스트가 바뀌며 목록이 잔뜩 올라오는데

4. 거기서 "Web, XML, Java EE and OSGI Enterprise Development" 클릭하여 세부 항목 확인

5. JST Server Adapters, JST Server Adapters Extension 2개 항목 체크하고 설치 진행

6. 이클립스 재시작 후 목록 확인. 끝.

이 경우 기존 자바 프로젝트 불러오면 추가 문제가 될 수 있는 것이

프로젝트 설정에서 웹 다이나믹 모듈이 없어 서버에서 프로젝트 추가/제거 목록에 뜨지 않음 

그냥 Java & WEB 이클립스 최신 버전 받아서 진행하는 것 권장