pitcampmaster4960

<p>아, 제가 아직 강의를 끝까지 듣지 않아서 그렇네요. 강의를 더 들어보겠습니다! 감사합니다!</p>

next에서 route주소에서 새로고침 하면 404에러 질문입니다.

<p><span style="caret-color: #333333; color: #333333; font-family: 'Open Sans', 'Clear Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; orphans: 4; white-space: pre-wrap; text-size-adjust: auto; background-color: #ffffff;">프론트 서버에 아래 같이 server.js로 express 설정을 했는데, 이거 말씀하시는게 아닌가요? 다른걸 더 해야할까요?</span></p>
<pre class="language-javascript"><code>const express = require("express");
const next = require("next");
const morgan = require("morgan");
const cookieParser = require("cookie-parser");
const expressSession = require("express-session");
const dotenv = require("dotenv");
// option 설정
const dev = process.env.NODE_ENV !== "production"; // 개발모드
const prod = process.env.NODE_ENV === "production"; // 배포모드
// express와 next를 연결하는 방법
const app = next({ dev });
const handle = app.getRequestHandler();
dotenv.config();
// 이 부분이 next에 필요한 내용
// 이렇게 하면 next랑 express가 연결됌.
app.prepare().then(() => {
  const server = express();

  server.use(morgan("dev"));
  server.use(express.json());
  server.use(express.urlencoded({ extended: true }));
  server.use(cookieParser(process.env.COOKIE_SECRET));
  server.use(
    expressSession({
      resave: false,
      saveUninitialized: false,
      secret: process.env.COOKIE_SECRET,
      cookie: {
        httpOnly: true,
        secure: false // https를 사용한다면 true로 바꿔야함
      }
    })
  );
  server.get("/comment/:id", (req, res) => {
    return app.render(req, res, "/comment", { tag: req.params.id });
    // 이걸통해서 프론트 hashtag 페이지에 tag가 함께 내려감.
    // app.render를 통해 pages에 "/hashtag"를 찾는다.
  });
  server.get("/hashtag/:tag", (req, res) => {
    return app.render(req, res, "/hashtag", { tag: req.params.tag });
    // 이걸통해서 프론트 hashtag 페이지에 tag가 함께 내려감.
    // app.render를 통해 pages에 "/hashtag"를 찾는다.
  });
  //모든 get요청을 전부 처리함. 화면 띄우는 거 포함
  server.get("*", (req, res) => {
    return handle(req, res);
  });

  server.listen(3060, () => {
    console.log("next+express running on port http://localhost:3060");
  });
});
</code></pre>

<p>브라우저 에러 해결했는데도 불구하고, 같은 증상이 반복됩니다. 다음에 어떤걸 확인해봐야 할까요?</p>
<p></p>
<p></p>
<p><img src="https://cdn.inflearn.com/public/comments/d8ed9d31-b206-4334-bdd0-aecb5a04d417/1.png" title="1.png" width="500" height="130" alt="" /></p>
<p><img src="https://cdn.inflearn.com/public/comments/d84f70b4-c4e4-49da-816b-449b7411c419/2.png" title="2.png" width="600" height="317" alt="" /></p>
<p><img src="https://cdn.inflearn.com/public/comments/285666e9-0a1f-4691-a3a9-3304500ee3b4/3.png" title="3.png" width="500" height="257" alt="" /></p>

팔로워 목록 삭제 기능 구현 중 질문드립니다.

<p>부끄럽네요..해결했습니다. 정말 빠른 답변 너무 감사드립니다..갓로초님 늘 감사합니다..</p>

로컬 서버에 이미지 등록은 성공했는데, 프론트에서 썸네일 이미지가 보이지 않습니다.

<p>오타가 있었습니다. 해결 했습니다. 감사합니다!</p>

sequelize Cannot read property 'findOne' of undefined 에러 입니다.

<p>아...네 몰랐던 내용이었습니다. 해결 해주셔서 정말 감사드립니다!</p>

workbench 연결 실패 질문입니다.

<p>제로초님, 다른 질문 글 답변 보고 해결했습니다. 빠른 답변 해주셔서 정말 감사드립니다.</p>

model을 전부 만든 후, table을 생성하는 과정에서 에러가 발생했습니다.

