전산사기단

ubuntu 설치 https://www.elastic.co/guide/en/elasticsearch/reference/current/deb.html1. pgp 키 가져오기 (Pretty Good Privacy)wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | sudo gpg --dearmor -o /usr/share/keyrings/elasticsearch-keyring.gpg2. 저장소 정보 업데이트.sudo apt-get install apt-transport-httpsecho "deb [signed-by=/usr/share/keyrings/elasticsearch-keyring.gpg] https://artifacts.elastic.c..

엘라스틱 스택.https://www.elastic.co/elastic-stackELv2 및 SSPL 라이선스 계약.엘라스틱 스택의 핵심컴포넌트 : 엘라스틱서치, 키바나, 로그스태시, 비츠It's comprised of Elasticsearch, Kibana, Beats, and Logstash (also known as the ELK Stack) and more. Reliably and securely take data from any source, in any format, then search, analyze, and visualize.  1) 엘라스틱 서치.- 전문 검색 엔진이자 다목적 데이터 저장소. JAVA 기반이고, 아파치 루씬을 기반으로 만들어짐.https://www.elastic.co/gu..

goaccessbrew install goaccess  LC_TIME="en_US.UTF-8" bash -c 'goaccess access.log --log-format=COMBINED' 211.235.?.? - - [17/Aug/2024:00:00:05 +0900] "POST /api/account/login HTTP/1.1" 200 3922 "-" "okhttp/5.0.0-alpha.2"59.150.?.? - - [17/Aug/2024:00:00:05 +0900] "POST /api/account/login HTTP/1.1" 200 530 "-" "okhttp/5.0.0-alpha.2"61.252.?.? - - [17/Aug/2024:00:00:05 +0900] "POST /api/account/lo..

OPNSensePFsenseUntagle https://www.youtube.com/watch?v=STrP0o4iZU4 https://github.com/nbs-system/naxsi

sudo apt install mysql-serversudo ufw allow mysqlsudo systemctl enable mysqlsudo systemctl start mysqlsudo mysql -u rootCREATE DATABASE DB명 default CHARACTER SET UTF8;CREATE USER '유저명'@'localhost' IDENTIFIED BY '패스워드';GRANT ALL PRIVILEGES ON *.* TO '유저명’@‘%’ WITH GRANT OPTION;FLUSH PRIVILEGES;  [HY000][1418] This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration an..

cent 7을 선택 후 설치.해당 리눅스에 접속 후 http, mysql 서버 설치.  에러 1.[root@localhost ~]# sudo yum install -y httpd24 php72 mysql57-server php72-mysqlndhttp://mirrors.linode.com/centos/7/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not FoundTrying other mirror.To address this issue please refer to the below wiki article  에러 2.sudo yum install -y httpd24 php72 mysql57-server php72-mysqlndNo package..

계정 생성시 $500 크래딧을 받아서 사용해 보기로 함. 1. VPC 생성. 오사카에 생성. (region이 많지 않음)  2. firewall 만들고 정책 추가.  3. ssh-keygen 명령어로 공개키 생성. 4. 서버 선택타 업체처럼 region에 한국과 free tier가 안보여서 vpc와 같은 osaka에, 제일 싼 plan 선택. ...  외부에서 접속을 해야 하므로 Assign a public IPv4 address for this Linode 를 체크했다. (체크안하면 안주나?)  Launch LISH Console 선택시 아래와 console. 접속 환경을 제공하지만, public 으로  외부 접속을 위해 add an ip address 를 선택해서 IP를 추가함.  추가한 다음 ssh..

aws ubuntu 20.04 버전이 필요한데 quick start엔 없다.마켓에서 사긴전에 생각해보니 우리가 18버전이 있었음.18버전을 ami 로 만들고, 가져다가 업그레이드를 실행하려고 함.New release '20.04.6 LTS' available.Run 'do-release-upgrade' to upgrade to it. do-release-upgrade 를 치니깐 아래 메시지가 나옴 ubuntu@ip-172-31-9-206:~$ do-release-upgradeChecking for a new Ubuntu releasePlease install all available updates for your release before upgrading. 뭐지 검색....sudo apt updates..

관련자료https://docs.aws.amazon.com/ko_kr/prescriptive-guidance/latest/patterns/migrate-an-on-premises-postgresql-database-to-aurora-postgresql.html 목적 : 온프레미스 PostgreSQL 데이터베이스 -> Aurora PostgreSQL-Compatibleselect version();PostgreSQL 12.15 (Ubuntu 12.15-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bitshow server_version;12.15 (Ubuntu 12.15-1.pgd..

사용하는 aurora DB가 window function 안되는 버전이어서 아래 쿼리를 참조해서 만듬 https://docs.aws.amazon.com/dms/latest/sql-server-to-aurora-mysql-migration-playbook/chap-sql-server-aurora-mysql.sql.windowfunctions.html