๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

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

[jpa] mariadb ํ…Œ์ด๋ธ” ์ƒ์„ฑ ์•ˆ๋จ ๋ถ„๋ช… sts ์ƒ ๋กœ๊ทธ์—๋Š” entity ๋‚ด์šฉ์ด create ๋œ๊ฒƒ์œผ๋กœ ๋ณด์˜€๋‹ค. ํ•˜์ง€๋งŒ mariadb hedisql ์ƒ์—๋Š” ํ…Œ์ด๋ธ”์ด ์กด์žฌํ•˜์ง€ ์•Š์•˜๋‹ค. ๊ทธ๋ž˜์„œ sts ๋กœ๊ทธ์˜ ddl ๊ตฌ๋ฌธ์„ heidisql์—์„œ ์ง์ ‘ ์ž…๋ ฅํ•˜์—ฌ ์‹คํ–‰ํ•ด๋ณด์•˜์œผ๋‚˜ ์‹คํŒจ. ์‚ฝ์งˆ ํ›„ ์•Œ๊ฒŒ๋œ ์‚ฌ์‹ค ํ…Œ์ด๋ธ” ์ปฌ๋Ÿผ ์ด๋ฆ„์ค‘ "desc" ๋ผ๋Š” ์ปฌ๋Ÿผ๋ช…์ด ์žˆ์—ˆ๊ณ  ์ด๊ฒƒ์€ mariadb์—์„œ ์‚ฌ์šฉํ•˜๋Š” ์–ด๋–ค ํ‚ค์›Œ๋“œ์˜€๋˜๊ฒƒ ๊ฐ™๋‹ค. desc๋ฅผ description์œผ๋กœ ๋ณ€๊ฒฝํ•˜๋‹ˆ ํ…Œ์ด๋ธ”์ด ์ž˜ ์ƒ์„ฑ๋˜๋„ค... 2021. 8. 28.
[ํ•ด๊ฒฐ ์™„๋ฃŒ] centos7 mariadb Access denied for user Caused by: java.sql.SQLInvalidAuthorizationSpecException: (conn=8512) Access denied for user 'root'@'centos7' (using password: YES) Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding' maven project๋ฅผ ํ†ฐ์บฃ์˜ webapp์— ์˜ฌ๋ฆฌ๊ณ . ์ ‘์†ํ•˜๋ ค ํ•˜๋‹ˆ ์•„๋ฌด๋Ÿฐ ์‘๋‹ต์ด ์—†์—ˆ๋‹ค. ํ†ฐ์บฃ ๋กœ๊ทธ๋ฅผ ํ™•์ธํ•ด๋ณด๋‹ˆ jpa๋ฅผ ์ด์šฉํ•˜๊ธฐ ์œ„ํ•œ mariadb ์ ‘์†์ด ์•ˆ๋˜๋˜๊ฒƒ. ๊ตฌ๊ธ€๋งํ•ด์„œ ๋‚˜์˜จ ํ•ด๊ฒฐ๋ฐฉ๋ฒ•์€ 1. mysql๊ณผ mariadb๊ฐ€ 3306 ํฌํŠธ๋ฅผ ๋™์‹œ์— .. 2021. 7. 20.
centos (๋ฆฌ๋ˆ…์Šค) ์Šคํ”„๋ง ๋ฐฐํฌ์‹œ, ๋กœ๊ทธ ํ™•์ธ ์œ„์น˜ 1. ์„ ์ œ ์กฐ๊ฑด - ํ†ฐ์บฃ์ด ์„ค์น˜๋˜์–ด์žˆ์–ด์•ผํ•œ๋‹ค. - ๊ทธ ๋””๋ ‰ํ† ๋ฆฌ๊ฐ€ ์–ด๋”˜์ง€ ์•ˆ๋‹ค. 2. ๋””๋ ‰ํ† ๋ฆฌ ์œ„์น˜ - ๋‚˜ ๊ฐ™์€ ๊ฒฝ์šฐ๋Š” sftp๋กœ binary ํŒŒ์ผ์„ ์˜ฌ๋ฆฌ๊ณ , /usr/local/lib ์œ„์น˜์— cpํ•˜์˜€๋‹ค. - ๊ทธ ํ›„์— ์••์ถ• ํŒŒ์ผ์„ ์—ด๊ณ  ./shutdown, ./startup ํ•จ. 3. ๋กœ๊ทธ ํŒŒ์ผ ์œ„์น˜ - {ํ†ฐ์บฃ ์„ค์น˜์œ„์น˜}/logs ์— ์žˆ์Œ. 2021. 7. 20.
๋ถˆ๋งŒ๋งŒ ์Œ“์—ฌ๊ฐ€๋Š” ์š”์ฆ˜ ์‹ ์ž…์ธ ์‹œ์ ˆ์—” ํšŒ์‚ฌ์— ๋ถˆ๋งŒ์„ ๊ฐ€์ง€๊ธฐ๊นŒ์ง€ ๊ฑธ๋ฆฌ๋˜ ์‹œ๊ฐ„์€ ์•ฝ 1๋…„์ •๋„. ๋‘๋ฒˆ์งธ ํšŒ์‚ฌ์—์„œ ๋ถˆ๋งŒ์„ ๊ฐ€์ง€๊ธฐ๊นŒ์ง€ ๊ฑธ๋ฆฌ๋˜ ์‹œ๊ฐ„์€ ์•ฝ 6๊ฐœ์›” ์ •๋„. ์„ธ๋ฒˆ์žฌ ํšŒ์‚ฌ์—์„œ ๋ถˆ๋งŒ์„ ๊ฐ€์ง€๊ธฐ๊นŒ์ง€ ๊ฑธ๋ฆฌ๋˜ ์‹œ๊ฐ„์€ ์•ฝ 1๊ฐœ์›” ์ •๋„. ์ง์žฅ์ƒํ™œ ๋„ํ•ฉ 8๋…„์ฐจ์— ์ ‘์–ด๋“  ํ˜„์žฌ. ํšŒ์‚ฌ์˜ ๊ตฌ์กฐ์ ์ธ ๋ฌธ์ œ๋“  ํŒ€์˜ ์‹œ์Šคํ…œ์ ์ธ ๋ฌธ์ œ๋“  ๋งŽ์€ ๊ฒƒ๋“ค์ด ๋„ˆ๋ฌด๋‚˜ ๋น ๋ฅธ ์‹œ๊ฐ„์•ˆ์— ๊ด€์ฐฐ์ด ๊ฐ€๋Šฅํ•ด์กŒ๋‹ค. ์ž˜ ๋ชจ๋ฅด๋Š” ํ”„๋กœ์ ํŠธ๋ฅผ ์šฐ์„  ๋ฐ›์•„์™€์„œ ์ผ๋‹จ ์ง„ํ–‰ํ•˜๋Š” ํ”„๋กœ์ ํŠธ ๋งค๋‹ˆ์ € ์›น์— ๋Œ€ํ•ด์„œ ์•„๋ฌด๊ฒƒ๋„ ๋ชจ๋ฅด๋Š” ํŒ€์žฅ์ด ํ”„๋กœ์ ํŠธ ๋ฆฌ๋”๊ฐ€ ๋˜๊ณ . ์ฒ˜์Œ์œผ๋กœ ํ•˜๋Š” ์›น ํ”„๋กœ์ ํŠธ์˜ ์„œ๋ฒ„๋‹จ์„ ๋‹ด๋‹นํ•˜๊ณ  ์žˆ๋Š” ๊ณผ์žฅ(๋‚˜๋‹ค.) ์›น ํ”„๋กœ์ ํŠธ์˜ ์ดˆ์ค‘๊ธ‰ ๋ ˆ๋ฒจ์„ ๊ฐ€์ ธ์„œ ํ”„๋ก ํŠธ์—”๋“œ ๋‹จ์„ ๋‹ด๋‹นํ•˜๊ณ  ์žˆ๋Š” ์‚ฌ์› ์ž‘๋…„์—” ๊ทธ๋ž˜๋„ ์ต์ˆ™ํ•œ c++๋ฅผ ๊ฐ€์ง€๊ณ  ์›น์„œ๋ฒ„๋ฅผ ๊ตฌ์ถ•ํ•ด๋ณด์•˜์œผ๋‚˜ ์‚ฌ์‹ค ์ •๋ง ๋„ˆ๋ฌด๋‚˜ ๋…ธ๊ฐ€๋‹ค ์ˆ˜์ค€์ด๊ณ  ๋ณด์•ˆ๋”ฐ์œˆ ์•ˆ์ค‘์—๋„.. 2021. 7. 19.