약간의 제약이 있긴 하지만
view로 만든 것으로도 insert가 가능하군.
[링크 : http://recoveryman.tistory.com/181]
+
2017.04.07
볼수 있는건 다 뷰로 만들수 있는듯 조인도 되고
[링크 : https://dev.mysql.com/doc/refman/5.7/en/create-view.html]
[링크 : http://stackoverflow.com/questions/12352048/mysql-create-view-joining-two-tables]
| db에 mac / ip 저장하기(자료형) (0) | 2017.05.09 |
|---|---|
| mysql innodb compress (0) | 2017.04.12 |
| db designer (0) | 2017.03.14 |
| 데이터베이스 구조 버전관리 (0) | 2017.02.13 |
| mysql 통화관련 변수타입 (0) | 2017.02.07 |
mysql 디자인 해서 좀 편하게 하고 이력남겨 볼까 했는데
아주 구버전인거 같고 유지보수가 안되는 것 같아서 고민..
| mysql innodb compress (0) | 2017.04.12 |
|---|---|
| mysql view (0) | 2017.03.14 |
| 데이터베이스 구조 버전관리 (0) | 2017.02.13 |
| mysql 통화관련 변수타입 (0) | 2017.02.07 |
| mysql 다국어 문자길이 (0) | 2017.02.06 |
ssh가 차단이 안되서 좀 봤더니..
이런식으로 ssh 를 만들다가 실패하는거 같은데..
다시 보니.. unban이 실패네?
770 2017-03-06 11:33:08,276 fail2ban.actions[1253]: WARNING [ssh] Unban 117.179.164.237 771 2017-03-06 11:33:08,311 fail2ban.actions.action[1253]: ERROR iptables -D fail2ban-ssh -s 117.179.164.237/24 -j REJECT --reject-with icmp-port-unreachable returned 100 ... 828 2017-03-06 11:33:09,223 fail2ban.jail [1253]: INFO Jail 'ssh' stopped 829 2017-03-06 11:33:09,893 fail2ban.jail [1253]: INFO Jail 'apache-multiport' stopped 830 2017-03-06 11:33:09,896 fail2ban.server [1253]: INFO Exiting Fail2ban 831 2017-03-06 11:33:22,281 fail2ban.server [1184]: INFO Changed logging target to /var/log/fail2ban.log for Fa il2ban v0.8.13 832 2017-03-06 11:33:22,297 fail2ban.jail [1184]: INFO Creating new jail 'ssh' 833 2017-03-06 11:33:22,595 fail2ban.jail [1184]: INFO Jail 'ssh' uses pyinotify 834 2017-03-06 11:33:22,891 fail2ban.jail [1184]: INFO Initiated 'pyinotify' backend |
아무튼 이거는 race condition으로 추측되서 아래와 같이 수정해주면 된다는데 아직까진 티는 안나네
$ sudo vi /usr/bin/fail2ban-client def __processCmd(self, cmd, showRet = True): beautifier = Beautifier() for c in cmd: time.sleep(0.1) beautifier.setInputCmd(c) |
[링크 : http://www.evilbox.ro/linux/fail2ban-iptables-error-on-ispconfig-on-ubuntu-11/]
| fail2ban with 404 (2) | 2019.03.20 |
|---|---|
| fail2ban ssh 차단 실패??? (0) | 2017.03.06 |
| fail2ban phpmyadmin (0) | 2017.02.28 |
| fail2ban 재시작을 위한 차단목록 추가? (0) | 2017.02.15 |
| fail2ban 차단 관련... (0) | 2017.02.09 |
머지??
도대체 어떻게 차단되었는데 또 ssh로 접속을 하는거야?!?!?
혹시.. 차단되기 전에 동시에 세션 몇십개 열어두고 순차적으로 시도해서 끊어지던 말던
연결된것들 까진 차단 안되니 그렇게 하는건가?
720 2017-03-01 02:18:17,757 fail2ban.actions[1253]: WARNING [ssh] Ban 117.179.164.237 721 2017-03-01 02:18:26,883 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned 722 2017-03-01 02:18:35,897 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned 723 2017-03-01 02:18:53,922 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned 724 2017-03-01 02:19:03,936 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned 725 2017-03-01 02:19:14,952 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned 726 2017-03-01 02:19:24,966 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned 727 2017-03-01 02:19:34,981 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned 728 2017-03-01 02:19:43,995 fail2ban.actions[1253]: INFO [ssh] 117.179.164.237 already banned |
엥? 차단 되었는데 어떻게 계속 접속하지?!?! 머지?!?!
8438 Mar 1 02:18:08 raspberrypi sshd[10320]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8439 Mar 1 02:18:08 raspberrypi sshd[10320]: input_userauth_request: invalid user root [preauth] 8440 Mar 1 02:18:08 raspberrypi sshd[10320]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8441 Mar 1 02:18:11 raspberrypi sshd[10320]: Failed password for invalid user root from 117.179.164.237 port 22077 ssh2 8442 Mar 1 02:18:13 raspberrypi sshd[10320]: Failed password for invalid user root from 117.179.164.237 port 22077 ssh2 8443 Mar 1 02:18:15 raspberrypi sshd[10320]: Failed password for invalid user root from 117.179.164.237 port 22077 ssh2 8444 Mar 1 02:18:17 raspberrypi sshd[10320]: Failed password for invalid user root from 117.179.164.237 port 22077 ssh2 8445 Mar 1 02:18:19 raspberrypi sshd[10320]: Failed password for invalid user root from 117.179.164.237 port 22077 ssh2 8446 Mar 1 02:18:19 raspberrypi sshd[10320]: fatal: Read from socket failed: Connection reset by peer [preauth] 8447 Mar 1 02:18:19 raspberrypi sshd[10320]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8448 Mar 1 02:18:19 raspberrypi sshd[10320]: PAM service(sshd) ignoring max retries; 5 > 3 8449 Mar 1 02:18:20 raspberrypi sshd[10336]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8450 Mar 1 02:18:20 raspberrypi sshd[10336]: input_userauth_request: invalid user root [preauth] 8451 Mar 1 02:18:20 raspberrypi sshd[10336]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8452 Mar 1 02:18:22 raspberrypi sshd[10336]: Failed password for invalid user root from 117.179.164.237 port 21532 ssh2 8453 Mar 1 02:18:24 raspberrypi sshd[10336]: Failed password for invalid user root from 117.179.164.237 port 21532 ssh2 8454 Mar 1 02:18:26 raspberrypi sshd[10336]: Failed password for invalid user root from 117.179.164.237 port 21532 ssh2 8455 Mar 1 02:18:28 raspberrypi sshd[10336]: Failed password for invalid user root from 117.179.164.237 port 21532 ssh2 8456 Mar 1 02:18:30 raspberrypi sshd[10336]: Failed password for invalid user root from 117.179.164.237 port 21532 ssh2 8457 Mar 1 02:18:30 raspberrypi sshd[10336]: fatal: Read from socket failed: Connection reset by peer [preauth] 8458 Mar 1 02:18:30 raspberrypi sshd[10336]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8459 Mar 1 02:18:30 raspberrypi sshd[10336]: PAM service(sshd) ignoring max retries; 5 > 3 8460 Mar 1 02:18:31 raspberrypi sshd[10344]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8461 Mar 1 02:18:31 raspberrypi sshd[10344]: input_userauth_request: invalid user root [preauth] 8462 Mar 1 02:18:31 raspberrypi sshd[10344]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8463 Mar 1 02:18:33 raspberrypi sshd[10344]: Failed password for invalid user root from 117.179.164.237 port 21892 ssh2 8464 Mar 1 02:18:35 raspberrypi sshd[10344]: Failed password for invalid user root from 117.179.164.237 port 21892 ssh2 8465 Mar 1 02:18:37 raspberrypi sshd[10344]: Failed password for invalid user root from 117.179.164.237 port 21892 ssh2 8466 Mar 1 02:18:39 raspberrypi sshd[10344]: Failed password for invalid user root from 117.179.164.237 port 21892 ssh2 8467 Mar 1 02:18:42 raspberrypi sshd[10344]: Failed password for invalid user root from 117.179.164.237 port 21892 ssh2 8468 Mar 1 02:18:42 raspberrypi sshd[10344]: fatal: Read from socket failed: Connection reset by peer [preauth] 8469 Mar 1 02:18:42 raspberrypi sshd[10344]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8470 Mar 1 02:18:42 raspberrypi sshd[10344]: PAM service(sshd) ignoring max retries; 5 > 3 8471 Mar 1 02:18:52 raspberrypi sshd[10352]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8472 Mar 1 02:18:52 raspberrypi sshd[10352]: input_userauth_request: invalid user root [preauth] 8473 Mar 1 02:18:52 raspberrypi sshd[10352]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8474 Mar 1 02:18:53 raspberrypi sshd[10352]: Failed password for invalid user root from 117.179.164.237 port 21949 ssh2 8475 Mar 1 02:18:55 raspberrypi sshd[10352]: Failed password for invalid user root from 117.179.164.237 port 21949 ssh2 8476 Mar 1 02:18:57 raspberrypi sshd[10352]: Failed password for invalid user root from 117.179.164.237 port 21949 ssh2 8477 Mar 1 02:18:59 raspberrypi sshd[10352]: Failed password for invalid user root from 117.179.164.237 port 21949 ssh2 8478 Mar 1 02:19:01 raspberrypi sshd[10352]: Failed password for invalid user root from 117.179.164.237 port 21949 ssh2 8479 Mar 1 02:19:01 raspberrypi sshd[10352]: fatal: Read from socket failed: Connection reset by peer [preauth] 8480 Mar 1 02:19:01 raspberrypi sshd[10352]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8481 Mar 1 02:19:01 raspberrypi sshd[10352]: PAM service(sshd) ignoring max retries; 5 > 3 8482 Mar 1 02:19:02 raspberrypi sshd[10361]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8483 Mar 1 02:19:02 raspberrypi sshd[10361]: input_userauth_request: invalid user root [preauth] 8484 Mar 1 02:19:02 raspberrypi sshd[10361]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8485 Mar 1 02:19:05 raspberrypi sshd[10361]: Failed password for invalid user root from 117.179.164.237 port 22141 ssh2 8486 Mar 1 02:19:07 raspberrypi sshd[10361]: Failed password for invalid user root from 117.179.164.237 port 22141 ssh2 8487 Mar 1 02:19:09 raspberrypi sshd[10361]: Failed password for invalid user root from 117.179.164.237 port 22141 ssh2 8488 Mar 1 02:19:11 raspberrypi sshd[10361]: Failed password for invalid user root from 117.179.164.237 port 22141 ssh2 8489 Mar 1 02:19:14 raspberrypi sshd[10361]: Failed password for invalid user root from 117.179.164.237 port 22141 ssh2 8490 Mar 1 02:19:14 raspberrypi sshd[10361]: fatal: Read from socket failed: Connection reset by peer [preauth] 8491 Mar 1 02:19:14 raspberrypi sshd[10361]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8492 Mar 1 02:19:14 raspberrypi sshd[10361]: PAM service(sshd) ignoring max retries; 5 > 3 8493 Mar 1 02:19:15 raspberrypi sshd[10369]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8494 Mar 1 02:19:15 raspberrypi sshd[10369]: input_userauth_request: invalid user root [preauth] 8495 Mar 1 02:19:15 raspberrypi sshd[10369]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8496 Mar 1 02:19:17 raspberrypi sshd[10369]: Failed password for invalid user root from 117.179.164.237 port 21735 ssh2 8497 Mar 1 02:19:19 raspberrypi sshd[10369]: Failed password for invalid user root from 117.179.164.237 port 21735 ssh2 8498 Mar 1 02:19:21 raspberrypi sshd[10369]: Failed password for invalid user root from 117.179.164.237 port 21735 ssh2 8499 Mar 1 02:19:24 raspberrypi sshd[10369]: Failed password for invalid user root from 117.179.164.237 port 21735 ssh2 8500 Mar 1 02:19:26 raspberrypi sshd[10369]: Failed password for invalid user root from 117.179.164.237 port 21735 ssh2 8501 Mar 1 02:19:26 raspberrypi sshd[10369]: fatal: Read from socket failed: Connection reset by peer [preauth] 8502 Mar 1 02:19:26 raspberrypi sshd[10369]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8503 Mar 1 02:19:26 raspberrypi sshd[10369]: PAM service(sshd) ignoring max retries; 5 > 3 8504 Mar 1 02:19:27 raspberrypi sshd[10377]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8505 Mar 1 02:19:27 raspberrypi sshd[10377]: input_userauth_request: invalid user root [preauth] 8506 Mar 1 02:19:27 raspberrypi sshd[10377]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8507 Mar 1 02:19:29 raspberrypi sshd[10377]: Failed password for invalid user root from 117.179.164.237 port 21863 ssh2 8508 Mar 1 02:19:31 raspberrypi sshd[10377]: Failed password for invalid user root from 117.179.164.237 port 21863 ssh2 8509 Mar 1 02:19:34 raspberrypi sshd[10377]: Failed password for invalid user root from 117.179.164.237 port 21863 ssh2 8510 Mar 1 02:19:35 raspberrypi sshd[10377]: Failed password for invalid user root from 117.179.164.237 port 21863 ssh2 8511 Mar 1 02:19:38 raspberrypi sshd[10377]: Failed password for invalid user root from 117.179.164.237 port 21863 ssh2 8512 Mar 1 02:19:38 raspberrypi sshd[10377]: fatal: Read from socket failed: Connection reset by peer [preauth] 8513 Mar 1 02:19:38 raspberrypi sshd[10377]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8514 Mar 1 02:19:38 raspberrypi sshd[10377]: PAM service(sshd) ignoring max retries; 5 > 3 8515 Mar 1 02:19:39 raspberrypi sshd[10386]: User root from 117.179.164.237 not allowed because listed in DenyUsers 8516 Mar 1 02:19:39 raspberrypi sshd[10386]: input_userauth_request: invalid user root [preauth] 8517 Mar 1 02:19:39 raspberrypi sshd[10386]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8518 Mar 1 02:19:41 raspberrypi sshd[10386]: Failed password for invalid user root from 117.179.164.237 port 21996 ssh2 8519 Mar 1 02:19:43 raspberrypi sshd[10386]: Failed password for invalid user root from 117.179.164.237 port 21996 ssh2 8520 Mar 1 02:19:45 raspberrypi sshd[10386]: Failed password for invalid user root from 117.179.164.237 port 21996 ssh2 8521 Mar 1 02:19:48 raspberrypi sshd[10386]: Failed password for invalid user root from 117.179.164.237 port 21996 ssh2 8522 Mar 1 02:19:48 raspberrypi sshd[10386]: fatal: Read from socket failed: Connection reset by peer [preauth] 8523 Mar 1 02:19:48 raspberrypi sshd[10386]: PAM 3 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=117.179.164.237 user=root 8524 Mar 1 02:19:48 raspberrypi sshd[10386]: PAM service(sshd) ignoring max retries; 4 > 3 |
753 2017-03-04 19:45:18,761 fail2ban.actions[1253]: INFO [ssh] 122.171.39.147 already banned 754 2017-03-04 19:45:21,767 fail2ban.actions[1253]: INFO [ssh] 122.171.39.147 already banned 755 2017-03-04 19:45:26,777 fail2ban.actions[1253]: INFO [ssh] 122.171.39.147 already banned 756 2017-03-04 19:45:28,781 fail2ban.actions[1253]: INFO [ssh] 122.171.39.147 already banned 757 2017-03-04 19:45:44,806 fail2ban.actions[1253]: INFO [ssh] 122.171.39.147 already banned 758 2017-03-04 19:45:58,828 fail2ban.actions[1253]: INFO [ssh] 122.171.39.147 already banned |
938 Mar 4 19:45:11 raspberrypi sshd[30438]: User root from 122.171.39.147 not allowed because listed in DenyUsers 939 Mar 4 19:45:11 raspberrypi sshd[30438]: input_userauth_request: invalid user root [preauth] 940 Mar 4 19:45:11 raspberrypi sshd[30438]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 941 Mar 4 19:45:13 raspberrypi sshd[30442]: User root from 122.171.39.147 not allowed because listed in DenyUsers 942 Mar 4 19:45:13 raspberrypi sshd[30442]: input_userauth_request: invalid user root [preauth] 943 Mar 4 19:45:13 raspberrypi sshd[30442]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 944 Mar 4 19:45:13 raspberrypi sshd[30438]: Failed password for invalid user root from 122.171.39.147 port 50859 ssh2 945 Mar 4 19:45:14 raspberrypi sshd[30444]: User root from 122.171.39.147 not allowed because listed in DenyUsers 946 Mar 4 19:45:14 raspberrypi sshd[30444]: input_userauth_request: invalid user root [preauth] 947 Mar 4 19:45:14 raspberrypi sshd[30444]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 948 Mar 4 19:45:15 raspberrypi sshd[30442]: Failed password for invalid user root from 122.171.39.147 port 50866 ssh2 949 Mar 4 19:45:16 raspberrypi sshd[30438]: Failed password for invalid user root from 122.171.39.147 port 50859 ssh2 950 Mar 4 19:45:16 raspberrypi sshd[30444]: Failed password for invalid user root from 122.171.39.147 port 50876 ssh2 951 Mar 4 19:45:18 raspberrypi sshd[30442]: Failed password for invalid user root from 122.171.39.147 port 50866 ssh2 952 Mar 4 19:45:18 raspberrypi sshd[30455]: User root from 122.171.39.147 not allowed because listed in DenyUsers 953 Mar 4 19:45:18 raspberrypi sshd[30455]: input_userauth_request: invalid user root [preauth] 954 Mar 4 19:45:18 raspberrypi sshd[30455]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 955 Mar 4 19:45:18 raspberrypi sshd[30438]: Failed password for invalid user root from 122.171.39.147 port 50859 ssh2 956 Mar 4 19:45:18 raspberrypi sshd[30444]: Failed password for invalid user root from 122.171.39.147 port 50876 ssh2 957 Mar 4 19:45:20 raspberrypi sshd[30455]: Failed password for invalid user root from 122.171.39.147 port 50906 ssh2 958 Mar 4 19:45:20 raspberrypi sshd[30442]: Failed password for invalid user root from 122.171.39.147 port 50866 ssh2 959 Mar 4 19:45:20 raspberrypi sshd[30438]: Failed password for invalid user root from 122.171.39.147 port 50859 ssh2 960 Mar 4 19:45:20 raspberrypi sshd[30444]: Failed password for invalid user root from 122.171.39.147 port 50876 ssh2 961 Mar 4 19:45:23 raspberrypi sshd[30455]: Failed password for invalid user root from 122.171.39.147 port 50906 ssh2 962 Mar 4 19:45:23 raspberrypi sshd[30442]: Failed password for invalid user root from 122.171.39.147 port 50866 ssh2 963 Mar 4 19:45:23 raspberrypi sshd[30438]: Failed password for invalid user root from 122.171.39.147 port 50859 ssh2 964 Mar 4 19:45:24 raspberrypi sshd[30444]: Failed password for invalid user root from 122.171.39.147 port 50876 ssh2 965 Mar 4 19:45:25 raspberrypi sshd[30455]: Failed password for invalid user root from 122.171.39.147 port 50906 ssh2 966 Mar 4 19:45:26 raspberrypi sshd[30438]: Failed password for invalid user root from 122.171.39.147 port 50859 ssh2 967 Mar 4 19:45:26 raspberrypi sshd[30438]: Disconnecting: Too many authentication failures for invalid user root from 122.171.39.147 port 50859 ssh2 [preauth] 968 Mar 4 19:45:26 raspberrypi sshd[30444]: Failed password for invalid user root from 122.171.39.147 port 50876 ssh2 969 Mar 4 19:45:26 raspberrypi sshd[30438]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 970 Mar 4 19:45:26 raspberrypi sshd[30438]: PAM service(sshd) ignoring max retries; 6 > 3 971 Mar 4 19:45:26 raspberrypi sshd[30442]: Failed password for invalid user root from 122.171.39.147 port 50866 ssh2 972 Mar 4 19:45:28 raspberrypi sshd[30455]: Failed password for invalid user root from 122.171.39.147 port 50906 ssh2 973 Mar 4 19:45:28 raspberrypi sshd[30444]: Failed password for invalid user root from 122.171.39.147 port 50876 ssh2 974 Mar 4 19:45:28 raspberrypi sshd[30444]: Disconnecting: Too many authentication failures for invalid user root from 122.171.39.147 port 50876 ssh2 [preauth] 975 Mar 4 19:45:28 raspberrypi sshd[30444]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 976 Mar 4 19:45:28 raspberrypi sshd[30444]: PAM service(sshd) ignoring max retries; 6 > 3 977 Mar 4 19:45:28 raspberrypi sshd[30442]: Failed password for invalid user root from 122.171.39.147 port 50866 ssh2 978 Mar 4 19:45:28 raspberrypi sshd[30442]: Disconnecting: Too many authentication failures for invalid user root from 122.171.39.147 port 50866 ssh2 [preauth] 979 Mar 4 19:45:28 raspberrypi sshd[30442]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 980 Mar 4 19:45:28 raspberrypi sshd[30442]: PAM service(sshd) ignoring max retries; 6 > 3 981 Mar 4 19:45:30 raspberrypi sshd[30455]: Failed password for invalid user root from 122.171.39.147 port 50906 ssh2 982 Mar 4 19:45:32 raspberrypi sshd[30455]: Failed password for invalid user root from 122.171.39.147 port 50906 ssh2 983 Mar 4 19:45:32 raspberrypi sshd[30455]: Disconnecting: Too many authentication failures for invalid user root from 122.171.39.147 port 50906 ssh2 [preauth] 984 Mar 4 19:45:32 raspberrypi sshd[30455]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 985 Mar 4 19:45:32 raspberrypi sshd[30455]: PAM service(sshd) ignoring max retries; 6 > 3 986 Mar 4 19:45:42 raspberrypi sshd[30484]: User root from 122.171.39.147 not allowed because listed in DenyUsers 987 Mar 4 19:45:42 raspberrypi sshd[30484]: input_userauth_request: invalid user root [preauth] 988 Mar 4 19:45:42 raspberrypi sshd[30484]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 989 Mar 4 19:45:44 raspberrypi sshd[30484]: Failed password for invalid user root from 122.171.39.147 port 51032 ssh2 990 Mar 4 19:45:47 raspberrypi sshd[30484]: Failed password for invalid user root from 122.171.39.147 port 51032 ssh2 991 Mar 4 19:45:50 raspberrypi sshd[30484]: Failed password for invalid user root from 122.171.39.147 port 51032 ssh2 992 Mar 4 19:45:52 raspberrypi sshd[30484]: Failed password for invalid user root from 122.171.39.147 port 51032 ssh2 993 Mar 4 19:45:55 raspberrypi sshd[30484]: Failed password for invalid user root from 122.171.39.147 port 51032 ssh2 994 Mar 4 19:45:58 raspberrypi sshd[30484]: Failed password for invalid user root from 122.171.39.147 port 51032 ssh2 995 Mar 4 19:45:58 raspberrypi sshd[30484]: Disconnecting: Too many authentication failures for invalid user root from 122.171.39.147 port 51032 ssh2 [preauth] 996 Mar 4 19:45:58 raspberrypi sshd[30484]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=122.171.39.147 user=root 997 Mar 4 19:45:58 raspberrypi sshd[30484]: PAM service(sshd) ignoring max retries; 6 > 3
|
+
| fail2ban with 404 (2) | 2019.03.20 |
|---|---|
| fail2ban error 100 (0) | 2017.03.06 |
| fail2ban phpmyadmin (0) | 2017.02.28 |
| fail2ban 재시작을 위한 차단목록 추가? (0) | 2017.02.15 |
| fail2ban 차단 관련... (0) | 2017.02.09 |
라즈베리 파이에서 써볼려고
lossless video로 검색하다 보니. ffmpeg의 비디오 옵션으로 나오길래 검색
[링크 : https://github.com/raspberrypi/userland/issues/28]
[링크 : http://superuser.com/questions/486325/lossless-universal-video-format]
| ffmpeg concat (0) | 2018.11.05 |
|---|---|
| ffmpeg concat (0) | 2018.10.10 |
| ffmpeg으로 컨테이너 변경하기 (0) | 2016.12.01 |
| ffmpeg 으로 파일 재생하기 (0) | 2015.02.10 |
| Mplayer/ffmpeg 크로스 컴파일 하기 (0) | 2015.01.27 |
sketchup에서 바로 3d 출력용 포맷이 나오는게 아니라
STL Exporter를 다운로드 받아서 설치해야 되는 듯..
[링크 : https://i.materialise.com/blog/3d-printing-with-sketchup/]
| 스케치업 도면 작업(출력?) (0) | 2016.11.18 |
|---|---|
| sketchup flip 하기 (0) | 2016.08.31 |
| sketchup 여러번 복사하기 (0) | 2016.08.31 |
| 스케치업 자격증 (0) | 2014.02.28 |
| 스케치업 / export to DWG (0) | 2014.02.04 |
[링크 : http://serverfault.com/questions/435016/custom-fail2ban-filter-for-phpmyadmin-bruteforce-attempts]
wordpress
[링크 : http://envyandroid.com/fail2ban-wordpress-login-attacks/]
| fail2ban error 100 (0) | 2017.03.06 |
|---|---|
| fail2ban ssh 차단 실패??? (0) | 2017.03.06 |
| fail2ban 재시작을 위한 차단목록 추가? (0) | 2017.02.15 |
| fail2ban 차단 관련... (0) | 2017.02.09 |
| ssh 로그인 보안 - fail2ban (4) | 2017.02.08 |
생각을 해보니..
차단될때 마다 blacklist 파일에 추가해주면
다음번 재시작 시에 blacklist를 보고 자동으로 DROP 하도록 되어 있으니
REJECT 하는 자동 차단이랑 섞어서 쓰면 쓸만할지도?!
$ cat /etc/fail2ban/action.d/iptables-multiport24.conf actionban = iptables -I fail2ban-<name> 1 -s <ip>/24 -j <blocktype> echo <ip> >> /etc/fail2ban/ip.blacklist |
| fail2ban ssh 차단 실패??? (0) | 2017.03.06 |
|---|---|
| fail2ban phpmyadmin (0) | 2017.02.28 |
| fail2ban 차단 관련... (0) | 2017.02.09 |
| ssh 로그인 보안 - fail2ban (4) | 2017.02.08 |
| apache ip deny (0) | 2017.02.08 |
음.. 웹쪽이야 svn으로 하면되는데
db의 구조가 변경되는건 어떻게 이력으로 남길수 있지?
라는 생각이 들어 검색을 해보니
결론은.. db 스키마 덤프해서 버전관리해라 정도의 느낌?
[링크 : https://blog.codinghorror.com/get-your-database-under-version-control/]
[링크 : https://blog.codinghorror.com/is-your-database-under-version-control/] <<
[링크 : http://stackoverflow.com/questions/115369/do-you-use-source-control-for-your-database-items]
[링크 : http://stackoverflow.com/questions/175451/how-do-you-version-your-database-schema]
[링크 : http://stackoverflow.com/questions/173/versioning-sql-server-database]
| mysql view (0) | 2017.03.14 |
|---|---|
| db designer (0) | 2017.03.14 |
| mysql 통화관련 변수타입 (0) | 2017.02.07 |
| mysql 다국어 문자길이 (0) | 2017.02.06 |
| mysql select case insensitive (0) | 2017.02.06 |
:ls 버퍼 목록
:bn buffer next
:bp buffer previous
:b0 0번째로 이동
:bf buffer first 처음
:bl buffer last 마지막
:[N]bn[ext][!] [+cmd] [N] *:bn* *:bnext* *E87* Go to [N]th next buffer in buffer list. [N] defaults to one. Wraps around the end of the buffer list. See |:buffer-!| for [!]. Also see ||+cmd|. If you are in a help buffer, this takes you to the next help buffer (if there is one). Similarly, if you are in a normal (non-help) buffer, this takes you to the next normal buffer. This is so that if you have invoked help, it doesn't get in the way when you're browsing code/text buffers. The next three commands also work like this. |
bN이 대문자임
:[N]bN[ext][!] [+cmd] [N] *:bN* *:bNext* *:bp* *:bprevious* *E88* :[N]bp[revious][!] [+cmd] [N] Go to [N]th previous buffer in buffer list. [N] defaults to one. Wraps around the start of the buffer list. See |:buffer-!| for [!] and 'switchbuf'. Also see ||+cmd|. |
:br[ewind][!] [+cmd] *:br* *:brewind* Go to first buffer in buffer list. If the buffer list is empty, go to the first unlisted buffer. See |:buffer-!| for [!]. :bf[irst] [+cmd] *:bf* *:bfirst* Same as |:brewind|. Also see |+cmd|. |
:bl[ast][!] [+cmd] *:bl* *:blast* Go to last buffer in buffer list. If the buffer list is empty, go to the last unlisted buffer. See |:buffer-!| for [!]. |
:[N]bd[elete][!] *:bd* *:bdel* *:bdelete* *E516* :bd[elete][!] [N] Unload buffer [N] (default: current buffer) and delete it from the buffer list. If the buffer was changed, this fails, unless when [!] is specified, in which case changes are lost. The file remains unaffected. Any windows for this buffer are closed. If buffer [N] is the current buffer, another buffer will be displayed instead. This is the most recent entry in the jump list that points into a loaded buffer. Actually, the buffer isn't completely deleted, it is removed from the buffer list |unlisted-buffer| and option values, variables and mappings/abbreviations for the buffer are cleared. |
:[N]bw[ipeout][!] *:bw* *:bwipe* *:bwipeout* *E517* :bw[ipeout][!] {bufname} :N,Mbw[ipeout][!] :bw[ipeout][!] N1 N2 ... Like |:bdelete|, but really delete the buffer. Everything related to the buffer is lost. All marks in this buffer become invalid, option settings are lost, etc. Don't use this unless you know what you are doing. |
[링크 : http://gyuha.tistory.com/157]
+
ctrl-n,n은 새 버퍼로 수평 창을 여는데
ctrl-n,v는 이전 창의 버퍼를 연결해서 수직 창으로 연다
CTRL-W CTRL-V *CTRL-W_CTRL-V* CTRL-W v *CTRL-W_v* :[N]vs[plit] [++opt] [+cmd] [file] *:vs* *:vsplit* Like |:split|, but split vertically. The windows will be spread out horizontally if 1. a width was not specified, 2. 'equalalways' is set, 3. 'eadirection' isn't "ver", and 4. one of the other windows is wider than the current or new window. Note: In other places CTRL-Q does the same as CTRL-V, but here it doesn't! CTRL-W n *CTRL-W_n* CTRL-W CTRL_N *CTRL-W_CTRL-N* :[N]new [++opt] [+cmd] *:new* Create a new window and start editing an empty file in it. Make new window N high (default is to use half the existing height). Reduces the current window height to create room (and others, if the 'equalalways' option is set and 'eadirection' isn't "hor"). Also see |++opt| and |+cmd|. If 'fileformats' is not empty, the first format given will be used for the new buffer. If 'fileformats' is empty, the 'fileformat' of the current buffer is used. This can be overridden with the |++opt| argument. Autocommands are executed in this order: 1. WinLeave for the current window 2. WinEnter for the new window 3. BufLeave for the current buffer 4. BufEnter for the new buffer This behaves like a ":split" first, and then an ":enew" command. :[N]vne[w] [++opt] [+cmd] [file] *:vne* *:vnew* Like |:new|, but split vertically. If 'equalalways' is set and 'eadirection' isn't "ver" the windows will be spread out horizontally, unless a width was specified. :[N]new [++opt] [+cmd] {file} :[N]sp[lit] [++opt] [+cmd] {file} *:split_f* Create a new window and start editing file {file} in it. This behaves like a ":split" first, and then an ":e" command. If [+cmd] is given, execute the command when the file has been loaded |+cmd|. Also see |++opt|. Make new window N high (default is to use half the existing height). Reduces the current window height to create room (and others, if the 'equalalways' option is set). |
[링크 : http://stackoverflow.com/.../vim-how-do-you-open-another-no-name-buffer-like-the-one-on-startup]
| vi 여러개 파일 편집하기(동시 x) (0) | 2017.09.16 |
|---|---|
| vi 반복 입력 (0) | 2017.09.16 |
| vi buffer window tab 차이점? (0) | 2017.02.11 |
| vi 창 분할해서 보기 (0) | 2017.02.10 |
| vi 현재 위치에서 끝까지 복사 (0) | 2017.02.01 |
|
