SNR#2689 이메일 MFA 기능 추가

버전: 4.0.2502.0

로그프레소 소나 로그인 MFA 인증 방식에 이메일 유형이 추가되었습니다.

이메일 MFA 인증 기능을 설정한 경우, 로그인 시 인증 코드 입력 화면이 보입니다.

이메일을 확인하여 인증 코드를 가져올 수 있습니다.

개별 계정에 대해 MFA 인증 방식을 선택하려면 계정 추가 혹은 편집 화면의 MFA 설정에서 OTP와 이메일 중에 하나를 선택합니다.

• OTP: OTP 방식(기본값, 기존 2FA 설정과 동일)
• 메일: 계정에 설정된 이메일 주소로 메일 인증 코드를 보내 인증하는 방식

여러 계정에 대해 인증 방식을 일괄 변경하려면 다음 방법을 사용합니다.

• 인증 방식 변경: 선택한 계정들의 MFA 설정을 OTP, 이메일 중 선택하여 적용할 수 있습니다.
• MFA 활성화: 선택한 계정들의 MFA 설정을 사용으로 변경합니다. 비활성화 전 설정된 값으로 다시 활성화됩니다.
• MFA 비활성화: 선택한 계정들의 MFA 설정을 사용 안 함으로 변경합니다.

1. 로그프레소 셸에서 마이그레이션을 234번까지 수행 - 로그프레소 셸에서 다음 명령어 수행

   > sonar.migrate 234
   

