[#3144] added unit tests

[#3144] implemented commands

[#3144] updated doc

[#4480] Another fix for mariadbd version in hammer.py

[#4491] Added ChangeLog entry

new file:   changelog_unreleased/4491-shared-flq-allocator-fix-postgresql-pd-pool-free-lease-generation

[#4491] Updated ARM doc

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

[#4491] Addressed review comments

Fixed nits and revamped sflqCreateFlqPool6
stored functions to use SELECT FOR UPDATE.

modified:   src/hooks/dhcp/mysql/mysql_lease_mgr.cc
modified:   src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
modified:   src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.cc
modified:   src/share/database/scripts/mysql/dhcpdb_create.mysql
modified:   src/share/database/scripts/mysql/upgrade_034_to_035.sh.in
modified:   src/share/database/scripts/pgsql/dhcpdb_create.pgsql
modified:   src/share/database/scripts/pgsql/upgrade_033_to_034.sh.in

[#4491] Fix SFLQ create functions

new file:   src/share/database/scripts/mysql/upgrade_034_to_035.sh.in
new file:   src/share/database/scripts/pgsql/upgrade_033_to_034.sh.in

/src/bin/admin/tests/mysql_tests.sh.in
    mysql_upgrade_34_to_35_test()
    - new test

/src/bin/admin/tests/pgsql_tests.sh.in
    pgsql_upgrade_33_to_34_test()
    - new test

/src/hooks/dhcp/mysql/mysql_lease_mgr.cc
    MySqlLeaseMgr::sflqCreateFlqPool4()
    MySqlLeaseMgr::sflqCreateFlqPool6()
    - wrap create call in transaction

/src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
    PgSqlLeaseMgr::sflqCreateFlqPool4()
    PgSqlLeaseMgr::sflqCreateFlqPool6()
    - wrap create call in transaction

/src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.cc
    GenericLeaseMgrTest::sflqCreateFlqPool4Concurrent()
    GenericLeaseMgrTest::sflqCreateFlqPool6Concurrent()
    - add more threads and test recreate

/src/lib/mysql/mysql_constants.h
/src/lib/pgsql/pgsql_connection.h
    Update schema version to 35

/src/share/database/scripts/mysql/dhcpdb_create.mysql
    sflqCreateFlqPool4()
    - remove transaction statements.

    sflqCreateFlqPool6()
    - remove transaction statements.
    - add recreate on delegated_len change logic
    - update flq_pool6 values on recreate

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
    sflqCreateFlqPool6()
    - add recreate on delegated_len change logic
    - update flq_pool6 values on recreate
    - fix end address overrun

[#4480] More hammer.py updates for Fedora 44 and Ubuntu 26.04

[#4492] Fixed a few more nits

modified:   src/hooks/dhcp/lease_cmds/lease_cmds_messages.cc
modified:   src/hooks/dhcp/lease_cmds/lease_cmds_messages.mes
modified:   src/hooks/dhcp/lease_cmds/sflq_cmds.cc
modified:   src/share/api/sflq-pool4-rebuild.json

[#4492] Addressed more comments

modified:   doc/sphinx/arm/hooks-lease-cmds.rst
modified:   src/hooks/dhcp/lease_cmds/lease_cmds_messages.cc
modified:   src/hooks/dhcp/lease_cmds/lease_cmds_messages.mes
modified:   src/lib/cc/simple_parser.h

[#4492] Replaced create cmd with rebuild cmd

Replaced sflq-poolX-create with sflq-poolX-rebuild,
the latter takes only start and end addresses and
the pool must already exist.

/src/hooks/dhcp/lease_cmds/lease_cmds_callouts.cc
/src/hooks/dhcp/lease_cmds/lease_cmds_messages.mes
/src/hooks/dhcp/lease_cmds/libloadtests/lease_cmds_unittest.cc
/src/hooks/dhcp/lease_cmds/libloadtests/sflq_cmds_unittests.cc
/src/hooks/dhcp/lease_cmds/sflq_cmds.cc
/src/hooks/dhcp/lease_cmds/sflq_cmds.h

/doc/sphinx/api-files.txt
/doc/sphinx/arm/hooks-lease-cmds.rst
/src/share/api/sflq-pool4-rebuild.json
/src/share/api/sflq-pool6-rebuild.json

/src/hooks/dhcp/mysql/mysql_lease_mgr.cc
    fixed a shadow warning

[#4492] Addressed Minor review comments

modified:   ../../../../doc/sphinx/arm/hooks-lease-cmds.rst
modified:   libloadtests/sflq_cmds_unittests.cc
modified:   sflq_cmds.cc
modified:   ../../../lib/cc/simple_parser.h
modified:   ../../../lib/dhcpsrv/lease_mgr.h

[#4492] Addressed some initial comments

Mostly typos and  minor fixes

modified:   doc/sphinx/arm/dhcp4-srv.rst
modified:   doc/sphinx/arm/dhcp6-srv.rst
modified:   doc/sphinx/arm/hooks-lease-cmds.rst
modified:   src/hooks/dhcp/lease_cmds/lease_cmds_messages.cc
modified:   src/hooks/dhcp/lease_cmds/libloadtests/sflq_cmds_unittests.cc
modified:   src/hooks/dhcp/lease_cmds/sflq_cmds.cc
modified:   src/hooks/dhcp/lease_cmds/sflq_cmds.h
modified:   src/lib/dhcp/tests/iface_mgr_unittest.cc
modified:   src/lib/dhcpsrv/testutils/sflqtest_lease_mgr.h
modified:   src/share/api/sflq-pool4-create.json
modified:   src/share/api/sflq-pool4-del.json
modified:   src/share/api/sflq-pool4-get-all.json
modified:   src/share/api/sflq-pool4-get-by-range.json
modified:   src/share/api/sflq-pool4-get-by-subnet.json
modified:   src/share/api/sflq-pool6-create.json
modified:   src/share/api/sflq-pool6-del.json
modified:   src/share/api/sflq-pool6-get-all.json
modified:   src/share/api/sflq-pool6-get-by-range.json
modified:   src/share/api/sflq-pool6-get-by-subnet.json

[#4492] Finished API doc

/doc/sphinx/api-files.txt
    Added API files

/doc/sphinx/arm/hooks-lease-cmds.rst
    Documented SFLQ commands

/src/hooks/dhcp/lease_cmds/lease_cmds_messages.mes
    Removed command args from get-all messages

/src/hooks/dhcp/lease_cmds/libloadtests/sflq_cmds_unittests.cc
    Udpated UTs

/src/hooks/dhcp/lease_cmds/sflq_cmds.*
    Improved arg handling

/src/share/api/sflq-pool4-del.json
/src/share/api/sflq-pool4-get-all.json
/src/share/api/sflq-pool4-get-by-range.json
/src/share/api/sflq-pool4-get-by-subnet.json
/src/share/api/sflq-pool6-create.json
/src/share/api/sflq-pool6-del.json
    finihsed API files

[#4492] Added remaining bad parameter UTs

modified:   src/hooks/dhcp/lease_cmds/libloadtests/sflq_cmds_unittests.cc

[#4492] Fix message file, add API files

modified:   src/hooks/dhcp/lease_cmds/lease_cmds_messages.mes
modified:   src/share/api/sflq-pool4-create.json
new file:   src/share/api/sflq-pool4-del.json
modified:   src/share/api/sflq-pool4-get-all.json
new file:   src/share/api/sflq-pool4-get-by-range.json
new file:   src/share/api/sflq-pool4-get-by-subnet.json
new file:   src/share/api/sflq-pool6-create.json
new file:   src/share/api/sflq-pool6-del.json
new file:   src/share/api/sflq-pool6-get-all.json
new file:   src/share/api/sflq-pool6-get-by-range.json
new file:   src/share/api/sflq-pool6-get-by-subnet.json

[4492] Added callouts and handlers and UTs

/src/hooks/dhcp/lease_cmds/sflq_cmds.cc
/src/hooks/dhcp/lease_cmds/sflq_cmds.h
    New files that implement the SFLQ command handlers

/src/hooks/dhcp/lease_cmds/libloadtests/sflq_cmds_unittests.cc
    New file with API tests

/src/hooks/dhcp/lease_cmds/lease_cmds_callouts.cc
    Add callouts to SLFQ command handlers

/src/hooks/dhcp/lease_cmds/lease_cmds_messages.mes
    New log messages for SFLQ commands

/src/lib/dhcpsrv/testutils/sflqtest_lease_mgr.*
    Implemented SFLQ commands

[#4452] attempt to fix UTs

[#4487] Removed libca symlink

[#3982] Refomatted meson.build

[#3982] More cross-compilation fixes in meson.build

[#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