๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ

ยทDBMS
๋คํ”„ํ•  ์ผ์ด ์žˆ์–ด์„œ ๊ธฐ์กด ๋ฐฉ์‹๋Œ€๋กœ ํ•˜๋ ค๋‹ˆ๊น ์•ˆ๋˜์–ด์„œ ์ ๋Š” ๋ธ”๋กœ๊ทธ elasticdump --input=http:/{target ip}:9200/{target_index_name} --output=https://elastic:{elastic๊ณ„์ • ๋น„๋ฒˆ}@localhost:9200/{index name} --type=mapping --tlsAuth --output-ca={http_ca.crt ์ ˆ๋Œ€๊ฒฝ๋กœ} elastic ๊ณ„์ •์˜ ๋น„๋ฒˆ์€ elasticsearch 8๋ฒ„์ „ ์ฒซ ๊ตฌ๋™์‹œ ์•Œ๋ ค์ค€๋‹ค ์ด๊ฑธ ์–ด๋”˜๊ฐ€ ์•ˆ์ „ํ•œ ๊ณณ์— ์ ์–ด๋‘๋Š” ๊ฒƒ์„ ์ถ”์ฒœํ•œ๋‹ค. ๋ฌผ๋ก  ์žฌ๋ฐœ๊ธ‰๋„ ๊ฐ€๋Šฅํ•˜์ง€๋งŒ ๊ทธ๊ฑด ๊ท€์ฐฎ๊ธฐ ๋•Œ๋ฌธ์— ์ž˜ ์ ์–ด๋‘์ž
์ •๋ง ๋นก์น˜๊ณ ๋„ ๊ธฐ๋‚˜๊ธด ์—ฌ์ •์„ ์ง€๋‚ฌ๋‹ค. 1์›” 31์ผ๋ถ€ํ„ฐ 2์›” 6์ผ๊ฐ„์˜ ๊ณต๋™๊ฒฉ๋ฆฌ์ž๋กœ์„œ ๋™๊ฑฐ์ธ์ธ ์˜ˆ๋ž‘์ด๊ฐ€ ํ™•์ง„๋˜์–ด ์˜จ๊ฐ– ์ˆ˜๋ชจ๋ฅผ ๊ฒช์—ˆ๋‹ค.. ๋‚ด ๋ธ”๋กœ๊ทธ์— ์ฐพ์•„์˜ค๋Š” ์‚ฌ๋žŒ๋“ค์€ ๋ถ€๋”” ์ด๋Ÿฐ ์ผ์„ ์กฐ๊ธˆ์ด๋‚˜๋งˆ ๋œ ๊ฒช๊ธธ ๋ฐ”๋ผ๋ฉฐ ์ •๋ฆฌ๋ฅผ ํ•ด๋ณด๊ณ ์ž ํ•œ๋‹ค. 1. ์ƒํ™œ์ง€์›๊ธˆ ์ •๋ถ€์—์„œ ์ง€์›ํ•ด์ฃผ๋Š” ์ƒํ™œ ์ง€์›๊ธˆ์— ๊ด€ํ•œ ์ด์•ผ๊ธฐ์ด๋‹ค. ์šฐ๋ฆฌ๋Š” 2์ธ๊ฐ€๊ตฌ์—, 3์ฐจ ๋ฐฑ์‹  ์™„๋ฃŒํ–ˆ๊ธฐ ๋•Œ๋ฌธ์— ์ € ๊ธˆ์•ก์—์„œ ์ผํ•  ๊ณ„์‚ฐํ•ด์„œ ์ง€๊ธ‰ ๋ฐ›๋Š”๋‹ค ๋Œ€๋žต 70์ •๋„ ์ผ๋“ฏ. ๊ฒฉ๋ฆฌ ์ผํ•  ๊ณ„์‚ฐ์ด๊ธฐ ๋•Œ๋ฌธ์— ์—ฐํœด๋Š” ์•ˆ์น˜๊ณ  ์ด๋Ÿฐ๊ฑฐ ์—†๋‹ค. ๋ฌด๊ธ‰ํœด๊ฐ€ + ์ƒํ™œ์ง€์›๊ธˆ ๋ฐ›๋“ ๊ฐ€ ์œ ๊ธ‰ํœด๊ฐ€ ์ง€์› ๋ฐ›๋“ ๊ฐ€ ํ•œ๋Š”๋ฐ, ์šฐ๋ฆฌ๋Š” ์ „์ž๊ฐ€ ๋” ๋ˆ์„ ๋งŽ์ด ๋ฐ›๊ธฐ ๋•Œ๋ฌธ์— ๋ฌด๊ธ‰ํœด๊ฐ€๋กœ ์ง„ํ–‰ํ–ˆ๋‹ค. ๋ณธ์ธ์˜ ์ƒํ™ฉ์— ๋งž๊ฒŒ ์ง„ํ–‰์‹œํ‚ค๊ธธ. ๊ฒฉ๋ฆฌ ํ•ด์ œ๋˜๊ณ  ์‹ ์ฒญํ•˜๋Š” ๊ฑฐ๊ณ , ๋™ ์ฃผ๋ฏผ์„ผํ„ฐ์—์„œ ์‹ ์ฒญํ•˜๋ฉด ๋œ๋‹ค. ํ™•์ง„์ž ๋ช…์˜๋กœ ๋œ ํ†ต์žฅ์œผ๋กœ ๋ฐ›๋Š” ํŽธ..
windows ์—์„œ๋Š” ๊ทธ๋ƒฅ ์›๊ฒฉ ๋ฐ์Šคํฌ ํ†ฑ ํ™œ์„ฑํ™” ํ† ๊ธ€์„ ์‰ฝ๊ฒŒ on ํ•ด์ฃผ๋ฉด ๋˜์ง€๋งŒ ์šฐ๋ถ„ใ…Œํˆฌ์˜ ์‚ฌ์ •์€ ๊ทธ๋ ‡์ง€๊ฐ€ ์•Š๋‹ค. ์‹ ์ž… ๊ฐœ๋ฐœ์ž์ธ๋ฐ ํŒ€์žฅ๋‹˜ํ•œํ…Œ ๋” ๋ˆ„๊ฐ€ ๋˜๊ณ ์‹ถ์ง€ ์•Š๊ณ , ์š”์ฆ˜ ์ฝ”๋กœ๋‚˜ ํ™•์ง„์ž ์ˆ˜๊ฐ€ ๋ฌด์„ญ๊ฒŒ ์˜ค๋ฅด๋Š” ์ถ”์„ธ์ด๋‹ˆ (์ผ์ผ ํ™•์ง„์ž ์•ฝ 3๋งŒ๋ช…) ์žฌํƒ๊ทผ๋ฌด ๊ด€๋ จํ•ด์„œ linux ์›๊ฒฉ๋ฐ์Šคํฌํ†ฑ์€ ์–ด๋–ป๊ฒŒ ํ™œ์„ฑํ™” ์‹œํ‚ค๋Š”์ง€ ํ—ค๋งฌ ์‚ฌ๋žŒ๋“ค์„ ์œ„ํ•ด& ๋‚˜์ค‘์— ๋‚˜๋ฅผ ์œ„ํ•ด ํฌ์ŠคํŒ…์„ ํ•˜๊ณ ์ž ํ•œ๋‹ค. xrdp ๋Š” Microsoft์˜ ์›๊ฒฉ ๋ฐ์Šคํฌํ†ฑ ํ”„๋กœํ† ์ฝœ (RDP)์— ํ•ด๋‹นํ•˜๋Š” ์˜คํ”ˆ ์†Œ์Šค์ด๋‹ค. ๊ทธ๋‹ˆ๊น ์ € ํ† ๊ธ€์— ํ•ด๋‹นํ•˜๋Š” ๊ฑฐ๋ฅผ ํ”„๋กœํ† ์ฝœ์„ ์„ค์น˜ํ•ด์„œ ํ™œ์„ฑํ™”๋ฅผ ํ•ด์ค˜์•ผํ•œ๋‹ค๋Š” ๋œป์ด๋‹ค. 1. xrdp ์„ค์น˜ $ sudo apt -y install xrdp 2. ํ™œ์„ฑํ™” ํ™•์ธ $ sudo systemctl status xrdp 3. xrdp ๊ตฌ์„ฑ Xrdp..
file -bi ์œผ๋กœ ํŒŒ์ผ ํ˜•์‹ ํ™•์ธ iso-8859-1 ์ด๊ฑด euc-kr ์ด๋‹ค iconv -c -f euc-kr -t utf-8 'ํƒ€๊ฒŸ ํŒŒ์ผ' > '๊ฒฐ๊ณผ ํŒŒ์ผ' ์ด๋Ÿฌ๋ฉด ํ•ด๊ฒฐ
ยทDBMS
https://www.elastic.co/guide/en/elastic-stack-get-started/current/get-started-docker.html Running the Elastic Stack on Docker | Getting Started [7.16] | Elastic At this point, Kibana cannot connect to the Elasticsearch cluster. You must generate a password for the built-in kibana_system user, update the ELASTICSEARCH_PASSWORD in the compose file, and restart to enable Kibana to communicate with ..
ยทDBMS
filebeat 64bit deb ํŒŒ์ผ๋กœ ๋‹ค์šด. dpkg -i ๋กœ ์••์ถ• ํ’€๊ธฐ /etc/filebeat ์•„๋ž˜์— filebeat.yaml ํŒŒ์ผ ์ˆ˜์ • output์— elasticsearch๋กœ ๋˜์–ด์žˆ๋Š” ๋ถ€๋ถ„์„ logstash๋กœ ๋ฐ”๊ฟ” ์ค€๋‹ค host ์—ด์–ด์ฃผ๊ธฐ sudo service filebeat start filebeat๋Š” ์„œ๋น„์Šค๋กœ ์‹คํ–‰๋œ๋‹ค. logstash ๋Š” ๊ฑ tar๋กœ ๋‹ค์šด ๋ฐ›์•„์„œ ์••์ถ•ํ’€๊ณ , config ๋””๋ ‰ํ† ๋ฆฌ ์•ˆ์˜ pipelines.yaml ํŒŒ์ผ ์ˆ˜์ • path.config ํ™œ์„ฑํ™”, ํ•ด๋‹น ํ™•์žฅ์ž *.conf๋กœ ๋ฐ”๊พธ๊ณ  (๋ฒ„์ „๊ด€๋ฆฌ ๊ฐ€๋Šฅ) path.config์˜ ๋””๋ ‰ํ† ๋ฆฌ ์—†์œผ๋ฉด ์ƒ์„ฑ, conf ํŒŒ์ผ ๋„ฃ๋Š”๋‹ค config ๋ฐ‘์˜ logstash-sample.conf๋ฅผ cpํ•˜๋Š” ๊ฒƒ์„ ์ถ”์ฒœ ํ•˜๋ฉด elasticsearch..
์š”์ฆ˜ ๋“ฃ๋Š” ์ˆ˜์—…์—์„œ ๊ณผ์ œํ•˜๋‹ค๊ฐ€ ์žฌ๋ฐŒ์–ด์„œ ํ•œ๋ฒˆ ๋‚จ๊ฒจ๋ณธ๋‹ค inputs = "cat32dog16cow5" def find_string(inputs): result = [] word = "" for index,target in enumerate(inputs): if target.isdigit(): if word != "": result.append(word) word = "" else: word += inputs[index] return result string_list = find_string(inputs) print(string_list) word ์—๋‹ค๊ฐ€ ์ž ๊น string ์ €์žฅํ•ด๋‘๊ณ  number์ผ๋•Œ append ํ•˜๊ณ  word ์ดˆ๊ธฐํ™”, ๊ทธ๋ฆฌ๊ณ  word๊ฐ€ ๋นˆ ๋ฌธ์ž์—ด์ด ์•„๋‹ ๋•Œ๋งŒ appendํ•˜๋Š” ์กฐ๊ฑด ์ถ”๊ฐ€ ๊ฐ„๋‹จํ•œ..
ยทDBMS
1. ์šฐ์„  ์ €๋Š” ์šฐ๋ถ„ํˆฌ 20.04๋กœ ์‹น ๋ฐ€์–ด๋ฒ„๋ฆฌ๊ณ , elk๋„ 7.16.3์œผ๋กœ ๊ฐˆ์•„ํƒ€๊ณ  ์™”์Œ์„ ์•Œ๋ ค๋“œ๋ฆฝ๋‹ˆ๋‹ค ..ใ…Ž.. 2. stack management - index patterns ๋กœ ๊ฐ€์„œ ์—…๋กœ๋“œ ํ•ด๋†จ๋˜ ๋ฐ์ดํ„ฐ๋ฅผ ์ธ๋ฑ์Šค ํŒจํ„ด ์ •์˜๋ฅผ ํ•ด์ค์‹œ๋‹ค. timestamp field์— ์„œ๋ฒ„๊ธฐ์ค€ ์‹œ๊ฐ„์œผ๋กœ ์„ค์ •ํ•˜๊ณ  logstash ํŒจํ„ด ์ •์˜๋ฅผ ํ•ด์ค„๊ฒŒ์šฉ 2. ํ™•์ธํ•˜๊ธฐ ์š”๋ก ๊ฒŒ ์ƒ๊ธด๊ฒŒ ๋ณด์ด์‹œ์ฃต? ๋งˆ์ฐฌ๊ฐ€์ง€๋กœ shakes* ๋„ ์ •์˜ํ•ด์ค๋‹ˆ๋‹ค. shakes๋Š” ๋”ฐ๋กœ timestamp ์ •์˜ ์•ˆํ• ๊ฒŒ์š” ํŒจํ„ด ์ƒ์„ฑ ์™„์„ฑ!!
ยทDBMS
https://www.elastic.co/guide/en/kibana/7.1/tutorial-load-dataset.html Loading sample data | Kibana Guide [7.1] | Elastic If security is enabled, you must have the all Kibana privilege to run this tutorial. You must also have the create, manage read, write, and delete index privileges. See Security privileges for more information. www.elastic.co ๋ฒ„์ „์— ๋งž์ถฐ์„œ sample log data๋ฅผ elasticsearch์— ๋ฐ€์–ด ๋„ฃ์–ด์ค€๋‹ค ์ฐธ๊ณ  ..
ยทDBMS
1 ๋ฒˆ POST /tourcompany/_delete_by_query { "query":{ "match": { "holiday_dest": "Bora Bora" } } } POST /tourcompany/_update_by_query { "query": { "match": { "holiday_dest": "Hawaii" } }, "script": { "source": "if(ctx._source.departure_date == '2017/01/10'){ctx._source.departure_date = '2017/01/17'}" } } GET /tourcompany/_search?pretty { "query": { "match": { "holiday_dest": "Disneyland" } }, "_sou..
ํ‚จ์ง€ (Kinzie)
'๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๊ธ€ ๋ชฉ๋ก (8 Page)