Hello,
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:
INFO/keactrl: Starting /usr/local/sbin/kea-dhcp4 -c /usr/local/etc/kea/kea-dhcp4.conf
INFO/keactrl: Starting /usr/local/sbin/kea-ctrl-agent -c /usr/local/etc/kea/kea-ctrl-agent.conf
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
2021-07-30 10:07:11.128 INFO [kea-dhcp4.dhcpsrv/72005.140077962851840] DHCPSRV_CFGMGR_ADD_IFACE listening on interface ens160
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
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
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
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
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
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
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'
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'
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'
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
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
INFO/keactrl: Starting /usr/local/sbin/kea-ctrl-agent -c /usr/local/etc/kea/kea-ctrl-agent.conf
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
2021-07-30 10:07:11.128 INFO [kea-dhcp4.dhcpsrv/72005.140077962851840] DHCPSRV_CFGMGR_ADD_IFACE listening on interface ens160
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
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
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
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
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
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
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'
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'
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'
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
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
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?
Thanks and regards
Johannes
_______________________________________________ ISC funds the development of this software with paid support subscriptions. Contact us at https://www.isc.org/contact/ for more information.
To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users. Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
