[Kea-users] [EXTERNAL] Kea fail start after power outage, mysql connect problem

[Geist, Dan (CCI-Atlanta)]

Have you considered putting in a “watchdog” timer at the operating system level to restart the OS after a number of minutes (if network link is down) to allow your network gear more time to recover?

From: Kea-users <kea-users-bounces at lists.isc.org> on behalf of Wagner Vlastimil - HZS Ústeckého kraje <Vlastimil.Wagner at hzscr.cz>
Date: Tuesday, October 29, 2024 at 8:00 AM
To: kea-users at lists.isc.org <kea-users at lists.isc.org>
Subject: [EXTERNAL] [Kea-users] Kea fail start after power outage, mysql connect problem
Hi

I have Kea servers on places where sometimes doesnt work power (longer than UPS)
I have config, leases and hosts in database MySQL
When power is back server get up faster than switches and routers so interface is down and Kea doesnt start

říj 29 12:42:15 dhcp-01.hzsulk.cz kea-dhcp4[8647]: ERROR [kea-dhcp4.dhcp4.140105088432256] DHCP4_CONFIG_LOAD_FAIL configuration error using file: /etc/kea/kea-dhcp4.conf, reason: during update from config backend database: Unknown server host 'db.example.com' (-2)
říj 29 12:42:15 dhcp-01.hzsulk.cz kea-dhcp4[8647]: ERROR [kea-dhcp4.dhcp4.140105088432256] DHCP4_INIT_FAIL failed to initialize Kea server: configuration error using file '/etc/kea/kea-dhcp4.conf': during update from config backend database: Unknown server host 'db.example.com' >
říj 29 12:42:15 dhcp-01.hzsulk.cz kea-dhcp4[8647]: ERROR [kea-dhcp4.dhcp4.140105088432256] DHCP4_PARSER_COMMIT_FAIL parser failed to commit changes: during update from config backend database: Unknown server host 'db.example.com' (-2)


Config is:


"Dhcp4": {
    "server-tag": "DHCP-01",
    "interfaces-config": {
        "interfaces": ["ens33"],
        "service-sockets-max-retries": 100,
        "service-sockets-retry-wait-time": 5000
    },
    "config-control": {
        "config-databases": [{
                "type": "mysql",
                "name": "kea",
                "user": "kea",
                "password": "fhgfethfgthtfeg",
                "host": "db.example.com",
                "port": 3306,
#               "retry-on-startup": "true",
                "max-reconnect-tries" : 30000,
                "reconnect-wait-time": 3000
            }],
        "config-fetch-wait-time": 20
    },

No setting work to try connect again


VW
--
ISC funds the development of this software with paid support subscriptions. Contact us at https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&data=05%7C02%7Cdan.geist%40cox.com%7C34ce6c43dd16473322f208dcf8113d70%7C9feebc97ff0442c9a152767073872118%7C1%7C0%7C638658000201454565%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=YyAIuowltu%2FHI4FiN5Q5OU5Zzg5LoHeXIZw%2BfNK%2Bnn0%3D&reserved=0<https://www.isc.org/contact/> for more information.

To unsubscribe visit https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=05%7C02%7Cdan.geist%40cox.com%7C34ce6c43dd16473322f208dcf8113d70%7C9feebc97ff0442c9a152767073872118%7C1%7C0%7C638658000201479405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=2AVX6msPo9CIFVkdBWmUu2ZM2e%2BFr9Hwid9cg4CM9Hg%3D&reserved=0<https://lists.isc.org/mailman/listinfo/kea-users>.

Kea-users mailing list
Kea-users at lists.isc.org
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=05%7C02%7Cdan.geist%40cox.com%7C34ce6c43dd16473322f208dcf8113d70%7C9feebc97ff0442c9a152767073872118%7C1%7C0%7C638658000201494671%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=tYR3rNuy1%2FmtiOmtiagSOhKedTCpQqSWfGOqFowT1IE%3D&reserved=0<https://lists.isc.org/mailman/listinfo/kea-users>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20241029/0ebeb53f/attachment-0001.htm>