<div dir="ltr">Sorry for my mistake in subject message.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-02-27 15:33 GMT+01:00 Stéphane Klein <span dir="ltr"><<a href="mailto:contact@stephane-klein.info" target="_blank">contact@stephane-klein.info</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi,<br><br>I have this Kea static configuration:<br><br>```<br>{<br> "Dhcp4": {<br> "valid-lifetime": 4000,<br> "renew-timer": 1000,<br> "rebind-timer": 2000,<br> "interfaces-config": {<br> "interfaces": [ "enp0s8" ]<br> },<br> "lease-database": {<br> "type": "memfile",<br> "name": "/var/kea/dhcp4.leases"<br> },<br> "valid-lifetime": 4000,<br> "subnet4": [<br> {<br> "subnet": "<a href="http://192.168.0.0/24" target="_blank">192.168.0.0/24</a>",<br> "pools": [<br> {<br> "pool": "192.168.0.10 - 192.168.0.20"<br> }<br> ],<br> "reservations": [<br> {<br> "hw-address": "08:00:27:8e:15:8a",<br> "ip-address": "192.168.0.11"<br> },<br> {<br> "hw-address": "08:00:27:8e:15:8b",<br> "ip-address": "192.168.0.12"<br> }<br> ]<br> }<br> ],<br> "next-server": "192.168.0.254",<br> "boot-file-name": "pxelinux.0"<br> },<br> "Logging": {<br> "loggers": [<br> {<br> "name": "kea-dhcp4",<br> "output_options": [<br> {<br> "output": "stdout"<br> }<br> ],<br> "severity": "INFO"<br> }<br> ]<br> }<br>}<br>```<br><br>It works perfectly.<br><br>I would like to do the same thing with PostgreSQL backend.<br><br>I have initialized my PostgreSQL database with: [dhcpdb_create.pgsql<br>](<a href="https://github.com/isc-projects/kea/blob/master/src/share/database/scripts/pgsql/dhcpdb_create.pgsql" target="_blank">https://github.com/isc-<wbr>projects/kea/blob/master/src/<wbr>share/database/scripts/pgsql/<wbr>dhcpdb_create.pgsql</a>)<br><br>I have this kea configuration file:<br><br>```<br>{<br> "Dhcp4": {<br> "valid-lifetime": 4000,<br> "renew-timer": 1000,<br> "rebind-timer": 2000,<br> "interfaces-config": {<br> "interfaces": [ "enp0s8" ]<br> },<br> "lease-database": {<br> "type": "memfile",<br> "name": "/var/kea/dhcp4.leases"<br> },<br> "valid-lifetime": 4000,<br> "hosts-database": {<br> "type": "postgresql",<br> "name": "kea",<br> "user": "kea",<br> "password": "password",<br> "host": "127.0.0.1"<br> },<br> "subnet4": [<br> {<br> "subnet": "<a href="http://192.168.0.0/24" target="_blank">192.168.0.0/24</a>",<br> "pools": [<br> {<br> "pool": "192.168.0.10 - 192.168.0.20"<br> }<br> ]<br> }<br> ],<br> "next-server": "192.168.0.254",<br> "boot-file-name": "pxelinux.0"<br> },<br> "Logging": {<br> "loggers": [<br> {<br> "name": "kea-dhcp4",<br> "output_options": [<br> {<br> "output": "stdout"<br> }<br> ],<br> "severity": "INFO"<br> }<br> ]<br> }<br>}<br>```<br><br>Next, for now I have inserted this data in database:<br><br>```<br>DELETE FROM lease4;<br>INSERT INTO lease4 (<br> address,<br> hwaddr,<br> hostname<br>) VALUES(<br> '192.168.0.11'::inet - '0.0.0.0'::inet,<br> DECODE(REPLACE('08-00-27-8e-<wbr>15-8a', '-', ''), 'hex'),<br> 'blank_machine'<br>);<br>INSERT INTO lease4 (<br> address,<br> hwaddr,<br> hostname<br>) VALUES(<br> '192.168.0.12'::inet - '0.0.0.0'::inet,<br> DECODE(REPLACE('08-00-27-8e-<wbr>15-8b', '-', ''), 'hex'),<br> 'test-dhcp-server'<br>);<br>```<br><br>but this insert are incomplete.<br><br>Do you have example how to insert properly my host in Kea PostgreSQL database?<br><br>Best regards,<br>Stéphane<span class="HOEnZb"><font color="#888888"><br clear="all"><br>-- <br><div class="m_-7095409444812566125gmail_signature"><div dir="ltr"><div>Stéphane Klein <<a href="mailto:contact@stephane-klein.info" target="_blank">contact@stephane-klein.info</a>><br>blog: <a href="http://stephane-klein.info" target="_blank">http://stephane-klein.info</a><br>cv : <a href="http://cv.stephane-klein.info" target="_blank">http://cv.stephane-klein.info</a><br>Twitter: <a href="http://twitter.com/klein_stephane" target="_blank">http://twitter.com/klein_<wbr>stephane</a></div></div></div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
Kea-users mailing list<br>
<a href="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</a><br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/<wbr>listinfo/kea-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Stéphane Klein <<a href="mailto:contact@stephane-klein.info" target="_blank">contact@stephane-klein.info</a>><br>blog: <a href="http://stephane-klein.info" target="_blank">http://stephane-klein.info</a><br>cv : <a href="http://cv.stephane-klein.info" target="_blank">http://cv.stephane-klein.info</a><br>Twitter: <a href="http://twitter.com/klein_stephane" target="_blank">http://twitter.com/klein_stephane</a></div></div></div>
</div>