2023/02 7

์„œ๋ฒ„์˜ ๊ณต์ธ IP ํ™•์ธํ•˜๊ธฐ

์ผ๋ฐ˜์ ์ธ ๋ฆฌ๋ˆ…์Šค ์„œ๋ฒ„๋Š” ์ด๋”๋„ท๋ณ„๋กœ IP๋ฅผ ํ• ๋‹นํ•˜์—ฌ ifconfig ๋ช…๋ น์–ด๋กœ ํ• ๋‹น๋œ IP ๋ฅผ ํ™•์ธํ•  ์ˆ˜ ์žˆ์œผ๋‚˜ AWS (Amazon Web Service)๋“ฑ์˜ ํด๋ผ์šฐ๋“œ ์žฅ๋น„์—์„œ๋Š” Private IP ๋งŒ ํ™•์ธ์ด ๊ฐ€๋Šฅํ•˜๊ณ  Public IP ๋Š” Amazon Console ๋“ฑ์„ ํ†ตํ•ด์„œ ํ™•์ธ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. ๋˜๋Š” NAT ์•„๋ž˜์— ์œ„์น˜ํ•œ ์„œ๋ฒ„๋“ค์˜ ๊ฒฝ์šฐ๋„ ์‹ค์ œ ํ• ๋‹น๋œ IP๋Š” ์‚ฌ์„ค IP๋งŒ ํ‘œ์‹œ๋˜๊ณ , ์™ธ๋ถ€ ์ ‘์†์‹œ ์™ธ๋ถ€ ์„œ๋ฒ„์—์„œ ์ธ์‹ํ•˜๋Š” IP ๋Š” NAT ์˜ IP ๊ฐ€ ๋œ๋‹ค. ์ด๋Ÿฐ ๊ฒฝ์šฐ ์„œ๋ฒ„์—์„œ ๊ฐ„๋‹จํ•˜๊ฒŒ ์™ธ๋ถ€๋กœ ์ ‘์†ํ•˜๋Š” ๋ณธ์ธ IP๋ฅผ ํ™•์ธํ•˜๋Š” ๋ฐฉ๋ฒ•์€ ์•„๋ž˜์™€ ๊ฐ™๋‹ค. 1. ํ˜„์žฌ ์‚ฌ์šฉ์ค‘์ธ ์„œ๋ฒ„์˜ ๊ณต์ธIP ์กฐํšŒ (Outbound) $ curl ip.ojj.kr Your IP is 175.123.191.3 2. ํŠน์ • IP์˜ ์ •๋ณด ์กฐํšŒ $ cu..

IT Talks/Linux 2023.02.22

S23U ๋กœ ์ฐ์€ ๊ณ ์–‘์ด - ํ˜ธ๋‘

์šฐ๋ฆฌ์ง‘ ๊ณ ์–‘์ด๋“ค ์ค‘์— ๊ท€์š”๋ฏธ๋ฅผ ๋‹ด๋‹นํ•˜๋Š” ํ˜ธ๋‘. ์ฑ…์ƒ์œ„์— ์˜ฌ๋ผ๊ฐ€์„œ ๋…ธ๋ ค๋ณด๋Š” ์‚ฌ์ง„์„ ์ฐ์–ด์„œ S23์— ์žˆ๋Š” ์ถ”์ถœํ•˜๊ธฐ(๋ˆ„๋ผ ?) ๊ธฐ๋Šฅ์œผ๋กœ ๋ƒฅ์ด๋งŒ ์˜์˜ฅ~ ์ƒ๊ฐ๋ณด๋‹ค ์ถ”์ถœ์ด ์ž˜๋˜๋Š”๋“ฏ.

Animal 2023.02.21

[๋ฆฌ๋ˆ…์Šค] date ๋ช…๋ น์œผ๋กœ timestamp ๋ณ€ํ™˜ํ•˜๊ธฐ

