yunhwan19037701

<p>저도 같은 문제를 겪었습니다. 감사합니다.&nbsp;</p>

movieimage가 안뜨네요...

취약점 문제

<p>라우터 부분 코드도 추가했습니다!</p>

안녕하세요 선생님!

<div style="color: #d4d4d4; background-color: #1e1e1e; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;">
<div><span style="color: #569cd6;">const</span> <span style="color: #dcdcaa;">express</span> = <span style="color: #dcdcaa;">require</span>(<span style="color: #ce9178;">'express'</span>);</div>
<div><span style="color: #569cd6;">const</span> <span style="color: #4fc1ff;">db</span> = <span style="color: #dcdcaa;">require</span>(<span style="color: #ce9178;">'./models'</span>);</div>
<div><span style="color: #569cd6;">const</span> <span style="color: #dcdcaa;">cors</span> = <span style="color: #dcdcaa;">require</span>(<span style="color: #ce9178;">'cors'</span>);</div>
<br />
<div><span style="color: #569cd6;">const</span> <span style="color: #4fc1ff;">app</span> = <span style="color: #dcdcaa;">express</span>();</div>
<br />
<div><span style="color: #4fc1ff;">db</span>.<span style="color: #9cdcfe;">sequelize</span>.<span style="color: #dcdcaa;">sync</span>();</div>
<br />
<div><span style="color: #4fc1ff;">app</span>.<span style="color: #dcdcaa;">use</span>(<span style="color: #dcdcaa;">express</span>.<span style="color: #dcdcaa;">json</span>());</div>
<div><span style="color: #4fc1ff;">app</span>.<span style="color: #dcdcaa;">use</span>(<span style="color: #dcdcaa;">cors</span>({</div>
<div><span style="color: #9cdcfe;">origin</span><span style="color: #9cdcfe;">:</span> <span style="color: #ce9178;">'http://localhost:3000'</span>,</div>
<div><span style="color: #9cdcfe;">credentials</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">true</span>,</div>
<div>}));</div>
<br />
<div><span style="color: #4fc1ff;">app</span>.<span style="color: #dcdcaa;">get</span>(<span style="color: #ce9178;">'/'</span>, (<span style="color: #9cdcfe;">req</span>, <span style="color: #9cdcfe;">res</span>) <span style="color: #569cd6;">=></span> {</div>
<div><span style="color: #9cdcfe;">res</span>.<span style="color: #dcdcaa;">send</span>(<span style="color: #ce9178;">'hello backend'</span>)</div>
<div>})</div>
<br />
<div><span style="color: #4fc1ff;">app</span>.<span style="color: #dcdcaa;">post</span>(<span style="color: #ce9178;">'/user'</span>, <span style="color: #569cd6;">async</span> (<span style="color: #9cdcfe;">req</span>, <span style="color: #9cdcfe;">res</span>, <span style="color: #dcdcaa;">next</span>) <span style="color: #569cd6;">=></span> {</div>
<div><span style="color: #c586c0;">try</span> {</div>
<div><span style="color: #9cdcfe;">console</span>.<span style="color: #dcdcaa;">log</span>(<span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>)</div>
<div><span style="color: #569cd6;">const</span> <span style="color: #4fc1ff;">newUser</span> = <span style="color: #c586c0;">await</span> <span style="color: #4fc1ff;">db</span>.<span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">create</span>({</div>
<div><span style="color: #9cdcfe;">where</span><span style="color: #9cdcfe;">:</span> {</div>
<div><span style="color: #9cdcfe;">email</span><span style="color: #9cdcfe;"> :</span> <span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>.<span style="color: #9cdcfe;">email</span>,</div>
<div><span style="color: #9cdcfe;">password</span><span style="color: #9cdcfe;"> :</span> <span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>.<span style="color: #9cdcfe;">password</span>,</div>
<div><span style="color: #9cdcfe;">nickname</span><span style="color: #9cdcfe;"> :</span> <span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>.<span style="color: #9cdcfe;">nickname</span>,</div>
<div>}</div>
<div>});</div>
<div><span style="color: #9cdcfe;">res</span>.<span style="color: #dcdcaa;">status</span>(<span style="color: #b5cea8;">201</span>).<span style="color: #dcdcaa;">json</span>(<span style="color: #4fc1ff;">newUser</span>);</div>
<div>} <span style="color: #c586c0;">catch</span> (<span style="color: #9cdcfe;">err</span>) {</div>
<div><span style="color: #9cdcfe;">console</span>.<span style="color: #dcdcaa;">log</span>(<span style="color: #9cdcfe;">err</span>);</div>
<div><span style="color: #dcdcaa;">next</span>(<span style="color: #9cdcfe;">err</span>);</div>
<div>}</div>
<div>})</div>
<br />
<div><span style="color: #4fc1ff;">app</span>.<span style="color: #dcdcaa;">listen</span>(<span style="color: #b5cea8;">3085</span>, () <span style="color: #569cd6;">=></span> {</div>
<div><span style="color: #9cdcfe;">console</span>.<span style="color: #dcdcaa;">log</span>(<span style="color: #ce9178;">'backend server on ${3085} port'</span>)</div>
<div>})</div>
<br /><br /></div>
<div style="color: #d4d4d4; background-color: #1e1e1e; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;"></div>
<div style="color: #d4d4d4; background-color: #1e1e1e; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;"><br /><br /></div>

