[Kea-users] [*Newsletter*] [*Suspicious Email*] Re: [EXTERNAL] Kea fail start after power outage, mysql connect problem

Wagner Vlastimil - HZS Ústeckého kraje Vlastimil.Wagner at hzscr.cz
Thu Oct 31 11:05:44 UTC 2024


Not work


říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: ERROR [kea-dhcp4.dhcp4.139906395854976] DHCP4_PARSER_COMMIT_FAIL parser failed to commit changes: during update from config backend database: Can't
connect to server on '1.2.3.4' (101)
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: ERROR [kea-dhcp4.dhcp4.139906395854976] DHCP4_CONFIG_LOAD_FAIL configuration error using file: /etc/kea/kea-dhcp4.conf, reason: during update from
config backend database: Can't connect to server on '1.2.3.4' (101)
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: ERROR [kea-dhcp4.dhcp4.139906395854976] DHCP4_INIT_FAIL failed to initialize Kea server: configuration error using file '/etc/kea/kea-dhcp4.conf':
during update from config backend database: Can't connect to server on '1.2.3.4' (101)
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: 2024-10-31 11:57:32.578 INFO  [kea-dhcp4.stat-cmds-hooks/1968.139906395854976] STAT_CMDS_DEINIT_OK unloading Stat Commands hooks library successful
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: 2024-10-31 11:57:32.578 INFO  [kea-dhcp4.mysql-cb-hooks/1968.139906395854976] MYSQL_CB_DEINIT_OK unloading MYSQL CB hooks library successful
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: 2024-10-31 11:57:32.578 INFO  [kea-dhcp4.lease-cmds-hooks/1968.139906395854976] LEASE_CMDS_DEINIT_OK unloading Lease Commands hooks library
successful
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: 2024-10-31 11:57:32.578 INFO  [kea-dhcp4.hooks/1968.139906395854976] HOOKS_LIBRARY_CLOSED hooks library /usr/lib64/kea/hooks/libdhcp_stat_cmds.so
successfully closed
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: 2024-10-31 11:57:32.578 INFO  [kea-dhcp4.hooks/1968.139906395854976] HOOKS_LIBRARY_CLOSED hooks library /usr/lib64/kea/hooks/libdhcp_mysql_cb.so
successfully closed
říj 31 11:57:32 dhcp-01.example.com kea-dhcp4[1968]: 2024-10-31 11:57:32.578 INFO  [kea-dhcp4.hooks/1968.139906395854976] HOOKS_LIBRARY_CLOSED hooks library /usr/lib64/kea/hooks/libdhcp_lease_cmds.so
successfully closed
říj 31 11:57:32 dhcp-01.example.com systemd[1]: kea-dhcp4.service: Main process exited, code=exited, status=1/FAILURE




 "config-control": {
        "config-databases": [{
                "type": "mysql",
                "name": "kea",
                "user": "kea",
                "password": "gfdgfddfshfs",
                "host": "1.2.3.4",
                "port": 3306,
#               "retry-on-startup": "true",
                "max-reconnect-tries" : 30000,
                "reconnect-wait-time": 3000
            }],
        "config-fetch-wait-time": 20
    },



VW


On Čt, 2024-10-31 at 04:39 -0400, Darren Ankney wrote:
> Hi,
> 
> Kea could have a solution in 2.6.1, but I'm not sure it would work
> because you are using a name rather than an IP for the database.  So
> the name resolution is failing.  But there is a retry-on-startup
> parameter: https://kea.readthedocs.io/en/kea-2.6.1/arm/database-connectivity.html
> Since Kea was never able to actually try to connect, it may not retry.
> This would have to be tested.
> 
> Thank you,
> Darren Ankney
> 
> On Wed, Oct 30, 2024 at 2:50 AM Wagner Vlastimil - HZS Ústeckého kraje
> <Vlastimil.Wagner at hzscr.cz> wrote:
> > 
> > I made in systemd service:
> > 
> > ExecStartPre=/bin/bash -c "until host db.example.com; do sleep 1; done"
> > 
> > but i thought that Kea have solution
> > 
> > VW
> > 
> > On Út, 2024-10-29 at 12:23 +0000, Geist, Dan (CCI-Atlanta) via Kea-users wrote:
> > > 
> > > 
> > > 
> > > 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.example.com 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.example.com 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.example.com 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://www.isc.org/contact/ for more information.
> > 
> > To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users.
> > 
> > Kea-users mailing list
> > Kea-users at lists.isc.org
> > https://lists.isc.org/mailman/listinfo/kea-users



More information about the Kea-users mailing list