I have configured kea 1.3.0 with mysql and everything works but after few hours found kea is dead and spotted following error in log, I have check everything mysql running fine everything looks good in DB.
2018-06-15 11:48:55.798 INFO [kea-dhcp4.dhcp4/16020] DHCP4_STARTED Kea DHCPv4 server version 1.3.0 started 2018-06-15 12:01:29.048 ERROR [kea-dhcp4.dhcpsrv/16020] DHCPSRV_MYSQL_FATAL_ERROR Unrecoverable MySQL error occurred: unable to execute for <SELECT h.host_id, h.dhcp_identifier, h.dhcp_identifier_type, h.dhcp4_subnet_id, h.dhcp6_subnet_id, h.ipv4_address, h.hostname, h.dhcp4_client_classes, h.dhcp6_client_classes, h.dhcp4_next_server, h.dhcp4_server_hostname, h.dhcp4_boot_file_name, o.option_id, o.code, o.value, o.formatted_value, o.space, o.persistent FROM hosts AS h LEFT JOIN dhcp4_options AS o ON h.host_id = o.host_id WHERE h.dhcp4_subnet_id = ? AND h.dhcp_identifier_type = ? AND h.dhcp_identifier = ? ORDER BY h.host_id, o.option_id>, reason: MySQL server has gone away (error code: 2006). Server exiting now! 2018-06-15 12:01:29.055 INFO [kea-dhcp4.legal-log/16020] LEGAL_LOG_FILE_CLOSED @@Missing placeholder %1 for '/var/log//kea-forensic4.20180615.txt'@@ 2018-06-15 12:01:29.056 INFO [kea-dhcp4.hooks/16020] HOOKS_LIBRARY_UNLOADED hooks library /usr/lib64/hooks/libdhcp_legal_log.so successfully unloaded 2018-06-15 12:01:29.056 INFO [kea-dhcp4.lease_cmds_hooks/16020] LEASE_CMDS_DEINIT_OK 2018-06-15 12:01:29.056 INFO [kea-dhcp4.hooks/16020] HOOKS_LIBRARY_UNLOADED hooks library /usr/lib64/hooks/libdhcp_lease_cmds.so successfully unloaded 2018-06-15 12:01:29.056 INFO [kea-dhcp4.host_cmds_hooks/16020] HOST_CMDS_DEINIT_OK 2018-06-15 12:01:29.056 INFO [kea-dhcp4.hooks/16020] HOOKS_LIBRARY_UNLOADED hooks library /usr/lib64/hooks/libdhcp_host_cmds.so successfully unloaded _______________________________________________ Kea-users mailing list Kea-users@lists.isc.org https://lists.isc.org/mailman/listinfo/kea-users