Moa Kim

<p>html은 안깨지고 mustache에서만 깨지네요. 차셋은 utf-8이긴 합니다.</p>
<p>&nbsp;</p>

한글깨짐 발생하네요.

<p style="box-sizing: border-box; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: 'Noto Sans KR'; background-color: #fcfcfc; margin: 0px !important 0px 16px 0px;">지인에게 부탁해서 접속해봤는데 다른 폰 + 안드로이드 타블렛도 안되네요.</p>
<p style="box-sizing: border-box; margin: 0px 0px 16px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: 'Noto Sans KR'; background-color: #fcfcfc;">비밀번호 맞든 틀리든 excusemoa.com 내용: undefined라고 alert가 나오고</p>
<p style="box-sizing: border-box; margin: 0px 0px 16px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: 'Noto Sans KR'; background-color: #fcfcfc;">회원가입도 동작하지 않는것 보면(mysql에서 테이블 확인했는데 값 안들어오네요)</p>
<p style="box-sizing: border-box; margin: 0px 0px 16px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: 'Noto Sans KR'; background-color: #fcfcfc;">요청자체를 제대로 못보내거나 back에서 거부하고 있는것 같은데...</p>
<p style="box-sizing: border-box; margin: 0px 0px 16px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: 'Noto Sans KR'; background-color: #fcfcfc;">왜 모바일 브라우저에서만 그런건지 답답하면서 신기하네요</p>
<p style="box-sizing: border-box; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: 'Noto Sans KR'; background-color: #fcfcfc; margin: 0px 0px 0px !important 0px;">브라우저는 크롬, 삼성 이렇게 썼습니다. (둘다 크롬기반?) 아이폰이 없어서 사파리는 못써봤네요.</p>

배포 후 모바일에서 로그인 안되는 문제.

<p>자문 자답입니다.</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>https://www.inflearn.com/questions/41022</p>
<p>&nbsp;</p>
<p>기존 mysql 5.7 깔린게 안지워져서 그런것같은데</p>
<p>&nbsp;</p>
<p><span style="color: #24292e; font-family: 'Noto Sans KR'; font-size: 16px; background-color: #ffffff;">ls로 파일목록보고&nbsp;</span><span style="color: #24292e; font-family: Noto Sans KR;">mysql-apt-config_0.8.12-1_all.deb가 있으면</span></p>
<p><span style="color: #24292e; font-family: Noto Sans KR;">sudo rm&nbsp;</span><span style="color: #24292e; font-family: Noto Sans KR;">mysql-apt-config_0.8.12-1_all.deb</span></p>
<p><span style="color: #24292e; font-family: Noto Sans KR;">으로 지운 후에</span></p>
<p><span style="color: #24292e; font-family: 'Noto Sans KR'; font-size: 16px; background-color: #ffffff;">sudo apt-get remove mysql-server</span></p>
<p><span style="color: #24292e; font-family: 'Noto Sans KR'; font-size: 16px; background-color: #ffffff;">로 mysql 지워주고</span></p>
<p><span style="color: #24292e; font-family: Noto Sans KR;">위 링크안의 링크글 따라들어가서 명령어 따라치니 MYSQL 8로 설치가 되네요.</span></p>

우분투 mysql 계속 5.7로만 설치됩니다.

