<html><head><style>p{margin-top:0px;margin-bottom:0px;}</style></head><body><div style="font-size:10pt; font-family:Gulim, sans-serif;"><p><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);">I am testing to use Kea instead of dhcpd.</span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"></span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);">I am using mysql as the hosts backend of kea.</span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);">The schema version is 8.2. I am using the hosts table well for host reservation purposes. (<a href="https://gitlab.isc.org/isc-projects/kea/-/wikis/docs/editing-host-reservations">https://gitlab.isc.org/isc-projects/kea/-/wikis/docs/editing-host-reservations</a>)</span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);">However, I would like to use only Mysql, not /etc/kea/kea-dhcp4.conf configuration file.</span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"></span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"></span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);">For example, instead of config below, I would like to use mysql's table to set up a subnet.</span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);">"subnet4": [ { "subnet": "192.0.2.0/24", "reservations": [ {"hw-address": "1a:1b:1c:1d:1e:1f", "ip-address": "192.0.2.201"} ]}</span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"></span><br style="font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);"><span style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; font-family: "Noto Sans", "Noto Sans JP", "Noto Sans KR", Helvetica, "Microsoft YaHei", "Apple SD Gothic Neo", "Malgun Gothic", "맑은 고딕", Dotum, 돋움, sans-serif; font-size: 18px; background-color: rgb(253, 253, 253);">I only use host table, but I don't know how to insert data for other tables. Please give me a guide for insert.</span> </p></div></body></html><table style='display:none'><tr><td><img src="https://mail.naver.com/readReceipt/notify/?img=owYmFzlG%2BBFCMxbYaqEraxudMxJoKxKZpopCMrUdFzEqFo3CKrEra6ioauIo%2BrkSKAuw74lR74l4b4u516YQarR0ML99brkZbdIn1BFdbZlGbrK5WXiN.gif" border="0"/></td></tr></table>