<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div style="font-family: Verdana;font-size: 12.0px;">
<div>Hello,</div>
<div>I've set up kea with mysql and would like to use the configuration backend to store everything in a database. When I start kea it creates the following errors:</div>
<div> </div>
<div><em>INFO/keactrl: Starting /usr/local/sbin/kea-dhcp4 -c /usr/local/etc/kea/kea-dhcp4.conf<br/>
INFO/keactrl: Starting /usr/local/sbin/kea-ctrl-agent -c /usr/local/etc/kea/kea-ctrl-agent.conf<br/>
root@xxx:~# 2021-07-30 10:07:11.127 INFO [kea-dhcp4.hosts/72005.140077962851840] HOSTS_BACKENDS_REGISTERED the following host backend types are available: mysql<br/>
2021-07-30 10:07:11.128 INFO [kea-dhcp4.dhcpsrv/72005.140077962851840] DHCPSRV_CFGMGR_ADD_IFACE listening on interface ens160<br/>
2021-07-30 10:07:11.128 INFO [kea-dhcp4.dhcpsrv/72005.140077962851840] DHCPSRV_CFGMGR_SOCKET_TYPE_DEFAULT "dhcp-socket-type" not specified , using default socket type raw<br/>
2021-07-30 10:07:11.129 INFO [kea-dhcp4.hooks/72005.140077962851840] HOOKS_LIBRARY_CLOSED hooks library /usr/local/lib/kea/hooks/libdhcp_mysql_cb.so successfully closed<br/>
2021-07-30 10:07:11.129 INFO [kea-dhcp4.commands/72005.140077962851840] COMMAND_ACCEPTOR_START Starting to accept connections via unix domain socket bound to /tmp/kea4-ctrl-socket<br/>
2021-07-30 10:07:11.131 INFO [kea-dhcp4.mysql-cb-hooks/72005.140077962851840] MYSQL_CB_INIT_OK loading MYSQL CB hooks library successful<br/>
2021-07-30 10:07:11.131 INFO [kea-dhcp4.hooks/72005.140077962851840] HOOKS_LIBRARY_LOADED hooks library /usr/local/lib/kea/hooks/libdhcp_mysql_cb.so successfully loaded<br/>
2021-07-30 10:07:11.131 INFO [kea-dhcp4.dctl/72005.140077962851840] DCTL_OPEN_CONFIG_DB Opening configuration database: host=x.x.x.x name=kea password=***** port=xxxx type=mysql user=kea<br/>
2021-07-30 10:07:11.140 ERROR [kea-dhcp4.dhcp4/72005.140077962851840] DHCP4_PARSER_COMMIT_FAIL parser failed to commit changes: during update from config backend database: unable to prepare MySQL statement <SELECT g.id, g.name, g.value, g.parameter_type, g.modification_ts, s.tag FROM dhcp4_global_parameter AS g INNER JOIN dhcp4_global_parameter_server AS a ON g.id = a.parameter_id INNER JOIN dhcp4_server AS s ON (a.server_id = s.id) WHERE (s.tag = ? OR s.id = 1) AND g.name = ? ORDER BY g.id, s.id>, reason: Unknown column 'g.parameter_type' in 'field list'<br/>
2021-07-30 10:07:11.140 ERROR [kea-dhcp4.dhcp4/72005.140077962851840] DHCP4_CONFIG_LOAD_FAIL configuration error using file: /usr/local/etc/kea/kea-dhcp4.conf, reason: during update from config backend database: unable to prepare MySQL statement <SELECT g.id, g.name, g.value, g.parameter_type, g.modification_ts, s.tag FROM dhcp4_global_parameter AS g INNER JOIN dhcp4_global_parameter_server AS a ON g.id = a.parameter_id INNER JOIN dhcp4_server AS s ON (a.server_id = s.id) WHERE (s.tag = ? OR s.id = 1) AND g.name = ? ORDER BY g.id, s.id>, reason: Unknown column 'g.parameter_type' in 'field list'<br/>
2021-07-30 10:07:11.140 ERROR [kea-dhcp4.dhcp4/72005.140077962851840] DHCP4_INIT_FAIL failed to initialize Kea server: configuration error using file '/usr/local/etc/kea/kea-dhcp4.conf': during update from config backend database: unable to prepare MySQL statement <SELECT g.id, g.name, g.value, g.parameter_type, g.modification_ts, s.tag FROM dhcp4_global_parameter AS g INNER JOIN dhcp4_global_parameter_server AS a ON g.id = a.parameter_id INNER JOIN dhcp4_server AS s ON (a.server_id = s.id) WHERE (s.tag = ? OR s.id = 1) AND g.name = ? ORDER BY g.id, s.id>, reason: Unknown column 'g.parameter_type' in 'field list'<br/>
2021-07-30 10:07:11.141 INFO [kea-dhcp4.mysql-cb-hooks/72005.140077962851840] MYSQL_CB_DEINIT_OK unloading MYSQL CB hooks library successful<br/>
2021-07-30 10:07:11.141 INFO [kea-dhcp4.hooks/72005.140077962851840] HOOKS_LIBRARY_CLOSED hooks library /usr/local/lib/kea/hooks/libdhcp_mysql_cb.so successfully closed</em><br/>
</div>
<div>Kea seems to be missing the column "parameter_type" in table "dhcp4_global_parameter_server". When checking the mysql script it is not intended to create the column in this table. Can I ignore these errors or is there something I could do to get rid of it?</div>
<div> </div>
<div>Thanks and regards</div>
<div>Johannes</div>
</div></div></body></html>