[#3982] Addressed comments

[#3982] Improved Botan version

[#3982] Last improvements

[#3982] Checkpoint: applied proposal

[#3982] Checkpoint

[#4368] Grammar

[#4368] Addressed comments

[#4368] Final improvements

[#4368] Almost finished

[#4368] Checkpoint

[#4368] Added a comment about unicast option

[#4368] Cleaned up IA_TA references

[#4341] Addressed comments

[#4341] Spelling

[#4341] Checkpoint: lib UTs done

[#4341] Checkpoint: UT and doc to do

[#4341] Made emulate flag static.class

[#4481] change version to 3.1.9

[#4481] Bump up versions after release

[#4481] Bump up versions after release

[#4465] Bump up timeout of dhcp-ha-lib-tests

[#4464] increase queue size to not drop pkts

[#4480] Combine debug log into single line

[#4480] Fix MariaDB version detection

Version string was parsed with [0:1] instead of [0:2], yielding only
the major number (e.g. '11' instead of '11.8'), so zero_conf_tls was
never set correctly. Also, systemctl status exits with code 3 when
the service is inactive, causing an ExecutionError; fixed by adding
raise_error=False.

[#4348] Imported other core updates

[#4348] Updated checkContext

[#4348] Made state and event signed

[#4493] Added ChangeLog

[#4493] Proposed fix

[#4450] Hammer: use abs path for meson install

[#4352] Avoid reports and improved code

[#4459] Regenerated message documentation

[#4459] Fix HA_PAUSE_CLIENT_LISTENER_FAILED

[#4489] A few more nits.

modified:   doc/sphinx/arm/dhcp4-srv.rst
modified:   doc/sphinx/arm/dhcp6-srv.rst

[#4489] One more nit.

modified:   doc/sphinx/arm/dhcp6-srv.rst

[#4489] Addressed further comments

modified:   doc/sphinx/arm/dhcp4-srv.rst
modified:   doc/sphinx/arm/dhcp6-srv.rst

[#4489] Addressed review comments

modified:   doc/sphinx/arm/dhcp4-srv.rst
modified:   doc/sphinx/arm/dhcp6-srv.rst

[#4489] Added ChangeLog

new file:   4489-shared-flq-allocator-add-arm-documentation-for-sflq

[#4489] Minor fixes

modified:   doc/sphinx/arm/dhcp4-srv.rst
modified:   doc/sphinx/arm/dhcp6-srv.rst

[#4489] Added SFLQ to V6 arm

modified:   doc/sphinx/arm/dhcp4-srv.rst
modified:   doc/sphinx/arm/dhcp6-srv.rst

[#4489] Added SFLQ section of dhcp4-srv.rst

    modified:   doc/sphinx/arm/dhcp4-srv.rst

[#4438] Spelling

[#4438] Added ChangeLog entry

[#4438] Removed obsolete lossless comment

[#4438] Updated netconf UT

[#4438] Fixed and improvements

[#4438] Updated lexer and fromJSON

[#4466] Fixed duplicate messages

modified:   src/hooks/dhcp/mysql/mysql_lb_messages.mes
modified:   src/hooks/dhcp/pgsql/pgsql_lb_messages.mes

[#4466] A few more fixes

modified:   src/hooks/dhcp/mysql/mysql_lease_mgr.h
modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.h

[#4466] Addressed review comments

modified:   src/hooks/dhcp/mysql/mysql_lb_messages.cc
modified:   src/hooks/dhcp/mysql/mysql_lb_messages.mes
modified:   src/hooks/dhcp/mysql/mysql_lease_mgr.cc
modified:   src/hooks/dhcp/mysql/mysql_lease_mgr.h
modified:   src/hooks/dhcp/pgsql/pgsql_lb_messages.cc
modified:   src/hooks/dhcp/pgsql/pgsql_lb_messages.mes
modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.h
modified:   src/lib/dhcpsrv/lease_mgr.cc
modified:   src/lib/dhcpsrv/lease_mgr.h
modified:   src/lib/dhcpsrv/sflq_allocator.h
modified:   src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.cc
modified:   src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.h

[#4466] Minor cleanups

modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
modified:   src/lib/asiolink/addr_utilities.h
modified:   src/lib/dhcpsrv/lease_mgr.h
modified:   src/lib/dhcpsrv/sflq_allocation_state.h
modified:   src/lib/dhcpsrv/sflq_allocator.h
modified:   src/lib/dhcpsrv/tests/lease_mgr_unittest.cc
modified:   src/lib/dhcpsrv/testutils/sflqtest_lease_mgr.h

[#4466] Added concurrent pool create UT

modified:   src/hooks/dhcp/mysql/tests/mysql_lease_mgr_unittest.cc
modified:   src/hooks/dhcp/pgsql/tests/pgsql_lease_mgr_unittest.cc
modified:   src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.cc
modified:   src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.h

[#4466] Added new SFLQ API funcs to PgSqlLeaseMgr

/src/hooks/dhcp/pgsql/pgsql_lb_messages.*
    PGSQL_LB_SFLQ_POOL4_GET_ALL
    PGSQL_LB_SFLQ_POOL4_GET_BY_SUBNET
    PGSQL_LB_SFLQ_POOL4_GET_BY_RANGE
    PGSQL_LB_SFLQ_POOL4_DELETE delete
    PGSQL_LB_SFLQ_POOL6_GET_ALL fetch
    PGSQL_LB_SFLQ_POOL6_GET_BY_SUBNET
    PGSQL_LB_SFLQ_POOL6_GET_BY_RANGE
    PGSQL_LB_SFLQ_POOL6_DELETE
    - new messages

/src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
    PgSqlLeaseMgr::SFLQ_POOL4_GET_ALL
    PgSqlLeaseMgr::SFLQ_POOL4_GET_BY_SUBNET
    PgSqlLeaseMgr::SFLQ_POOL4_GET_BY_RANGE
    PgSqlLeaseMgr::SFLQ_POOL4_DELETE
    PgSqlLeaseMgr::SFLQ_POOL6_GET_ALL
    PgSqlLeaseMgr::SFLQ_POOL6_GET_BY_SUBNET
    PgSqlLeaseMgr::SFLQ_POOL6_GET_BY_RANGE
    PgSqlLeaseMgr::SFLQ_POOL6_DELETE
    - new SQL statements

    PgSqlLeaseMgr::sflqCreateFlqPool4()
    PgSqlLeaseMgr::sflqPickFreeLease4()
    PgSqlLeaseMgr::sflqCreateFlqPool6()
    PgSqlLeaseMgr::sflqPickFreeLease6()
    - added range adddress validation

    PgSqlLeaseMgr::sflqPool4GetAll()
    PgSqlLeaseMgr::sflqPool4Get(*)
    PgSqlLeaseMgr::sflqPool4Del()
    PgSqlLeaseMgr::sflqPool6GetAll()
    PgSqlLeaseMgr::sflqPool6Get(*)
    PgSqlLeaseMgr::sflqPool6Del()
    PgSqlLeaseMgr::sflqPoolGetCommon()
    PgSqlLeaseMgr::sflqPoolDelCommon()
    - new functions

[#4466] Added new SFLQ API funcs to MySqlLeaseMgr

/src/hooks/dhcp/mysql/mysql_lb_messages.*
    MYSQL_LB_SFLQ_POOL4_GET_ALL
    MYSQL_LB_SFLQ_POOL4_GET_BY_SUBNET
    MYSQL_LB_SFLQ_POOL4_GET_BY_RANGE
    MYSQL_LB_SFLQ_POOL4_DELETE delete
    MYSQL_LB_SFLQ_POOL6_GET_ALL fetch
    MYSQL_LB_SFLQ_POOL6_GET_BY_SUBNET
    MYSQL_LB_SFLQ_POOL6_GET_BY_RANGE
    MYSQL_LB_SFLQ_POOL6_DELETE
    - new messages

/src/hooks/dhcp/mysql/mysql_lease_mgr.cc
    MySqlLeaseMgr::SFLQ_POOL4_GET_ALL
    MySqlLeaseMgr::SFLQ_POOL4_GET_BY_SUBNET
    MySqlLeaseMgr::SFLQ_POOL4_GET_BY_RANGE
    MySqlLeaseMgr::SFLQ_POOL4_DELETE
    MySqlLeaseMgr::SFLQ_POOL6_GET_ALL
    MySqlLeaseMgr::SFLQ_POOL6_GET_BY_SUBNET
    MySqlLeaseMgr::SFLQ_POOL6_GET_BY_RANGE
    MySqlLeaseMgr::SFLQ_POOL6_DELETE
    - new SQL statements

    MySqlLeaseMgr::sflqCreateFlqPool4()
    MySqlLeaseMgr::sflqPickFreeLease4()
    MySqlLeaseMgr::sflqCreateFlqPool6()
    MySqlLeaseMgr::sflqPickFreeLease6()
    - added range adddress validation

    MySqlLeaseMgr::sflqPool4GetAll()
    MySqlLeaseMgr::sflqPool4Get(*)
    MySqlLeaseMgr::sflqPool4Del()
    MySqlLeaseMgr::sflqPool6GetAll()
    MySqlLeaseMgr::sflqPool6Get(*)
    MySqlLeaseMgr::sflqPool6Del()
    MySqlLeaseMgr::sflqPoolGetCommon()
    MySqlLeaseMgr::sflqPoolDelCommon()
    - new functions

/src/hooks/dhcp/mysql/tests/mysql_lease_mgr_unittest.cc
    TEST_F(MySqlLeaseMgrTest, testSflqAPIFuncs4)
    TEST_F(MySqlLeaseMgrTest, testSflqAPIFuncs6NA)
    TEST_F(MySqlLeaseMgrTest, testSflqAPIFuncs6PD)
    TEST_F(MySqlLeaseMgrTest, testSflqAPIOverlappingPools4)
    TEST_F(MySqlLeaseMgrTest, testSflqAPIOverlappingPools6NA)
    TEST_F(MySqlLeaseMgrTest, testSflqAPIOverlappingPools6PD)
    - new tests

/src/hooks/dhcp/pgsql/tests/pgsql_lease_mgr_unittest.cc
    TEST_F(PgSqlLeaseMgrTest, testSflqAPIFuncs4)
    TEST_F(PgSqlLeaseMgrTest, testSflqAPIFuncs6NA)
    TEST_F(PgSqlLeaseMgrTest, testSflqAPIFuncs6PD)
    TEST_F(PgSqlLeaseMgrTest, testSflqAPIOverlappingPools4)
    TEST_F(PgSqlLeaseMgrTest, testSflqAPIOverlappingPools6NA)
    TEST_F(PgSqlLeaseMgrTest, testSflqAPIOverlappingPools6PD)
    - new tests - currently fail with NotImplemented

/src/lib/asiolink/addr_utilities.*
    void validateV4Range() - new funcion
    void validateV6Range() - new funcion

/src/lib/dhcpsrv/lease_mgr.*
    SflqPoolInfo::SflqPoolInfo() - new class

    LeaseMgr::sflqPool4GetAll()
    LeaseMgr::sflqPool4Get(SubnetID)
    LeaseMgr::sflqPool4Get(asiolink::IOAddress, asiolink::IOAddress)
    LeaseMgr::sflqPool4Del(asiolink::IOAddress, asiolink::IOAddress, bool)
    LeaseMgr::sflqPool6GetAll()
    LeaseMgr::sflqPool6Get(SubnetID)
    LeaseMgr::sflqPool6Get(asiolink::IOAddress, asiolink::IOAddress)
    LeaseMgr::sflqPool6Del(asiolink::IOAddress, asiolink::IOAddress, bool)
    - new functions - all throw NotImplemented

 typedef boost::shared_ptr<LeaseStatsRow> LeaseStatsRowPtr;

/src/lib/dhcpsrv/tests/lease_mgr_unittest.cc
    TEST(SflqPoolInfo, toElement) - new test

/src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.cc
    GenericLeaseMgrTest::testSflqAPIFuncs4()
    GenericLeaseMgrTest::testSflqAPIFuncs6()
    GenericLeaseMgrTest::testSflqAPIOverlappingPools4()
    GenericLeaseMgrTest::testSflqAPIOverlappingPools6()
    - new test

[#4480] Make hammer.py work on Fedora 44

MariaDB >= 11.8 introduced zero conf TLS. We rely on that instead of
creating our own certificates. It seems something upset the MariaDB
server about the certificates we were previously creating.

[#4480] Remove unnecessary EOF here-documents from hammer.py

Started looking into this to see if it fixes the env var in the previous
commit not propagating thorugh sudo. It did not. But the code is much
cleaner this way. Also it uncovered that the preivous approach hid
errors. Because immediately after switching to this, I got an error on
SQL statement: "GRANT ALL PRIVILEGES ON DATABASE keauser TO keadb;"
which is wrong because database and user parameters are swapped. The
parameters were also fixed in this commit.

[#4480] Make hammer.py work on Ubuntu 26.04

- Add 'make' to NETCONF dependencies. It's required to build libyang and sysrepo.
- sudo seems to behave differently. Add explicit PGPASSWORD.

[#4453] Changed map into list

[#4453] formatting

[#4453] Added ChangeLog entry

[#4453] Extended syntaxes

[#4445] Fixed typo

[#4478] fixed more typos

[#4478] added missing issue number

[#4478] fixed typo

[#4478] release changes

[#4472] bump up library versions for 3.1.8 release

[#3636] Add ReplicatingFuzzingIssues subsection to fuzz.dox

[#4160] Fix rpath for kea-msg-compiler

[#4344] Added a changelog entry

[#4344] Close connection once

[#4344] Unregister once

[#4314] Fixed indentation

[#4314] Fixed json

[#4314] Updated doc

[#4367] handle all exceptions

[#3985] Fix version in conf.py for EPUB generation in RTD

[#3144] fixed unit tests related to #3062

[#3144] detect before inactivating

[#4154] Spelling

[#4154] Applied RFC 4578 Errata

[#3970] Added reject of all HTTP or TLS keywords

[#3985] Fix `-git` not appearing in ARM for non-released versions

[#4475] Define constexprs in sflq_allocator.cc

  modified: src/lib/dhcpsrv/sflq_allocator.cc

[#4473] fix Changelog etries

[#4376] Change DDNS Lease Length to TTL in log

[#3448] fixed netconf

[#4447] Fixed missed typos

modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc

[#4447] Addresses review comments

modified:   changelog_unreleased/4447-shared-flq-allocator-reconcile-sflq-pool-create-and-pick-free-lease-inconsistency
modified:   src/hooks/dhcp/mysql/mysql_lease_mgr.cc
modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
modified:   src/lib/dhcpsrv/sflq_allocator.cc

[#4447] Removed left joins from pick functions

Left joins are perf killers. Relying on free
leseseX consistency instead.

a/src/bin/admin/tests/mysql_tests.sh.in
    mysql_sflqPickFreeLease6()
    mysql_sflqPickFreeLease6()
    - updated tests

/src/bin/admin/tests/pgsql_tests.sh.in
    pgsql_sflqPickFreeLease6()
    pgsql_sflqPickFreeLease6()
    - updated tests

/src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.cc
    GenericLeaseMgrTest::testSflqLeaseOps4()
    GenericLeaseMgrTest::testSflqLeaseOps6()
    - updated tests

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    - remove left join from SFLQ pick functions

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    - remove left join from SFLQ pick functions

[#4447] Remove checks after rebase

modified:   src/share/database/scripts/mysql/dhcpdb_create.mysql
modified:   src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
modified:   src/share/database/scripts/pgsql/dhcpdb_create.pgsql
modified:   src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in

[#4447] Fix update stored procedures

Fix merge mistake which left expiration check in update
stored procedures.

modified:   src/bin/admin/tests/mysql_tests.sh.in
modified:   src/share/database/scripts/mysql/dhcpdb_create.mysql
modified:   src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
modified:   src/share/database/scripts/pgsql/dhcpdb_create.pgsql
modified:   src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in

[#4447] Do not include expired in SFLQ

/src/bin/admin/tests/mysql_tests.sh.in
    Updated tests:
    mysql_sflqCreateFlqPool4()
    mysql_sflqCreateFlqPool6()
    mysql_sflqInsertLease4()
    mysql_sflqUpdateLease4()
    mysql_sflqInsertLease6()
    mysql_sflqUpdateLease6()

/src/bin/admin/tests/pgsql_tests.sh.in
    Updated tests:
    pgsql_sflqCreateFlqPool4()
    pgsql_sflqCreateFlqPool6()
    pgsql_sflqInsertLease4()
    pgsql_sflqUpdateLease4()
    pgsql_sflqInsertLease6()
    pgsql_sflqUpdateLease6()

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    Updated functions:
    sflqCreateFlqPool4()
    sflqCreateFlqPool6()
    sflqInsertLease4()
    sflqUpdateLease4()
    sflqInsertLease6()
    sflqUpdateLease6()

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    Updated functions:
    sflqCreateFlqPool4()
    sflqCreateFlqPool4()
    sflqCreateFlqPool6()
    sflqInsertLease4()
    sflqUpdateLease4()
    sflqInsertLease6()
    sflqUpdateLease6()

[#4454] addressed review comments

[#4454] remove solaris iface_mgr

[#3448] addressed review

[#3448] Fixed json

[#3448] Removed extra CA refs in examples

[#3448] Moved rbac example

[#3448] Fixed rebase