<p><span style="color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px; background-color: #ffffff;">config에 입력하는 password&nbsp;</span><span style="background-color: #ffffff; color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px;">(제로초님은 nodejsbook&nbsp; 으로 설정한 내용) </span></p>
<p><span style="background-color: #ffffff; color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px;">제가 제 컴퓨터에 설치되어 있는 mysql 접속할때,&nbsp;</span></p>
<p><span style="color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px; background-color: #ffffff;">myslq -u root -p '</span><span style="color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px; background-color: #ffffff;">password'</span><span style="color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px; background-color: #ffffff;">&nbsp;<br /></span>저 위에 '<span style="background-color: #ffffff; color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px;">password</span>' 에 들어가는거랑 같아야된다는 말씀이신거죠?</p>
<p>방금 password 찾아서 config에도 변경했습니다.</p>
<p>그리고 아래와 같은 버그가 발생했습니다.</p>
<p>이번에는 이름을 잘못설정한건가요?</p>
<p></p>
<p>Unhandled rejection SequelizeConnectionError: Unknown database 'react-nodebird'</p>
<p>&nbsp; &nbsp; at Promise.tap.then.catch.err (/Users/kim/Desktop/projects/nodebird/back/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:133:19)</p>
<p>&nbsp; &nbsp; at tryCatcher (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/util.js:16:23)</p>
<p>&nbsp; &nbsp; at Promise._settlePromiseFromHandler (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:547:31)</p>
<p>&nbsp; &nbsp; at Promise._settlePromise (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:604:18)</p>
<p>&nbsp; &nbsp; at Promise._settlePromise0 (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:649:10)</p>
<p>&nbsp; &nbsp; at Promise._settlePromises (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:725:18)</p>
<p>&nbsp; &nbsp; at _drainQueueStep (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:93:12)</p>
<p>&nbsp; &nbsp; at _drainQueue (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:86:9)</p>
<p>&nbsp; &nbsp; at Async._drainQueues (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:102:5)</p>
<p>&nbsp; &nbsp; at Immediate.Async.drainQueues [as _onImmediate] (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:15:14)</p>
<p>&nbsp; &nbsp; at runCallback (timers.js:705:18)</p>
<p>&nbsp; &nbsp; at tryOnImmediate (timers.js:676:5)</p>
<p>&nbsp; &nbsp; at processImmediate (timers.js:658:5)</p>
<p></p>
<p></p>
<p></p>
<div style="color: #d6deeb; background-color: #011627; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 16px; line-height: 24px; white-space: pre;">
<div>{</div>
<div><span style="color: #7fdbca;">"development"</span>: {</div>
<div><span style="color: #7fdbca;">"username"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">root</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"password"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">ssafy</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"database"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">react-nodeBird</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"host"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">127.0.0.1</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"dialect"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">mysql</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"operatorsAliases"</span>: <span style="color: #ff5874;">false</span></div>
<div>},</div>
<div><span style="color: #7fdbca;">"test"</span>: {</div>
<div><span style="color: #7fdbca;">"username"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">root</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"password"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">ssafy</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"database"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">react-nodeBird</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"host"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">127.0.0.1</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"dialect"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">mysql</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"operatorsAliases"</span>: <span style="color: #ff5874;">false</span></div>
<div>},</div>
<div><span style="color: #7fdbca;">"production"</span>: {</div>
<div><span style="color: #7fdbca;">"username"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">root</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"password"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">ssafy</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"database"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">react-nodeBird</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"host"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">127.0.0.1</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"dialect"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">mysql</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"operatorsAliases"</span>: <span style="color: #ff5874;">false</span></div>
<div>}</div>
<div>}</div>
</div>

