[#4446] Increase timeout of mysql_tests.sh

[#4425] Fixed typos

modified:   src/lib/dhcpsrv/sflq_allocator.h
modified:   src/lib/dhcpsrv/testutils/sflqtest_lease_mgr.h

[#4425] Addressed more review comments

/src/bin/admin/tests/pgsql_tests.sh.in
     Minor nits

/src/lib/dhcpsrv/tests/sflq_allocator_unittest.cc
    Replace contains with count

/src/lib/dhcpsrv/testutils/sflqtest_lease_mgr.h
    Fixed override warnings

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    inetToBytea(inet_address inet) - handle v6 addresses
    with empty first hextet

[#4425] Fixed v4-mapped address issue in inetToBytea

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

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    Handle special case first octect zero

[#4425] Addressed review comments

/src/bin/admin/tests/mysql_tests.sh.in
    mysql_sflqCreateFlqPool4Invalid() - new test
    mysql_sflqPickFreeLease4() - added test cases
    mysql_sflqCreateFlqPool6Invalid() - new test
    mysql_sflqPickFreeLease6() - added test cases

/src/bin/admin/tests/pgsql_tests.sh.in
    pgsql_sflqCreateFlqPool4Invalid() - new test
    pgsql_sflqPickFreeLease4() - added test cases
    pgsql_sflqCreateFlqPool6Invalid() - new test
    pgsql_sflqPickFreeLease6() - added test cases

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    Added parameter validation and fixed overruns in
    create pool functions

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    Added parameter validation and fixed overruns in
    create pool functions
    Fixed a bug in inetToBytea on address with an empty first octet

And various nits.

[#4425] Catch overrun in MySql sflqCreateFlqPool4

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

[#4425] Improved MySQL setLoopLimit

Sets a cap of 1000, and sets the DB's session
variable limit if it is zero.

[#4425] Implement SharedFlqAllocator class

modified:   src/lib/dhcpsrv/cfg_subnets4.cc
modified:   src/lib/dhcpsrv/cfg_subnets6.cc
modified:   src/lib/dhcpsrv/iterative_allocator.h
modified:   src/lib/dhcpsrv/meson.build
new file:   src/lib/dhcpsrv/sflq_allocator.cc
new file:   src/lib/dhcpsrv/sflq_allocator.h
modified:   src/lib/dhcpsrv/tests/meson.build
new file:   src/lib/dhcpsrv/tests/sflq_allocator_unittest.cc
modified:   src/lib/dhcpsrv/testutils/meson.build
new file:   src/lib/dhcpsrv/testutils/sflqtest_lease_mgr.cc
new file:   src/lib/dhcpsrv/testutils/sflqtest_lease_mgr.h

[#4417] Addressed review comments

Applied batch to turn PostgreSQL procedures into functions
for PosgreSQL 10 compatibility

Several smaller typos and mistakes.

modified:
src/bin/admin/tests/pgsql_tests.sh.in
src/hooks/dhcp/mysql/mysql_lb_messages.cc
src/hooks/dhcp/mysql/mysql_lb_messages.mes
src/hooks/dhcp/mysql/mysql_lease_mgr.cc
src/hooks/dhcp/mysql/mysql_lease_mgr.h
src/hooks/dhcp/mysql/tests/mysql_lease_mgr_unittest.cc
src/hooks/dhcp/pgsql/pgsql_lb_messages.cc
src/hooks/dhcp/pgsql/pgsql_lb_messages.mes
src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
src/hooks/dhcp/pgsql/pgsql_lease_mgr.h
src/lib/dhcpsrv/lease_mgr.h
src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.cc
src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.h
src/lib/mysql/mysql_binding.h
src/share/database/scripts/mysql/dhcpdb_create.mysql
src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
src/share/database/scripts/pgsql/dhcpdb_create.pgsql
src/share/database/scripts/pgsql/dhcpdb_drop.pgsql
src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in

[#4417] Fix missing log argument

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

[#4417] Add log messages

modified:   ../mysql/mysql_lb_messages.cc
modified:   ../mysql/mysql_lb_messages.h
modified:   ../mysql/mysql_lb_messages.mes
modified:   ../mysql/mysql_lease_mgr.cc
modified:   pgsql_lb_messages.cc
modified:   pgsql_lb_messages.h
modified:   pgsql_lb_messages.mes
modified:   pgsql_lease_mgr.cc

[#4417] SFLQ Create/Pick added to LeaseMgrs

Added new SQL statements and functions to
create and pick from SFLQ pools to
MySQL and PostgreSQL lease managers

/src/hooks/dhcp/pgsql/pgsql_lease_mgr.cc
    New SQL statements:
    SFLQ_CREATE_POOL4
    SFLQ_PICK_FREE_LEASE4
    SFLQ_CREATE_POOL6
    SFLQ_PICK_FREE_LEASE6

    New functions:
    PgSqlLeaseMgr::sflqCreateFlqPool4()
    PgSqlLeaseMgr::sflqPickFreeLease4()
    PgSqlLeaseMgr::sflqCreateFlqPool6()
    PgSqlLeaseMgr::sflqPickFreeLease6()

/src/hooks/dhcp/pgsql/tests/pgsql_lease_mgr_unittest.cc
    New tests:
    TEST_F(PgSqlLeaseMgrTest, testSFLQ4)
    TEST_F(PgSqlLeaseMgrTest, testSFLQ6)

/src/hooks/dhcp/mysql/mysql_lease_mgr.*
    New SQL statements:
    MySqlLeaseMgr::SFLQ_CREATE_FLQ_POOL4
    MySqlLeaseMgr::SFLQ_PICK_FREE_LEASE4
    MySqlLeaseMgr::SFLQ_CREATE_FLQ_POOL6
    MySqlLeaseMgr::SFLQ_PICK_FREE_LEASE6

    New functions:
    MySqlLeaseMgr::sflqCreateFlqPool4()
    MySqlLeaseMgr::sflqPickFreeLease4()
    MySqlLeaseMgr::sflqCreateFlqPool6()
    MySqlLeaseMgr::sflqPickFreeLease6()

/src/hooks/dhcp/mysql/tests/mysql_lease_mgr_unittest.cc
    New tests:
    TEST_F(MySqlLeaseMgrTest, testSFLQ4)
    TEST_F(MySqlLeaseMgrTest, testSFLQ6)

/src/lib/dhcpsrv/lease_mgr.*
    New Functions:
    LeaseMgr::sflqCreateFlqPool4()
    LeaseMgr::sflqPickFreeLease4()
    LeaseMgr::sflqCreateFlqPool6()
    LeaseMgr::sflqPickFreeLease6()

/src/lib/dhcpsrv/testutils/generic_lease_mgr_unittest.*
    New tests:
    GenericLeaseMgrTest::testSFLQ4()
    GenericLeaseMgrTest::testSFLQ6()

[#4405] Addressed review comments

    Fixed typos

modified:   src/bin/admin/tests/mysql_tests.sh.in
modified:   src/bin/admin/tests/pgsql_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

[#4405] Removed transactions

Removed transactions from add/update/delete procedures.
They have a big impact performance and don't make much sense.

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

[4405] SFLQ lease insert,update,delete procedures

Added stored procedures and UTs for MySql
and PostgreSQL for lease insert, update, and delete

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/dhcpdb_drop.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    New stored procedures:
    sflqInsertLease4
    sflqUpdateLease4
    sflqDeleteLease4
    sflqInsertLease6
    sflqUpdateLease6

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/dhcpdb_drop.pgsql
/src/share/database/scripts/mysql/upgrade_032_to_033.sh.in
    New stored procedures:
    sflqInsertLease4
    sflqUpdateLease4
    sflqDeleteLease4
    sflqInsertLease6
    sflqUpdateLease6

/src/bin/admin/tests/mysql_tests.sh.in
    New tests:
    mysql_sflqInsertLease4
    mysql_sflqUpdateLease4
    mysql_sflqDeleteLease4
    mysql_sflqInsertLease6
    mysql_sflqUpdateLease6
    mysql_sflqDeleteLease6

/src/bin/admin/tests/pgsql_tests.sh.in
    New tests:
    pgsql_sflqInsertLease4
    pgsql_sflqUpdateLease4
    pgsql_sflqDeleteLease4
    pgsql_sflqInsertLease6
    pgsql_sflqUpdateLease6
    pgsql_sflqDeleteLease6

[#4373] Fix postgresql pick logic

Fix the if clause on the second try pick in sflqPickFreeLease*

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

[#4373] Addressed more review comments

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

[#4373] Missed typo fix

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

Typo fix

[#4373] Addressed some review comments

    Use ON DUPLICATE UPDATE instead of INSERT IGNORE
    Raise an error on invalid delegated length

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

[#4373] Made perf improvements for postgresql

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    sflqCreateFlqPool6() - optmized for perf

[#4373] Improve Mysql sflqCreateFlqPool6 performance

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

[#4373] Added setLoopLimit() to MySql

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/dhcpdb_drop.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    new procedure setLoopLimit()
    sflqCreateFlqPool4() - modified to use new procedure

[#4373] Addressed some early comments

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/mysql/wipe_data.sh.in
modified:   src/share/database/scripts/pgsql/dhcpdb_create.pgsql
modified:   src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
modified:   src/share/database/scripts/pgsql/wipe_data.sh.in

[#4373] Changed v4 postgresql columsn to BIGINT

Changed flq_pool4 and free_lease4 to store addresses
as BIGINT only. Reduces the number of conversions
dramatically.

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

[#4373] Capture select output in procedure

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

[#4373] Drop lease type from free_lease6 table

Tracking lease type in free_lease6 serves no purpose.

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

[#4373] remvoed extraneous DECLAREs

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

[#4373] Added new UTs

/src/bin/admin/tests/mysql_tests.sh.in
    mysql_sflqCreateFlqPool4()
    mysql_sflqCreateFlqPool6()

/src/bin/admin/tests/pgsql_tests.sh.in
    pgsql_sflqCreateFlqPool4()
    pgsql_sflqCreateFlqPool6()

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    sflqCreateFlqPool6() - fixed where clause

[#4373] function renaming,add expired on create

modified:
src/bin/admin/tests/mysql_tests.sh.in
src/bin/admin/tests/pgsql_tests.sh.in
src/share/database/scripts/mysql/dhcpdb_create.mysql
src/share/database/scripts/mysql/dhcpdb_drop.mysql
src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
src/share/database/scripts/pgsql/dhcpdb_create.pgsql
src/share/database/scripts/pgsql/dhcpdb_drop.pgsql
src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    renamed:
        createSharedFlqPool4 -> sflqCreateFlqPool4
        createSharedFlqPool6 -> sflqCreateFlqPool6
        pickFreeLease4 -> sflqPickFreeLease4
        pickFreeLease6 -> sflqPickFreeLease6

[#4373] Minor improvements to incrementV6Prefix

Changes to be committed:
modified:   src/share/database/scripts/mysql/dhcpdb_create.mysql
modified:   src/share/database/scripts/mysql/upgrade_033_to_034.sh.in

[#4373] Added MySQL UTs

/src/bin/admin/tests/mysql_tests.sh.in
    mysql_SFLQ4()
    mysql_SFLQ6() - new tests

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    Fixed pickFreeLease6

[#4373] Added postgresql UTs

/src/bin/admin/tests/pgsql_tests.sh.in
    pgsql_SFLQ4()
    pgsql_SFLQ6() - new tests

/src/lib/dhcpsrv/tests/iterative_allocator_unittest.cc
    removed experimental test

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    Changed free_lease4 bin_address type from INT to BIGINT

[#4373]  Postgresql SFLQ tables and functons

/src/bin/admin/tests/mysql_tests.sh.in
    Updated tests

/src/bin/admin/tests/pgsql_tests.sh.in
    Added tests for new functions and procedures

/src/lib/dhcpsrv/iterative_allocator.h

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    Added bin_address to free_lease6
    createSharedFlqPool4() - added delete or free_lease4 data

    createSharedFlqPool6()
    pickFreeLease6() - modified to use bin_address

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    free_lease4
    free_lease6
    - added bin_address

    added new functions:
    createSharedFlqPool4()
    pickFreeLease4()
    hexToBin()
    inetToBytea()
    byteaToInet()
    incrementV6Prefix()
    createSharedFlqPool6()
    pickFreeLease6()

/src/share/database/scripts/pgsql/dhcpdb_drop.pgsql
    updated

[#4373] Added SFLQ tables for postreSQL

new file:   upgrade_032_to_033.sh.in

/src/bin/admin/tests/mysql_tests.sh.in
    Added test one function shortcut

/src/bin/admin/tests/pgsql_tests.sh.in
    Added test one function shortcut
    Updated version number
    Added pgsql_upgrade_32_to_33_test()

/src/lib/pgsql/pgsql_connection.h
    Updated version number

/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
/src/share/database/scripts/pgsql/dhcpdb_drop.pgsql
    Added SFLQ tables

/src/share/database/scripts/pgsql/meson.build
    Added upgrade_032_to_033.sh.in

[#4373] Added MySQL functions

/src/bin/admin/tests/mysql_tests.sh.in
    mysql_upgrade_33_to_34_test() -
        Added tests for new functions

/src/share/database/scripts/mysql/dhcpdb_create.mysql
/src/share/database/scripts/mysql/dhcpdb_drop.mysql
/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
    Added functions: incrementV6Prefix, createShareFlqPool4
    pickFreeLease4. createShareFlqPool6, pickFreeLease6.

[#4373] Added MySQL SFLQ tables

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

/src/bin/admin/tests/mysql_tests.sh.in
    update schem versrion check added
    mysql_upgrade_33_to_34_test()

/src/lib/mysql/mysql_constants.h
    const uint32_t MYSQL_SCHEMA_VERSION_MAJOR = 34;

/src/share/database/scripts/mysql/dhcpdb_create.mysql
    create new tables:
    flq_pool4
    free_lease4
    flq_pool6
    free_lease6

/src/share/database/scripts/mysql/dhcpdb_drop.mysql
    added drops of new tables

/src/share/database/scripts/mysql/meson.build
    added upgrade_033_to_034.sh

[#4434] added ChangeLog entry

[#4434] added v4 unit tests

[#4434] handle lease6_select SKIP flag

[#4304] Updated gitattributes

[#4304] Changed exhonerat* into exonerat* (file)

[#4304] Changed exhonerat* into exonerat*

[#4340] Unified to datatracker

[#4208] Updated RFC4741 ref into RFC6241

[#4410] Changed deadline_timer for system_timer

[#4432] fix unit tests

[#4342] Addressed review comments

modified:   changelog_unreleased/4342-get-rid-of-json_supported-logic-in-mysql-and-postgresql-code
modified:   src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in

[#4342] Updated ARM added change log

new file:   changelog_unreleased/4342-get-rid-of-json_supported-logic-in-mysql-and-postgresql-code
modified:   doc/sphinx/arm/admin.rst

[#4342] Fix missing comment in script

modified:   pgsql/upgrade_032_to_033.sh.in

[#4342] Removed isJsonSupported

/src/share/database/scripts/mysql/upgrade_033_to_034.sh.in
/src/share/database/scripts/pgsql/upgrade_032_to_033.sh.in
    New files

/src/bin/admin/tests/mysql_tests.sh.in
    Updated version check, removed isJsonSupported checks in tests
    add mysql_upgrade_33_to_34_test()

/src/bin/admin/tests/pgsql_tests.sh.in
    Updated version check, removed isJsonSupported checks in tests

/src/hooks/dhcp/limits/limit_manager.h
    Removed isJsonSupported() check

/src/hooks/dhcp/mysql/mysql_lease_mgr.*
/src/hooks/dhcp/pgsql/pgsql_lease_mgr.*
/src/lib/dhcpsrv/testutils/concrete_lease_mgr.*
/src/lib/dhcpsrv/memfile_lease_mgr.*
/src/lib/dhcpsrv/lease_mgr.h
    Removed isJsonSupported() fucntion

/src/hooks/dhcp/mysql/tests/mysql_lease_mgr_unittest.cc
/src/hooks/dhcp/pgsql/tests/pgsql_lease_mgr_unittest.cc
    Removed isJsonSupported() check

/src/lib/dhcpsrv/tests/memfile_lease_mgr_unittest.cc
    Removed isJsonSupported() tests

/src/lib/mysql/mysql_constants.h
    Updated schema version

/src/share/database/scripts/mysql/dhcpdb_create.mysql
    Remove isJsonSupported

[#4330] Update release_checklist.md

[#4330] Update release_checklist.md

[#4330] Update release_checklist.md with lessons learned from March releases

[#4330] Update release_checklist.md about syncing both Kea and Forge

[#4330] Color-coded release_checklist.md

[#4330] Update release_checklist.md

[#4363] addressed review comments

[#4363] always use false for persist when testing config

Edit release_checklist.md to clarify that subscribers should get link to Cloudsmith -prv when releasing

[#4430] Bump up versions after release

[#4420] release changes

[#4419] Bump up library versions for 3.1.7

[#4389] addressed review comments

[#4389] addressed review comments

[#4389] addressed review comments

[4389] use fatal error result

[#4389] updated unit tests

[#4389] handle recoverable errors

[#4360] added unit tests

[#4365] do not allow missing "socket-name" in service map

[#4380] Bump urllib3 2.5.0 -> 2.6.3 for sphinx

Bumps [urllib3](https://github.com/urllib3/urllib3) from 2.5.0 to 2.6.3.
- [Release notes](https://github.com/urllib3/urllib3/releases)
- [Changelog](https://github.com/urllib3/urllib3/blob/main/CHANGES.rst)
- [Commits](https://github.com/urllib3/urllib3/compare/2.5.0...2.6.3)

---
updated-dependencies:
- dependency-name: urllib3
  dependency-version: 2.6.3
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

[#3574] Addressed comments

[#3574] Final UT updates

[#3574] Checkpoint: almost done

[#3574] Checkpoint: code done, UTs to adjust

[#1117] addressed review comments

[#1117] fixed bsd BPF code for vlan filter

[#1117] drop packets with vlan tag

[#4279] apply zero filter and drain socket

[#4338] Build with current Openssl API

[#4338] Put meson.build through muon fmt

[#4369] Update checkout@v6; use build-mode: none

GitHub now supports CodeQL scans of C and C++ code without building
the executable.

https://github.blog/changelog/2025-10-14-codeql-scanning-rust-and-c-c-without-builds-is-now-generally-available/

[#4369] Update CodeQL workflow to v4

[#4231] fixed race on markReady and clearReady in IfaceMgr

[#4364] bump up version to 3.1.7

[#4355] release changes

[#4356] New proposal

[#4356] Added experimental status

[#4356] Spelling

[#4356] Proposal

[#4354] bump up library versions for 3.1.6 release

[#4351] Fix an integer overflow in cfg_iface_unittest.cc

[#4351] Remove couts from dhcpsrv tests which make you think that they are errors when you skim through the output

[#4349] check for unicast in hasOpenSocket

[#2212] added reference to unicast config for v6 global addresses

[#3370] addressed comments

[#3062] added ChangeLog entry

[#3062] added unittests

[#3062] compute iface flags on redetect