2. 마리아디비 sonar 데이터베이스에서 다음 SQL 쿼리문을 순서대로 수행 ()

   ALTER TABLE `sonar_logos` ADD COLUMN IF NOT EXISTS `mail_header_logo` mediumtext DEFAULT NULL COMMENT 'base64 PNG 이미지' AFTER `login_logo`;
   
   ALTER TABLE `sonar_logos` ADD COLUMN IF NOT EXISTS `mail_footer_logo` mediumtext DEFAULT NULL COMMENT 'base64 PNG 이미지' AFTER `mail_header_logo`;
   
   INSERT INTO `sonar_logos` (`host`, `mail_header_logo`, `mail_footer_logo`) (SELECT NULL, "iVBORw0KGgoAAAANSUhEUgAAAN4AAABACAYAAAB1C8mEAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAA0YSURBVHgB7Z3RbtzGFYZ/au02RQpYeQJTTxALbVL0yhSQFE5Q16sn8OoJJD1BqQcoLD2BqcteSYaD2q1TiOpF2iYFtLnJRdHEDFwgAtLEioA0dR2ZmbOcI85SQ3KGy13vSvMBI3KXc2aG3DlzZs4MR4DD4XA4HA6Hw+FwOBwOh8PhcDgcDofD4XA4HA6Hw/Ey8NAC6Yfvroq/oQjzaBXvSKTZFyfb3psPIzgc54SRFS/96EaAFHsYNx5C742HG3A4zgFzGJUUtzEJUoTp395Zg8NxDhjJ4qV/veGjg8eYGKLrefnHC97i7hEcjhnmEkahg99ioogx5PP/++Kkj8kQyECKvolm0Lj3mgi3RPDlZ0rvngixCAnsCDRpfSzTiktk1mRcHYkMcQNZlu+j/DfpIrt/U2KcLQvl3xPhdeW7z1F9zyxH+V+3lFMJpLwvAz3vBPnv14jGFk9auz1ZmEmyMkFHSygCNS6JCAuwZ1WmUVVxIxE2UK+AVIHuoPp5JyIs4Wxaj1H/OyWyHFEDWZZfF2G38H0kgs1whMoQKp9Jlhq9qoZjBWeVIBBhp0ZOd7+ML8JdmQ4q0tA971qaW7zOoEA+xsFz0R58RUcRLotwRYSfpNk1z/4mXxKksKHyORZhX55Ty01WwEfWkgeo/gGr0vIx3CKToizjrAIAuXVTmVfKQhXtKrIKaSILJV8KVNF7Imxr4pGlMOmpJMo5NTaRIr8tj1Tm60q5yQDQ84uVMu0pcvQsPpdy9OwD5PfL11UCDCstlXu/JG963j3o77mUUbqa7XczSeE+E8fHXqZ0KlfEdz9LE2/pQYzpR1WUGFmLnGjihTKuj6yiLCL7cVVWlbSoAiyXpNWTaekqErONYQVmfGQV7Zq8vo+zFqRMFlJuR6ZD1ukezt4HlX0JdnAdS6B/NpzvUaG8dxQ5XYPmI1esuOIayemsKaH2QCLkXVgjGnk10w9v9NC2tftOKNZfRPinRumIb0T4/Zyf/uo3k/GiNsdHXkFJAaosGcVbV+TWNGnx2JIq7mJFWpHMaxn2JFKWK3YXdlDZVuQ5W9A24HTIAh+V5EtDgKJCB/K4Bf3zou8WoVdmagBZ6VQrWqT4295F9ZBiiKbTCe1X/g+Ewv23Js6XIk6aRlOufGorvW4QnxSLLRRZt3lNWoSJQiVoMN6QsMOHeB32xMq5j3apq9BHJd/7sJPrKjIm4266vqLk1YMh1oo3cKpUDzjteWKgdM9EnGNPFmKqla8njzHMlWBLHtkLxwTyGKG5QtlwFc3xlfMjtEMsj9QA9WAOjyVvW8rdkscE5U6XIrGSX2Ao02CMN44phCdefZynhTgD5bv5jfen+7uYHgLl3GawHSMfuHP3is59ef4xxo+PvPy2+VFZ7yif+yXp91BNcVpiQ5aJ0qeuHNW9GJllpnhJSTrU09hrIMfP3vb+96WscU/BSvGkteuhTb6THsw6vtAoZ4q76dvvJt6jP/QxfSSwgxXvivysdq/KKnLV4gWD1uyUAFkFZTY1cahS9TTfX5Xf+/JzWRfNL+Shg2TVe42RdbHZieHLvHrKdWrgokI6PB7eK5Gj61saOdWLaQNbeN9UwM7iXfJWhaVBq/zHIM63og49014RD6qzJ5RvaQqVz3igPcG0qOt1vZCuj+H0yzywXVQ7XajykeJsVlyv64Lqru/KwPnzVAwRyEDfFcfTCTLHC13vFeToSI0APY9lTb5t/nZa7BQvTbtom88MGubDyjjTpHyJck4/rml5dN3KRLnuQ5/XQuG7ANVWxUd5qxwjU5y45HpRceaRV1CyOmuoVqwm0wkqrICEj+xeeSqG8ia/d6iRi5HfE4+hyYl1TaaxpsglMj1b5xLHN65/xs6VsUwhkLPk2DBeNZny3ej6eLkkyBXGxvmjNmix5vwWqvNTQxVUcVcKgVr811DtOieoa7ZQCH2lfGO3EgoJsm4ilSFGXoY6jqTcoiK3qlzfl8cA5vfjIx8bt6948LxVtI2JtXta2s0sMo+Tk2lQPnaqBDDzctEPrE5BqD/ePcu06iBrGhUCKWNdF1AHyXA3je5hB+1jUvn3NXFN5LY1cTeVc1Mn4m0ljQ1DGQvFS9NraBsTp8rXBsqZ40+B8tGPl8hzXg1SBldYX35eKVyPCmn5qGaSVodIkI+t6D7voD18EQ5kmlX3xVMg3HjMS7m7qH5ePNZNlO8oDZ7aoS5onfKpK5QiWDjUbObxErTJVwZzdyfIJs3tGJfyBQaBKFoCrgSqAtL3a/Iay+nGV8W0yIvJ45pi2SiPHUVuUkQYrqxlXWwex9YFVrJV5OM3ek49DN83T2H05GcuA8ej416JnDoveA/DhMh7HSGGfyMmkGmH8nMCs8USpxjX6vSjd9aE1WuvResLnX9SE4eU7tOmi2vEw+h0lryHuwmaE8K8y5Fg2NlBiqazUqxEKvSjbaIcXVpHSlrFqYfiek5+w4CUO4QdprIHspxUJnVpWwS78S7FZ8sf4uzzVy0bE2PYcUNyxVVAQO48Ydjho/NqUkPWrZHnvHWe0UqMa7X3xgNRMbwttMUXBnHsrZ1KZvm63Ul3vxj+UYvzWlweHuiTsm42SKs4FRAjq7BV6znHSXG818ZzD5E9HxqPJfI7taHhKYwljdxiQY7wNXI6heGeBj3PWCMP5M+7LI1KrGu28G6SiQ0wCrRSpV+TNS0ROxh9ZwrRtKx7f7xfV7EnAVkDtcIkaN4lbDOtWUK97wTmDcw88q5+AvuGSZUnqCEc6XnbLxm7/Moynv+PuhU+mnJooO8m0wwmvJiaCtlHe7SZ1izR9L6pDsRozqjyZ7A2KYP9Tk7IvHrNKjQtETs0iHfYgrUjOp0YDseU0ah2e798mAjJFTTBdInYt2iDaETnisMxFhqbFe/nD3aRmk8YnmLyJsKh9dBTT6djXz6HYwKM1J/zfvEwFMq3bSxg+ibCcSuK56ydY2oZfSD1o1fWhAqaDXo/NYhzbLxErBpn7RxTTCumxXirvz/P1a9WoQnzL0cuVuQ9ut9sDDoDhGHoy2NiIUbxT+fAbGXbgPN/GXlPGy0Npgb/uETMc6R7pf+4hJaIfWCQ3T86wPcYjU5n4Tx2Mzc2NlbTlP45zNAc3i5dqqrMUlF52ZqtLK9cWRbnu4VrPZnuijiPUIOSlm38IrEsd4wZpSWfvdDgN+lduLR8vZqJU4Us3ahKd07HdlTJhdLxQgBaQURdaVKeHip2BZBKx+sN+1J2S5HdYwtaw13DeGXl6CFXItv9ciLkb1LEkGslRZoBZpTRtnAvQDs8p38X3U5Ps76xzqlCK1X+3UI7cH7HdrxyYllp6UOq0DXWg/ceIQsRKt+vSTlSArJaS6hmsBRMyCyJ0GQOl5WNlKdLSmNqsUS8lcJnaoBWZZoxZpDWLB6j9XQe1ryJQEr3yVwbTpXz7MnkLuLQC59VSqdYmaigdIxwjA0sX2BgzchKkvKbLhpXy+Ejs1IR8rcIRtk0K5JHHzNK64pHCOXrDc3xVc3LHbemdOfdkxnJI1mqxyLsSGs3XyHDVlK7a5a0XNxIBqgmRNZVpfzXYAcrGY/LKJgouxbP87jxmcTua2NhLIpHDCzfCRbwtbeLf2kU71i+8tOW0p3zeTtZYReQKQopWxdZF/FAXOuWiKkLisvQvWajy199N/CO+HwNZuX2kY0lY8WJww1kzzCNPSU8lQ6mBM3/g9NLZ2yKRwyWlv3u0r3BWwYHUsnoSJ7LT1qZNmBivNqxehFxFqGKK60c75FCSugjc3zoFIeVqkpJeKOeBAb5I9/RekdYnquoh7cMoWkEKifv7jW4VmOxGV8G9spGIiyGMzwtMVbFk2QPmXeCftaK5xLy/6NvIU2XxJzdkrd7/v9Zpdo1Iwsox3DU/TudnyvA7v9VXbdOfkfWMilOFVSUIUZmsXxpeepga0xK08OwF5bKXNttFXkuUECu9AFmnLEqntx+IUC7xGL8uI5X5xa8R++tee+/F+MCICoevf2/p47rpDudzo90rb9Uki0Z59T9TvJSaQ9kVKuxsXTUxAbxesgs1bo499SAbGczaiyNN9FS7sfHOP5b1QQZr8X7/qSLVihYt/fvb14EC1eA9o3kLQmeikqYIt8puXRnAOkI4cq6J+WeIt9/cz00mMzWUNxeQgcrx66mXPT70X4n86HdfFwI6eTZ2NiwnQ+cGsareHOe0QC8ghj0ev0Fs246pJWh7QxoTitC7ppfkteqZEn5lmT8GPl/oV2Qc2JV8GR9MU12ttC1vua6j2wMulIxFtuU8vOmeav5iq7ua5hRWvNu6EjfurkmcrDcIElYt/TFFrwXu1P6PxEcjpFpdeXKWdK+hW6LsVu6IbqRMRyOc85YLR6RvvXrUMx4lgyEpXX76aWLOGZzXGDGrnhE+vbNnshKeK9oN+qBo6SfWbeLO2ZzOBwOh8PhcDgcDofD4XA4HA6Hw+FwOBwOh8PhcDgcjsnzAxLjaAdTH+ZdAAAAAElFTkSuQmCC", "iVBORw0KGgoAAAANSUhEUgAAAJYAAAAaCAYAAABVc6VBAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAlQSURBVHgB7VrLbiPHFa1qksnEMhzOBwSmvmAomNQo2QyFIIEMxDDnC0R9ATnbbIb6AklfIGqTLIdyAGcQJyC9cSRKwtAIklUAM8jCBvwixiONbJFdPqe6iupuFcmmoAFsiweg+lXPW7fOfZSkiEEdv10WvtjFXVbMhrbIiA259LQn5rj18K688dXWNZSKKIkL0VLPytepO8dPDBHFUkdrJVxy4vrIiYvzspjj1iPGWLIqroMzeXnvyzljzSHS9kb9cy0nlJqNbf4Phfo3fhd8wPVXuGRUT8xx63HJWCnxWMwCKlXXKpXBf/H8p/SWWivnxBy3GtqGaYf74vyZmMW/+gd08iz27jO86+kme2IhtSSbzb64BpYLhTouj5WUG0dHR40kdVZWVnL+YLCO2zKYV5tjKWXPl3JvWhulUil79uJFFSMvKaVyti7+dGUqtXNwcNCzZfP5fPbn6fQTRzN9lO9JpfYPjo/bCcrrOhjffiqVaifsIwLleR92Op26fV4pFEpKiCrmkLdz4Pzj7euykJcaDqvK98uh+fYw3814WQsrJ5FAxoFiddYquOyKpPgS1T6SV98/SwnxrX1QXbGQXr2Ocs2qWPeLxaqvVB0jCvw7pSgk3gfPmLyXSq26BFYsFvMo3xpbN0C9c3y8yRujwJ9MGg/GvY1xP0panuMTvv+oc3LSTFxHV5ONw6OjDd5DZrQ4decc4u1DAYdCPDFz7qM8N0VOOOZrMauMrSmc3QzGcSpDSqV7yovTQUuVX236gQLFDt02I9p87fXX70KAixDMXUxuVe9EsJA/HLZKYIJwXS6gVSowzU6kbjq9yPb0TJS6e6VjChJl7A/KtORhI8iAtWr3C4VapDjyfOHytg7GvsPxob3d+PhcdcK/XywsjJQXlzr75pwjcwCbsH3P80Ztg2F2OWeOl+VYnnMPjT8yXyrVOBlzDnjXtDI2YxHpICEa0H9ifOl495lD2bRyDZEXExviFcDs7DrvMcFVsEQ3/N2YpEUo3xMGJi8zmchYKAizAzcPT07qkbrBzquD0ZoQYNfVv4MBu2CDHsxRC+OhydieUp6oLReLWYxv/WU6XUlYJwI1GGhzhsXfOwyZYVO3AhNWa7fb2nIYmeWotAcha2C+N/C9fWdhYWRlWH4IGXN1XTI2zw+X33qLba1jLLR8q54YBvY4MahAZ473z+W4GhX1u3eSm9kZAB/BMu1mfMJhfDcYUJn6EHzFsgIEQT8hxx0KxamPqzupXReMMveFSr5ZwRC6DxU1v4nh+75WBMzlTdd3q1RhoC/nulMZw+WHFxc1zegwuxNlPBySoftot0Rl9IT0YHdlcj/IxUzP42bwCirq9+9siRuGdVJB+Y1J5brdLn2Ifd6fZjLB7uZJQdDIjrhBGFMQ+C5JIeU9ffW8mZTY4sL3te/EjQOztUsfalxZw2LsJwum/ASMTEbLjh+afMArvOeJcqKMyZh6HGDQtFx+vwvnnbZ6OqswtfCp4/3nUkyFEjUw18fyg780xM2BitVPYi60syk0O+R4hT9xTwntx0QWs4BFSUm5Hq+OaGkP/bQndWGiJr2BsCDNSPdwdK3/MQJMEpzod6kQZM7DTidaB03CjCtXXzRlMHurvOeirhSLG3Cut9gWKlRQT5dxRWzYiA/B9i1GwCizizHvonwXY2jHo2BhMgUfJWFuMq+UvOZ0glQuP22ozttYJDU58062Gjjef51AsX54cDKK9P0cwvhK/D38sQ8jLxBukx3Cz6cvXpSM2dBhe6x83hXpyeDHBd1wjpERm3OgUStDf4n+kRgOmTJZp6mjYmIjlcBMj8MRm7kuQhkrUMZ3RcDeeVoAsE1lZXm5dtDp7IkZwQCBuwCbqD/KvMvlv9bAXPeENREuuKLBz8coWxwU9t/ea4ibRBDy5sgE01gLo9QMZc0NBPo/KID1Ndq23MIbbzTPz89Hz9jZNQjcteGyZIdYH1zsTURr23G/RkenoX7EZc5s83CMj0c2RVCxKhLCyKBhfjavxai5ZJ3qSPmAyXRZpl3QX41BBHy2bfii+226EMxJQkZsK5yfc4ImXSlag1468iFz5+HYROlL6Y4Gv0rIVr6YeQdMA4S2j96rYIKKsDkcB0wkVOK9ZxQL5q7poy5uuWO3bVmjECOlgIkYxxg6bxN+NVG5sQmgQCNWMovewm0V42skMuczwihCG3P4muzFwMUoyxUYx7yCNMkvUbZsfNEGfvRN80MpKaf2uL60G3B6WtIPSMhGDqHlEpKZQ2q1w5n/wtHatzKZGeRuTXsNccNIZTJWIaq/YaJzDKBU9Ht0ZDMyBxA6WYQCj+eckoJthX8z1UX/Kggcshjf1Cz7JHDjmATpVFABYMK34jmzEYyJleaKiJoy7jM3NykogBvw2ETZWsZX/h9L/pr/qKceXanpMoPPRTKAreTTZk/cMDgBjIpjzQ6Q6KSChCMcCgLvyApll98DYWkGgXJtcWHCzjXbKVDhjCMv5QyRc0IcnZwwlG/jNg9TdCVqtg7/uJ+dqzFzdc41vPj8XiwU9Kbi8RTZ6vSbb+pQ6NpZJvOMEWG4P9b1zT8iWGZnYCBNohgM34rLycqYZjQs47F0ow7X6vga7AKawb/Hig7w/C9vWpqB6IMal2ZRrNGRTrBTnAuKaGfn+Ph4O1z+cvCqx0Wxxw/aOU6nN1yswnyW9Lwte0Zoo8fYEcemzXWNjluY/zo6WhRTYMuHozjHd7ofWWbNyWSzHumYc7+WnYOVW0gGfUSCS5w/zyF/RqaHLyXGyCs835Gcpsk4OFd9aGWcHjvo+0/rUC6hlSueYqBS/SeRUhHN67KVDHaak7K9UDKRQqCfgsitjgkzAMnK4PyrLZiNNmdkLvD8DHW7jIbQ3wN16V9yx+4zRxZXSMMyPZF8Hm0yhusb24Zy8yilany+9qjONCj1sW1D8ISBSV/PK0srg2CMkTl0Ax+rgjnXGZhQXpwz5YUN1sR1z+WkWxmbYOaBCMkYzvr+gesQeuLY+V+lf0614HsF0R+z7vwvhoSRICa6+irM4Bw/bKSnlvjjHWj4UMwG+CPK34EJbMyV6nZiumIJvyKSA5SP1P9rXls237txZ3eOHw+mK5ZSb042mIadpN+UH7x/rbOuOX56mK5YHhxEJcuOL3N2mmMsEqXN1W//sI08fXXOTnMkxfeFN0Uf8lZtsQAAAABJRU5ErkJggg==" FROM DUAL WHERE NOT EXISTS (SELECT * FROM `sonar_logos` WHERE `host` IS NULL));
   
   UPDATE `sonar_logos` SET `mail_header_logo`="iVBORw0KGgoAAAANSUhEUgAAAN4AAABACAYAAAB1C8mEAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAA0YSURBVHgB7Z3RbtzGFYZ/au02RQpYeQJTTxALbVL0yhSQFE5Q16sn8OoJJD1BqQcoLD2BqcteSYaD2q1TiOpF2iYFtLnJRdHEDFwgAtLEioA0dR2ZmbOcI85SQ3KGy13vSvMBI3KXc2aG3DlzZs4MR4DD4XA4HA6Hw+FwOBwOh8PhcDgcDofD4XA4HA6Hw/Ey8NAC6Yfvroq/oQjzaBXvSKTZFyfb3psPIzgc54SRFS/96EaAFHsYNx5C742HG3A4zgFzGJUUtzEJUoTp395Zg8NxDhjJ4qV/veGjg8eYGKLrefnHC97i7hEcjhnmEkahg99ioogx5PP/++Kkj8kQyECKvolm0Lj3mgi3RPDlZ0rvngixCAnsCDRpfSzTiktk1mRcHYkMcQNZlu+j/DfpIrt/U2KcLQvl3xPhdeW7z1F9zyxH+V+3lFMJpLwvAz3vBPnv14jGFk9auz1ZmEmyMkFHSygCNS6JCAuwZ1WmUVVxIxE2UK+AVIHuoPp5JyIs4Wxaj1H/OyWyHFEDWZZfF2G38H0kgs1whMoQKp9Jlhq9qoZjBWeVIBBhp0ZOd7+ML8JdmQ4q0tA971qaW7zOoEA+xsFz0R58RUcRLotwRYSfpNk1z/4mXxKksKHyORZhX55Ty01WwEfWkgeo/gGr0vIx3CKToizjrAIAuXVTmVfKQhXtKrIKaSILJV8KVNF7Imxr4pGlMOmpJMo5NTaRIr8tj1Tm60q5yQDQ84uVMu0pcvQsPpdy9OwD5PfL11UCDCstlXu/JG963j3o77mUUbqa7XczSeE+E8fHXqZ0KlfEdz9LE2/pQYzpR1WUGFmLnGjihTKuj6yiLCL7cVVWlbSoAiyXpNWTaekqErONYQVmfGQV7Zq8vo+zFqRMFlJuR6ZD1ukezt4HlX0JdnAdS6B/NpzvUaG8dxQ5XYPmI1esuOIayemsKaH2QCLkXVgjGnk10w9v9NC2tftOKNZfRPinRumIb0T4/Zyf/uo3k/GiNsdHXkFJAaosGcVbV+TWNGnx2JIq7mJFWpHMaxn2JFKWK3YXdlDZVuQ5W9A24HTIAh+V5EtDgKJCB/K4Bf3zou8WoVdmagBZ6VQrWqT4295F9ZBiiKbTCe1X/g+Ewv23Js6XIk6aRlOufGorvW4QnxSLLRRZt3lNWoSJQiVoMN6QsMOHeB32xMq5j3apq9BHJd/7sJPrKjIm4266vqLk1YMh1oo3cKpUDzjteWKgdM9EnGNPFmKqla8njzHMlWBLHtkLxwTyGKG5QtlwFc3xlfMjtEMsj9QA9WAOjyVvW8rdkscE5U6XIrGSX2Ao02CMN44phCdefZynhTgD5bv5jfen+7uYHgLl3GawHSMfuHP3is59ef4xxo+PvPy2+VFZ7yif+yXp91BNcVpiQ5aJ0qeuHNW9GJllpnhJSTrU09hrIMfP3vb+96WscU/BSvGkteuhTb6THsw6vtAoZ4q76dvvJt6jP/QxfSSwgxXvivysdq/KKnLV4gWD1uyUAFkFZTY1cahS9TTfX5Xf+/JzWRfNL+Shg2TVe42RdbHZieHLvHrKdWrgokI6PB7eK5Gj61saOdWLaQNbeN9UwM7iXfJWhaVBq/zHIM63og49014RD6qzJ5RvaQqVz3igPcG0qOt1vZCuj+H0yzywXVQ7XajykeJsVlyv64Lqru/KwPnzVAwRyEDfFcfTCTLHC13vFeToSI0APY9lTb5t/nZa7BQvTbtom88MGubDyjjTpHyJck4/rml5dN3KRLnuQ5/XQuG7ANVWxUd5qxwjU5y45HpRceaRV1CyOmuoVqwm0wkqrICEj+xeeSqG8ia/d6iRi5HfE4+hyYl1TaaxpsglMj1b5xLHN65/xs6VsUwhkLPk2DBeNZny3ej6eLkkyBXGxvmjNmix5vwWqvNTQxVUcVcKgVr811DtOieoa7ZQCH2lfGO3EgoJsm4ilSFGXoY6jqTcoiK3qlzfl8cA5vfjIx8bt6948LxVtI2JtXta2s0sMo+Tk2lQPnaqBDDzctEPrE5BqD/ePcu06iBrGhUCKWNdF1AHyXA3je5hB+1jUvn3NXFN5LY1cTeVc1Mn4m0ljQ1DGQvFS9NraBsTp8rXBsqZ40+B8tGPl8hzXg1SBldYX35eKVyPCmn5qGaSVodIkI+t6D7voD18EQ5kmlX3xVMg3HjMS7m7qH5ePNZNlO8oDZ7aoS5onfKpK5QiWDjUbObxErTJVwZzdyfIJs3tGJfyBQaBKFoCrgSqAtL3a/Iay+nGV8W0yIvJ45pi2SiPHUVuUkQYrqxlXWwex9YFVrJV5OM3ek49DN83T2H05GcuA8ej416JnDoveA/DhMh7HSGGfyMmkGmH8nMCs8USpxjX6vSjd9aE1WuvResLnX9SE4eU7tOmi2vEw+h0lryHuwmaE8K8y5Fg2NlBiqazUqxEKvSjbaIcXVpHSlrFqYfiek5+w4CUO4QdprIHspxUJnVpWwS78S7FZ8sf4uzzVy0bE2PYcUNyxVVAQO48Ydjho/NqUkPWrZHnvHWe0UqMa7X3xgNRMbwttMUXBnHsrZ1KZvm63Ul3vxj+UYvzWlweHuiTsm42SKs4FRAjq7BV6znHSXG818ZzD5E9HxqPJfI7taHhKYwljdxiQY7wNXI6heGeBj3PWCMP5M+7LI1KrGu28G6SiQ0wCrRSpV+TNS0ROxh9ZwrRtKx7f7xfV7EnAVkDtcIkaN4lbDOtWUK97wTmDcw88q5+AvuGSZUnqCEc6XnbLxm7/Moynv+PuhU+mnJooO8m0wwmvJiaCtlHe7SZ1izR9L6pDsRozqjyZ7A2KYP9Tk7IvHrNKjQtETs0iHfYgrUjOp0YDseU0ah2e798mAjJFTTBdInYt2iDaETnisMxFhqbFe/nD3aRmk8YnmLyJsKh9dBTT6djXz6HYwKM1J/zfvEwFMq3bSxg+ibCcSuK56ydY2oZfSD1o1fWhAqaDXo/NYhzbLxErBpn7RxTTCumxXirvz/P1a9WoQnzL0cuVuQ9ut9sDDoDhGHoy2NiIUbxT+fAbGXbgPN/GXlPGy0Npgb/uETMc6R7pf+4hJaIfWCQ3T86wPcYjU5n4Tx2Mzc2NlbTlP45zNAc3i5dqqrMUlF52ZqtLK9cWRbnu4VrPZnuijiPUIOSlm38IrEsd4wZpSWfvdDgN+lduLR8vZqJU4Us3ahKd07HdlTJhdLxQgBaQURdaVKeHip2BZBKx+sN+1J2S5HdYwtaw13DeGXl6CFXItv9ciLkb1LEkGslRZoBZpTRtnAvQDs8p38X3U5Ps76xzqlCK1X+3UI7cH7HdrxyYllp6UOq0DXWg/ceIQsRKt+vSTlSArJaS6hmsBRMyCyJ0GQOl5WNlKdLSmNqsUS8lcJnaoBWZZoxZpDWLB6j9XQe1ryJQEr3yVwbTpXz7MnkLuLQC59VSqdYmaigdIxwjA0sX2BgzchKkvKbLhpXy+Ejs1IR8rcIRtk0K5JHHzNK64pHCOXrDc3xVc3LHbemdOfdkxnJI1mqxyLsSGs3XyHDVlK7a5a0XNxIBqgmRNZVpfzXYAcrGY/LKJgouxbP87jxmcTua2NhLIpHDCzfCRbwtbeLf2kU71i+8tOW0p3zeTtZYReQKQopWxdZF/FAXOuWiKkLisvQvWajy199N/CO+HwNZuX2kY0lY8WJww1kzzCNPSU8lQ6mBM3/g9NLZ2yKRwyWlv3u0r3BWwYHUsnoSJ7LT1qZNmBivNqxehFxFqGKK60c75FCSugjc3zoFIeVqkpJeKOeBAb5I9/RekdYnquoh7cMoWkEKifv7jW4VmOxGV8G9spGIiyGMzwtMVbFk2QPmXeCftaK5xLy/6NvIU2XxJzdkrd7/v9Zpdo1Iwsox3DU/TudnyvA7v9VXbdOfkfWMilOFVSUIUZmsXxpeepga0xK08OwF5bKXNttFXkuUECu9AFmnLEqntx+IUC7xGL8uI5X5xa8R++tee+/F+MCICoevf2/p47rpDudzo90rb9Uki0Z59T9TvJSaQ9kVKuxsXTUxAbxesgs1bo499SAbGczaiyNN9FS7sfHOP5b1QQZr8X7/qSLVihYt/fvb14EC1eA9o3kLQmeikqYIt8puXRnAOkI4cq6J+WeIt9/cz00mMzWUNxeQgcrx66mXPT70X4n86HdfFwI6eTZ2NiwnQ+cGsareHOe0QC8ghj0ev0Fs246pJWh7QxoTitC7ppfkteqZEn5lmT8GPl/oV2Qc2JV8GR9MU12ttC1vua6j2wMulIxFtuU8vOmeav5iq7ua5hRWvNu6EjfurkmcrDcIElYt/TFFrwXu1P6PxEcjpFpdeXKWdK+hW6LsVu6IbqRMRyOc85YLR6RvvXrUMx4lgyEpXX76aWLOGZzXGDGrnhE+vbNnshKeK9oN+qBo6SfWbeLO2ZzOBwOh8PhcDgcDofD4XA4HA6Hw+FwOBwOh8PhcDgcjsnzAxLjaAdTH+ZdAAAAAElFTkSuQmCC", `mail_footer_logo`="iVBORw0KGgoAAAANSUhEUgAAAJYAAAAaCAYAAABVc6VBAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAlQSURBVHgB7VrLbiPHFa1qksnEMhzOBwSmvmAomNQo2QyFIIEMxDDnC0R9ATnbbIb6AklfIGqTLIdyAGcQJyC9cSRKwtAIklUAM8jCBvwixiONbJFdPqe6iupuFcmmoAFsiweg+lXPW7fOfZSkiEEdv10WvtjFXVbMhrbIiA259LQn5rj18K688dXWNZSKKIkL0VLPytepO8dPDBHFUkdrJVxy4vrIiYvzspjj1iPGWLIqroMzeXnvyzljzSHS9kb9cy0nlJqNbf4Phfo3fhd8wPVXuGRUT8xx63HJWCnxWMwCKlXXKpXBf/H8p/SWWivnxBy3GtqGaYf74vyZmMW/+gd08iz27jO86+kme2IhtSSbzb64BpYLhTouj5WUG0dHR40kdVZWVnL+YLCO2zKYV5tjKWXPl3JvWhulUil79uJFFSMvKaVyti7+dGUqtXNwcNCzZfP5fPbn6fQTRzN9lO9JpfYPjo/bCcrrOhjffiqVaifsIwLleR92Op26fV4pFEpKiCrmkLdz4Pzj7euykJcaDqvK98uh+fYw3814WQsrJ5FAxoFiddYquOyKpPgS1T6SV98/SwnxrX1QXbGQXr2Ocs2qWPeLxaqvVB0jCvw7pSgk3gfPmLyXSq26BFYsFvMo3xpbN0C9c3y8yRujwJ9MGg/GvY1xP0panuMTvv+oc3LSTFxHV5ONw6OjDd5DZrQ4decc4u1DAYdCPDFz7qM8N0VOOOZrMauMrSmc3QzGcSpDSqV7yovTQUuVX236gQLFDt02I9p87fXX70KAixDMXUxuVe9EsJA/HLZKYIJwXS6gVSowzU6kbjq9yPb0TJS6e6VjChJl7A/KtORhI8iAtWr3C4VapDjyfOHytg7GvsPxob3d+PhcdcK/XywsjJQXlzr75pwjcwCbsH3P80Ztg2F2OWeOl+VYnnMPjT8yXyrVOBlzDnjXtDI2YxHpICEa0H9ifOl495lD2bRyDZEXExviFcDs7DrvMcFVsEQ3/N2YpEUo3xMGJi8zmchYKAizAzcPT07qkbrBzquD0ZoQYNfVv4MBu2CDHsxRC+OhydieUp6oLReLWYxv/WU6XUlYJwI1GGhzhsXfOwyZYVO3AhNWa7fb2nIYmeWotAcha2C+N/C9fWdhYWRlWH4IGXN1XTI2zw+X33qLba1jLLR8q54YBvY4MahAZ473z+W4GhX1u3eSm9kZAB/BMu1mfMJhfDcYUJn6EHzFsgIEQT8hxx0KxamPqzupXReMMveFSr5ZwRC6DxU1v4nh+75WBMzlTdd3q1RhoC/nulMZw+WHFxc1zegwuxNlPBySoftot0Rl9IT0YHdlcj/IxUzP42bwCirq9+9siRuGdVJB+Y1J5brdLn2Ifd6fZjLB7uZJQdDIjrhBGFMQ+C5JIeU9ffW8mZTY4sL3te/EjQOztUsfalxZw2LsJwum/ASMTEbLjh+afMArvOeJcqKMyZh6HGDQtFx+vwvnnbZ6OqswtfCp4/3nUkyFEjUw18fyg780xM2BitVPYi60syk0O+R4hT9xTwntx0QWs4BFSUm5Hq+OaGkP/bQndWGiJr2BsCDNSPdwdK3/MQJMEpzod6kQZM7DTidaB03CjCtXXzRlMHurvOeirhSLG3Cut9gWKlRQT5dxRWzYiA/B9i1GwCizizHvonwXY2jHo2BhMgUfJWFuMq+UvOZ0glQuP22ozttYJDU58062Gjjef51AsX54cDKK9P0cwvhK/D38sQ8jLxBukx3Cz6cvXpSM2dBhe6x83hXpyeDHBd1wjpERm3OgUStDf4n+kRgOmTJZp6mjYmIjlcBMj8MRm7kuQhkrUMZ3RcDeeVoAsE1lZXm5dtDp7IkZwQCBuwCbqD/KvMvlv9bAXPeENREuuKLBz8coWxwU9t/ea4ibRBDy5sgE01gLo9QMZc0NBPo/KID1Ndq23MIbbzTPz89Hz9jZNQjcteGyZIdYH1zsTURr23G/RkenoX7EZc5s83CMj0c2RVCxKhLCyKBhfjavxai5ZJ3qSPmAyXRZpl3QX41BBHy2bfii+226EMxJQkZsK5yfc4ImXSlag1468iFz5+HYROlL6Y4Gv0rIVr6YeQdMA4S2j96rYIKKsDkcB0wkVOK9ZxQL5q7poy5uuWO3bVmjECOlgIkYxxg6bxN+NVG5sQmgQCNWMovewm0V42skMuczwihCG3P4muzFwMUoyxUYx7yCNMkvUbZsfNEGfvRN80MpKaf2uL60G3B6WtIPSMhGDqHlEpKZQ2q1w5n/wtHatzKZGeRuTXsNccNIZTJWIaq/YaJzDKBU9Ht0ZDMyBxA6WYQCj+eckoJthX8z1UX/Kggcshjf1Cz7JHDjmATpVFABYMK34jmzEYyJleaKiJoy7jM3NykogBvw2ETZWsZX/h9L/pr/qKceXanpMoPPRTKAreTTZk/cMDgBjIpjzQ6Q6KSChCMcCgLvyApll98DYWkGgXJtcWHCzjXbKVDhjCMv5QyRc0IcnZwwlG/jNg9TdCVqtg7/uJ+dqzFzdc41vPj8XiwU9Kbi8RTZ6vSbb+pQ6NpZJvOMEWG4P9b1zT8iWGZnYCBNohgM34rLycqYZjQs47F0ow7X6vga7AKawb/Hig7w/C9vWpqB6IMal2ZRrNGRTrBTnAuKaGfn+Ph4O1z+cvCqx0Wxxw/aOU6nN1yswnyW9Lwte0Zoo8fYEcemzXWNjluY/zo6WhRTYMuHozjHd7ofWWbNyWSzHumYc7+WnYOVW0gGfUSCS5w/zyF/RqaHLyXGyCs835Gcpsk4OFd9aGWcHjvo+0/rUC6hlSueYqBS/SeRUhHN67KVDHaak7K9UDKRQqCfgsitjgkzAMnK4PyrLZiNNmdkLvD8DHW7jIbQ3wN16V9yx+4zRxZXSMMyPZF8Hm0yhusb24Zy8yilany+9qjONCj1sW1D8ISBSV/PK0srg2CMkTl0Ax+rgjnXGZhQXpwz5YUN1sR1z+WkWxmbYOaBCMkYzvr+gesQeuLY+V+lf0614HsF0R+z7vwvhoSRICa6+irM4Bw/bKSnlvjjHWj4UMwG+CPK34EJbMyV6nZiumIJvyKSA5SP1P9rXls237txZ3eOHw+mK5ZSb042mIadpN+UH7x/rbOuOX56mK5YHhxEJcuOL3N2mmMsEqXN1W//sI08fXXOTnMkxfeFN0Uf8lZtsQAAAABJRU5ErkJggg==" WHERE `host` IS NULL;
   

3. 소나 스키마 버전을 235로 변경 - 로그프레소 셸에서 다음 명령어 수행

   > sonar.setSchemaVersion 235
   

4. 로그프레소 셸에서 나머지 마이그레이션 수행 - 로그프레소 셸에서 다음 명령어 수행

   > sonar.migrate