<p><img src="https://cdn.inflearn.com/public/files/posts/9c6d214d-2efd-48df-b85f-0d758ad64c8f/blob" alt="" /></p>
<p></p>
<p>워크벤치에서도 테이블이 보이지 않습니다!</p>

<p>안녕하세요 선생님 violation error 는 해결을 했는데요 ㅠ!&nbsp;</p>
<p><img src="https://cdn.inflearn.com/public/files/posts/bffe79cd-1c0d-4df2-8780-8527bfa74968/blob" alt="" /></p>
<p>이렇게 body는 잘 들어간 것을 확인했으나&nbsp;</p>
<p></p>
<p><img src="https://cdn.inflearn.com/public/files/posts/0fbda8c5-f053-4c56-9e86-2738228b957d/blob" alt="" /></p>
<p>mysql 에서는 null로 들어가있네요 원인을 알 수 있을까요~?&nbsp;</p>
<p></p>
<p></p>
<p></p>
<p>스키마 정의하는 부분 코드입니다.&nbsp;</p>
<div style="color: #d4d4d4; background-color: #1e1e1e; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;">
<div><span style="color: #4ec9b0;">module</span>.<span style="color: #4ec9b0;">exports</span> = (<span style="color: #9cdcfe;">sequelize</span>, <span style="color: #9cdcfe;">DataTypes</span>) <span style="color: #569cd6;">=></span> {</div>
<div><span style="color: #569cd6;">const</span> <span style="color: #4fc1ff;">User</span> = <span style="color: #9cdcfe;">sequelize</span>.<span style="color: #dcdcaa;">define</span>(<span style="color: #ce9178;">'User'</span>, {</div>
<div><span style="color: #9cdcfe;">email</span><span style="color: #9cdcfe;">:</span> {</div>
<div><span style="color: #9cdcfe;">type</span><span style="color: #9cdcfe;">:</span> <span style="color: #9cdcfe;">DataTypes</span>.<span style="color: #dcdcaa;">STRING</span>(<span style="color: #b5cea8;">40</span>), <span style="color: #6a9955;">// 40자 이내</span></div>
<div><span style="color: #9cdcfe;">unique</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">false</span>, <span style="color: #6a9955;">// 중복금지</span></div>
<div>},</div>
<div><span style="color: #9cdcfe;">nickname</span><span style="color: #9cdcfe;">:</span> {</div>
<div><span style="color: #9cdcfe;">type</span><span style="color: #9cdcfe;">:</span> <span style="color: #9cdcfe;">DataTypes</span>.<span style="color: #dcdcaa;">STRING</span>(<span style="color: #b5cea8;">20</span>),</div>
<div><span style="color: #9cdcfe;">unique</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">false</span>, <span style="color: #6a9955;">// 중복금지</span></div>
<div>},</div>
<div><span style="color: #9cdcfe;">password</span><span style="color: #9cdcfe;">:</span> {</div>
<div><span style="color: #9cdcfe;">type</span><span style="color: #9cdcfe;">:</span> <span style="color: #9cdcfe;">DataTypes</span>.<span style="color: #dcdcaa;">STRING</span>(<span style="color: #b5cea8;">100</span>),</div>
<div><span style="color: #9cdcfe;">unique</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">false</span>, <span style="color: #6a9955;">// 중복금지</span></div>
<div>},</div>
<div>}, {</div>
<div><span style="color: #9cdcfe;">charset</span><span style="color: #9cdcfe;">:</span> <span style="color: #ce9178;">'utf8'</span>,</div>
<div><span style="color: #9cdcfe;">collate</span><span style="color: #9cdcfe;">:</span> <span style="color: #ce9178;">'utf8_general_ci'</span>, <span style="color: #6a9955;">// 한글 저장돼요</span></div>
<div>});</div>
<div></div>
<div><span style="color: #4fc1ff;">User</span>.<span style="color: #dcdcaa;">associate</span> = (<span style="color: #9cdcfe;">db</span>) <span style="color: #569cd6;">=></span> {</div>
<div><span style="color: #6a9955;">// db.User.hasMany(db.Post);</span></div>
<div><span style="color: #6a9955;">// db.User.hasMany(db.Comment);</span></div>
<div>};</div>
<div></div>
<div><span style="color: #c586c0;">return</span> <span style="color: #4fc1ff;">User</span>;</div>
<div>};</div>
</div>