<p>mysql 비밀번호가 틀린거라면, mysql 비밀번호를 어디에 입력해서 틀린거일텐데,<br />비밀번호를 어디에 입력을 한건가요?&nbsp; 강의보면서 mysql 비밀번호를 입력한 경우가 없었어서요.</p>
<p>정말 몰라서 질문드립니다.ㅠㅠ</p>
<p>환경은 맥 os 사용하고 있고, 다른 질문 글 찾아본 후 mysql@5.7 버전 다운받아서 사용하고 있습니다.</p>
<p>제가 해야 될게,</p>
<p>1. mysql를 설치 후, 비밀번호도 nodejsbook 으로 변경하고,&nbsp;</p>
<p>2. config 파일도 아래처럼 설정하면 되나요?</p>
<p>Unhandled rejection SequelizeAccessDeniedError: Access denied for user 'root'@'localhost' (using password: YES)&nbsp;</p>
<p>위 에러를 해결 하기 위해&nbsp;<span style="background-color: #ffffff; color: #000a12; font-family: 'Noto Sans KR', -apple-system, system-ui, system-ui, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px;">MySQL 데이터베이스 비밀번호가 틀렸다고 하셨는데, 제가 어디에 입력을 해서 틀린건지 모르겠습니다.</span></p>
<p></p>
<div style="color: #d6deeb; background-color: #011627; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 16px; line-height: 24px; white-space: pre;">
<div>{</div>
<div><span style="color: #7fdbca;">"development"</span>: {</div>
<div><span style="color: #7fdbca;">"username"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">root</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"password"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">nodejsbook</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"database"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">react-nodeBird</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"host"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">127.0.0.1</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"dialect"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">mysql</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"operatorsAliases"</span>: <span style="color: #ff5874;">false</span></div>
<div>},</div>
<div><span style="color: #7fdbca;">"test"</span>: {</div>
<div><span style="color: #7fdbca;">"username"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">root</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"password"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">nodejsbook</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"database"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">react-nodeBird</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"host"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">127.0.0.1</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"dialect"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">mysql</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"operatorsAliases"</span>: <span style="color: #ff5874;">false</span></div>
<div>},</div>
<div><span style="color: #7fdbca;">"production"</span>: {</div>
<div><span style="color: #7fdbca;">"username"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">root</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"password"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">nodejsbook</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"database"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">react-nodeBird</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"host"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">127.0.0.1</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"dialect"</span>: <span style="color: #d9f5dd;">"</span><span style="color: #c789d6;">mysql</span><span style="color: #d9f5dd;">"</span>,</div>
<div><span style="color: #7fdbca;">"operatorsAliases"</span>: <span style="color: #ff5874;">false</span></div>
<div>}</div>
<div>}</div>
</div>
<p></p>

<p>back을 처음부터 다시 폴더를 생성 후 만들어도 같은 에러가 반복됩니다. 이번에는 처음부터 비밀번호를 문자열로 했는데도 불구하고, 아래와 같은 에러가 계속 반복되네요. 새로 만든다고 해도, mysql에는 이전에 만들어놓는 곳으로 접근을 하나요? npm init 부터 해서 처음부터 다시 만들었는데도 불구하고 같은 에러가 나와서 어떻게 해결해야될지 모르겠습니다.</p>
<p>아래는 에러 메시지 입니다.</p>
<p>[nodemon] restarting due to changes...</p>
<p>[nodemon] starting `node index.js`</p>
<p>(node:2663) [SEQUELIZE0004] DeprecationWarning: A boolean value was passed to options.operatorsAliases. This is a no-op with v5 and should be removed.</p>
<p>server is running on http://localhost:3065</p>
<p>Unhandled rejection SequelizeAccessDeniedError: Access denied for user 'root'@'localhost' (using password: YES)</p>
<p>&nbsp; &nbsp; at Promise.tap.then.catch.err (/Users/kim/Desktop/projects/nodebird/back/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:125:19)</p>
<p>&nbsp; &nbsp; at tryCatcher (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/util.js:16:23)</p>
<p>&nbsp; &nbsp; at Promise._settlePromiseFromHandler (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:547:31)</p>
<p>&nbsp; &nbsp; at Promise._settlePromise (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:604:18)</p>
<p>&nbsp; &nbsp; at Promise._settlePromise0 (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:649:10)</p>
<p>&nbsp; &nbsp; at Promise._settlePromises (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/promise.js:725:18)</p>
<p>&nbsp; &nbsp; at _drainQueueStep (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:93:12)</p>
<p>&nbsp; &nbsp; at _drainQueue (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:86:9)</p>
<p>&nbsp; &nbsp; at Async._drainQueues (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:102:5)</p>
<p>&nbsp; &nbsp; at Immediate.Async.drainQueues [as _onImmediate] (/Users/kim/Desktop/projects/nodebird/back/node_modules/bluebird/js/release/async.js:15:14)</p>
<p>&nbsp; &nbsp; at runCallback (timers.js:705:18)</p>
<p>&nbsp; &nbsp; at tryOnImmediate (timers.js:676:5)</p>
<p>&nbsp; &nbsp; at processImmediate (timers.js:658:5)</p>
<p></p>

pitcampmaster4960

Posts