Bug 2404145 - Postgres support missing after update to Fedora 43 beta
Summary: Postgres support missing after update to Fedora 43 beta
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Fedora
Classification: Fedora
Component: kea
Version: 43
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Martin Osvald 🛹
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2025-10-15 11:52 UTC by Mat Booth
Modified: 2025-10-15 13:10 UTC (History)
5 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2025-10-15 13:04:02 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Mat Booth 2025-10-15 11:52:34 UTC
Description of problem:

After upgrading the following error is observed:

Oct 15 12:26:01 major-clanger.matbooth.test kea-dhcp4[27296]: ERROR [kea-dhcp4.dhcpsrv] DHCPSRV_UNKNOWN_DB unknown database type: postgresql
Oct 15 12:26:01 major-clanger.matbooth.test kea-dhcp4[27296]: ERROR [kea-dhcp4.dhcp4] DHCP4_CONFIG_LOAD_FAIL configuration error using file: /etc/kea/kea-dhcp4.conf, reason: Unable to open database: The Kea server has not been compiled with support for lease database type: postgresql. Did you forget to use -D postgresql=enabled during setup or to load libdhcp_pgsql hook library?
Oct 15 12:26:01 major-clanger.matbooth.test kea-dhcp4[27296]: 2025-10-15 12:26:01.555 ERROR [kea-dhcp4.dhcp4/27296.140053513608512] DHCP4_INIT_FAIL failed to initialize Kea server: configuration error using file '/etc/kea/kea-dhcp4.conf': Unable to open database: The Kea server has not been compiled with support for lease database type: postgresql. Did you forget to use -D postgresql=enabled during setup or to load libdhcp_pgsql hook library?


Version-Release number of selected component (if applicable):

kea-3.0.1-2.fc43.x86_64

How reproducible:

100%

Steps to Reproduce:

Using the following configuration snippet:

"Dhcp4": {
    "hosts-database": {
        "type": "postgresql",
        "name": "kea_dhcp",
        "user": "kea",
        "password": "<redacted>",
        "host": "::1",
        "port": 5432
    }
}


I am upgrading from Fedora 41. This is a regression from package version: kea-2.6.1-4.fc41.x86_64

The removal of postgres support seems unintentional because in your specfile you still pass the build flag "-D postgresql=enabled" to meson. Any idea why postgres support is missing?

Comment 1 Martin Osvald 🛹 2025-10-15 13:04:02 UTC
Thank you for reporting this issue.

Since Kea.2.7.4, the libdhcp_pgsql.so hook library must be loaded in order to store leases in the PostgreSQL Lease Database Backend. Specify the lease backend hook library location.

~~~
"Dhcp4": { "hooks-libraries": [
    {
        // the PostgreSQL lease backend hook library required for lease storage.
        "library": "/opt/lib/kea/hooks/libdhcp_pgsql.so"
    }, ... ], ... }
~~~

https://downloads.isc.org/isc/kea/2.7.4/Kea-2.7.4-ReleaseNotes.txt

 1. **SQL hooks**: Support for MySQL and PostgreSQL was moved to
separate hooks. Administrators who want to use specific backends need to
load those hooks. [ #3536]. The documentation regarding those new hooks
was updated [ #3586]. The parser was relaxed to accept any lease and
host database type [ #3585].

See the full configuration snippet:

https://kea.readthedocs.io/en/kea-3.0.1/arm/dhcp4-srv.html#enabling-the-configuration-backend

Comment 2 Mat Booth 2025-10-15 13:10:52 UTC
Aha, thanks. And for future readers, the hook library is in "kea-hooks" package which is not pulled in by default -- it was not obvious to me I needed to install extra packages.


Note You need to log in before you can comment on or make changes to this bug.