[Kea-users] Issue installing Kea DHCP4 on Ubuntu 22 with Postgresql 16

[Darren Ankney]

Hi Ben,

I'm not sure what to make of those errors.  It does appear that
changing database ownership is the correct course of action:
https://gitlab.isc.org/isc-projects/kea/-/issues/2773

I'd say perform some tests and make sure that leases are successfully
stored in the database (perhaps use the API to retrieve some leases).
Keep an eye on logs for any error messages.

Thank you,

Darren Ankney

On Tue, Oct 17, 2023 at 2:35 PM Ben Bridges <bbridges at springnet.net> wrote:
>
> Hi,
>
>
>
> I am trying to install the Kea DHCP4 server on Ubuntu 22.04 with PostgreSQL v16.  When I try to create the database tables with kea-admin, I get the following error:
>
>
>
> psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:36: ERROR:  permission denied for schema public
>
> LINE 1: CREATE TABLE lease4 (
>
>
>
> I had granted all privileges on the public schema (as well as all privileges to the kea database) to the kea user.  I read that in postgresql v16 only the owner of a database can create objects in it, so I changed the owner of the kea database to be the kea user and re-ran “kea-admin db-init” to initialize the kea database.  I did not get the above error, and the “kea-admin db-version …” command now returns ’18.0’, but the “kea-admin db-init” command did output the following NOTICEs:
>
>
>
> psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:140: NOTICE:  function lease4dumpheader() does not exist, skipping
>
> psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:148: NOTICE:  function lease4dumpdata() does not exist, skipping
>
> psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:178: NOTICE:  function lease6dumpheader() does not exist, skipping
>
> psql:/usr/share/kea/scripts/pgsql/dhcpdb_create.pgsql:186: NOTICE:  function lease6dumpdata() does not exist, skipping
>
>
>
> Are those message ok?  Did I do the correct thing by changing the owner of the kea database to be the kea user?  Will that cause problems later when Kea is upgraded to a newer version?  Should the owner of the kea database be changed back to the root user after it is initialized?  Should the kea user be granted all privileges on the public schema as I did?
>
>
>
> Thanks,
>
> .Ben Bridges.
>
>
>
> --
> 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