1. timestamp ๊ฐ’์œผ๋กœ ์›ํ•˜๋Š” ๋‚ ์งœ ํ˜•ํƒœ๋กœ ๋ณ€ํ™˜ํ•˜๊ธฐ $ date -d '1970-01-01 1676360315 sec' 2023. 02. 14. (ํ™”) 07:38:35 KST $ date -d '1970-01-01 1676360315 sec' +'%Y-%m-%d %H:%M:%S' 2023-02-14 07:38:35 * ๊ฒฐ๊ณผ๋Š” ์‹œ์Šคํ…œ Timezone์— ๋งž์ถฐ์„œ ํ‘œ์‹œ๋จ 2. ๋‚ ์งœ ํ˜•์‹์œผ๋กœ timestamp ๊ฐ’ ๊ตฌํ•˜๊ธฐ (1๋ฒˆ๊ณผ ๋ฐ˜๋Œ€) $ date -d '2022-02-14' +%s 1644764400

IT Talks 2023.02.14

ChatGPT ๊ฐ€ ์ถ”์ฒœํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์ปค๋ฆฌ์–ด

Q. Please recommend a career as a software developer. A. A career as a software developer can be a very rewarding and fulfilling choice. Here are some reasons why: 1. High demand: Software development is a rapidly growing field with a high demand for skilled professionals. This means that there are many job opportunities available and the demand for software developers is expected to continue to..

IT Talks/AI 2023.02.13

ChatGPT ์—๊ฒŒ ๊ฐœ๋ฐœํˆด์„ ์ถ”์ฒœํ•ด ๋‹ฌ๋ผ๊ณ  ํ–ˆ๋‹ค.

(์˜๋ฌธ) Q. What is the best IDE for developers ? A. The best IDE (Integrated Development Environment) for a developer largely depends on the individual's specific needs and requirements. Some popular IDEs include: 1. Visual Studio Code: It's a free, open-source code editor developed by Microsoft, that supports multiple programming languages and platforms. 2. PyCharm: A dedicated Python IDE develope..

TALKs 2023.02.13

ํ•˜์ด๋ธŒ (HYBE) SM ์ด์ˆ˜๋งŒ ์ง€๋ถ„ ์ธ์ˆ˜ํ•ด 1๋Œ€ ์ฃผ์ฃผ๋กœ

์ตœ๊ทผ์— SM ๊ด€๋ จ ์ด์Šˆ๋กœ ๋‰ด์Šค๊ฐ€ ๋งŽ์ด ๋‚˜์˜ค๊ณ  ์žˆ์—ˆ๋Š”๋ฐ ์˜ค๋Š˜์€ ๋˜ ํ•˜์ด๋ธŒ๊ฐ€ ์ด์ˆ˜๋งŒ์˜ SM ์ง€๋ถ„์„ ๋ชจ๋‘ ์ธ์ˆ˜ํ•˜๊ณ  ๊ณต๊ฐœ๋งค์ˆ˜๊นŒ์ง€ ํ•ด์„œ ์ถ”๊ฐ€ ์ง€๋ถ„ ํ™•๋ณด์— ๋‚˜์„ ๋‹ค๋Š” ๊ธฐ์‚ฌ๊ฐ€ ๋‚˜์™”๋‹ค. ์ด์ˆ˜๋งŒ์€ ์นด์นด์˜ค๊ฐ€ SM์„ ์ธ์ˆ˜ํ•˜๋Š”๊ฒŒ ์™œ ์‹ซ์—ˆ์„๊นŒ ? ์นด์นด์˜ค ๋Œ€์‹  ํ•˜์ด๋ธŒ๋ฅผ ์„ ํƒํ•œ ์ด์œ ๋Š” ? ์•„๋ฌดํŠผ ํ•˜์ด๋ธŒ๋Š” ์ฐธ ๋Œ€๋‹จํ•œ๊ฒƒ ๊ฐ™๋‹ค. BTS๋กœ ๋ชธ์ง‘ ํ‚ค์›Œ์„œ IT๋ฅผ ๊ฒฐํ•ฉํ•œ ์ƒˆ๋กœ์šด ์„œ๋น„์Šค๋“ค๋„ ๋งŒ๋“ค๊ณ  BTS ์˜์กด๋„๊ฐ€ ์ข€ ๋†’๋‹ค๊ณ  ์ƒ๊ฐํ–ˆ๋”๋‹ˆ ๊ทธ ์‚ฌ์ด์— ๋ฅด์„ธ๋ผํ•Œ, ๋‰ด์ง„์Šค ๋“ฑ๊ณผ ๊ฐ™์€ ๊ดด๋ฌผ ์‹ ์ธ๋“ค๋„ ํ‚ค์›Œ๋‚ด๊ณ  ์žˆ์—ˆ๋˜๊ฑธ ๋ณด๋ฉด...ํ•˜์ด๋ธŒ๊ฐ€ ์ฒœํ•˜ํ†ต์ผํ•˜๋Š” ๋ถ„์œ„๊ธฐ์ธ๋“ฏํ•˜๋‹ค. [๊ด€๋ จ ๊ธฐ์‚ฌ] https://v.daum.net/v/20230210091121568 ํ•˜์ด๋ธŒ SM ์ธ์ˆ˜ “์ด์ˆ˜๋งŒ SM ๊ณ„์•ฝํ•ด์ง€=๋Œ€์Šน์  ๊ฒฐ๋‹จ…์ง€๋ฐฐ๊ตฌ์กฐ ๊ฐœ์„ ํ•  ๊ฒƒ” [๊ณต์‹์ž…์žฅ] [๋™์•„๋‹ท์ปด] ํ•˜์ด๋ธŒ SM ์ธ..