<div style="color: #d4d4d4; background-color: #1e1e1e; font-family: D2Coding, Consolas, 'Courier New', monospace, Consolas, 'Courier New', monospace; font-size: 19px; line-height: 26px; white-space: pre;">
<div>&nbsp; <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>, { <span style="color: #6a9955;">// MySQL에는 users 테이블 생성</span></div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">id</span><span style="color: #9cdcfe;">:</span> { <span style="color: #6a9955;">// 사업자번호</span></div>
<div>&nbsp; &nbsp; &nbsp; <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;">30</span>),</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">allowNull</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">false</span>, <span style="color: #6a9955;">// 필수</span></div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">unique</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">true</span>, <span style="color: #6a9955;">// 유일한 값</span></div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">primaryKey</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">true</span>,</div>
<div>&nbsp; &nbsp; },</div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">password</span><span style="color: #9cdcfe;">:</span> { <span style="color: #6a9955;">// 비밀번호</span></div>
<div>&nbsp; &nbsp; &nbsp; <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>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">allowNull</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">false</span>, <span style="color: #6a9955;">// 필수</span></div>
<div>&nbsp; &nbsp; },</div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">company</span><span style="color: #9cdcfe;"> :</span> { <span style="color: #6a9955;">// 회사명</span></div>
<div>&nbsp; &nbsp; &nbsp; <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>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">allowNull</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">false</span>, <span style="color: #6a9955;">// 필수</span></div>
<div>&nbsp; &nbsp; },</div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">name</span><span style="color: #9cdcfe;"> :</span> { <span style="color: #6a9955;">// 담당자 이름</span></div>
<div>&nbsp; &nbsp; &nbsp; <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;">10</span>),</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">allowNull</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">true</span>,</div>
<div>&nbsp; &nbsp; },</div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">phone</span><span style="color: #9cdcfe;">:</span> { <span style="color: #6a9955;">// 담당자 전화번호</span></div>
<div>&nbsp; &nbsp; &nbsp; <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>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">allowNull</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">true</span>,</div>
<div>&nbsp; &nbsp; },</div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">email</span><span style="color: #9cdcfe;">:</span> { <span style="color: #6a9955;">// 담당자 이메일</span></div>
<div>&nbsp; &nbsp; &nbsp; <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>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">allowNull</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">true</span>,</div>
<div>&nbsp; &nbsp; },</div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">role</span><span style="color: #9cdcfe;">:</span> { <span style="color: #6a9955;">// 회원등급</span></div>
<div>&nbsp; &nbsp; &nbsp; <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;">15</span>),</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">defaultValue</span><span style="color: #9cdcfe;">:</span> <span style="color: #ce9178;">"NOVICE"</span>,</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #6a9955;">// 비회원 NOVICE, 판매자 PROVIDER, 구매자 CUSTOMER, 판매-구매자 PROCUST, 관리자 ADMIN</span></div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">allowNull</span><span style="color: #9cdcfe;">:</span> <span style="color: #569cd6;">false</span>, <span style="color: #6a9955;">// 필수</span></div>
<div>&nbsp; &nbsp; },</div>
<div>&nbsp; },{</div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">charset</span><span style="color: #9cdcfe;">:</span> <span style="color: #ce9178;">'utf8'</span>,</div>
<div>&nbsp; &nbsp; <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>&nbsp; });</div>
<div>&nbsp; <span style="color: #4fc1ff;">User</span>.<span style="color: #dcdcaa;">associate</span> = (<span style="color: #9cdcfe;">db</span>) <span style="color: #569cd6;">=></span> { <span style="color: #6a9955;">// 릴레이션(관계) 정의</span></div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">hasMany</span>(<span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">Address</span>); <span style="color: #6a9955;">// 주소목록</span></div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">hasMany</span>(<span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">Order</span>); <span style="color: #6a9955;">// 주문내역</span></div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">hasMany</span>(<span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">Item</span>); <span style="color: #6a9955;">// 등록한 제품.</span></div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">belongsToMany</span>(<span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>, { <span style="color: #9cdcfe;">through:</span> <span style="color: #ce9178;">'UsersRelation'</span>, <span style="color: #9cdcfe;">as:</span> <span style="color: #ce9178;">'Providers'</span>, <span style="color: #9cdcfe;">foreignKey:</span> <span style="color: #ce9178;">'customerId'</span> }); <span style="color: #6a9955;">// 판매자-구매자 관계</span></div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">belongsToMany</span>(<span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>, { <span style="color: #9cdcfe;">through:</span> <span style="color: #ce9178;">'UsersRelation'</span>, <span style="color: #9cdcfe;">as:</span> <span style="color: #ce9178;">'Customers'</span>, <span style="color: #9cdcfe;">foreignKey:</span> <span style="color: #ce9178;">'providerId'</span> }); <span style="color: #6a9955;">// 판매자-구매자 관계</span></div>
<div>&nbsp; &nbsp; <span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">belongsToMany</span>(<span style="color: #9cdcfe;">db</span>.<span style="color: #9cdcfe;">Item</span>, { <span style="color: #9cdcfe;">through</span><span style="color: #9cdcfe;">:</span> <span style="color: #ce9178;">'ItemUsers'</span> }); <span style="color: #6a9955;">// 열람가능한 제품</span></div>
<div>};</div>
</div>
<p>&nbsp;</p>
<div style="color: #d4d4d4; background-color: #1e1e1e; font-family: D2Coding, Consolas, 'Courier New', monospace, Consolas, 'Courier New', monospace; font-size: 19px; line-height: 26px; white-space: pre;">
<div><span style="color: #6a9955;">// 고객등록</span></div>
<div><span style="color: #4fc1ff;">router</span>.<span style="color: #dcdcaa;">patch</span>(<span style="color: #ce9178;">'/addcustomer'</span>, <span style="color: #9cdcfe;">isLoggedIn</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> { <span style="color: #6a9955;">// </span></div>
<div>&nbsp; <span style="color: #6a9955;">// front의 data: { providerId:string, customerId:string }</span></div>
<div>&nbsp; <span style="color: #9cdcfe;">console</span>.<span style="color: #dcdcaa;">log</span>(<span style="color: #ce9178;">'고객등록'</span>,<span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>);</div>
<div>&nbsp; <span style="color: #c586c0;">try</span> {</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #569cd6;">const</span> <span style="color: #4fc1ff;">customer</span> = <span style="color: #c586c0;">await</span> <span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">findOne</span>({ <span style="color: #6a9955;">// 아이디 찾기</span></div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">where</span><span style="color: #9cdcfe;">:</span> {</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">id</span><span style="color: #9cdcfe;">:</span> <span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>.<span style="color: #9cdcfe;">customerId</span>,</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; }</div>
<div>&nbsp; &nbsp; &nbsp; });</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #569cd6;">const</span> <span style="color: #4fc1ff;">provider</span> = <span style="color: #c586c0;">await</span> <span style="color: #9cdcfe;">User</span>.<span style="color: #dcdcaa;">findOne</span>({ <span style="color: #6a9955;">// 아이디 찾기</span></div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">where</span><span style="color: #9cdcfe;">:</span> {</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">id</span><span style="color: #9cdcfe;">:</span> <span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>.<span style="color: #9cdcfe;">providerId</span>,</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; }</div>
<div>&nbsp; &nbsp; &nbsp; });</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #c586c0;">if</span> (!<span style="color: #4fc1ff;">customer</span> || !<span style="color: #4fc1ff;">provider</span>) {</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span style="color: #c586c0;">return</span> <span style="color: #9cdcfe;">res</span>.<span style="color: #dcdcaa;">status</span>(<span style="color: #b5cea8;">403</span>).<span style="color: #dcdcaa;">send</span>(<span style="color: #ce9178;">'해당 아이디가 존재하지 않습니다.'</span>);</div>
<div>&nbsp; &nbsp; &nbsp; }</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #c586c0;">await</span> <span style="color: #4fc1ff;">provider</span>.<span style="color: #dcdcaa;">addCustomers</span>(<span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>.<span style="color: #9cdcfe;">customerId</span>);</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #6a9955;">// await customer.addCustomers(req.body.providerId);</span></div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">res</span>.<span style="color: #dcdcaa;">status</span>(<span style="color: #b5cea8;">200</span>).<span style="color: #dcdcaa;">json</span>({ <span style="color: #9cdcfe;">customerId</span><span style="color: #9cdcfe;">:</span> <span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">body</span>.<span style="color: #9cdcfe;">customerId</span> });</div>
<div>&nbsp; } <span style="color: #c586c0;">catch</span> (<span style="color: #9cdcfe;">error</span>) {</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #9cdcfe;">console</span>.<span style="color: #dcdcaa;">error</span>(<span style="color: #9cdcfe;">error</span>);</div>
<div>&nbsp; &nbsp; &nbsp; <span style="color: #dcdcaa;">next</span>(<span style="color: #9cdcfe;">error</span>); <span style="color: #6a9955;">// status 500</span></div>
<div>&nbsp; }</div>
<div>});</div>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>CREATE TABLE IF NOT EXISTS `Users` (`id` VARCHAR(30) NOT NULL UNIQUE , `password` VARCHAR(100) NOT NULL, `company` VARCHAR(20) NOT NULL, `name` VARCHAR(10), `phone` VARCHAR(20), `email` VARCHAR(20), `role` VARCHAR(15) NOT NULL DEFAULT 'NOVICE', `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;</p>
<p>Executing (default): SHOW INDEX FROM `Users` FROM `excuse-moa`</p>
<p>&nbsp;</p>
<p>Executing (default): CREATE TABLE IF NOT EXISTS `UsersRelation` (`createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `providerId` VARCHAR(30) , `customerId` VARCHAR(30) , PRIMARY KEY (`providerId`, `customerId`), FOREIGN KEY (`providerId`) REFERENCES `Users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`customerId`) REFERENCES `Users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;</p>
<p>Executing (default): SHOW INDEX FROM `UsersRelation` FROM `excuse-moa`</p>
<p>&nbsp;</p>
<p>테이블 drop한다음에 서버끄고 다시 하니까 이번엔 의도한대로 작동하네요..&nbsp; 😅😯</p>
<p>답변 감사드립니다.....</p>

Moa Kim

投稿