<p>혹시 몇번째 강의에서 mysql DB 비밀번호 설정하는 부분이 있었는지 알 수 있을까요 ㅠ?&nbsp;</p>
<p></p>
<p>[해결완료]&nbsp;</p>
<p>아래 방식으로 해결했습니다! 다른 분들도 참고하시길..&nbsp;</p>
<ul>
<li>mysql 설치법
<ul>
<li><a href="https://velog.io/@wow/Mac%EC%97%90%EC%84%9C-mySQL5.7-%EC%9E%AC%EC%84%A4%EC%B9%98" target="_blank" rel="noopener noreferrer"></a><a href="https://velog.io/@wow/Mac%EC%97%90%EC%84%9C-mySQL5.7-%EC%9E%AC%EC%84%A4%EC%B9%98" target="_blank" rel="noopener noreferrer">https://velog.io/@wow/Mac에서-mySQL5.7-재설치</a></li>
</ul>
</li>
<li>mysql 초기 비밀번호 설정법
<ul>
<li><a href="https://kogun82.tistory.com/122" target="_blank" rel="noopener noreferrer"></a><a href="https://kogun82.tistory.com/122" target="_blank" rel="noopener noreferrer">https://kogun82.tistory.com/122</a></li>
</ul>
</li>
</ul>

back/config/config.json 패스워드에 대해 궁금합니다. SequelizeAccessDeniedError: Access denied for user 'root'@'localhost' (using password: NO)

<p><img src="https://cdn.inflearn.com/public/files/posts/ac4b3405-5100-43f9-aae5-9bee07e4f99f/blob" alt="" /></p>
<p>에러 내역 첨부합니다 !</p>

<p>return 은 필수여야하는 것일까요?</p>

pending status

<p>app.post 안에 res.send()를 넣으니까 해결이 되었습니다!</p>

yunhwan19037701

Posts