News 2023.02.10

๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ ์—†์ด MySQL ์ ‘์†ํ•˜๊ธฐ

MySQL ๋ฒ„์ „์ด ์ ์  ์˜ฌ๋ผ๊ฐ€๋ฉด์„œ ์–ธ์ œ๋ถ€ํ„ฐ์ธ๊ฐ€ mysql ๋ช…๋ น์–ด๋กœ ์ ‘์†์‹œ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ๊ฐ™์ด ์ž…๋ ฅํ•˜๋ฉด ์•„๋ž˜์™€ ๊ฐ™์ด ์•ˆ์ „ํ•˜์ง€ ์•Š๋‹ค๋Š” ๊ฒฝ๊ณ ๊ฐ€ ๋‚˜์˜จ๋‹ค. $ mysql -hlocalhost -udb_user -pdb_password mysql: [Warning] Using a password on the command line interface can be insecure. ์‰˜ ์Šคํฌ๋ฆฝํŠธ๋กœ DB ์ ‘์†ํ•˜๋Š” ์ž‘์—…์„ ํ•˜๋Š” ๊ฒฝ์šฐ ์œ„์™€ ๊ฐ™์ด ๋ช…๋ น์–ด์— ๋น„๋ฐ€๋ฒˆํ˜ธ๊นŒ์ง€ ๊ฐ™์ด ์ž…๋ ฅํ•˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋งŽ์€๋ฐ ์‹คํ–‰์€ ๋˜์ง€๋งŒ ๊ฒฝ๊ณ ๊ฐ€ ๋‚˜์˜ค๋Š”๊ฒŒ ๋งค์šฐ ๊ฑฐ์Šฌ๋ฆฐ๋‹ค. ์ด๋Ÿฐ ๊ฒฝ์šฐ๋Š” ์•„๋ž˜ 2๊ฐ€์ง€ ๋ฐฉ๋ฒ•์œผ๋กœ ํ•ด๊ฒฐ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. ๋ฐฉ๋ฒ•1) ๊ณ„์ • home path (๋ฆฌ๋ˆ…์Šค ๊ธฐ์ค€ /home/userid ๋“ฑ) ์— .my.cnf ํŒŒ์ผ์„ ์ƒ์„ฑํ•˜๊ณ  ์•„๋ž˜์™€ ๊ฐ™์ด ๋‚ด์šฉ์„ ์ž…๋ ฅํ•œ๋‹ค. ..

IT Talks/Database 2023.02.09
728x90