<![CDATA[
<p># kimtheho<br># PostgreSQL<br><br>SQL Error [39000]: 오류: decrypt_iv error: Cipher cannot be initialized</p><p> </p><p>version 차이 때문에 에러가 발생한다. 원인은 다양하지만 일반적으로는 암호화 알고리즘을 수정하면 된다.<br><br>before:</p><div class="table-wrap"><table data-ke-type="table" data-ke-align="alignLeft" style="width: 100%;" border="1"><tbody><tr><td style="width: 100%;"><span style="background-color: #ffffff;"><span style="color: #000000; background-color: #ffffff;" data-ke-size="size20"><span style="color: #800000;">select</span> <span style="color: #000080;">encode</span>(<span style="color: #000000;">decrypt_iv</span>(<span style="color: #008000;">'\x50735067b073bb93'</span>, <span style="color: #008000;">'0123456'</span>, <span style="color: #008000;">'abcd'</span>, <span style="color: #008000;">'<span style="color: #ee2323; background-color: #f3c000;"><span style="background-color: #f3c000;" data-ke-size="size20">des-cbc/pad:pkcs</span></span>'</span>),<span style="color: #008000;">'escape'</span>)<span style="color: #ff0000;">;</span></span></span></td></tr></tbody></table></div><p> </p><p>after:</p><div class="table-wrap"><table data-ke-type="table" data-ke-align="alignLeft" style="width: 100%;" border="1"><tbody><tr><td style="width: 100%;"><span style="background-color: #ffffff;"><span style="color: #000000; background-color: #ffffff;" data-ke-size="size20"><span style="color: #800000;">select</span> <span style="color: #000080;">encode</span>(<span style="color: #000000;">decrypt_iv</span>(<span style="color: #008000;">'\x50735067b073bb93'</span>, <span style="color: #008000;">'0123456'</span>, <span style="color: #008000;">'abcd'</span>, <span style="color: #008000;">'<span style="color: #ee2323; background-color: #f3c000;">3des</span>'</span>),<span style="color: #008000;">'escape'</span>)<span style="color: #ff0000;">;</span></span></span></td></tr></tbody></table></div><p> </p><p>최신 버전에서 안 되는 경우 참고하자.</p>
<!-- -->
]]>
카페 게시글
RDBMS
PostgreSQL
SQL Error [39000]: 오류: decrypt_iv error: Cipher cannot be initialized
운영자
추천 0
조회 2
25.03.07 16:11
댓글 0
다음검색
